Good afternoon,
I've created an NL rows report to give me the quantity on hand for all items that are not blocked in addition I need any sales quotes found in the sales line which I've created a linked function in cell N9 (this is working propertly). The issue is that it is only giving me items where there is a sales quote or sales order associated but not other items that have a quantity on hand base on the date filter. I tried to attach the report but didn't know how to but this is what the options in the first report reflects:
ORIGINAL REPORT
=NL("Rows","Item",,"DataSource=","MyDataSource","Gen. Prod. Posting Group",$C$4,"Inventory Posting Group",$C$3,"Quantity on Hand","<>0","Date Filter",$C$5,"Sales Location Code",$C$7)
the second report which I've added the the column for sales quote is as follows
REVISED REPORT
=NL("Rows","Item",,"DataSource=","MyDataSource","Filters=",$B$3:$C$4,"Quantity on Hand","<>0","Sales Location Code",$C$6,"Link=","Sales Line","No.","=No.","No.",$C$9,"Location Code",$C$6,"Company=",$C$5)
cell N9 of the report where it pulls quantity from the sales line for doc type "quote" is as follows:
=NL("sum","Sales Line","Quantity","DataSource=","MyDataSource","No.",$G9,"Document Type","Quote","Requested Delivery Date",$C$7,"Location Code",$C$6)
I don't know where I'm going wrong that it's not returning the items that appeared in the original report. Hopefully someone can provide some suggestions on how to make the corrections.