Aging reports in AX 2012

Hi All,

I am getting this error on generating vendor aging and customer aging in my live environment for a particular time period.

"Cannot execute a data definition language command on Account totals (VendTmpAccountSum).

The SQL database has issued an error."

Kindly help ASAP .



Hi Kalpana,

Try to clear the user cache in the AX instance

  1. Stop AOS.

  2. Delete the .auc file from users\Appdata\ folder

  3. Restart AOS.



Just synchronize that table and open the table browser from AOT.

The error will be resolved.