Cannot create record in Dimension history for documents (InventReportDimHistory). Type: None. The record already exists. in AX 2012

During the time of Invoice posting I got some error based on the table. Then i realized the solution.
Error: Cannot create record in Dimension history for documents (InventReportDimHistory). Type: None. The record already exists.
Reason: When you are making any entries in case of any mistakes if you done during the Posting of any transaction you may get this type of error Infolog may display on your screen. So once if you got this type of message you cannot do another transition based out of this same like that. First of all, you need to solve this issue, for that below steps might solve the solution for you.


Solution:
Initially read that error message and from there you will get the Table name from there. If you got that exact table name, then probably the issue has been solved.

Now go to the error table InventReportDimHistory, there you need to delete the lines which is having the quantity “0” in that table. Then make the transaction once again, should be you must get the result.

No comments:

Post a Comment