@dvarsani
You can just overwrite your existing files with the 2.3.20 tarball. Maybe @apmuthu has diff files for you. I hope he will comment on this.
Joe
1,652 03/10/2014 11:33:28 am
Topic: Release 2.3.20 (9 replies, posted in Announcements)
Announcement
This is a 2.3.20 security & bugfix release.
Important Note for release 2.3.20.
Warning:
This version consists crucial security patches, so all FA users running any earlier 2.3.x application version are encouraged to update their installations to version 2.3.20 as soon as possible. This applies especially to all installations which are run in not fully trusted environment like public demos, shared accounts or SAAS installations.
Common
Allowing more than one document attachment per number.
Voiding an allocated currency invoice doesn't clear Exchange account
Fixed a check that company logo exists when using header3.
Fixed security issues in file uploads.
Gettext template update.
Sales
Fixed back link presented when trying to modify fully invoiced Customer Delivery.
Link customer payment entry after saving Invoice (if not cash).
Purchasing
Supplier Payments: Fixed error during payment allocation in strict MySQL mode.
Fixed bug in Supplier Credit Note allocation to Purchase Invoice.
Supp credit notes should not be shown in allocable list.
Items and Inventory
Fixed inventory valuation bug after voiding foreign supplier GRN leading to negative inventory.
Inventory Items Movements always starts with 0 qty. Fixed.
Banking and General Ledger
Payments, Deposits: fixed false error when payment is made in customer/supplier currency.
Journal Inquiry (bank transaction view): fixed database error on bank transaction view triggered on some buggy MySQL versions.
Avoiding redundant passes in Fiscal Year deletion.
Supplier info not shown on gl inquiry for bank account.
If no memo on GL line in GL account inquiry, the comments for the voucher is shown on the line.
1,653 03/10/2014 07:03:27 am
Re: I need to re-arrange the Account Groups/Classes. How do I do that? (7 replies, posted in Banking and General Ledger)
Did you also change these account types in the Accounts?
/Joe
1,654 03/08/2014 08:01:50 pm
Re: Bank Account Transfers with different currencies (2 replies, posted in Banking and General Ledger)
This is the exact foreign amount to enter here. This is to avoid rounding errors.
Joe
1,655 03/07/2014 03:55:03 pm
Re: Emailing function on localhost - Centos (1 replies, posted in Reporting)
FA uses the built-in PHP mail and it might not work on localhost.
Joe
1,656 03/06/2014 05:12:42 pm
Re: Settled amount have to be positive number. (10 replies, posted in Banking and General Ledger)
Oh boy, I think I know what the problem is here.
We had resently a nasty bug in the file /gl/gl_bank.php.
Please go to this link.
Press download this file and after that, replace the file in /gl folder.
Then everything should work.
Joe
1,657 03/06/2014 09:19:47 am
Re: Different users are trying to use the same invoice number (6 replies, posted in Accounts Receivable)
Oh yes, this should work but I am not sure about how this works technically. Please wait for Janusz comments.
1,658 03/05/2014 02:14:37 pm
Re: payed invoices stay ind overdue list (5 replies, posted in Accounts Receivable)
ok, thanks. I will investigate further.
/Joe
1,659 03/05/2014 11:33:05 am
Re: payed invoices stay ind overdue list (5 replies, posted in Accounts Receivable)
Please look into the table X_debtor trans, where X is the client number. Look if the invoice total is equal to the allocated.
Joe
1,660 03/05/2014 11:30:13 am
Re: Accounts classes in en_AU-0000.sql (Australian company) (1 replies, posted in Misc. Charts of Accounts)
You should set the account types (groups) for equity to be of your class Equity.
Joe
1,661 03/05/2014 10:45:48 am
Re: payed invoices stay ind overdue list (5 replies, posted in Accounts Receivable)
Are there some rounding problems?
Joe
1,662 03/04/2014 08:52:04 am
Re: Using FIFO and LIFO in Frontaccounting (3 replies, posted in Items and Inventory)
FA doesn't use FIFO or LIFO. FA uses average material costs.
Joe
1,663 03/03/2014 12:54:35 pm
Re: Settled amount have to be positive number. (10 replies, posted in Banking and General Ledger)
Hello again.
I don't know how to help you with this. I hope somebody using UTF8 out there will help us on that.
/Joe
1,664 03/02/2014 02:10:02 pm
Re: Settled amount have to be positive number. (10 replies, posted in Banking and General Ledger)
I am not sure. Did you enter the amounts with an initial minus sign? All amounts should be entered positively. FA handles the sign internally.
Joe
1,665 03/01/2014 11:30:43 am
Re: Different users are trying to use the same invoice number (6 replies, posted in Accounts Receivable)
Earlier we had an automatic updating of the next reference number but this was removed for some reason I cannot recall.
Maybe Janusz can tell.
Joe
1,666 03/01/2014 07:19:54 am
Re: Australian BAS Report (11 replies, posted in Reporting)
Regarding the built-in Tax Report, FA is supporting all the tax types, including 0% tax on the report. The outputs and inputs are also given as well all the sales/purchases transactions in the selected period.
In the Company Setup you can set how many months shouldbe included in the report and in which months the report should end.
These info will be used as default date selectors when doing the Tax Report.
Due to that almost all countries has its own way of tax reporting, you will have to create a custome report to support your needs.
But you have all the information that is needed in the built-in report.
/Joe
1,667 03/01/2014 05:35:47 am
Re: Instructions (23 replies, posted in Misc. Charts of Accounts)
1. You just upload it to the /company/X/backup folder, where X is your company number.
Make a search and replace of the table prefix, f.i. If the table prefix in the COA is 0_ then replace it with table prefix for your existing company.
Restore this backup on your existing company.
Remember to take backups before acting.
Joe
1,668 02/28/2014 07:48:33 pm
Re: How to Treat an Item which is manufactured and purchased (1 replies, posted in Manufactoring)
There should be no problems purchasing a manufacturing item. Try it out on the Training and or the demo site.
Joe
1,669 02/24/2014 05:38:43 pm
Re: Account tags (1 replies, posted in Banking and General Ledger)
You can use in in the balance sheet or profit & loss statements.
Joe
1,670 02/24/2014 10:17:02 am
Re: Direct Invoice allocates a Cash Receipt Automatically (1 replies, posted in Accounts Receivable)
This is done, when the payment terms is Cash.
/Joe
1,671 02/23/2014 10:21:19 am
Re: Remove Inventory (1 replies, posted in FA Modifications)
Create one Service item, f.i. - as id (or something else) and Service as description. Let the service item description be editable.
Everytime you invoice and go to the item description you can enter your own description. If you enter more item lines, Ignore the warning that the item is already on the invoice.
/Joe
1,672 02/22/2014 07:21:00 am
Re: Receipt in foreign currency (2 replies, posted in Accounts Receivable)
You can accept payment in whatever currency the bank account has, despite the customer currency.
But if the customer is set to use USD, your receipt is always created in USD, even if he pays in CAD.
Joe
1,673 02/21/2014 04:13:36 pm
Re: Cash Flow Statement (28 replies, posted in Banking and General Ledger)
Hello again sealhawk,
I have now made a first draft of the Cash Flow Statement according to your advice. At this stage I have made it as a custom report.
The selection periods are slightly different from your approach. I have made the same selection as the detailed break down reports.
Please download the attached zip file. Unzip it in the modules folder. You will then have a folder called rep_cash_flow_statement.
Go into FA and move to Setup tab, select the install/activate extensions. Select the rep_cash_flow_statement.
After that you must activate it for the Company you are working on.
Now the report should show up in the Banking Reports.
Tell me if we are on the right way 
/Joe
1,674 02/20/2014 09:50:57 pm
Re: Type in Void a Transaction not in alphabetic order (1 replies, posted in Setup)
They are sorted in an internal number order. This way they are presented in sales - purchasing etc.
Joe
1,675 02/19/2014 09:47:58 pm
Re: Recapitulative Statement Report (5 replies, posted in Reporting)
But the printed tax report lists all tax invoices, both for sales and purchases.
Joe