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:
- 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.
- 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.
- 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.