Skip to main content
Solved

Which DAC/Table can get the Beginning Balance and Ending Balance of the Accounts by each day?


nhatnghetinh
Captain II
Forum|alt.badge.img+7

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

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. 

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img
  • Jr Varsity II
  • 25 replies
  • July 15, 2022

There is no DAC I am aware of that stores this information. You could create a SQL View and DAC using GLTran.


nhatnghetinh
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • 337 replies
  • July 16, 2022

Dear Concannon,

If you have this SQL View can you share it for me.

Thanks,

NNT


Forum|alt.badge.img+3
  • Pro II
  • 76 replies
  • Answer
  • July 17, 2022

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. 


Forum|alt.badge.img
  • Jr Varsity I
  • 37 replies
  • November 22, 2024
RoyceLithgo wrote:

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings