My Oracle Support Banner

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 JANUARY 11, 2023

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.


“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:

  1. 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).
  2. Define (UDC 41/E) and Assign Commodity Codes (P744102).
  3. Attach the Shipping Commodity Class to the Item Master (P4101), via the Category Codes, Shipping Commodity Class (SHCM) for item.
  4. Define Nature of Transaction Codes (UDC 74/NT).
  5. Enter a sales order with 6 lines for different quantities and save.
  6. Open the order and cancel the last 2 lines. Note the total amount of the sales order.
  7. 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.
  8. 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.




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

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