GST: Incorrect Tax Populated on AR Invoice When Delivery Is Split during Sales Order Shipment (Doc ID 2898220.1)

Last updated on APRIL 03, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
On splitting the Delivery into multiple lines during Shipping, wrong tax amount gets populated on AR invoice. Tax from only one of the Delivery Detail line is being applied on AR invoice.

EXPECTED BEHAVIOR
-----------------------
The tax amount on AR Invoice should match with Tax amount on Delivery and should be consolidated by Delivery lines total when shipment is split into multiple lines.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create Sales Order with line item.

India Local Order Management->Oracle Order Management->Orders, Returns-> Sales Orders

2. Navigate to Tools-> India Tax details and apply the appropriate Tax.

Line quantity: 10
Price: 18
Line amount: 180
Tax amount: 32

3. Book the Order and Pick release it. At this step Delivery number is generated.

India Local Order Management->Oracle Order Management->Shipping-> Transactions

4. On Delivery details tab split the Delivery into two lines.

5. Ship confirm the Delivery and navigate to Tools-> India Tax details to review Taxes.

Observe that Delivery is split into 2 lines with individual Delivery detail ID and Tax lines.

Individual Delivery detail ID line total
Quantity: 5
Line amount: 90
Tax amount: 16

5. Run Auto-Invoice import and query the AR invoice at workbench:
India Local Receivable-> Oracle Receivables-> Transactions-> Transactions

Base transaction has correct line total: 180

7. Navigate to Tools-> India Tax details and review Tax details. Observe that Tax imported is wrong and does not match with Delivery Tax amount.

Line quantity: 10
Price: 18
Line amount: 90 (wrong, should be 180)
Tax: 16 (wrong, should be 32)

Changes

Cause

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