Dear ALL,
Which DAC/Table can get the Beginning Balance and Ending Balance of the Accounts by each day ?
Many thanks !
NNT
Answer
Which DAC/Table can get the Beginning Balance and Ending Balance of the Accounts by each day?
+11Best answer by RoyceLithgo
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.
There is no DAC I am aware of that stores this information. You could create a SQL View and DAC using GLTran.
Dan
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.
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.
Is it possible for you to share your table relations? When I tried, it was duplicating the lines based on each transaction against the GL code.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.