Whether you've already started using the powerful purchase order "Invoicing" feature in SELVEO or not, you can use it to associate i.e. a shipping cost to a certain purchase order and distribute that cost (or discount) to the corresponding stored cost of the products received on that purchase order.
We've created a purchase order containing one item with the cost of $10:
On the product page, under the Stock & Availability tab, we can confirm that the stored cost is indeed $10:
Going back to the purchase order, click the Attach New Invoice button:
Fill in the required fields (Tax and reference) and click the "Save Invoice" button to reveal a table:
Click the "+" in the new table and fill in "Title" and "Unit price" with your surcharges. In case of a discount, type a negative number. Be sure to leave the "Line Type" on "Finance".
That's it! The line will automatically be saved. We added a shipping cost of $150, and we ordered two products. This surcharge will be distributed equally on the two items, adding $75 to each of the stored costs, summing up to $85:
What happens if the purchase order contains more than one product?
The surcharge/discount will be distributed using a weighted average of the items cost as the cost driver.
Item | Quantity | Cost | Weight (qty x cost) | Percentage of surcharge added ¹ | Amount added to each item² |
Product A | 20 | $ 10 | 200 | 22.22 % | $ 1.70 |
Product B | 2 | $ 100 | 200 | 22.22 % | $ 16.70 |
Product C | 10 | $ 50 | 500 | 55.56 % | $ 8.30 |
|
| Total Weight | 900 |
|
|
¹ Weight / Total Weight
² $ 150 x weighted percentage / total quantity