Good day all,
I have a request from our sales team to provide them a cue/queue which displays the last 2 days sales orders that do not contain a certain part number (as the call centre are instructed to add this part to all orders that match certain criteria, and this is to catch the ones that have slipped through). I based my cue on the form MCRSalesTableOrderHistory, located Call centre/Inquiries/Sales orders.
I have put in several filters but I cannot get the cue to return orders that do not contain a specific part number. I have tried adding in the table "Order Lines" and setting the filter to Order lines/Order lines/Model number/!P1 (as "P1" is the part number in question we need to add to all orders).
This does not work as it is still returning orders that contain lines with "P1" in. I guess this is because they also contain order lines that are not P1.
I understand you can use some SQL in these to so tried Order lines/Order lines/Model number/(SalesLine.ItemId != "P1") but this gives me an error "Query extended range failure: SalesLine.ItemId is not a valid datasource.field pair near pos 22."
As I know zero about SQL I am probably going about this the wrong way, but would appreciate any help on what form/filters I could use to do this, or will I have to get a bespoke report written up please?
Many thanks.
*This post is locked for comments
I have the same question (0)
