Hi
I am trying to create a sum function in jet which looks at the item ledger entry table. I wish to return the quantity for a range of posting dates and entry type of sale and a specific location code and item number and source no. and account manager.
However, the problem arises in that the account manager has changed during the time period, so I want to take the account manager from the customer table as it is now.
I have tried various permutations, and googled the issue but no luck with nested jet function, link or filter or lookup.
Any help much appreciated.
Date
Votes
1 comment
-
Jet Reports Historic Posts Something like this probably, if I'm interpreting it correctly. I had to use Salesperson instead of Account Manager.
=NL("sum","item ledger entry","Quantity","Posting Date",$C$3,"Entry Type",$C$8,"Location Code",$C$4,"Item No.",$C$5,"Source No.",$C$6,"Link=","Customer","No.","=Source No.","Salesperson Code",$C$7)
I also attached a mockup.
Please sign in to leave a comment.