Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Error while generating...
Finance forum

Error while generating "Report sales tax for settlement period"

Posted on by 670

Hi Champs,

I am trying to open the following report:

7360.11.png

But when I am trying to generate the report after inputting parameters, it is giving following errors:

5707.12.png

Error 1: An error occurred during the 'Format mapping' run. For more information, contact your system administrator.
Error 2: Excel file %1 is broken or has incorrect structure
Error 3: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> DocumentFormat.OpenXml.Packaging.OpenXmlPackageException: The specified package is invalid. The main part is missing. at DocumentFormat.OpenXml.Packaging.OpenXmlPackage.Load() at DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.Open(Stream stream, Boolean isEditable, OpenSettings openSettings) at Dynamics.AX.Application.OxmlSpreadsheetDocument_RU.`constructFromStream(Stream _stream) in xppSource://Source/ApplicationFoundation\AxClass_OxmlSpreadsheetDocument_RU.xpp:line 87 at Dynamics.AX.Application.OxmlSpreadsheetDocument_RU.constructFromStream(Stream _stream) at Dynamics.AX.Application.XMLExcelDocument_RU.`openDocument(Stream _stream) in xppSource://Source/ApplicationFoundation\AxClass_XMLExcelDocument_RU.xpp:line 425 --- End of inner exception stack trace ---
 
It seems that there is something related to setting up excel file mapping but I literally have don't any idea where to see its related configurations if there are any.
Any guidance will be highly appreciated.

Categories:
  • Error while generating "Report sales tax for settlement period"
    Hello, We are also getting the similar error
     
    We are at version 10.0.37 

    The report is for Belgium
     
    An error occurred during the 'Format mapping' run. For more information, contact your system administrator.
     
     
    Evaluating binding of format component Folder/VAT declaration preview (BE)/Group_OutgoingOperations/Box_00.
     
     
    Error while evaluating expression for path 'Boxes/Box_00'.
     
     
    Error while evaluating expression for path 'ReportFieldGroups/$00_ExemptSalesSpecialScheme/aggregated/TaxBaseAmountCur'.
     
     
    Error while evaluating expression for path '$ReportFieldClassifier'.
     
     
    Error while evaluating expression for path 'Lookups/$ReportFieldLookup'.
     
     
    No matched condition is found for Lookup based on format enumeration 'ReportField' in company 'e400
  • lauradownserp Profile Picture
    lauradownserp 10 on at
    RE: Error while generating "Report sales tax for settlement period"

    Hi,

    We're currently on 10.0.14, it seems to open for some users and other users get the same error messages as above, regardless of the security roles they possess.

  • Ramit Paul Profile Picture
    Ramit Paul 22,293 Most Valuable Professional on at
    RE: Error while generating "Report sales tax for settlement period"

    Hi,

    Which version you are using and getting this issue?

  • lauradownserp Profile Picture
    lauradownserp 10 on at
    RE: Error while generating "Report sales tax for settlement period"

    Hi,

    Did you find a solution for this in the end?

    Thanks.

  • Aman Bhatia Profile Picture
    Aman Bhatia 5 on at
    RE: Error while generating "Report sales tax for settlement period"

    Hi Ludwig,

    Could you please redirect me to the hotfixes that you have mentioned about.

    I am facing the similar issue for Norwegian entity, but unable to find the hotfixes.

    Thanks,

    Aman

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Error while generating "Report sales tax for settlement period"

    Hello,

    What D365FO version do you operate?

    If you are not on the latest one, please check the available hotfixes in LCS.

    I had a quick look and found some for version 7.3., 8.0 and even 8.1.

    Best regards,

    Ludwig

  • Ehtasham Rahman Profile Picture
    Ehtasham Rahman 670 on at
    RE: Error while generating "Report sales tax for settlement period"

    We are trying for UAE

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Error while generating "Report sales tax for settlement period"

    Hi,

    For which country did you setup sales tax?

    Can you share some details on your setup, tax configuration and tax recordings made?

    Many thanks,

    Ludwig

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans