I would like to know if there is any option to fetch the Item price on the basis of Customer so every time when i enter the customer name and it should come the last sale price of the same customer for particular item in sale price column.
Example :- if i had sold Item No-1 to Customer No-1 with 5.00Rs price and next time if that customer come the same sale price should be fetch by system.
Now if the third time customer came and i sale the same item with the price of 6.00Rs the price list should update for that customer and next time the same price should fetch in sales price column.
Appreciate your help for the above query.
I tried the selling price option by customer but if the price change its not updating and keeping the old price in records.