Value Mismatch in Order and Invoice value due delivery split

[rjde779]

I have sales order with one line item having 20 Qty later 3 deliveries are created (8 Qty, 8Qty, 4 Qty), in sales order Condition type (Handling cost) having calculation type B-Fixed Amount is entered manually (Let say 95 EUR), Now all three deliveries  are combined in single invoice now system added 95 EUR to each line item (Order Net Value = 100 (Base value) +95 (Handling cost) = 195 EUR, Invoice value 100+95+95+95= 385 EUR).

Business want in invoice also Handling cost should come only once, How to achieve this ?

[Lakshmipathi]

When you create multiple deliveries and combine them into a single invoice, SAP treats each delivery item as a separate invoice item. Since the condition was entered manually at item level, SAP applies the same fixed amount to each invoice item, resulting in 95 EUR × 3 = 285 EUR added to the invoice.

To avoid this issue, what you can do is use a Header-Level Manual Condition type like HM00 and enter the fixed amount at the header level of the sales order.
SAP will then distribute the amount proportionally across invoice items based on quantity or value.

Check in Copy Control VTFL, whether the Pricing Type is = D or G to copy pricing from the sales order without recalculating. This helps preserve the original fixed amount, though it may still distribute it across items.

[Lakshmipathi]

Not sure, whether the condition type is set to Header or Item level and Group condition box is ticked. Normally, Fixed Amount condition types, during copying, will be adjusted on a quantity basis. Having said that, they multiply with the quotient of old and new quantities. So you need to ensure quantity split will not happen in delivery. If that is not possible, then, you can explore on custom validation to avoid this

[rjde779]

Condition type is set as item condition only, Group condition is untick,