Skip to Content
0
Former Member
Jun 27, 2008 at 07:37 AM

Fixed Freight in Sales Billing

419 Views

Hi,

We are on ECC 6.0 and have a typical requirement.

We have an agreemnt with our customer and our Freight Forwarder that we charge a fixed amount as Freight on all of our deliveries. This Freight amount will vary from order to order and will be fixed for every delivery, irrespective of number of deliveries (partial or complete deliveries) or number of items in the delivery (one item or multiple items). Same amount will flow from Sales Order to Invoice.

E.g.

Sales Order 1001

Number of Items - 2

Item # 1, Quantity - 100

Item # 2, Quantity - 200

Freight Amount - 3000

Now delivery 1

Item # 1 - Delivery Quantity - 100

Freight Amount - 3000 (Fixed)

Delivery 2

Item # 2, Delivery Quantity - 200

Freight Amount - 3000 (Fixed)

Sales Order 1002

Number of Items - 2

Item # 1, Quantity - 100

Item # 2, Quantity - 200

Freight Amount - 3000

Now delivery 1

Item # 1 - Delivery Quantity - 70

Freight Amount - 3000 (Fixed)

Delivery 2

Item # 2, Delivery Quantity - 50

Freight Amount - 3000 (Fixed)

How do we handle this situation ?

We tried the following -

1. In Freight Condition Type, specify Group Condition as Yes, Header Condition as Yes

2. In Freight Condition Type, specify Group Condition as Yes, Header Condition as No, Item Condition as Yes

3. In Freight Condition Type, specify Condition Category as "B" - Fixed Amount, Group Condition as Yes, Header Condition as Yes

4. In Freight Condition Type, specify Condition Category as "B" - Fixed Amount, Group Condition as No, Header Condition as Yes

5. In Freight Condition Type, specify Condition Category as "D" - Gross Weight, Group Condition as No, Header Condition as Yes

6. In Copy Control of Sales Order to Billing, Price Type as "D" or "G" or "H"

and combinations of all above.

As a result of (3) and (4) above, in Billing -> Condition Tab, Amount field is being fixed, as per Sales Order Freight amount. But Condition Value field is getting calculated as per Partial Delivery Quantity.

We want Condition Value also to remain unchanged.

Thanks