Skip to main content

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?

Hi @ekaplan  We are NOT having the Status field at SO Line level.

But we can identify Back Ordered items (Partial shipped items) at SO Line level by considering below fields.

  • Order Qty - Ordered Qty
  • Open Qty - items are still to be shipped 
  • Shipped Qty - items already shipped

We can compare these fields and can able to know backordered items. Please find the screenshot for reference.

Hope this helps!

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.

@ekaplan , @Naveen B , actually there is a kind of ‘back Order’ status at SO Line Level. It is the ‘Back Ordered’ Allocation Type visible in the Inventory Allocation Details. 

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

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.

 

@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!

@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!

Hi @ekaplan ! I was wondering if you were able to figure this out? I am also looking to create a GI that shows all SO line item that has back order status. If yours worked, can you share a screenshot of how you table relations look like? Thanks!

Reply


Terms & ConditionsCookie settings