Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / UK MTD VAT 100 report ...
Finance | Project Operations, Human Resources, ...
Suggested answer

UK MTD VAT 100 report GER file not generating and giving error

(0) ShareShare
ReportReport
Posted on by FaizM 30

Problem: VAT 100 excel report not generating and error is shown as below An error occurred during the 'Format mapping' run. For more information, contact your system administrator.Message details Evaluating binding of format component Excel/TaxReport_UK.Report/Box_1. Evaluating expression for path 'Box values/$VatDueSales'.   

Steps:


1) All setups for UK MTD in web applications completed and access token is generated successfully and GER configurations for UK MTD completed successfully
2) Importing of MTD configurations with setup file from LCS has been imported from Data management
3) VAT return submitted from Electronic messages screen successfully
4) However in the VAT return submission to HMRC process,  the step for previewing the VAT return in VAT100 format gives an error. The same error can be got by opening the VAT 100 report from Tax > Inquiries and reports > VAT inquiries > VAT payments. 

pastedimage1680689690887v1.png

Resolution needed: Error to be fixed, so that user can preview the VAT 100 report before submitting the return to HMRC

  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    RE: UK MTD VAT 100 report GER file not generating and giving error

    Hi Mansoor,

    I'm glad your problem has been solved and thank you for sharing.

    Best Regards, 

    Hana

  • Suggested answer
    FaizM Profile Picture
    FaizM 30 on at
    RE: UK MTD VAT 100 report GER file not generating and giving error

    Thanks Arcadi for responding, as mentioned I had to remove all references to the VAT100 excel GER configuration and then delete it completely. A fresh import of the GER config resolved the issue.

  • Suggested answer
    FaizM Profile Picture
    FaizM 30 on at
    RE: UK MTD VAT 100 report GER file not generating and giving error

    Thanks Hana, the application parameters had been setup according to the documentation on Learn. I eventually had to log a support ticket with MS and the support engineer deleted the VAT100 excel GER configuration completely and then we reimported it again. It seems to have resolved the error and now the return in excel opens without errors.

  • Suggested answer
    Arcadi Profile Picture
    Arcadi 786 on at
    RE: UK MTD VAT 100 report GER file not generating and giving error

    In ER there's a form (Application specific parameters) and it's usually used by tax reports to link tax codes with an enum.

    To find it go to the ER workspace, select the first tile to go to the list of all ER nodes and select your format. At the top Configurations > Application specific parameters > Setup

  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    RE: UK MTD VAT 100 report GER file not generating and giving error

    Hi Mansoor,

    Before you start to generate the VAT 100 report, make sure that the following prerequisites are in place in your system.

    1. Import the following electronic reporting (ER) configurations.
    2. The ReportFieldLookup application-specific parameters is set up for the VAT Declaration Excel (UK) format in ER.
    3. In the Feature management workspace, find and select the VAT statement format reports feature in the list, and then select Enable now.
    4. To define the VAT Declaration Excel (UK) format, go to Tax > Setup > General ledger parameters. On the Sales tax tab, in the Tax options section, in the VAT statement format mapping field, enter the format information.

    According to the screenshot you provided, the hint to the error “application specific parameters setup is not completed for the uk02 company” seems to be that you need to check your application-specific parameters.

    More details found for you are in the links below, you can check it.

    Generate a VAT declaration in paper format (VAT 100 report) - Finance | Dynamics 365 | Microsoft Learn

    Prepare your environment to interoperate with HMRC's MTD VAT web service - Finance | Dynamics 365 | Microsoft Learn

    Best Regards,

    Hana

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

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,099 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans