State versions of OS, platform and FA used.
3,577 04/07/2016 04:46:40 pm
Re: Remove manufacturing and dimension modules, (4 replies, posted in FA Modifications)
You can use the company number in an if statement to prevent it's inclusion / execution for the specific company you want to suppress it for. The currently logged in company should be in the session.
3,578 04/07/2016 10:43:44 am
Re: Customer Database Import Error (4 replies, posted in Modules Add-on's)
You may have some dummy entries in the table that links entities (branches) to contacts - FA's basic CRM tables. See the ERD link in the wiki alluded to in the second post in this thread.
3,579 04/04/2016 07:48:30 pm
Re: Printing product label with barcode (6 replies, posted in Items and Inventory)
https://frontaccounting.com/fawiki/index.php?n=Devel.BarCodeUsage
has the necessary code.
3,580 04/04/2016 07:46:10 pm
Re: Customer Database Import Error (4 replies, posted in Modules Add-on's)
Study the ERD at:
https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram23
Then you will notice that in this new version, there are additional CRM tables where entities are linked to instances.
Take a backup now.
Choose one customer and add a branch.
Tanke another backup.
Use WinMerge or some diff tool to study what records got added.
Do it likewise for the other imported customers.
3,581 04/04/2016 07:35:43 pm
Re: Problems in trial balance (on cash basis) (1 replies, posted in Reporting)
If the petty cash paid and petty cash received have been incorporated into the cash and bank accounts, then they should be zero or at the very least equal to one another with sign reversal. Make a journal voucher moving the amounts in balance in each of the petty cash accounts to the cash account and then use the resultant trial balance.
3,582 04/04/2016 07:32:18 pm
Re: Print (PDF) is not working anywhere in 2.3.25 (13 replies, posted in Report Bugs here)
Check the error logs and revert.
Since it works in 2.3.24, check out some intermediate versions of 2.3.24+ and see when it breaks.
3,583 04/04/2016 07:28:39 pm
Re: A Customer providing a service. (2 replies, posted in Accounts Receivable)
Alternatively, a credit of maximum usage can be agreed upon and provided as a loan to the customer and advance received back into the customer's account.
A credit limit too can be used.
3,584 04/04/2016 07:26:20 pm
Re: POS integration with FA (1 replies, posted in Wish List)
A cursory look at the code shows that the schema is in install.php. It uses the mysql constructs and can be updated to use the mysqli functions.
3,585 04/04/2016 07:20:39 pm
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
Check the history of file changes for the said file in github.com and see if an upgrade to the latest FA v2.3.25+ is of any use.
3,586 03/26/2016 02:19:53 pm
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
Take a backup and zip it up and upload somewhere (possibly password protected) and pm me the link. Also state what your version of FA is.
3,587 03/22/2016 04:53:53 am
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
Choose default theme - no dashboards. Dashboard themes do too much querying for each front page display.
3,588 03/20/2016 03:18:47 am
Re: F.A Get Hangs/Freeze (10 replies, posted in Report Bugs here)
Rebuild the index / table.
3,589 03/16/2016 04:41:36 pm
Re: Items and Inventory (1 replies, posted in Items and Inventory)
Try treating Commission as a pseudo tax using a separate Commission Account that receives it (or pays it out if negative).
Otherwise, make an extension for it.
3,590 03/16/2016 04:38:29 pm
Re: calculate tax when specific amount is reached (1 replies, posted in Accounts Receivable)
FA does not have taxes based on Invoice Value. You will need to write your own extension for it. Cumulative taxes (Tax on Tax) is however available in FA.
3,591 03/16/2016 04:35:33 pm
Re: Vat and Tax Setup (5 replies, posted in Setup)
Difference compared to FA 2.3 would be useful if illustrated.
Attached is your page in PDF.
3,592 03/16/2016 04:29:01 pm
Re: Items received to be Invoiced (1 replies, posted in Accounts Payable)
Post the invoices as on today and make a note in the memo that it pertains to goods received in 2015.
3,593 03/16/2016 04:27:03 pm
Re: Negative zero values in Balance sheet (4 replies, posted in Report Bugs here)
Check the MySQL and platform versions. Also do a query to take the difference of the field value from a zero constant. It is possible to assign 0 instead of 0.00 in the insert statement in the backup sql and re-import it.
3,594 02/21/2016 04:29:04 am
Re: Setup for non VAT registered company (3 replies, posted in Setup)
Move to a country that does not charge (so much) VAT ![]()
The CoAs will not be updated in the v2.3 repo anymore judging by what I have seen hitherto in the last couple of years. The various CoAs have not been formatted in a standard way and hence is not amenable to easy comparison - that probably was not the intention but less diligence amongst the many contributors and little or no vetting while incorporating into the repo and/or not updated when the primary sqls changed would be the real reasons.
Whether you setup separate tax accounts or just use the filtered reporting in FA is a matter of choice.
The wiki and the forum posts abound with several examples. The search feature in the wiki is broken and unlikely to be fixed in the near future on priority.
Removing the VAT lines from the reports (repXXX.php) and placing them in the company's reporting folder will override the standard ones for that company.
3,595 02/21/2016 04:21:22 am
Re: Change name of a Report (10 replies, posted in Reporting)
Just re-compile the standard en_US.mo file. Only changed strings need be in the new .po file and compiled into the .mo file.
In the case of Australian or Indian English too the same applies with changed strings.
Extract the .po file from your current .mo file - only those stings that changed need/will be there. Then refer to the empty.po file and add in "the strings you wish to change" into the extracted .po file and recompile and use it.
In future, do not upgrade the language file at all from the GUI and instead only incorporate the changes in them into your version of the extracted .po file, compile and use the resultant .mo file.
In most instances language files have little or no changes and version bumps occur regularly - good business for "consultants".
3,596 02/19/2016 05:28:01 pm
Re: Change name of a Report (10 replies, posted in Reporting)
Hardcoding is the "Quick 'n Dirty" means.
You can make the string translatable using _("...") since the input argument will be used if not found in the .mo file (as absent in the original empty.po file). Changing it in the .po file and then using the newly compiled .mo file will make for less hassles when comparing code with the master repo and seamless in upgradation.
3,597 02/16/2016 03:35:26 am
Re: Change name of a Report (10 replies, posted in Reporting)
Do not edit the _('DELIVERY NOTE') as it is a translatable string that needs to be altered in the appropriate .po file which then needs to be compiled into a .mo file before being used.
If you are using only 1 language and/or prefer this string to be in English alone, hard code it using the following instead:
{
$rep->title = 'CUSTOMER INVOICE';
$rep->filename = "Delivery" . $myrow['reference'] . ".pdf";
}3,598 02/16/2016 03:30:48 am
Re: How to Add Column in Direct Invoice and Invoice - Supplier (4 replies, posted in Accounts Payable)
Post the code changes you have done.
3,599 02/16/2016 03:29:32 am
Re: How to include checkbox in Table Pager (16 replies, posted in Banking and General Ledger)
As the db_pager_view.inc is a core file, modifying it may not be good. Checking the file that @joe suggested may be useful.
3,600 02/14/2016 06:26:16 pm
Re: Add_access_extensions() Function Call (3 replies, posted in Report Bugs here)
There are many places where the session.inc file is included but the add_access_extension() is not called.
Please use the "set_ext_domain()" function - see some extensions for examples like this. Even the logout.php file does not call the add_access_extension() function.
