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!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.