Skip to main content
Question

Intrastat report generation misleading

  • 5 September 2024
  • 1 reply
  • 33 views

Hello everyone.

 

The IFS standard way of getting the information for the intrastat reporting is to retrieve the data (including the statistical data, amounts...) from the orders ; customer orders and purchase orders.

 

Two clients of us told us the legal requirement was that the report should be based on invoiced articles (and not ordered ones).

 

Did you encounter this question? 

If so, did you manage to find a workaround?

 

Kind regards,

Sara

Hi @Sarabonncleret 

Possible Workarounds:

  1. Custom Reports via Data Migration/Custom Fields: One solution would be to create a custom Intrastat report that fetches data from the invoicing tables instead of the order tables. You could link invoiced articles, quantities, and amounts through custom fields or data migration jobs. This may require SQL queries to access the right tables for invoiced items.

  2. Use of IFS Business Reporter: If you are using IFS Business Reporter, you could configure a specific report layout to pull invoice data for Intrastat, adjusting the standard report to meet legal requirements.

  3. Manual Adjustments: Some users opt to extract the data from IFS (order-based) and adjust it manually with invoiced information before submission.


I'm happy to share my advises on this. If you found the answer helpful, could you please mark it as the correct answer? This will allow us to close the thread and make it easier for other community users to find and benefit from in the future.
 

Regards,

Chanuka


Reply