Wednesday, 22 August 2018

Clear Statement and Calculate Statement Buttons Disable in Retail Statement

If you are stuck in previously Calculated Statement, in ribbon tab showing Clear Statement and Calculate Statement Buttons Disabled as below











Resons:- When a statement posting fails, the expectation would be that the statement postings are rolled back and the statement returns to its original calculated state.  What is actually occurring is that the statement stops where it is and doesn’t completely roll back.
Some of those Sales Orders may have already been created and are still linked to the statements transactions. 

Solution :- Run Below Query into the AX database into the SQL 

select POSTINGDATE, * from RETAILSTATEMENTTABLE where STATEMENTID = '002-000009'
update RETAILSTATEMENTTABLE set POSTINGDATE = '' where STATEMENTID = '002-000009'

1 comment:

  1. I had done same but still its not allowing me to clear the statement, I am using Ax2012 R3

    ReplyDelete