Which DAC takes the data of the accounts of full periods of the year?

  • 23 June 2022
  • 2 replies

Dear ALL,

Please help me to know which DAC takes the data of the accounts for all periods of the year (Period 1 to Period 12).

This DAC will have Fin.BeginingBalance, Fin.PTD Debit, , Fin.PTD Credit, Fin.YtdBalance,.. almost like DAC GLHistory. But the DAC GLHistory is missing periods where there are no transactions.

Many thanks !



2 replies

Userlevel 5
Badge +3

@nhatnghetinh This DAC and Table would have records for any period with at least one posted transaction otherwise the would be no records for that finperiod.

However, you can do a Left join with FinYear DAC and use formula for fields you need to show 0.00 if NULL. This way you would see all FinPeriods even if they are 0.00 Db and Cr with no Activity.

Dear @hkabiri

May I ask which FinYear DAC to use in the list as shown in the picture?

Many thanks !




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 — 2020  Acumatica, Inc. All rights reserved