Hi we have experience an issue where some of the records - production orders in AX 2012 have found to be missing. We are running AX 2012 FP , SQL 2012 and Win 2012. It has been working fine in the last 3 months. We checked to see if there any log from AX server but none. I am trying to find out what would have caused this data loss from the SQL. Does AX archive these orders (say if they are ended) and move the records to another table? but they are seen in another test environment.
Is there a way to trace from SQL server? Any thoughts on this would be appreciated very much as we troubleshoot this issue
thanks a lot