7.4.3. Vendor Price List Update

The Vendor Price List Update process, located in the Product Setup -> Prices menu, allows you to generate or update vendor prices based on vendor invoices.

• List Price - price list where prices are inserted or updated;

• Accounting schema - is used to determine the prices for products using the "Standard Cost" costing method;

• Valid from - validity date of the price list version;

• Vendor - only invoices from this vendor are used;

• Invoiced Date - time range for invoice selection;

• Product Type - only prices for products of this type are added to the price list;

• Update existing record checkbox - if selected a price list version will be updated (the one with the closest but smaller date than the date specified in Valid from). If not selected a new price list version will be created at date specified in Valid from.

If the invoice currency differs from the currency of the selected list price, it tries to convert the price using the exchange rate of the date specified in Valid from.

If in the specified range an article exists several times, with different prices, then the final price will be taken from the last invoice with the most current invoice date.