It is possible that several records can be added to the table for each report especially when select queries are enabled. Generally there are no update / insert SQLs captured during output of standard reports.
1,801 04/22/2018 05:07:22 pm
Re: How to find the query for a specific report? (10 replies, posted in Reporting)
1,802 04/22/2018 11:33:31 am
Re: How to find the query for a specific report? (10 replies, posted in Reporting)
Turn on the debug and sql_trail flags in the config.php file.
1,803 04/22/2018 05:46:51 am
Topic: sys_prefs flag ref_no_auto_increase added to all Chart of Accounts (0 replies, posted in Misc. Charts of Accounts)
All Charts of Accounts in the FA24extensions repo have been updated with the new flag ref_no_auto_increase in the sys_prefs table data.
1,804 04/21/2018 05:58:12 pm
Re: How i can fix the invoice shape to small size Thermal printer (8 replies, posted in Reporting)
You will need to adjust the font size and column size to fit in clearly and the paper size too can be set in the FrontReport object property while instanciation. All possible sizes are in the switch case statement in the constructor of the FrontReport class from Line 73 onwards in reporting/includes/pdf_report.inc.
1,805 04/21/2018 05:48:51 pm
Re: zh_TW updates (14 replies, posted in Translations)
Committed.
Includes the missing 25 stings as well (two letter abbreviations retained in English).
1,806 04/19/2018 06:07:28 pm
Re: zh_TW updates (14 replies, posted in Translations)
@mlance_2: Thanks. I have updated it and included it in Transifex and committed it to the FA24extensions repo. It is about 70% done and is for the latest po file in FA 2.4.4 last updated towards the end of FA 2.4.3.
Any further updates, you can carry out from the attachment. Please note the carriage return and line feed differences (CRLF => LF). Transifex FA24 has the install po as well done about 63% taken from your core translations.
1,807 04/19/2018 05:02:43 pm
Re: refs table (20 replies, posted in Items and Inventory)
The $info variable is populated when the api24/src/Inventory.php file got included (see line 65) and the class Inventory was instantiated in api24/index.php in line 73. The latter file calls the function stock_adjustment_add() without any arguments in line 129 where the $info gets populated from $_POST of the Ajax Request. In all of these cases, we see that the $info['type'] and $info['increase'] do not appear in any validation and hence the validations in the api24/inventory.inc file for these elements can be removed as well.
Does this satisfy your stock transfer?
1,808 04/19/2018 03:47:53 am
Re: refs table (20 replies, posted in Items and Inventory)
You are right. We need to remove the type and increase parameters. It is documented at the end of api_changes.txt.
Verify if any more endpoints are needed to satisfy: ST_LOCTRANSFER / ST_INVADJUST / ST_LOCTRANSFER
1,809 04/18/2018 04:19:18 pm
Re: refs table (20 replies, posted in Items and Inventory)
The API extension for FA 2.3.x is here.
The API24 version is attached herewith. Looks like you are using the one from the official / source repos that may not be updated.
The functions you alluded to have since been updated in the FA24extensions repo and attached here.
1,810 04/17/2018 06:57:10 pm
Re: refs table (20 replies, posted in Items and Inventory)
Have a look at the API24 in the extensions repo.
1,811 04/17/2018 06:55:24 pm
Re: Anatomy of adding 1 Inventory Item (2 replies, posted in Items and Inventory)
Have a look at the Inventory => Add New Item page and view the form field names and see how they relate to the various sql statements above.
1,812 04/16/2018 08:16:52 am
Re: The Future of FrontAccounting (1 replies, posted in Announcements)
This is indeed a very nice move.
Handing the baton to the next generation developers who have shown their mettle.
Much better than corrupted democracies foisted on one and all!
1,813 04/14/2018 06:51:09 am
Re: Can not release workorder (5 replies, posted in Manufactoring)
Check your database name and prefix in the config_db.php file and then check that the said tables exist.
1,814 04/14/2018 06:49:27 am
Re: Bug in Sales Quotation, Order, Delivery & Direct Invoice, Credit Note (3 replies, posted in Reporting)
Since there is more than one issue in the topic referred to in @stefan's link, the specific post is here.
1,815 04/14/2018 06:47:04 am
Re: Setup DB Connection Error (37 replies, posted in Installation)
Manually create the database and then proceed to create the new company or permit the db user used to create new databases.
1,816 04/14/2018 06:45:04 am
Re: User or password is invalid or you have no permissions to create datab (9 replies, posted in Installation)
Try to explicitly put in:
error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED
1,817 04/12/2018 07:09:59 pm
Re: Bug in Sales Quotation, Order, Delivery & Direct Invoice, Credit Note (3 replies, posted in Reporting)
What do you mean by "coming blanks"? If you mean that they are the form for entry of data, then you may not have the same files from a single FA version.
Which version of FA are you using and what platform versions are you on (OS/MySQL/PHP)? The latest GitHub FA version is v2.4.4+.
1,818 04/12/2018 03:13:21 am
Re: Shipping with FA (9 replies, posted in Setup)
You can upgrade to FA 2.3.26 first and see if this issue is resolved in it. This will also make you ready for moving onto FA 2.4.x later.
Have you tried Quick Entries?
Attached are the changed files from FA 2.3.19 to FA 2.3.26.
Pay attention to the sql/en_US-new.sql and config.default.php file changes and implement those in the latter in your config.php file. Also read each release page in the forum for any other changes / sql data changes.
1,819 04/11/2018 06:41:28 pm
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
It would be nice to refresh the Extensions repo with the latest changes as in the FA24extensions repo. Tamil / Hindi translations are yet to be refreshed.
1,820 04/11/2018 06:39:39 pm
Re: Australian Tax Invoice extension (9 replies, posted in Modules Add-on's)
The GST / VAT are addressed in the locale translation files.
There are some computational changes you have introduced - in what way do these changes affect the output?
1,821 04/11/2018 02:19:03 am
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
The effect of the return -1; above should be tested under various PHP dispensations - is it an error or is it a graceful change to a new_reference, the calling entity should know and act accordingly.
1,822 04/10/2018 07:20:56 am
Re: Setup DB Connection Error (37 replies, posted in Installation)
Then it is a case of permissions for files/folders. Check if the contents of your config_db.php are okay and the db access credentials for the said db are fine. If the file is absent, then during the installation, the webserver process did not have sufficient permissions to write to the FA webroot folder.
1,823 04/10/2018 07:17:40 am
Re: Frontaccounting 2.4.4 bug in Import transactions extension (1 replies, posted in Report Bugs here)
The official extensions repo has not been updated in a while. The file stands okay in the FA24extensions repo.
Take the files for your extension from:
https://github.com/apmuthu/FA24extensio … ansactions.
1,824 04/10/2018 06:32:26 am
Re: Australian Tax Invoice extension (9 replies, posted in Modules Add-on's)
Will look into it. Need to check if the UPDATE / INSERT sqls are needed here or changes in the core file(s) are in order. Since many countries including India too follow the GST bandwagon (not that many in the trade are paying it / like to pay it / subsidise excessive and unwarranted govt spending on undesirables!) it may be in order to make it generic.
1,825 04/08/2018 12:49:08 am
Re: Keen on translating (40 replies, posted in Translations)
Older Windows OSes and older XAMPP have issues with gettext which if disabled in the php.ini and then restart webserver should allow for translations to occur from an array instead. This is because Windows uses 3 character language locales instead of Linux's 2_2.