I am extracting data with=NL("Rows","Value Entry",{"Item No.","Source No.","Salespers./Purch. Code","Brands Code","UOM"},"Item Ledger Entry Type","Sale","Posting Date",option!$C$2,"Item No.",option!$C$3,"Salespers./Purch. Code",option!$C$4,"Source No.",option!$C$5) then use NF to retrieve the key value from the rows function.
In normal circumstances the salesperson no. on value entry is the rightful salesperson, but in actual fact there are 2 salesperson that handle few group of customer and the salesperson in value entry is just the driver that deliever the goods for them.
How do i link the customer salesperson into the sales amount(actual), credit memos, invoiced quanity on the current row fucntions?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Emailhost,
Where is the correct salesperson code located? You said the wrong one is in the Value Entry table, so where do you look to find the right one? From there we can figure out how you link the tables together.
Please sign in to leave a comment.