Apologies if this is an obvious question (brain may not be working today!). If I wanted to modify a formula similar to the following:
=GL("Balance","6000..9800",$F$7,$F$8,,$E11,"DIRCOST",,,,,"PMS_LIVE")
to only include GL entries where there was no Job number can I do this?
Heather
Date
Votes
3 comments
-
Jet Reports Historic Posts Need a bit of clarification what are you considering as a job number ( 3rd dimension ?) if thats it try "@@" as filter
-
Jet Reports Historic Posts Sorry the field Job number in the G?L entries table
-
Jet Reports Historic Posts Okay then I'd try using the NL(Sum function on GL Entry table ) rather than GL Balance as it gives you greater filtering capability
Please sign in to leave a comment.