How to derive sales order line price by adding multiple price components other then Price List price
Summary:
It is very critical in our implementation program and we don't have any solution or workaround. you support is very critical to meet our milestones.
We want to derive sales order line price by adding LME+PREMUIM+CONVERSION(Not currency conversion) which we store in system(Lookup/Value set/EFF or Descriptive Flex fields)
LME Price - Will be published by Metal Exchange at the end of every month
Premium - Will be published by Metal Exchange at the end of every month
Conversion - Is fixed for each customer by our company (Not currency conversion)
At the time of sales order booking Current month LME+PREMIUM+CONVESRION prices will not be available in the system and we want to(Default) derive price based on previous month price (LME+PREMIUM) which is available in the system either M minus 1 (M-1) or M minus 2(M-2) and then we ship the material to customer.