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
Oracle Order Management - Header level Discount
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
Not a good news!!!
Cheers,
Saravanan
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
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
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.
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.
Who is online
Users browsing this forum: No registered users and 4 guests