Skip to main content

Dear ALL,

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

Many thanks !

NNT

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

Dear Concannon,

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

Thanks,

NNT

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.

Reply


Terms & ConditionsCookie settings
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