Intrastat reporting depends heavily of how properly users enters data into system, starting from master data (items/customer/vendor) setup and ending with actual transactions posting. If anything will be posted incorrectly, preparation of Intrastat journal can be challenging and in standard, there little to no possibility to enforce some policies on users. Intrastat Report Setup is a good start, but we need to add more control features, as there are many controls we need to have on document lines. So, to have proper Intrastat Reports we need to have the following setup, so we can prevent posting documents if the following information are missing:
• Tariff No. Mandatory – If a checkmark is inserted in this field, the system checks during posting whether the Tariff No. field has been filled in sales, purchase and transfer documents. After posting these documents, the entries will be created in the Item Ledger Entries or Job Ledger Entries tables.
• Net Weight Mandatory – If a checkmark is inserted in this field, the system checks during posting whether the Net Weight field has been filled in sales, purchase and transfer documents. After posting these documents, the entries will be created in the Item Ledger Entries or Job Ledger Entries tables.
• Country/Region of Origin Mand. – If a checkmark has been inserted in this field, during posting the system checks whether the Country/Region of Origin Code field has been filled in sales, purchase and transfer documents. After posting these documents, the entries will be created in the Item Ledger Entries or Job Ledger Entries tables.
Keep in mind these controls have to exist only if this is Intrastat compliance transaction. That means the followinhg:
• Country Code in Compamny Information is one of EU countries.
• If sales, the location country code must be the same as on Company Information or blank and customer must (ship-to address) be in other EU country.
• If purchase, the vendor must be in other EU country and the location must be wiith the country code the same as on Company Information or blank.
Business Central Team (administrator) on 2/23/2025 9:29:57 AM
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team