Symptom
In a Sales Order scenario, you notice that some line items still have their Delivery Status as 'In Process', however, the full quantity has been already delivered via Outbound Delivery and invoiced via Customer Invoice.
This KBA is only relevant if the Sales Order has been created from a Purchase Order.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to the Sales Orders work center.
- Open the Sales Orders view.
- Find Sales Order ABC (Where ABC represents the ID of the Sales Order which is still In Process).
- Click on Edit.
- Click on View All.
- Navigate to the Items tab.
You see the following setup on the line items:
Line item AA: This line item is Completed.
Line item BB: This line item contains the same Product as AA, but the Delivery Status is 'In Process' and the Invoicing Status is 'Not Started'.
- Now, navigate to the Document Flow tab.
- Open Purchase Order DEF (Where DEF represents the ID of the Purchase Order which created Sales Order ABC).
You notice that the Purchase Order only has one line item which represents the sum of Products in line item AA and BB of the Sales Order.
Cause
This issue can happen when the quantity of an item is changed in the Purchase Order by increasing the amount (For example, changing an amount from 5 to 10), but in the Sales Order this change is represented by adding a new item to the document (For example, having an item with an amount of 5 and then adding a new line item with another amount of 5 of the same product).
This causes a scenario where the Purchase Order is only linked to the line item which was originally present in the Sales Order, and not to the new one. When the documents are then Delivered and Invoiced, the system understands that the original item in the Sales Order (Which came from the Purchase Order) was over-delivered and that the new item in the Sales Order has not been Delivered or Invoiced, which causes the Sales Order to still be In Process.
Resolution
You have two options to correct the scenario:
- You can cancel all of the documents and re-create them with the correct quantities and following the correct process.
- You can cancel the line items in the Sales Order that are not present in the Purchase Order. This will affect the total value of the sales order due to the process that was followed, but the delivered and invoiced amounts will still be correct.
Keywords
Sales Order, Purchase Order, Request, Invoiced, Delivered, Fulfilled, Incorrect, Inconsistent, Status, Outbound Delivery, OD, Customer Invoice, Invoicing, Link, Linked , KBA , AP-SLO-SO , Sales Order , How To