Understanding Work Table Generation for Intrastat
Intrastat reporting is based on the Intrastat Revision table (F0018T). This workfile is populated with information from the JD Edwards EnterpriseOne Sales Order Management, JD Edwards EnterpriseOne Procurement, and other systems. You run Intrastat reports based on the company's sales and procurement transactions for the reporting period. When you do this action, the update process writes all of the required information from the tables in the JD Edwards EnterpriseOne Sales Order and JD Edwards EnterpriseOne Procurement systems to the F0018T table.
This table shows the programs you use to update the F0018T table:
Program |
Description |
|---|---|
Intrastat Workfile Generation - Sales (R0018I1) |
Updates the F0018T table with sales information based on these tables:
|
Intrastat Workfile Generation - Procurement (R0018I2) |
Updates the F0018T table with purchase information based on these tables:
|
In addition, the update programs collect information from these tables:
Intrastat Supplier/Item Cross Reference Table (F744101).
Inventory Constants (F41001).
Business Unit Master (F0006).
Company Constants (F0010).
Currency Codes (F0013).
Currency Restatement Rates File (F1113).
Item Master (F4101).
Item Branch File (F4102).
Address Book Master (F0101).
Address by Date (F0116).
Order Address Information (F4006).
Item Units of Measure Conversion Factors (F41002).
Unit of Measure standard conversion (F41003).
User-Defined Codes (F0005).
When you run the update programs, you use processing options and data selections to select transactions that are based on a number of different criteria in the sales and procurement tables. Depending on the structure of the company and country-specific reporting requirements, you can specify that the system write records at cost, cost plus markup, or at the taxable purchase price. If you want to report the quantity actually shipped rather than the quantity ordered, you can use data selection to select order lines from the sales and procurement tables that are based on the order activity rule that corresponds to the shipped status. The system verifies that the transactions meet the selection criteria and qualify for Intrastat reporting before writing the required information from the sales and procurement tables, and any other applicable information from the additional tables, to the Intrastat Revision table.
To ensure that table F0018T contains the most current information, you should periodically update the information in table F0018T. The update program for sales accesses the detail for the sales transactions in table F4211. If you automatically purge the sales details to the Sales Order History File table (F42119) when you run the Sales Update program (R42800), run the Intrastat generation program for sales after you confirm shipments and before you update sales information. You should update table F0018T at least once per reporting period, after all sales order and purchase order transactions are entered and finalized.