I’m trying to find the budgets for the individual 12 months are. GLBudgetLine is supposedly where they are, but they’re not there. How Can I add these budgets to a GI?
Answer
Where can the period budgets be found for a GI?
Best answer by meganfriesen37
Hi
You may need to use FinPtdDebit and/or FinPtdCredit together to get the turnover value for the period, as there is no field that has the turnover value stored (at least not last time I checked).
Megan
+12You can get this information on the GLHistory table. Just filter for based on the Ledger to get the specific budget ledger (if you have multiple) or you can use [GLHistory.BalanceType] = 'B' (type ‘A’ is actuals).
Megan
Megan Friesen, Contego Software Solutions, Canada
You can get this information on the GLHistory table. Just filter for based on the Ledger to get the specific budget ledger (if you have multiple) or you can use [GLHistory.BalanceType] = 'B' (type ‘A’ is actuals).
Megan
Edit: Never mind, it was FinPtdDebit.
+12Hi
You may need to use FinPtdDebit and/or FinPtdCredit together to get the turnover value for the period, as there is no field that has the turnover value stored (at least not last time I checked).
Megan
Megan Friesen, Contego Software Solutions, Canada
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.