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 .

Regards,

Kalpna

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.

Regards,

Balakumar

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

The error will be resolved.