R12: AP/ZX: Tax Line Amount is Not Calucalated as Expected Amount When Using Control Amount
(Doc ID 2556235.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
When using CONTROL_AMOUNT in invoice header, one of tax line is not calculated as expected amount.
Invoice is created with Tax Rate 8% and CONTROL_AMOUNT 79 JPY like below.
Amount: 1041 JPY
Tax Control Amount: 79 JPY
Line #1: 251 JPY
Line #2: 250 JPY
Line #3: 231 JPY
Line #4: 230 JPY
Item Lines Total: 962 JPY
When Control Amount field is entered for an invoice, the tax rounding rule is recorded as 'NEAREST' regardless of the Rounding Rule setup.
And the tax amount(UNROUNDED_TAX_AMT) is calculated as ( LINE_AMT * (CONTROL_AMOUNT / LINE_AMT )).
Hence, as per the above rule, tax lines should be calculated with NEAREST rounding rule like below.
|Line||LINE_AMT||( LINE_AMT * (CONTROL_AMOUNT / LINE_AMT ))||UNROUNDED_TAX_AMT||Rounded Tax Amount (NEAREST)|
However, actually those tax lines are created in ZX_LINES and Tax distributions with the following amount.
Tax Line #1 20 JPY
Tax Line #2 21 JPY
Tax Line #3 19 JPY
Tax Line #4 19 JPY
Why the tax amount for Line #1 is calculated as 20 JPY which is different from expected amount: 21 JPY.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document