Hello Everyone,
AP Invoice posted and ends up with review journal whereas Debit and Credit match correctly. However, I have been encountering this problem.
Hello Everyone,
AP Invoice posted and ends up with review journal whereas Debit and Credit match correctly. However, I have been encountering this problem.
Yes, that is correct.
@sk.patchai
Try below mentioned 2 setup, it might work.
In the company configuration
Finance -> Accounts Payable -> Rounding
This should be true
Try matching a GL account for “Rounding”
we already enabled this setup but still its ends up with review journal.
Currency Master also i set the tolerance and we have one book in the book also i mentioned the tolerance.
@sk.patchai
Could you check what is difference between the total of the line amount in AP invoice and Review general (4789.996).
The error comes from a difference between APInvDtl amounts and APInvExp/APInvJob amounts depending on the type of line.
There are some other factors like non deductible taxes and advance payments but the basic formula seems to be:
Line Net = APInvDtl.DocExtCost + APInvDtl.DocTotalMiscChrg
Dist Total = Sum of APInvJob.DocExtCost or APInvExp.DocExpAmt (Depending on the type of line)
If these two amounts are different you get the above error.
Which ERP version are you using?
I see that in that version the amount comparison was made using base currency instead of document currency, there might be some rounding issues between the line net amount and the sum of related records.
I suggest you contact support to track this properly.