Hi there,
I am trying to create a report in Jet off of NAV which lists all open sales lines by customer and then by item #.
I first did an NL to the sales header to get the Customer Name (this is not in the sales line table).
Then a NL to the sales header again to get the customer number for the customer name above.
Then an NL to the sales line table to get the item number for the customer # above.
Then a NF to get the data,, sales order#, quantity, etc
The problem is that it includes all sales order with the item # under each customer who has a sales order for that item. So, under a particular customer, I am listing sales orders for a different customer.
I tried to make the NL key filter on the NL for inventory# and the NL for Customer #, but it only returns the first sales order for each customer.
Can a NL reference up to 2 other NLs?
Help!
Date
Votes
1 comment
-
Jet Reports Historic Posts I think you're making it a little bit harder then it is, altough I'd understand it better if you'd attached your report.
In one cell you get some rows for the customers that made orders (could add a "NL(filter)" for more complex filtering on the sales line, ie: only the customers that have open sales lines):
C3:=NL("Rows=2";"Sales Header";"Sell-to Customer No.";"Sell-to Customer No.";"<>''")
Then you get a NL for the customer name:
D3:=NL(;"Customer";"Name";"No.";$C3)
Now if I read yours correctly, you just had some "$" signs wrong, so be careful with that.
An easy trick, when starting the sales lines on the next row (4), is to copy the customer No. to that row and use it as a filter.
Ex:
C4:=$C3
Then you can add your "sales line" NL on line 4 and use C4 as your customer filter.
Hope this helps you out, I have some problems with my laptop and my office isn't working properly, otherwise I'd make you an example.
Please sign in to leave a comment.