How can we allow both Purchaser and sellers' LE to search Intrastat transactions?

Phil Qin

Hi

Since we have business between EU Country So there will be Intrastat Transactions in system. The customer will purchase goods from DE BU but shipped from the Warehouse (location in Netherland) belongs to UK. There are intercompany transactions between UK an DE and also external Transactions between DE and customer.

For this scenario, we have developed a custom Intrastat report based on Oracle standard Intrastat report process. So, the Oracle background table “JMF_IN_STATISTICS” is used as many fields source. Currently we can only get the data from UK legal entity since there isn't DE Intrastat Transactions in the Oracle background table “JMF_IN_STATISTICS”.

Could you please help provide the method how can we get the Intrastat transaction from DE in the Oracle background table “JMF_IN_STATISTICS”? Since it is the transaction between UK and DE, so we also want to get Intrastat Transactions under Legal Entity DE. But in our system, we can only get the Intrastat Transactions from UK.

Intrastat Report Setup for FR & NL.docx

I have also updated the attachment of configuration for your reference.

Phil Qin