Rounding Issue Occurs During Calculation of Tax While Posting a Debit Memo
(Doc ID 2419208.1)
Last updated on JULY 06, 2018
Applies to:Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.
Rounding issue occurs during calculation of tax while posting a debit memo.
Due to this, Total Amount and Total Tax displayed in Retail Invoice Matching System(ReIM) UI is different from the amounts posted to AP stage tables.
Steps to Recreate:
1. Create a debit memo with decimal values (preferably as follows):
Item1 - Qty: 2930, Cost: 2930 * -126.16 = -369648.80
Item2 - Qty: 1220, Cost: 1220 * -245.34 = -299314.80
Total Cost: -668963.60
Tax Rate: 7%
Total Tax: 7% of -668963.60 = -46827.45
Total Cost inc Tax: -715791.05
2. Run reimposting batch and notice that Tax and Total Amount are posted incorrectly as follows:
Total Amount: -715791.06 instead of -715791.05
TAX: -46827.46 instead of -46827.45
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!