Hi all,
Getting below bug:
ORA-20105: Invoice.ACCERROR1: Error (The Currency Posting Amounts for the Invoice XXXXX are not Balanced) occurred while booking Invoice CR XXXXX
How to debug?
We had similar kind of error message, when IP postings were missing. IFS needed to correct those transactions.
Go to Customer invoices with errors, press F2, select the line and go to Postings. Then you can validate if you have IP postings or not.
Posting control is M34.
how to check it is correct or not?
How to correct transaction for M34.?
There should be also posting for Accounts receivable, IP4 and possible posting for Tax, IP2. If those are not there, then you should ask IFS to correct transactions.
For the particular invoice, M34 is there and account is product Revenue.
In accounting you need to have always two postings. Without IP4 there is no postings in accounts receivable and without IP2 there is no tax postings.
IP4 and IP2 is available in Posting control window.
But, IP4 and IP2 is need to be available in customer invoice posting analysis window under posting type column also?
If it is not means it will throw error?
sorry late answer.
If IP2 and and IP4 are entered in posting controls, those should be automatically created when customer invoice is printed. So for some reason, those postings are not now created, and your voucher is not in balance.
We have not find a way to solve those errors ourselves and IFS Finland has always solved those issues. If you have not yet created case to IFS, I would suggest you to do that.
Userlevel 5
+10
We have had these issues in the past and it required a Release from IFS Support to resolve.
As
BR, Lukasz
This error message is a very generic text - can occur for different kinds of reasons.
If you want to debug yourself, add 2 oracle triggers to the inv_accounting_row_tab table for the insert and update processes. Triggers’ purpose should be to print table amount columns and posting_type column into a trace table.
By doing so, you can monitor the values of IP2, IP4 and any other postings. Then you can compare the printed values with the actual values of the invoice - just to get an idea where the incorrect amount is.
But for an in-depth analysis as suggested already in previous comments, you will need to proceed for a LCS case.
Hope this helps.
/Nalaka
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.