Summary trial balance report gives zeros for Opening balance, Net difference & Closing balance


AX users started getting zero balances under opening balance, Net difference & Closing balances in Summary trial balance report. It was working fine until few days ago. Clearing usage data every time before running the report helped for a while. Last night after deleting auc files for all users, it is not working any more even with clearing usage data.

I tried to redeploy the report, restart ssrs, restart AOS, clearing caches from each AOS. Please help!!