My Oracle Support Banner

R12: AP/ZX: Tax Line Amount is Not Calucalated as Expected Amount When Using Control Amount (Doc ID 2556235.1)

Last updated on JANUARY 30, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When using CONTROL_AMOUNT in invoice header, one of tax line is not calculated as expected amount.

Example)
Invoice is created with Tax Rate 8% and CONTROL_AMOUNT 79 JPY like below.


Invoice Header
  Amount:                          1041 JPY
  Tax Control Amount:      79 JPY

Invoice Lines
   Line #1:    251 JPY
   Line #2:    250 JPY
   Line #3:    231 JPY
   Line #4:    230 JPY
   Item Lines Total: 962 JPY

Reference: Doc ID 2415372.1
  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)
1 251 251*(79/962) 20.612266... 21 JPY
2 250 250*(79/962) 20.530146... 21 JPY
3 231 231*(79/962) 18.969854... 19 JPY
4 230 230*(79/962) 18.887734... 19 JPY


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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.