We are looking for exception reporting on Back Order Inventory Items, at the Sales Order line level: For Sales Orders that have Back Order Status, we want to pinpoint the specific Items which are on Back order. Is there a Back Order Status at the Sales Order Line level to flag which Inventory Items caused the Back Order, for follow up?
Best answer by Naveen Boga
View original@mvolshteyn thank you for your reply! We are working with the package “Sales Order Details by Inventory Item report” (on the Sales Orders workspace > Reports menu). I’m looking at joining in the SoLineSplit and/or INItemPlan tables if that makes sense per the information you provided, and what would be the identification of the Back Order record. Thank you!
+3
Corresponding screenshots for SO entered according to this commets are attached
Thank you very much for the feedback!
An issue we have with comparing the Quantity, Qty on Shipments, and Open Qty fields is if an order has multiple lines and none of them are shipped - one line may be Back Order without available On Hand to fill the order, but other lines may have available On Hand but not yet shipped.
+3
Technically, it is an InItemPlan record with PlanType = 68, referred by SOLineSplit record (shown in the Sales Order Allocations)
In the scenario in your last comment, the 1st line should have this SO Back Ordered allocation but other lines should be SO Booked
Thank you very much for the feedback!
An issue we have with comparing the Quantity, Qty on Shipments, and Open Qty fields is if an order has multiple lines and none of them are shipped - one line may be Back Order without available On Hand to fill the order, but other lines may have available On Hand but not yet shipped.
+17
Hi
But we can identify Back Ordered items (Partial shipped items) at SO Line level by considering below fields.
We can compare these fields and can able to know backordered items. Please find the screenshot for reference.
Hope this helps!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
