Hello! I need to make a basic report, but the things I've tried just haven't worked.
For most of the Report, I'm simply showing fields from the Sales Invoice Header - Posting Date, Salesperson Code, No., etc. - as NF functions based on an NL query.
However, for the amounts I need to show one column where only lines listing the Type (from the Sales Invoice Line) as "Item" are totalled, and a second column that totals all the lines of the invoice where the Type is equal to "Item" OR "Resource."
What's most frustrating is that this seems like it's probably VERY easy - but I just haven't been able to get it right. Thanks in advance to anyone willing to help!
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
How about these 2 functions:
- NL("Sum","Sales Invoice Line","Amount","Document No.",Cell reference to invoice no,"Type","Item",…other filters ….)
- NL("Sum","Sales Invoice Line","Amount","Document No.",Cell reference to invoice no,"Type","Item|Resource",…other filters ….)
The | is the operator symbol for "or".
Does this work for you? -
Jet Reports Historic Posts YES! THANK YOU, THANK YOU, THANK YOU!
I hope all the joy and relief I'm feeling right now transforms into awesomely good karma for you. You have been such a huge help!
Please sign in to leave a comment.