We need to have vendor specific pricelists for purchasing. Prices for the same product are different for different vendors. We also need a consolidated pricelist (includes all products with prices from current vendors), that will be used as the base for our sales pricelist.
We enter vendors and their prices on the Purchasing tab of the Product window. Then we create consolidated and vendor specific price list schemas. Pricelists are generated based on these schemas and with no base pricelist.
We get the consolidated pricelist the way we want (all products, price from current vendor), but the vendor specific pricelists are wrong. If vendor is not the current vendor for a product, then this product is not included into the vendor specific pricelist even though it is sold by this vendor.
In case it is relevant to you, another option for dealing with importing price lists is discussed in an article at the link below.
We came accross that problem too.
Is there any functional reason for the pricelist generation logic to be that way ?
In other words, why would pricelist generation not take product into consideration when it's defined as multi-vendors and considered vendor is not the default one ?
The main reason is because the same discounts would most likely not apply. You can have a single price sheet that is the resulting of merging multiple price sheets
Log in to post a comment.