All, I am trying to write a period to date vs budget income statement that runs a list of all main accounts and dimensions for a period from the G/L Entry table and comparing it to the G/L Budget Entry table.
I currently have the list running off the G/L Entry table, doing so is not picking up all the budgeted numbers for the month for accounts that did not have g/l activity, how do I combine the lists to include all activity for a period for the g/l and the g/l budget, so I am picking up those entries in the Budget table as well.
This is the current NL formula I am running for which is not including the G/L budget entry table:
=NL("Rows=5","G/L Entry","G/L Account No.","G/L Account No.",$C$13,"Posting Date",$D$8,"Company=",$D$6,"Department",$D$4)
Please help with a Filter that will capture all entries for the g/l and the budget.
Thanks in advance, M
Date
Votes
1 comment
-
Jet Reports Historic Posts I think you could do this with NP(Union). It would look something like this:
=NL("Rows=5",NP("Union",NL("Filter","G/L Entry","G/L Account No.","G/L Account No.",$C$13,"Posting Date",$D$8,"Company=",$D$6,"Department",$D$4),NL("Filter","G/L Budget Entry","G/L Account No.","G/L Account No.",$C$13,"Date",$D$8,"Company=",$D$6,"Department",$D$4)))
This should give you all G/L Accounts that have either an entry or a budget entry in the specified data range for the specified department and company. Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.