Orders Coming off Backorder – now Fully Committed
Hi,
I am trying to make a saved search which does the following:
Show orders that contained items on back order but are now fully committed.
I have the following so far:
Criteria:
Main Line is true
Type is Sales Order
Fully Committed Date (Custom Body) is on yesterday
Customer : Category is any of Wholesale – Credit, Wholesale – Proforma, Distributor
Results:
Document Number
Name
Date
Fully Committed Date (Custom Body)
I am not certain what to add to pick up the items that were on back order, i suspect a formula of some kind.
Thanks
You have mainline = T in your criteria, you cannot retrieve line level data with that criteria. You probably need to move the full committed date to the line level and restrict/pull from there instead.
cjones2021
Did this search work?
themelon007
Hi, We have not currently go this to work as required.