If your OS starts the MySQL server with the right default charset and collation and it matches that of the connection made from the php scripts, all should be well. This will affect both FA 2.3 and FA 2.4 as well.
2,327 11/29/2017 09:05:53 am
Re: UTF8 double encoding (5 replies, posted in Report Bugs here)
This is specific to the mysqli_query execution where the connection handle is passed.
2,328 11/29/2017 09:04:48 am
Re: Not able to load reports on localhost (9 replies, posted in Reporting)
Compare the php.ini files and the apache conf files.
2,329 11/29/2017 01:12:45 am
Re: UTF8 double encoding (5 replies, posted in Report Bugs here)
Make sure that the default / current session / connection are all of the same charset.
Check on the values of the concerned MySQL variables.
2,330 11/29/2017 01:10:33 am
Re: Not able to load reports on localhost (9 replies, posted in Reporting)
Make sure you have the appropriate font in the reporting/fonts folder.
2,331 11/28/2017 12:30:45 pm
Topic: Spinner on download keeps spinning (3 replies, posted in Setup)
When a backup is created and an attempt is made to download the backed-up file which downloads successfully, the spinner at the top keeps spinning and there is no message to state that the download was successful.
When a backed-up file is attempted to be viewed, there is no sql file extraction on archived backups before a view is attempted. If there is no intention of doing it for some reason, then a filter should be made before an attempt to allow a view like:
if (!preg_match("/\.sql$/", $fname))
display_error(_("You can only view *.sql backup files"));
else {
..
..in admin/backups.php file.
2,332 11/28/2017 12:23:30 pm
Re: REST API (86 replies, posted in Modules Add-on's)
By end user I mean those who install, maintain and use FrontAccounting by themselves with the Slim API, not the FA application operatives using what someone else installs and maintains.
What is wrong with line 6 of index,php? Just a plain include of all php files in the src folder so that any function in any endpoint can use it. I am planning on working on it to make sure that native FA functions are used for the most part. It works for me.
If there is anyone for whom the code does not work, please let me know - I'd like to know why and will do what needs to be done. I am keeping it as backward compatible as is possible so that those on older PHP versions too can still keep their installs whilst leveraging the REST API.
If you put in some test access values in util.php, you can easily browse to say: http://localhost/fa24/modules/api24/category/1
I've been packaging the original submission from Andres Amaya Diaz for FA 2.3 and worked on it while it was being hammered out. You check the wiki history and the original threads too.
2,333 11/28/2017 08:01:20 am
Re: REST API (86 replies, posted in Modules Add-on's)
Mine is packaged to work without composer and it's dependencies by default. The community now has the options of using it
1. with composer (your default) or
2. editing your release to work without it or
3. using mine (default no composer) directly.
Also my version does not need the PHP 5.4+ dependency of the new array declaration []. The FA and API paths are hardcoded in mine though.
Hope these differences will help end users make their choice.
2,334 11/28/2017 07:45:10 am
Re: REST API (86 replies, posted in Modules Add-on's)
Have synched my repo. Standardised the braces. It continues to work without composer. Latest version attached.
2,335 11/27/2017 02:21:33 pm
Re: Forum Usage - best practices (5 replies, posted in Announcements)
With the release of every new version, interest in the community peaks and so do the spammers who wish to be seen by those crowding in.
Attached is the stats for user registrations and their posts during the 30 day period ending today.
Two-thirds are unwanted registrations.
One-fifth are such posters and posts.
Average visibility of spammers - 2 hours.
2,336 11/27/2017 06:31:21 am
Re: Account Class drill down (5 replies, posted in Banking and General Ledger)
Opening too many windows may confuse cookies / sessions. This is more of a drill down to create a new account / account group without having to choose in a select box - especially one that is too long.
It will also be helpful for mobile layouts.
If we are to drill up and display as popups for information purposes, it should be okay for that.
2,337 11/27/2017 06:11:42 am
Re: localhost says : (2 replies, posted in Accounts Receivable)
It can be a database permission error. Does the db user have update permissions on the FA database?
There is only one function that outputs this string - function page_processing() when it's lone argument is true. It is defined in includes/ui/ui_controls.inc.
You need to backport this fix from FA v2.4 which has been done in my repo commit of 2015-08-29.
2,338 11/27/2017 03:38:45 am
Re: Account Class drill down (5 replies, posted in Banking and General Ledger)
This has been extended to Ac Master as well.
The consolidated changes are attached herewith.
@joe: when committing, please add filter removal link where appropriate.
2,339 11/27/2017 02:09:34 am
Topic: Account Class drill down (5 replies, posted in Banking and General Ledger)
Attached is the skeletal set of changes needed to implement a drill down from account classes to account groups.
It can be extended to accounts master as well.
A link for removing the filter can be added.
Repetitive columns can be moved to a header when in filter mode.
@joe: can extend and add it.
2,340 11/27/2017 01:02:06 am
Re: Release 2.4.3 (9 replies, posted in Announcements)
Pending Issues:
1. Accounting for expenses as part of Cost of Goods Purchased
2. Request to add 100% translated Hindi and Tamil in Install Wizard - Commited with 1, 2.
3. Update Language Packs for Hindi and Tamil
4. Account and Type Ordering
5. Merge Customers
6. Unable to Edit or Void a Credit Note - Was postponed to later minor release earlier
7. Multiple Sales Orders into Single Delivery - Feature Request - Currently keep editing a Single Sales Order till delivery. Was postponed to later minor release earlier
8. Move add_access_extensions(); to header.inc from all themes and extensions - being studied for Ajax and related security issues.
9. Remember Inquiry forms date / date ranges
10. Clone and Edit Sales Quote
11. Default Bank Account in select box order. - Committed
12. Zero price Supplier Invoice Item Entry
13. Backup Upload Fix - revert to multi-part form - Committed
14. Fixed Assets Depreciation Processing Fix - Committed
15. Voided Transaction Number re-used for new one errors out on old records present
16. items_db.inc Wrong Error Message - Committed.
2,341 11/27/2017 12:43:07 am
Re: How to allocate the Payment to Supplier A to the Invoice of Supplier B (3 replies, posted in Accounts Payable)
@andijani: Excellent way.
This can be a Standard Operating Procedure in such instances for all FA users.
Wiki-ed it.
2,342 11/26/2017 04:21:02 pm
Re: Adapting to google's error when getting exchange rates. (4 replies, posted in Report Bugs here)
@joe: want to commit this with a check for if (empty($val)) { ?
2,343 11/26/2017 01:06:12 pm
Re: Handling, Shipping & Clearance (19 replies, posted in Accounts Payable)
@joe: I'm out of my depth here!
Possibly keep editing/ adding to the GRN till all costs are added in.
2,344 11/26/2017 12:45:10 pm
Re: Adapting to google's error when getting exchange rates. (4 replies, posted in Report Bugs here)
The reason is that it is a very big numner for these conversions:
1 EUR = 24810.7356 STD
The inverse obtained is obviously too small:
1 STD = 0.000040305133073120169802623667474011 EUR
This is more than the 4 digits after the decimal place.
Hence Google needs to increase the number of decimal places for such evaluations.
Doing it in FA with the default values will be of no use and hence @notrinos solution is elegant.
If you search for "1 STD = ? EUR" you will get 0.000040 as the answer now.
Hence their evaluator for the search engine is okay.
Incidentally, we may have a Chart of Accounts for Sao Tome among the forum users - @odaio!
Alternatively, if all the reverse rates work, then we can swap the currencies and make just 1 single check. The reverse for IDR to OMR does not work.
USD to any currency works - hence only when a non USD is involved as the From and To currencies, we will need 2 conversions and then a division! Here we will have the second check only when the first fails.
2,345 11/26/2017 12:30:42 pm
Re: Handling, Shipping & Clearance (19 replies, posted in Accounts Payable)
Try to use line items to add the costs you want apportioned to the items and provide feedback. Also check if there are any settings - config, sys_prefs, etc that modify FA's computations.
2,346 11/26/2017 09:21:29 am
Re: Currency in sales order (1 replies, posted in Accounts Receivable)
Yes. The currency in which settlement takes place is fixed to the specific customer account. If it is a one off / rare transaction in another currency, use the currency exchange rate to get the equivalent in the default currency for the customer account and book it, providing the exchange rate conversion in the memo.
2,347 11/26/2017 01:29:55 am
Re: Not able to load reports on localhost (9 replies, posted in Reporting)
1. Check if there are any write permissions issues for the tmp folder.
2. Make sure you have OpenSSL extension enabled in your php.ini file (and restart webserver on any changes).
3. Check if any issues are listed in the wiki you may need.
4. What OS do you have for your local install?
5. When the report generation is complete, check if you have it present and valid in your company/#/pdf_files folder where # is your company id.
6. What do your Apache and FA logs say?
7. Turn on the various debug options in your FA config file and troubleshoot it by referring to the wiki.
2,348 11/25/2017 05:08:48 pm
Re: Not able to load reports on localhost (9 replies, posted in Reporting)
You will need to use MySQL 5.6 and lower. If you want it to run on MySQL 5.7 and above you will need to turn off strict mode for dates. Search the forum on how to do it. Later versions of MySQL do not look kindly on dates such as '0000-00-00' and zero timestamps as well. Hope you have installed the dejavu.zip fonts and enabled popup windows for localhost in your browser.
FA v2.4.3 is out and some post release fixes are in the Announcements page. There is no FA 2.4.23 yet. What browser and version are you using? Try Firefox 52.x ESR. Compare with versions on your remote server.
2,349 11/25/2017 03:23:27 am
Re: How to allocate the Payment to Supplier A to the Invoice of Supplier B (3 replies, posted in Accounts Payable)
By Credit Supplier B Invoice - GBP 1000 booked as CAD 1800 (based on the exchange rate for the day.
Debit Purchases for CAD 1800.
By Bank Credit Cheque issued CAD 1800
To Debit Supplier A (the 3rd party currency exchange broker) - CAD 1800.
When the money is wired as Forex to Supplier B:
By Credit Supplier A - CAD 1800 (wired as GBP 1000)
To Debit Supplier B - CAD 1800
If the Supplier B needs to have their accounts settled in GBP, then make the entries in GBP for them and how they get paid, keeping the CAD for local account heads only.
Payments made to Supplier A (appropriately GBP adjusted to CAD) can also be treated as having been made on behalf of Supplier B and allocations made in GBP itself.
Please consult your accountant on making journal entries such as this.
2,350 11/24/2017 02:13:18 pm
Re: Misleading on system diagnostics (3 replies, posted in FA Modifications)
@joe: Most new Debian and other distros are now defaulting to MariaDB. Verify and commit the above.