Solved

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

  • 15 July 2022
  • 3 replies
  • 167 views

Userlevel 6
Badge +3

Dear ALL,

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

Many thanks !

NNT

icon

Best answer by RoyceLithgo 18 July 2022, 00:18

View original

3 replies

Userlevel 2
Badge

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

Userlevel 6
Badge +3

Dear Concannon,

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

Thanks,

NNT

Userlevel 5
Badge +2

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


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved