Dear ALL,
Which DAC/Table can get the Beginning Balance and Ending Balance of the Accounts by each day ?
Many thanks !
NNT
Best answer by RoyceLithgo
View originalWhich DAC/Table can get the Beginning Balance and Ending Balance of the Accounts by each day?
There is no DAC I am aware of that stores this information. You could create a SQL View and DAC using GLTran.
I built a GI that does this - basically it combines monthly ledger with journals lines to get you balances as at whatever date you want.
It’s quite a complex query however and it currently only supports P&L.
I used GLHistory for the ledger part and GLTran for the journals.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.