Skip to main content

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 !

NNT
 

 

@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 !

NNT

 

Hi @nhatnghetinh - were you able to find a solution for your issue? Thank you!

@nhatnghetinh  You can use PX.Objects.GL.FinPeriods.MasterFinPeriod and FinPeriodID as the link to GLHistory DAC.

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