on 06-27-2008 8:37 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi pls revert on matter as soo as possibl.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.