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
View original
+5
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
May I ask which FinYear DAC to use in the list as shown in the picture?
Many thanks !
NNT
Hi
+5
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
