I need a list of the table SalesPrice (MS Nav) with only one unique record per customer, who are in a specified enddate of the salesprice. Some customers do have a lot of itemnrs. Only one record is enough to see what the enddate of the contract is.
How do I solve the problem?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi haweijs,
You could probably do this using the Link= functionality in Jet Reports. How do you link from the Sales Price table to a table with customer numbers? Do you go through the Item Ledger Entry perhaps? Would something like this work:
=NL("Rows","Item Ledger Entry","Source No.","Source Type","Customer","Link=","Sales Price","Item No.","=Item No.","Ending Date",$C$3)
Regards,
Hughes
Please sign in to leave a comment.