Page 1 of 1

Oracle Order Management - Header level Discount

Posted: Mon Nov 09, 2009 12:19 pm
by Ashwinram
Hi,

Our client has a specific requirement while creating Sales Orders. After the Order is booked, he requires lumpsum discounts to be given at the Order Header level for rounding off the amount. For example, if Order value is 1005.55, lets say, he would like to round off to 1000 by discounting 5.55 at header level. But in OM, Header level discount modifiers can be defined as a percentage only. Calculating a percentage is cumbersome and still gives rounding off errors.

Can anyone help?

Ashwin

Posted: Tue Nov 10, 2009 12:42 pm
by tgs100
It is good to have this feature in OM, but unfortunately discount amount can not be given in the sales order header. We tried with few options like adding one discount line item at the end (to round-off the sales order amount), but client was not comfortable with the work around and personalizations.

Not a good news!!!

Cheers,
Saravanan

Posted: Wed Nov 11, 2009 4:28 am
by hiszaki
Hi Saravanan

Thanks for your reply but let me ask you what the different between discount at the order header & the discount on the line item at the end? why the client not comfortable with this workaround if there is no any different.

Thanks
Hisham

Posted: Wed Nov 11, 2009 12:27 pm
by tgs100
It is not as easy as you think... Problem starts in the shipment. Consider the following scenario.

Item ---- Qty ----- Price ----- Value
--------------------------------------
X1 ----- 10 ----- 115.33 -----1153.30
X2 ----- 10 ------ 85.55 ----- 855.50
D1 ---- -0.80 ---- 1.00 ----- -0.80
==============================
Order Value ---------------- 2000.00

D1 is the discount item.

If you want to ship 5 qty of both products, what will be the shipment value? Is it 1000.40 or 1000.00 ?

If you want to ship 5 qty of X1 alone, what will be shipment value? Is it 1153.3/2 ? or...

1. You should include the discount line in all your (partial) shipments. If you forget to include the discount line, shipment amount will be wrong.
2. Even if you include the discount line, you need to calculate and change the discount amount in all your partial shipments which is cumbersome.

If you have a discount at the header level, you don't need to do the above two steps.

Cheers,
Saravanan

Posted: Thu Nov 12, 2009 4:27 am
by hiszaki
Saravanan

Thanks for your clarification.

Hisham

Posted: Mon Mar 22, 2010 6:31 am
by CORPSE84
Hi,

If u can convince ur client, there is another work around for this problem.

After the invoice is created, Incomplete it, add another line as discount and then complete the invoice manually. Adding discount this way won't disturb the other lines and this extra line won't affect ur inventory as well. The "Item description" Field in Invoice is pretty flexible. U can write just about anything in it provided that u don't select an inventory item.

Hope it helps.

Regards,

Faisal.