Purchase Terms
The Purchase Terms connect a stock item to its vendors. One item can have many purchase terms. These are used for auto-filling Purchase Orders, and for lead time and cost estimation when items are not in stock.
Jump to:
- Demo video Setting Up: Procured Items, Purchase Terms
- Create a Purchase Term.
- Use of Purchase Terms to auto-fill purchase orders.
- Use of Purchase Terms when estimating costs.
- Import Purchase Terms.
- Update Purchase Terms.
Saving a Purchase Term
- Open the article details in Stock -> Items.
- Scroll down to the Purchase Terms table. (If you do not see it, mark the checkbox for This is a procured item)
- Click "+" to add a new Purchase Term.
- Fill in the Price per UoM and Lead time fields, which are mandatory.
- The price is per 1 unit of item, or 1 unit of vendor UoM.
- The lead time is measured in business days, defined by the "Working hours" setting.
- Optionally, fill in:
- Vendor part no. - part number of the vendor.
- Min. quantity - minimum order quantity (MOQ) for this purchase term.
- Priority - useful if the item has several purchase terms, a higher number indicates higher priority.
- Vendor-specific unit of measurement - useful when the item should have another unit of measurement on the purchase order.
- Save.
Conversion from a vendor's unit of measurement
If the vendor has another unit of measurement than used in your stock:
- Go to the Purchase terms table at the bottom of the Item details page, and create a new purchase term or edit an existing one.
- Check the option Vendor-specific unit of measurement.
- Enter the name of the unit to the Vendor's UoM, e.g. 1 box.
- If the unit of measure is indivisible, select the option Indivisible UoM. Then a decimal quantity will be rounded up.
- Set the Conversion rate, e.g. 40 pcs = 1 box.
- Set the Price per UoM and Min. quantity according to the vendor's UoM, e.g. box.
When a purchase order is created, then the PO will show the vendor's unit of measurement which will be converted into your internal unit.
Entering price breaks or pricing tiers from a vendor
To enter price breaks from one vendor, enter several purchase terms with the same vendor, and for each define the Minimal order quantity of the pricing tier and a different Price per UoM. MRPeasy will choose the correct tier according to the PO quantity.
For example, 4 pricing tiers:
Vendor | Priority | Price per 1 unit | Min. quantity |
Vendor A | 10 | 10 | |
Vendor A | 10 | 9 | 10 |
Vendor A | 10 | 7 | 50 |
Vendor A | 10 | 5 | 100 |
Use of Purchase Terms when Creating Purchase Orders
When adding a Part to a purchase order:
- If it has one vendor, all details will be filled in automatically.
- If it has several vendors, its vendors will be highlighted in bold. After choosing the vendor, all details will be filled in automatically.
- If you choose a Vendor, then the parts from this vendor will be highlighted in bold. After choosing the part, all details will be filled in automatically.
- If a Vendor part number is chosen, only purchase terms with the same vendor part number are compared.
How the suitable Purchase Term is chosen:
- The purchase term with the highest priority, which satisfies the Minimal Order Quantity, is chosen.
- If there are several terms with equal priority, which all satisfy the Minimal Order Quantity, then the lower price term is chosen.
- If no supply terms meet the minimum quantity requirement, the term with the highest priority is used. If in this situation there are several terms with the highest priority the lower price term is chosen.
For example, if an item has four purchase terms:
Vendor | Priority | Price per 1 unit | Min. quantity |
Vendor A | 30 | 4 | 100 |
Vendor B | 25 | 4.5 | 100 |
Vendor A | 20 | 5 | 20 |
Vendor A | 10 | 6 |
Then, if the order quantity is
- greater than 100, the price is set to 4.
- less than 100, but greater than 20, the price is set to 5.
- less than 20, the price is set to 6.
Use of Purchase Terms when estimating the cost of out-of-stock items
When creating a Manufacturing Order and materials are not in stock, then the purchase term selection corresponds to the use of purchase terms when creating Purchase Orders.
At Stock -> Items page column "Cost", BOM cost estimation, and CO cost estimation, when the item is not in stock, the cost of the procured item is found as follows:
- The software selects the purchase term with the highest priority.
- If several purchase terms have the same priority, the lowest price is selected.
- Minimal order quantities are ignored.
Uploading and updating Purchase Terms
Updating Purchase Terms:
- When a purchase order is saved and an item has only one purchase term, then MRPeasy will use the price from the purchase order to automatically update the purchase term.
To disable this functionality, please go to Settings -> System Settings -> Software settings, and change the setting Update purchase terms from PO to No. - It's possible to bulk update purchase terms at Procurement -> Vendor -> Particular vendor's reports: Purchase terms.
- To upload new purchase terms for existing items from a CSV file, or to update existing ones, please go to Procurement -> Vendors -> Import from CSV.