Symptom
You notice that in the Pricing Tab of your Customer Invoice, the amount for Price Component: Freight is not same as the Freight amount which is added in Sales Order.
Environment
SAP Business Bydesign.
Reproducing the Issue
- Open Workcenter Sales Orders and navigate to View Sales Orders.
- Open Sales Order XXX (XXX is the ID of the Sales Order).
- Navigate to Tab Pricing and Invoicing.
- Under Total Pricing, you can see Freight is 120 Euros.
- Now Go to Customer Invoicing workcenter and navigate to Invoice Documents View
- Open the corresponding Customer Invoice YYY (YYY is the ID of the Customer Invoice created with reference to Sales Order XXX).
- In the Invoice, under Pricing Tab, you see the Freight is not 120 Euros.
Cause
When you create a Sales Order and manually enter a freight, The Freight is distributed among the Items based on their Net Price.
When an outbound delivery is created for few of those items, then the freight for only those items are added in the invoice. If you cancel any line item, then the freight will added to Customer Invoice only for the Uncancelled Items. if the full quantity was not delivered and invoiced the Freight is distributed accordingly in the Invoice.
To explain this in an example:
The Sales Order has 3 line items:
Line Item 10 has the quantity of 2 ea and the Net Value of 100.00 EUR
Line Item 20 has the quantity of 1 ea and the Net Value of 100.00 EUR
Line Item 20 has the quantity of 1 ea and the Net Value of 300.00 EUR
You added a Freight in the Sales Order with 120.00 EUR
The distribution of the Freight for each line item is as follows:
Line Item 10 with 24.00 EUR (120.00 EUR/500.00 EUR*100.00 EUR)
Line Item 20 with 24.00 EUR (120.00 EUR/500.00 EUR*100.00 EUR)
Line Item 30 with 72.00 EUR (120.00 EUR/500.00 EUR*300.00 EUR)
Scenario 1 - The full quantity is not delivered and invoiced:
If only 1 ea instead of the full quantity of 2 ea is delivered for Sales Order Line Item 10 the system will divide the assigned Freight on the Sales Order by the quantity.
This means that when the Outbound Delivery for Sales Order Line Item 10 with the quantity 1 ea is invoiced, the Freight Amount on the Invoice will be 60.00 EUR and the Price Component Value of the Freight will be 12.00 EUR
Scenario 2 – a line item in the Sales Order is canceled:
Sales Order Line Item 20 was canceled and only Sales Order Line Item 10 and 30 were delivered with the full quantity.
Depending on when the Item in the Sales Order was canceled the Freight on the Invoice is as follows:
a) If the Sales Order Line Item 20 was canceled before any other item was invoiced, the Freight in the Invoice when the Outbound Delivery for Sales Order Line Item 10 and 30 (with the full quantity) is as follows:
Freight Amount on the Invoice will be 120.00 EUR and the Price Component Value of the Freight will be 96.00 EUR
b) If the Sales Order Line Item 20 was canceled after the other items were invoiced, the Freight in the Invoice when the Outbound Delivery for Sales Order Line Item 10 and 30 (with the full quantity) is as follows:
Freight Amount on the Invoice will be 120.00 EUR and the Price Component Value of the Freight will be 120.00 EUR
Scenario 3 – a line item in the Sales Order is canceled, the cancellation was removed later:
The process of Scenario 2 a) was followed and the Reason for Rejection was removed for Sales Order Line Item 20 after the other items were invoiced (Invoice was released).
Freight Amount on the Invoice will be 120.00 EUR and the Price Component Value of the Freight will be 24.00 EUR
The process of Scenario 2 b) was followed and the Reason for Rejection was removed for Sales Order Line Item 20 after the other items were invoiced (Invoice was released).
Freight Amount on the Invoice will be 0.00 EUR and the Price Component Value of the Freight will be 0.00 EUR since the full Freight Amount was already allocated to the previous invoice.
Resolution
This is system standard behavior.
See Also
KBA 2264942 - Freight Amount is Showing Zero Value in Sales Documents
KBA 3579444 - How is the Freight distributed in a Sales Order and the Corresponding Invoice
Keywords
Incorrect Freight in customer invoice; Mismatch in freight in invoice and Sales Order; Wrong Freight in Customer Invoice; Incorrect Freight; , KBA , AP-PRC-PC , Calculation , Problem