Symptom
You created a Return XYZ which is based on a migrated Sales Order ABC and notice that the quantity is not taken into consideration when calculating the Net Value of the Item in the Return.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work center.
- Select the Returns view.
- Open Return XYZ (XYZ represents the ID of the Return).
- Navigate to the Items tab.
- Select Line item XX (XX represents the line item number).
- You can see that the Net value for the quantity is not the correct one.
For example:
The Net Value is 400 EUR and the Quantity is 2 EA.
However, when you open the Migrated Sales Order ABC (ABC represents the ID of the migrated Sales Order the Return is based on).
Navigate to the Items tab.
Select the Line Item YY (YY represents the line item number of the product used in the Return).
You can see that the Net Value is 400 EUR and the Quantity is 4 EA. Hence 1 EA is 100 EUR.
Therefore, in the Return the Net Value should be calculated as 200 EUR since the returned quantity is 2 EA.
Cause
The Return was created with a Warehouse Request.
If you create a Return without a Warehouse Request, but via a direct post goods return, the Net Value is calculated correctly from the Migrated Sales Order.
This is a current system limitation and has been taken up in our Product Backlog for a future Release.
Resolution
Create the Return without a Warehouse Request.
For the Returns created with a Warehouse Request you can change the Net Value manually as follows:
- Go to the Sales Orders work center.
- Select the Returns view.
- Open Return XYZ.
- Navigate to the Pricing tab.
- Expand the Line item XX.
- In the Price Component Migration Price, change the Amount to the correct Net Value e.g. in our example to 200 EUR.
- Save your changes.
Keywords
Return; Quantity; List Price; Net Value; Price; Migration; Sales Order; Quantity Calculation; , KBA , AP-PRC-PC , Calculation , Problem