E1: 74F: Discrepancy Between Intrastat Report - France – 42 (R0018IF) And Sales Order When Canceling Lines in the Order
(Doc ID 2920229.1)
Last updated on APRIL 04, 2025
Applies to:
JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
“Valeur fiscal (en Francs)” and “Masse Nette en KG” fields are incorrect calculated by R0018IF (Intrastat Report - France – 42) when there are canceled lines in the sales order. They include also the values from the canceled lines.
Steps to replicate:
- Set the Country (00/CN UDC table) in the Mailing Tab of the Address Book (P0101) records for the reporting company and the customer. These must also be listed in the Member States (74/EC UDC table).
- Define (UDC 41/E) and Assign Commodity Codes (P744102).
- Attach the Shipping Commodity Class to the Item Master (P4101), via the Category Codes, Shipping Commodity Class (SHCM) for item.
- Define Nature of Transaction Codes (UDC 74/NT).
- Enter a sales order with 6 lines for different quantities and save.
- Open the order and cancel the last 2 lines. Note the total amount of the sales order.
- Run Intrastats - Tax Update - Sales (R0018I1) process for this order. Notice that the information from all 6 lines of the sales orders will be transferred to the Intrastat Revision (F0018T) table even if 2 lines are canceled.
- Run R0018IF (Intrastat Report - France – 42) process, version XJDE0002 (French Intrastat – Exports). Notice that R0018IF displays incorrect values for “Valeur fiscal (en Francs)” and “Masse Nette en KG”. These values are calculated for all 6 lines of the order even if 2 lines are canceled.
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 |