We've deleted some lines in Dynamics AX 2009 from the INVENTTRANS table.
Now we have inserted the lines back via SQL from our backups and did some testing.
Then we also realised that some other tables were affected and we inserted missing lines for the Item in the following tables: INVENTTRANS, INVENTSETTLEMENT and INVENTSUM.
We realised that the Physical Stock by Stock Dimension report would not execute. It gives the following error:
"Cannot execute a data definition language command on On-hand stock periodic transactions (InventSumDateTrans). Parameter ID: , .
The SQL database has issued an error."
Please help. Which other tables would be affected and how can we be sure that we have solved the problem before we apply it to our live system?