Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Error Code posting sta...
Supply chain | Supply Chain Management, Commerce
Answered

Error Code posting statements

(0) ShareShare
ReportReport
Posted on by Afonso Rodrigues 205

Dear all

I hope this post finds you well.

I was trying to post several statements in D365 but I have encountered some errors in some statements. 

By looking at the error code message, I was able to figure out the source of most error. After fixing them, I clear those statements, I have calculated them again and post them after it. 

However, I still have 3 statements that I cannot post due to different reasons:

  1. One statement has the following error that I do not know how to fix: 

    "While processing the state Customer order created, generic exception encountered in retail statement XXXXX in the controller : Field Sales order must be filled in."

    UPDATE NOTE 2: I was able to fix this missing Sales Order error. I'm left with number 3 now.

  2. One statement cannot be fixed as I did before:

    "While processing the state Customer order created, generic exception encountered in retail statement XXXXX in the controller : The combination of Sales tax group XXXX and Item sales tax group XXXX is not valid since it doesn't result in a list of Sales tax codes. Please provide a valid combination of Sales tax group and Item sales tax group.
    Update has been canceled."

    This one is very odd, because I had this exact error in other statement and the way I fixed it is not "available" for this statement.
    The items in these transactions were specified with an incorrect Item Sales Tax Code, which is resulting in this error. I have already correctly specified the Item Sales tax Group which should now generate a correct Sales Tax Code. However, the systems seems to always "pull up" the original sales tax information with the previous incorrect Item Sales Tax Codes when I clear, calculate ant try to post the statement.

    When this error happened before I was able to manually fix this via Excel Add-in. For that, I went to "All Stores", I selected the respective store, clicked on the Excel button and select "Edit cash and carry transactions". However, if I try to do this now, there are no transactions lines in the Excel. In the "Stores Financials" form, I have zero "Cash and Carry Validation failures". 
    I think the difference from the other statement is that the error now is only at the statement level, and in the other one the errors were at the transaction level, which I don't quite understand.

    UPDATE NOTE: I was able to fix this Sales Tax Error. I'm left with number one and number 3 now. 

  3. One statement has an error that I know the source. I have already fixed it. However, I cannot clear this statement and, thus, I don't know how to "fix" the error in this particular situation. I think I cannot clear this statement because some of its transactions are already invoiced.

If someone can help with this error, or at least with part of them I would be very grateful.

Thank you all in advance.

  • Afonso Rodrigues Profile Picture
    Afonso Rodrigues 205 on at
    RE: Error Code posting statements

    Hi Ramune

    After enabling that parameter and since there were only a very small number of transactions which were generating the error, I temporarily define in the Accounts Structures to allow blank values for that particular Financial Dimenion.

    The statement was posted successfully now.

    Thank you very much for your help.

  • Verified answer
    Ramune Profile Picture
    Ramune on at
    RE: Error Code posting statements

    Hi Pedro,

    Do you mean this one link you used to correct dimensions in excel?

    docs.microsoft.com/.../edit-financial-dim

    Do you have the parameter 'Recalculate financial dimension on error' enabled in Commerce parameters/Tab Posting/section Statement?

    pastedimage1617270132717v1.png

    If yes, is the same parameter enabled on your statement which you are trying to post? The field might be hidden, so add field to the form be sure it is enabled on statement as well.

    If this will not help, please create support request for us to investigate deeper.

  • Afonso Rodrigues Profile Picture
    Afonso Rodrigues 205 on at
    RE: Error Code posting statements

    Hi Ramune, thank you for your answer.

    The error that I got is related to missing financial dimension values, that should have been defaulted on the items.

    I already edited the items so that the proper financial dimension value is set.

    I also edited the error transactions through Excel Add-in so that they contain the financial dimension value.

    I now needed to clear the statement, so that I could calculate it again and poste it. If i try to post it without clearing it first, it does not assume the changes that I have done, thus maintaining the errors.  

  • Suggested answer
    Ramune Profile Picture
    Ramune on at
    RE: Error Code posting statements

    Hi Pedro,

    Regarding:

    "3. One statement has an error that I know the source. I have already fixed it. However, I cannot clear this statement and, thus, I don't know how to "fix" the error in this particular situation. I think I cannot clear this statement because some of its transactions are already invoiced."

    If there are some invoiced transactions, then to clear the statement is not allowed.

    Why do you need to clear statement? What exactly error do you get?

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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans