💡 If the purchase prices from your standard supplier are known, you can record them in a price list linked to that supplier. As soon as you create a new purchase order, the prices will automatically be added to the selected products.
💡 You can only include a product once in an active price list for the same supplier.
⇢ Go to Purchasing – Prices and select Per supplier.
Click the green plus icon to create a new price list for a supplier.
Click on a price list line to edit prices or add a product to a price list.
Click the green duplicate icon on a price list line to duplicate a price list.
Create a New Supplier Price List
General data
Name: typically includes the supplier and the period during which the price list is valid. Optionally, you can also mention a product category if you split price lists by category.
Start date: the date when this price list becomes active. The order date of a purchase order is used to determine the correct price list. This date can be in the future, which allows you to set new, upcoming prices in advance.
End date: the date when this price list will no longer be active.
💡 Once the end date has passed, the price list will be set to inactive and Douano will no longer load prices from it into purchase orders.
💡 You can reactivate a price list by setting a new end date in the future, or you can duplicate the price list to create a new active one. Duplicating has the advantage of keeping an archive of past prices per supplier, providing insight into price increases.
Supplier: the supplier for whom the prices are set.
Purchase prices
Product: the product must have an active status and be marked as Can be purchased to appear in this list. An empty line is added automatically as soon as a line is filled in.
Supplier item code: optionally, enter the supplier’s item number.
Price excl. excise, VAT: unit price excluding VAT and excise duties. If you update this price, the Price excl. VAT will be updated automatically.
💡 This price is leading: if excise tariffs change, this price remains unchanged.
Excise: the excise amount applicable to the product. This amount is automatically calculated by Douano based on the product definition.
Price excl. VAT: unit price excluding VAT but including excise duties.
💡 If you change this price, the Price excl. excise, VAT will be updated automatically. This price is indicative: if excise tariffs change, this price will also change.
💡 If goods are received under suspension, no excise will be charged.
Duplicating a Supplier Price List
💡 Once a price list is inactive, you can duplicate it to create a new active price list for the same supplier, possibly with different products than in the existing list.
💡 If you purchase products from multiple suppliers, you can also duplicate an existing price list (with all products and prices included) and assign it to another supplier.
⇢ To duplicate a price list, click the green duplicate icon on the price list line.
General data
Name: update the name of the price list (e.g., by adding a year or referencing another supplier).
Start date: the date when the duplicated price list becomes active.
End date: the date when this price list will no longer be active.
Supplier: select another supplier if needed.
Optional price adjustment
💡 When duplicating, Douano can automatically increase or decrease all product prices in the list.
💡 Skip this step if prices remain unchanged or if you plan to update them manually afterwards.
Adjustment type: choose whether to apply an increase or decrease.
Adjustment method: choose between a percentage or absolute adjustment.
Adjustment value: enter the percentage (%) or amount (€), depending on your choice above.
Filter (optional)
With this filter you can choose to only transfer products with a specific status.
💡 For example, you can filter so that only products with an active status are transferred.