web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Intrastat reporting (i...
Small and medium business | Business Central, N...
Suggested answer

Intrastat reporting (in Germany) BC 24.3

(4) ShareShare
ReportReport
Posted on by Mo93 8
Hello,
 
We are using BC 24.3, and we have Intrastat DE 24.3 and Intrastat Core 24.3 installed.
I created a test file (XML) for Intrastat reporting in Business Central and submitted it.
We then received feedback about what still needs to be corrected.
One error was: No invoice amount is to be specified for the type of transaction used. Please check the type of transaction used and the reported invoice amount.
I posted a sales credit note with type of transaction 21, in this case no invoice amount is to be specified, but the statistical value in euros is to be specified.
In BC on the Intrastat report card (Page: 4812) I clicked on Suggest lines, then the line was created and the invoice amount was also entered.
I was wondering whether I should add a button to the Intrastat report card.
For example: If type of transaction = 21,22,..., then clear the amount column, but in this case the statistical value column will also be cleared, which would also be wrong.
The XML file is created using the data exchange definitions, can we filter it, and if so, how?
Actually, this should all be standard, I don't know if I'm doing something wrong or overlooking something.
 
I hope you can help me.
 
Thank you in advance.
 
Regards
Mo
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,201 on at
    Intrastat reporting (in Germany) BC 24.3

    Hello,

    Thank you for your detailed explanation.

    The issue you're encountering—where an invoice amount is incorrectly included for transaction type 21 in the Intrastat XML file—is related to how Business Central handles Intrastat reporting logic for specific transaction types. According to German Intrastat requirements, for transaction types such as 21 (returns), the invoice amount should not be reported, but the statistical value must still be included.

    Recommendations:

    1. Review Data Exchange Definitions
      Since the XML file is generated via Data Exchange Definitions, you can apply filters or transformation rules to exclude the invoice amount for specific transaction types. This may require:

      • Customizing the mapping logic.
      • Adding conditional filters based on the transaction type.

    2. Avoid Clearing Statistical Value
      If you implement a button or logic to clear the invoice amount on the Intrastat report card, ensure that it does not also clear the statistical value, as this would violate reporting requirements. You may need to separate the logic for each field.

    3. Custom Field Handling via AL Code
      If standard functionality does not support this behavior, consider a custom AL extension that:

      • Detects transaction types 21, 22, etc.
      • Clears only the invoice amount field.
      • Preserves or recalculates the statistical value as needed.

    4. Consult Localization Documentation
      Review the German localization documentation for Intrastat reporting in BC 24.3 to confirm the expected behavior for each transaction type. Microsoft may have provided guidance or updates specific to this version.

    5. Feedback to Microsoft
      If this behavior is not aligned with standard requirements, consider submitting feedback or a support request to Microsoft, as it may require a correction in the localization package.

    Please verify if this response was helpful.
    Best regards.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,511 Super User 2025 Season 2 on at
    Intrastat reporting (in Germany) BC 24.3
    Hi,
    most likely Intrastat Core is generating the journal lines, and is generating all fields there for the needs also for other countries.
    You should check just the reporting (export to XML file).. could be there is a setup somewhere (either when running report, or maybe in Intrastat Setup page) that can change the behavior of the Amounts provided based on transaction type.
     
    If different reporting has to be done based on transaction types, would be logical if in the Transaction Type list there would be a checkmark if this transaction type should or should not show amount/statistical amount only... 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,899 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,444

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,304

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans