I think having the system automatically create Item Price docs from Supplier Quotations. I was thinking of adding a button to a Submitted Supplier Quotation called “Create Item Prices”. A popup would display that lets you select the Price List that you want to add the prices to. After that, each line item of the quotation would be added to the price list.
There are a couple sticking points that I can see:
- A supplier quotation can have more than one line item with the same item code (for different quantity quotations). Right now, the Item Price can only support one Item Price per item code per Price List. I was thinking of removing this validation and allowing the system to create several Item Prices as long as the minimum quantity would be different, but I can see this causing lots of problems.
Ideally, when deciding an Item Price for any item (for Selling or Buying) the system would look at minimum quantity for the price and pick whichever was the closest minimum order quantity that wasn’t over.
- Overwritting existing Item Prices. If the system already has a price for that price list, how do you handle that? I was thinking of adding a check box to the popup that says “Overwrite existing Item Prices”, and using that to either ignore or update the existing item price.
That’s what I’ve got so far. I’ll probably go in stages (first get it working, then add multiple item prices per quote).
Any thoughts from the community here before I get started?
[EDIT: Supplier Quotation already has a price list field, so that could be used instead of prompting the user]