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 originalDear 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 originalThere 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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.