Intrastat - Wrong Amount Calculation
Last updated on JANUARY 02, 2018
Applies to:Oracle Supply Chain Globalization - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Inventory Transactions
Intrastat - Wrong amount calculation
We have an issue with the Intrastat, for the IR-ISO shipment. We have the IR and ISO created in Eaches and the shipment and the receipt is done in CTN UOM, where we have an UOM conversion setup for the item.
Now for this transaction, the Intercompany Invoices are created in Eaches.
But the issue is that for the Intrastat transactions, it uses the "CTN" from the material transaction and the unit price from the Intercompany invoice, and hence cause the issue.
The material transaction is in CTN, while the Intercompany Invoice is in EA. The system does not convert the unit price in EA to CTN before getting the amount.
Expect the system to convert the unit price in EA to CTN before getting the amount.
The issue can be reproduced at will with the following steps:
1. Create IR / ISO. ISO with UOM Each
2. Shipment and Receipt to be done in CTN
3. Intercompany Invoices are created in Eaches.
4. Run Movement statistics processor > Check Intrastat > System uses the UOM "CTN" from the material transaction and the unit price from the Intercompany invoice for Each.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms