Skip to main content
Solved

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


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

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
 

 

Best answer by hkabiri

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

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

4 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 191 replies
  • June 23, 2022

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


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

Dear @hkabiri

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

Many thanks !

NNT

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2527 replies
  • July 26, 2022

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


hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 191 replies
  • Answer
  • July 26, 2022

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


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