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:
Oracle Financials for India - Version 12.2 and laterInformation in this document applies to any platform.
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
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 |