How to capture lot base cost as a Sale Price on Sale Order
help require
we are Pharmaceutical distribution organization and we using Order Management with Advance pricing currently we are using R12.0.4 now will upgrade R12.2.4 we are facing a problem during sale booking
Actually our requirement is that sale order pick item cost as a sale price with lot wise but we are unable to do that. because there is no function available in oracle till this released, currently we are maintaining price list as lot wise but it is very difficult to update price continuously because there are more than 6000 sale order per day creation all order is import from another third party software via interfacing, management need solution that once order import in OM module item cost automatically pic as a sale price lot wise. some example is below