cancel
Showing results for 
Search instead for 
Did you mean: 

Fixed Freight in Sales Billing

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi

for this you need to maintain seperate condition table take the item no in the condition table and maintain the condition record for this condition table you can also maintain this table in the pricing condition type

try this one

regards

srini1379

Answers (6)

Answers (6)

0 Kudos

Hi,

Question - If there are multiple deliveries and multiple invoices for the same order. How do you want to see freight populating? Will the freight be added to all invoices, ex - if there are 10 invoices, you'll charge 3000X10 as freight?

If this is the case, then I'll suggest to add the freight at delivery level instead of sales order. Or you can make the condition type as statistical in sales order and use it to add a condition in the delivery every time (You'll need a developer to write a routine for this.)

Chintan

roopal_chaturvedi2
Discoverer
0 Kudos


Hi Manish, I have the same requirement with my client , could you please let me know how you resolved this , please let me know the solution ? I could not find your email id in the same to contact you for faster response.

jobis
Contributor
0 Kudos

Hi,

Make the condition as Fixed value 'B'.

Make it item condition.

do test and update.

jobi

Former Member
0 Kudos

Hi pls revert on matter as soo as possibl.

Regards

jasmeetmanik
Participant
0 Kudos

Hi all,

I have a same request but finding it difficult to sort this. please advise if you know anything. thanks

jasmeet

Lakshmipathi
Active Contributor
0 Kudos

Dear Pimplikar

For all header condition types, you can allocate the value proportionately to all line items automatically. To achieve this, click Goto --> Header --> Conditions. In this screen, input the condition type and click on [Activate] button at the bottom screen and save. Now you can see the fixed freight amount is bifurcated equally to your line items.

The same exercise can be done in billing also.

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi Laxmipahi,

What you are saying is not applicable for us.

We do not want any bifurcation of Freight Amount from Header to Line Items.

Freight Amount should remain fixed at the time of Partial Deliveries and Billing / Invoicing also i.e. it should be same in Sales Order Header and Billing / Invoicing. This is irrespective of number of deliveries (complete / partial deliveries) or number of items in a delivery

E.g. - In above example, Freight Amount should remain 3,000, whether we deliver Item #1 or Item # 2 and that too completely or partially.

Former Member
0 Kudos

Hi all experts,

No reply so far. !!

Option of Separate Condition table has also not resolved our issue.

Can someone suggest a quick solution in SAP standard ?

Thanks

Former Member
0 Kudos

Hi,

Thanks for your reply.

Could you please elaborate, with an example ?

Our requirement is that Freight should not get prorated as per Delivery Quantity. It will be entered manaully at the time of creation of a Sales Order and will remian the same at the time of Billing and Invoicing, irrespective of number of items in the Delivery/Invoicing documents and number of deliveries.

Thanks