My Oracle Support Banner

R12: AP: Tax Amount Is Calculated To 0 / Tax amount is not calculated correctly (Doc ID 2583221.1)

Last updated on SEPTEMBER 01, 2019

Applies to:

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

Symptoms

 PROBLEM DESCRIPTION
===================
R12: Incorrect Tax Amount / ROUNDING_LEVE:HEADER & ROUNDING_RULE:DOWN

When 0 < UNROUNDED_TAX_AMT of all invoice line < 1 or
-1 < UNROUNDED_TAX_AMT of all invoice line < 0,
Tax Amount is calculated to 0.

ACTUAL BEHAVIOR
---------------
Tax Amount is calculated to 0.

Tax amount is not calculated correctly.

EXPECTED BEHAVIOR
-----------------------
Tax amount is calculated correctly.

STEPS
-----------------------

Tax Rate 8%

1.Supplier : Tax Details

Rounding Level :Header
Rounding Rule: Down

Supplier Sites
Rounding Level :Header
Rounding Rule: Down

2.Create a invoice(Standard or Credit)

1)CREDIT memo
INVOICE_AMOUNT=-42
INVOICE_TYPE_LOOKUP_CODE =CREDIT
INVOICE_CURRENCY_CODE=JPY

AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM -6 <--UNROUNDED_TAX_AMT -0.48
2 ITEM -9 <-- UNROUNDED_TAX_AMT -0.72
3 ITEM -12 <-- UNROUNDED_TAX_AMT -0.96
4 ITEM -6 <-- UNROUNDED_TAX_AMT -0.48
5 ITEM -6 <-- UNROUNDED_TAX_AMT -0.48
6 ITEM -3 <-- UNROUNDED_TAX_AMT -0.24

2.Validate the invoice.
Tax Amount is calculated to 0.
AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM -6
2 ITEM -9
3 ITEM -12
4 ITEM -6
5 ITEM -6
6 ITEM -3
7 Tax 0 <--It should be -3

2)Standard Invoice
INVOICE_AMOUNT=42
INVOICE_TYPE_LOOKUP_CODE =STANDARD
INVOICE_CURRENCY_CODE=JPY

AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM 6
2 ITEM 9
3 ITEM 12
4 ITEM 6
5 ITEM 6
6 ITEM 3

2.Validate the invoice.
Tax Amount is calculated to 0.
AP_INVOICE_LINES_ALL
LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT
1 ITEM 6
2 ITEM 9
3 ITEM 12
4 ITEM 6
5 ITEM 6
6 ITEM 3
7 Tax 0 <--It should be 3

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
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.