In a Saved Search, is it possible to write a formu...
# beginnersb
Brandon Hunt
07/21/2023, 7:02 PMIn a Saved Search, is it possible to write a formula that shows the total amount of items back ordered on the order associated with a line item
i.e.
Copy code
Order 12340
|SKU|Quantity|Quantity Committed|Quantity BO|Order Quantity BO|
|123| 3 | 2 | 1 | 2 |
|456| 4 | 3 | 1 | 2 |m
MGBC
07/21/2023, 7:04 PM{quantity} - NVL({quantitycommitted},0) - NVL({quantityshiprecv},0)
b
Brandon Hunt
07/21/2023, 7:17 PMIs that for the entire order v the line item I used this tutorial to create a saved search that only shows Fully Committed orders, but it does not work for Wave Creation due to putting the line items being hidden under the summery. I am looking for a way to have a saved search for all line items on fully committed orders.
m
MGBC
07/21/2023, 7:19 PMAre you trying to setup a way to Wave only fully committed orders?
b
Brandon Hunt
07/21/2023, 7:19 PMYes
m
MGBC
07/21/2023, 7:20 PMThe best way I’ve seen this done is to either check the Ship Complete box OR add a custom check box called “all lines fully committed”
MGBC
07/21/2023, 7:20 PMThen make a Workflow that checks that box whenever an order is fully committed
MGBC
07/21/2023, 7:22 PMMake a transaction search and use this formula
CASE WHEN ({quantity} - NVL({quantitycommitted},0) - NVL({quantityshiprecv},0)) > 0 THEN 1 ELSE 0 END
MGBC
07/21/2023, 7:23 PMAdd it as summary criteria where SUM of that formula is equal to 0
MGBC
07/21/2023, 7:23 PMThen use that saved search as your WF criteria and schedule it for every 30 min
MGBC
07/21/2023, 7:25 PMThis will check every line and if committed will give a result of 0. Then add up every 0 and/or 1 from each line and if all lines add up to 0 it will be considered fully committed and mark the checkbox
MGBC
07/21/2023, 7:25 PMThen use the checkbox as your criteria for wave creation
b
Brandon Hunt
07/21/2023, 7:26 PMOk, I will give that a try. I think I am also going to look into having our connector bring orders over as Ship Complete. And then create a process of removing Ship Complete whenever we want to partially ship an order.
Brandon Hunt
07/21/2023, 7:27 PMIs there a way to create a saved search for all orders with line items only assigned to one location?
Brandon Hunt
07/21/2023, 7:27 PMNVM I think I have a way to figure that out.
🙌 1