Dear Ravi,
as the price of the oil product changes every day I would propose to move in this direction:
Proposal:
as soon as the new oil price in known, generate a file (if you cannot get it by external source) that contains all the price variances, load this file in the system automatically in order to update the selling price before that operation starts.
Based on the business structure you have in place I would apply one of the two decisions about open orders:
1. as soon as the new pricing file is loaded, re-price all open orders in order to fetch and see applied the prices variances
2. even if the new pricing file is loaded, do not re-price open orders; in this case old open orders will keep the old price; new price will be applied only for new orders.
Scenario *) Pricing maintained at material number level
I assume that in this case you would have:
a. new price of the oil provided in the morning
b. quite long list of material's prices to update
c. long list of pricing condition to maintain
Scenario **) Pricing maintained at material characteristic level (e.g.: product category or EMG = OIL (generic value))
I assume that in this case you would have:
a. new price of the oil provided in the morning
b. quite short list of condition to update
Even if in the second scenario there would be less entries to create and maintain, I would prefer to move always for an automatic integration of external data.
I experienced this type of scenario; even if it was not related to pricing, it was related to daily stock and weight variances based on a production planning.
I hope you may find helpful this experience.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.