Painful task. Adjust the font size to be really small and then name your items really short. Avoid all decimals if possible. Adjust the column widths! Make a copy of the reporting/rep107.php and place it in your company/#/reporting/ folder where # is your company number. Now edit the latter to suit your needs.
1,776 04/23/2018 02:40:04 pm
Re: Invoice size to Thermal printer (7 replies, posted in Jobs wanted/offered, non-free offers)
1,777 04/23/2018 02:37:00 pm
Re: How to find the query for a specific report? (10 replies, posted in Reporting)
Reports cannot ordinarily add records.
Only the Web UI forms can do it like generating a sales invoice or allocating a supplier payment to a purchase invoice.
Provide an example of a report where you get entries generated.
1,778 04/23/2018 02:33:45 pm
Re: Company Table (6 replies, posted in Setup)
Setup => Company Setup => Use Dimensions => choose 0, 1 or 2 Dimensions. The default in most charts is just 1.
In the Dimensions => Dimension Entry, the start and end dates can be the same as the fiscal year. his is where you will want your divisions to reside in a single dimension Type.
In Items and Inventory => Items, assign each item to a specific Dimension where desired.
The Wiki is quite explanatory.
If you forget to set the dimension in each entry form correctly, all the Profit and Loss Accounts pertaining to it will appear messed up.
1,779 04/22/2018 08:58:56 pm
Re: Company Table (6 replies, posted in Setup)
All company information are in the sys_prefs table as records. Dimensions can be used in any classification of profit centres - dated ranges too are accommodated but departments / divisions are the general usage.
1,780 04/22/2018 08:56:47 pm
Re: Exclusive Theme not working with PHP7 or higher (3 replies, posted in Installation)
The dashboard is now integrated with FA in v2.4.x and the __construct() is implemented in the themes for the constructor. Replace the Exclusive theme files with the ones from the FA24extensions repo and see whether it works.
1,781 04/22/2018 05:07:22 pm
Re: How to find the query for a specific report? (10 replies, posted in Reporting)
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,782 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,783 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,784 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,785 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,786 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,787 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,788 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,789 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,790 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,791 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,792 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,793 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,794 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,795 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,796 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,797 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,798 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,799 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,800 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?