Suggestions:
At the time of Sales order upload using upload utility, If the excel sheet is having rate of a particular item as ‘n1’ then system should consider rate as per excel .
Here in price list rate is n1 for the item which is as per minimum and maximum rates bracket of pricelist mapped to the customer. Then after uploading, the system should default set ‘n1’ which is in minimum and maximum rates in pricelist which is also there in the excel sheet.
Secondly, the system should also allow users to edit the rate of the particular item in the Sales order record, which is uploaded.