HI, I am trying to build a report for our logistis staff - they need to see current stock (Item ledger Entry - Remaining Quantity) and usage (again the item ledger entry table usign the Quantity field). So for the Remaining Quantity Field I need to filter on Location Code and for the Quantity field I want to filter on Entry Type Sale and Consumption. The two fields are from the sale table…how to set the filter? Many thanks :)
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
So these aren't flow fields, so it seems like you will need to use NL(First) to get each value and set the separate filters you need. So for example you might replicate the Entry No. field from the Item Ledger Entry using NL(rows) like this:
B3:=NL("Rows","Item Ledger Entry","Entry No.")
Then you could use 2 NL(First) functions to get the current stock and usage like this:=NL("First","Item Ledger Entry","Remaining Quantity","Entry No.",B3,"Location Code","Your Filter") =NL("First","Item Ledger Entry","Quantity","Entry No.",B3,"Entry Type","Your Filter","Consumption","Your Filter")
Does this help?
Regards,
Hughes
Please sign in to leave a comment.