My Oracle Support Banner

E1: 74: Additional Functionality for Intrastats-Tax Update-Purchasing (R0018I2) to Declare Intrastat Based On the VAT Period (Doc ID 2871301.1)

Last updated on MAY 20, 2022

Applies to:

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


Legislation provides member states flexibility in deciding whether to declare the Intrastat movement either in the period the goods are physically (PO Receipt) moved or in the chargeable VAT period (PO Vocuher).

Currently, the JDE Intrastat functionality is driven by the Purchase Order receipt which aligns with the ‘basic’ principle of when the goods are ‘moved’. There is no flexibility to enable the use of either the Purchase Order Receipt amount (F43121.MATC = ‘1’ with F43121.AREC) or the Amount Paid to Date (F43121.MATC = ‘2’ with F43121.APTD). If the data selection of UBE (R0018I2) Intrastat Tax Update – Purchasing is based on the PO Voucher (F43121.MATC = ‘2’) (to align with the VAT reporting period) the amount populated in the Intrastat Work file (F0018T) is still the PO Received amount (F43121.AREC) and not the PO Amount Paid to Date(F43121.APTD) ignoring the fact the  PO Voucher (F43121.MATC = ‘2’) is selected.   

National requirements for the Intrastat system — 2021 edition, Section 3.1.1 (pg 14) The Reference Period statement: The reference period for the information to be provided within the Intrastat system shall be the calendar month of export or import of the goods. This is the month in which the goods physically enter or leave the statistical territory of the reporting Member State. Alternatively the Member States may define the reference period to which the monthly trade flows should be allocated as the calendar month when the chargeable event for VAT purposes occurs.


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.