Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

(1) ShareShare
ReportReport
Posted on by Afonso Rodrigues 215

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.

  • CU10050454-0 Profile Picture
    CU10050454-0 2 on at
    Error Code posting statements
    Thank you for your update. It’s great to hear that you were able to identify and resolve most of the posting errors in D365 by reviewing the error codes and reprocessing the statements. As for the remaining issue with the specific error message regarding the "Sales order" field, it seems the system is expecting a linked sales order that hasn’t been properly assigned or created. You may need to check if the customer order is fully processed and that the sales order has been generated and linked correctly in the system. Let me know if you need help investigating this further. telelatino
  • Abdulla Magdy Profile Picture
    Abdulla Magdy 48 on at
    Error Code posting statements
    Thank you Ramune
  • Afonso Rodrigues Profile Picture
    Afonso Rodrigues 215 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 215 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

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Zain Mehmood Profile Picture

Zain Mehmood 241 Moderator

#2
Siv Sagar Profile Picture

Siv Sagar 111 Super User 2025 Season 1

#3
Danny Bilodeau Profile Picture

Danny Bilodeau 95 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans