Hello I am trying to create a saved search of backordered items in a specific date range of Requested ship date (custom field) , and compare them with quantities that are "on order" , so I can see what items need to be purchased.
To be able to have a backordered quantity for a specific date, I need to use SO lines rather than the backordered quantity on the item record. I therefore created the following saved search :
Criteria:
Results:
Now the result is this :
In the red section is an example of 2 SO lines for the same item : the formula pulls out the backordered quantity per SO line. SO for this item, my total backordered quantity ( for a specific date range) is 4000+2100 = 6100.
I know I can Sum this formula in the results page using "summary" but I need to compare it to the "on order" field. Because in this case, I have 10 400 of this items on order so I do not need to purchase more items.
I would need to be able to only see in this saved search backordered items with no (or not enough) quantity on order. ( like the blue section for example).
Hope my english is not too difficult to understand.
Thanks in advance for your help,
Best regards,