Skip to main content
Solved

Identify Back Order items at Sales Order Line Level

  • 28 September 2021
  • 6 replies
  • 1042 views

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

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!

View original
Did this topic help you find an answer to your question?

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3374 replies
  • Answer
  • September 28, 2021

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!


  • Author
  • Freshman I
  • 2 replies
  • October 26, 2021

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
Acumatica Employee
Forum|alt.badge.img+3
  • Technical Account Manager in the ISV Team
  • 102 replies
  • October 27, 2021

@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


mvolshteyn
Acumatica Employee
Forum|alt.badge.img+3
  • Technical Account Manager in the ISV Team
  • 102 replies
  • October 27, 2021

Corresponding screenshots for SO entered according to this commets are attached

ekaplan wrote:

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.

 


  • Author
  • Freshman I
  • 2 replies
  • October 28, 2021

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


Forum|alt.badge.img
  • Varsity I
  • 54 replies
  • October 16, 2024
ekaplan wrote:

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings