I know this has been asked, but it's still not working for me...
Current setup end to end;
Sales --> settings -> advanced pricing based on formula
Purchases --> settings --> costing Methods - use a 'fixed', 'real' or 'average' price costing method
Purchases --> setting --> vendor price --> Allow using and importing vendor pricelists
Sales -> Pricelists --> Pricelists --> Create New Pricelists
1st Pricelist; all products / apply on - global / compute price - formula / based on - cost
* note below "Based on" (New Price = Public Price -) shouldn't it read (New Price = Cost -) ????
2nd Pricelist; all products / apply on - global / compute price - formula / based on - other pricelist - 1st pricelist
* now it states correctly below based on (New Price= Other Pricelist)
Sales --> Products --> Create New Product
Product 1; Sale Price - $0.00 / Cost - $10.00 / Vendor 1 - $11.00 Vendor 2 - $12.00
When I select a product is quote/ sales order $10 is displayed in the cost column and not a figure from the average of $11 and $12 or their pricing.
When I edit Product 1 (cost - $0.00) $0.00 shows up in the product line.
If I update Product 1 under Suppliers Pricelist for Vendor 1 and Vendor 2, nothing changes for product line in the quote or sales order.
How am I able to keep updated pricing under Supplier Pricelist, and allow the system to use a calculation for the vendor pricing? Am I able to determine which vendor to use the pricing of? I'm so confused because there's no change, no matter what I do.