Solavel Docs
English

Supplier item terms

Last updated

Supplier item terms record how you buy one item from one supplier: the supplier's own code and product name, the currency, the unit the supplier sells in, the minimum order and order multiple, the lead time, a supplier discount and a list of dated price tiers. SolaCount uses them to suggest vendor prices on bills and purchase orders, to filter the item search by supplier, to stop purchases from a supplier that is blocked for an item, and to compare suppliers against what you actually paid.

Saved terms are your agreed vendor prices. They never change a document, a journal entry, a cost or an inventory valuation by themselves. What you actually paid comes from posted bills and is shown separately as Purchase history.

Typical users: buyers and purchasing clerks who keep supplier prices up to date, and accountants who check what was paid before posting a bill.

#Where to find it

Screen How to open it What you do there
Item page, Suppliers section Inventory → Catalog → Products & Services → open an item (/inventory/items/{id}), below the item details Add, edit and remove the suppliers of this item; import and export the pricelist.
Item page, Vendor comparison section Same page, under Suppliers Compare every supplier's vendor price with the last price paid, in your base currency.
Item page, Purchase history section Same page, under Vendor comparison Posted bill lines of this item, with statistics per supplier.
Supplier page, Items supplied section AP (Purchases) → Suppliers → open a supplier (/suppliers/{id}) Every item this supplier has terms for.
Supplier page, Purchase history section Same page, under Items supplied Posted bill lines from this supplier, with statistics per item.
Bill and purchase order forms Line items of New Bill and New Purchase Order Vendor price chips, the Only this supplier's items search switch and the blocked-supplier check. See Bills and Purchase orders.
Vendor pricelist import and export Import pricelist and Export CSV on the item and supplier sections See Vendor pricelists.

The sections appear only when your role has Supplier item terms: View and your plan includes the Suppliers feature. Without them the sections are simply not shown. Vendor comparison also needs the Purchase Analytics feature, and both history sections need Supplier purchase history: View. See Permissions and plans.

#Which app manages the terms

Each item has one set of terms per supplier, kept in one app only. Nothing is copied between SolaCount and SolaStock, so the two apps can never disagree.

Item Terms are managed in What SolaCount shows
Any item in an organization that uses SolaCount only SolaCount The terms, editable with Supplier item terms: Manage.
Services and non-inventory items, and any item not linked to a SolaStock item, in a SolaStock-connected organization SolaCount The terms, editable as above.
An item linked to SolaStock in a connected organization whose SolaStock owns the catalog, while the connection is active SolaStock The SolaStock terms, marked Managed in SolaStock. You can edit them from SolaCount; the change is made in SolaStock with your SolaStock role and plan.
The same item while the connection is paused SolaStock The terms, read only, with "The SolaStock connection is paused. Supplier terms managed in SolaStock are read-only until it is active again."
The same item when your plans do not include the SolaCount and SolaStock connection SolaStock No terms, only "This item's supplier terms are managed in SolaStock. Your plan does not include the SolaCount–SolaStock connection, so they are not shown here."
Any item while the connection needs review Not changeable "The SolaStock connection needs review before supplier terms can change."

The connection is included when the organization has SolaCount Premium or above and SolaStock Premium or above. SolaStock Premium can also come through an eligible bundle, such as SolaCount Advanced or Enterprise. See Connecting SolaCount and SolaStock.

On a SolaStock-managed row you may also see Supplier not linked in SolaCount: the SolaStock supplier has no verified SolaCount supplier yet, so it cannot be chosen on SolaCount documents. Adding a SolaCount supplier to a SolaStock-managed item is refused while that supplier has no SolaStock counterpart: "This supplier is not linked to SolaStock yet, so it cannot have SolaStock item terms. It is linked automatically with its first connected purchase, or from the supplier's SolaStock link."

#The Suppliers section on the item page

The section title is Suppliers. Under the title you see the price rule (see How the vendor price is chosen).

Buttons (top-right of the section):

Button Shown when What it does
Export CSV Always Downloads this item's terms as a CSV file, one row per price tier.
Import pricelist You may manage terms and the terms are editable Opens the import window. See Vendor pricelists.
Add supplier You may manage terms and the terms are editable Opens the terms window for a new supplier.

Columns:

Column What it shows
Supplier The supplier name, with Preferred (star) for the preferred supplier, Managed in SolaStock when SolaStock keeps the terms, and Supplier not linked in SolaCount when that applies.
Status Approved (green), Blocked (red) or Historical (grey). A blocked row is highlighted.
Supplier SKU The supplier's code for the item, with the supplier product name underneath. — when empty.
Currency The currency of this supplier's prices.
Current price The price of today's tier with the lowest minimum quantity, followed by from N (that minimum). +N means more tiers are valid today. No current price when no active tier is valid today.
Minimum order / Order multiple Both quantities in purchase units, with the purchase unit underneath and ×factor when one purchase unit holds more than one item unit.
Lead time N days, or —.
Discount % The supplier discount, or —.
(actions) Edit (pencil) and the bin icon, when you may manage terms.

Rows are listed approved first, then historical, then blocked. When the item has no suppliers: "No suppliers are linked to this item yet."

Remove a supplier. Click the bin icon and confirm "Remove this supplier from the item? Purchase history is not affected." The terms and all their price tiers are deleted; posted bills and their history stay as they are. If it fails, the reason is shown at the top of the section.

#Add or edit a supplier's terms

  1. Click Add supplier, or Edit on a row. The window is titled Add supplier or Edit · Supplier name. The price rule is repeated at the top.
  2. Fill in the fields below.
  3. Under Price tiers, click Add tier for each price (up to 50) and fill the tier row.
  4. Click Save (it shows Saving… while working), or Cancel.

After a successful save the window closes, and the Suppliers section and Vendor comparison refresh. If something is wrong, the fields are marked and the banner says "Check the highlighted fields and try again."

Field Required Rules Notes
Supplier Yes, when adding A searchable list (Search suppliers) of active suppliers that are not linked to the item yet. Fixed when editing. Already linked: "This supplier is already linked to the item. Edit the existing terms instead." Missing: "Select a supplier from this organization."
Status Yes Approved (default), Blocked or Historical. A new Approved row for an inactive supplier is refused: "This supplier is inactive. Reactivate it or record the terms as historical."
Preferred No Tick Preferred supplier for this item. Only possible when the status is Approved. One preferred supplier per item: ticking it here removes the mark from the previous one. Changing the status away from Approved removes it. Otherwise: "Only an approved supplier can be the preferred supplier."
Supplier SKU No Up to 100 characters. The supplier's own code. Used by the item search on bills and purchase orders.
Supplier product name No Up to 255 characters. The name on the supplier's quotes. Also searchable on documents.
Currency No 3 letters, for example AED or USD. Empty: the supplier's currency, else your base currency. Vendor prices are suggested only on documents in this currency.
Purchase unit No Up to 50 characters, for example Box. The placeholder shows the item's unit. The unit the supplier sells in.
Item units per purchase unit No Greater than 0, up to 8 decimals. Default 1. How many item units one purchase unit holds, for example 5 reams per box.
Minimum order No Greater than 0, up to 6 decimals. In purchase units.
Order multiple No Greater than 0, up to 6 decimals. In purchase units. Orders are rounded up to a multiple of it.
Lead time (days) No Whole number from 0 to 3650. Used for the expected date in suggestions.
Discount % No 0 to 100. Taken off every tier price of this supplier.
Price decimals No Organization default (N), 3, 4, 5 or 6. How many decimals this supplier's prices may have and how they are shown. With the organization default, up to 6 decimals are accepted.
Supplier description No Up to 2,000 characters.
Notes No Up to 2,000 characters. Internal.

Price tiers ("Minimum quantity and unit price are per purchase unit. Saving replaces this supplier's tier list with the rows below."):

Column Required Rules
Min qty Yes Greater than 0, in purchase units, up to 6 decimals. The first tier you add starts at 1.
Unit price Yes 0 or more, per purchase unit, before the supplier discount. At most the supplier's price decimals.
Valid from No Empty means valid from the beginning.
Valid to No Empty means open-ended. Must be on or after Valid from: "The end date must be on or after the start date."
Active — Ticked by default. An inactive tier is kept but never used.
(bin) — Remove tier deletes the row when you save.

Without tiers the window shows "No price tiers yet. Add one so this supplier has a vendor price." A supplier without tiers can still be preferred, blocked or historical, but has no vendor price.

Decimals are checked, never rounded. A number with more decimals than allowed is refused with "Use at most 3 decimal places for this supplier." (with the supplier's number). Trailing zeros do not count: 95.000 is accepted with 3 decimals. Numbers use a dot for decimals; anything else gives "Enter a positive number using a dot for decimals."

Overlapping tiers are refused. Two active tiers of the same supplier with the same minimum quantity may not be valid on the same day: "Another active price tier with the same minimum quantity is valid on overlapping dates." Validity dates are inclusive, so a tier valid to 31 December and another valid from 31 December overlap. Tiers with different minimum quantities may overlap freely, and an inactive tier never overlaps.

Someone changed the terms meanwhile. If another person saved the same terms after you opened the window: "Someone else changed these terms. Reload and apply your change again." For a tier that was deleted meanwhile: "This price tier no longer exists. Reload and try again." For SolaStock-managed terms the same situation reads "These terms changed in SolaStock. Reload and apply your change again.", and "SolaStock could not be reached. Nothing was changed; try again." or "Your SolaStock role or plan does not allow changing supplier terms." can appear.

SolaStock-managed terms in this window. The Purchase unit is a list of SolaStock units that convert to the item's base unit, shown as Name (symbol) · base unit or Name (symbol) · ×24, instead of the text field and Item units per purchase unit. Everything else is the same.

#Statuses

Status Meaning On bills and purchase orders
Approved You buy this item from this supplier. Used for vendor price suggestions, the best-price hint, the supplier filter and comparison ranking. Only an approved supplier can be preferred.
Blocked You must not buy this item from this supplier. A warning chip appears on the line, and saving the bill or purchase order is refused unless you may override blocked suppliers.
Historical You used to buy it here; kept for reference. Never suggested. Purchase history is unaffected.

#How the vendor price is chosen

The rule is shown under the section title and in the terms window:

Vendor price: approved suppliers only; the active tier valid on the document date with the highest minimum quantity not above the ordered quantity (in the supplier's purchase unit), less the supplier discount. A suggestion never changes a document price until you apply it.

Step by step, for one document line:

  1. Only Approved terms are used. On a document, the terms must also be in the document's currency.
  2. The line quantity is in item units. It is divided by Item units per purchase unit to get purchase units.
  3. Among the tiers that are active and valid on the document date (both dates included), the tier with the highest Min qty that the purchase quantity reaches is chosen.
  4. If the quantity is below every tier (for example below the minimum order), the quantity the terms require is priced instead: at least the Minimum order, rounded up to the Order multiple. The chip then also offers "Order N to meet the supplier's minimum or multiple".
  5. The net price is the tier price × (100 − discount %) ÷ 100, per purchase unit.
  6. The price per item unit is the net price ÷ Item units per purchase unit, shown with the supplier's price decimals.
  7. Nothing changes on the document until you click Apply.

#Worked example 1: one supplier, tiers and a minimum order (AED)

{Organization name} (base currency AED) buys A4 Copy Paper 80gsm (SKU PAP-A4-80, unit Ream) from {Supplier 2 name}. {User 1 name} adds the supplier on the item page:

Field Value
Status Approved, Preferred supplier for this item ticked
Supplier SKU / product name EPT-80-5R / Copy paper A4 80g, box of 5
Currency AED
Purchase unit / Item units per purchase unit Box / 5
Minimum order / Order multiple 10 / 5 (boxes)
Lead time / Discount % / Price decimals 4 days / 2 / 3

Tiers: Min qty 10, Unit price 95.00, valid from 1 January 2026, open-ended; Min qty 50, Unit price 90.00, valid 1 October to 31 December 2026. She first types 95.1234 by mistake and sees "Use at most 3 decimal places for this supplier.", corrects it and saves.

On a bill dated 22 October 2026 from {Supplier 2 name}:

Line quantity Purchase units Tier used Net per box Chip shows
120 reams 24 boxes from 10 (24 reaches 10, not 50) 95.00 × 0.98 = 93.10 Vendor price 18.620 AED (tier from 10 Box) and "Order 125 to meet the supplier's minimum or multiple": 24 boxes is rounded up to 25.
20 reams 4 boxes none reaches 4, so 10 boxes are priced 93.10 Vendor price 18.620 AED and "Order 50 to meet the supplier's minimum or multiple"
250 reams 50 boxes from 50 90.00 × 0.98 = 88.20 Vendor price 17.640 AED (tier from 50 Box)

On a bill dated 5 January 2027, the 50-box tier has ended, so 250 reams are priced at 18.620 AED again. {User 1 name} clicks Apply on the price chip; the line price becomes 18.62. She leaves the quantity at 120, so that chip stays.

#Worked example 2: a USD supplier for an AED organization

{Organization name} also buys the same paper from {Supplier 3 name}: Currency USD, Purchase unit Box of 5, no minimum or multiple, lead time 30 days, price decimals 4, one tier from 1 box at 24.50 USD. The latest rate on or before 22 October 2026 is 1 AED = 0.2723 USD.

  • Per ream: 24.50 ÷ 5 = 4.9000 USD. In base currency: 4.90 ÷ 0.2723 = 17.994859 AED.
  • On the AED bill from {Supplier 2 name} (example 1), the line also shows "Lower vendor price from {Supplier 3 name}: 4.9000 USD", because 17.99 AED is below 18.62 AED after conversion. Pacific's price is never applied to an AED document.
  • On a bill from Pacific Paper in USD, the chip reads Vendor price 4.9000 USD (tier from 1 Box). On a bill from Pacific in AED there is no price chip: the currencies differ.
  • If no USD rate were stored on or before the date, Pacific would still be listed in Vendor comparison with No exchange rate, but it would not be ranked or offered as the lower price.

#Vendor comparison

The section Vendor comparison compares every supplier of the item at a quantity and date you choose. Under the title:

Prices are compared per item unit in the base currency, using the latest exchange rate on or before the date (base = foreign amount ÷ rate). Suppliers without a rate are listed but not ranked. Inventory valuation is not used.

Filters: Quantity (item units, default 1), Date (empty means today) and Apply. The note above the table reads Saved vendor price vs last paid price · Base amounts in AED (your base currency).

Column What it shows
Supplier Name, with Best price (trophy) for the cheapest ranked supplier, Preferred and Managed in SolaStock chips.
Status Approved, Blocked or Historical; No saved terms for a supplier that only appears in posted bills.
Vendor price The net price per item unit at that quantity and date, in the supplier's currency, with from N (the tier). — when no tier applies or the supplier is not approved.
Vendor price (AED) The same price in base currency, or No exchange rate.
Last paid (AED) Base unit cost of the latest posted bill line from this supplier, with its date.
Difference Vendor price minus last paid, both in base currency. Red with + when the vendor price is now higher, green when it is lower.
Weighted average Quantity-weighted average base unit cost of all posted bill lines from this supplier.
Lead time N days.

Ties in price are broken in favour of the preferred supplier. When you save terms on the page, the comparison reloads and keeps your quantity and date. Empty: "No suppliers are linked to this item yet."

Cost trend (under the table, base currency): one row per month (newest first, up to 24 months) and one column per supplier, with the quantity-weighted average base unit cost of that month's posted bill lines.

#Purchase history

Purchase history shows what you actually paid, from posted bills only. The note reads: "Prices actually paid on posted bills — separate from the saved vendor prices." followed by "From posted bills only (journal posted and not reversed). Unit cost is the line amount after discounts and before tax, divided by quantity; base cost divides by the bill's exchange rate."

  • A bill counts when its journal entry is posted and not reversed. Drafts, voided bills and bills whose journal was reversed are left out. Only item lines with a quantity above zero are used.
  • Unit cost = line amount after the line discount and the line's share of any document discount, before tax, ÷ quantity, in the bill's currency.
  • Base unit cost = unit cost ÷ the bill's exchange rate (1 base = rate foreign), so a USD bill at 0.2723 is converted with ÷ 0.2723.
  • History is read only. It never changes bills, journals, item costs or valuation.

Filters: From, To, Apply, and Reset after filtering.

Summary table (By supplier on the item page, By item on the supplier page):

Column Meaning
Supplier / Item The group. Several currencies appears when the group has bills in more than one currency. On the supplier page the item name links to the item.
Last cost Unit cost of the latest line, in its bill currency, with the date.
Lowest / Highest Lowest and highest base unit cost.
Weighted average Total base value ÷ total quantity.
Total quantity Sum of quantities.
Total value Sum of line amounts in base currency (after discounts, before tax).
Bills Number of bills.

Bill lines table: Date, Bill (opens the bill), Supplier invoice (the supplier's number), Supplier or Item, Quantity (with the unit), Unit price, Discount (line plus document discount), Tax (amount, with the tax name and rate), Currency, Rate, Unit cost, Base unit cost. 25 lines per page, newest first, with Previous, Next and Page X of Y. Empty: "No posted bills for this selection."

#Worked example 3: purchase history and comparison

{Organization name}'s posted bills for PAP-A4-80 (the organization shows amounts with 2 decimals; SolaCount calculates with 6):

Bill Date Supplier Quantity Unit price Discount Line amount Rate Unit cost Base unit cost
BILL-00101 10 Sep 2026 {Supplier 2 name} 100 19.00 AED 0.00 1,900.00 AED 1 19.00 19.00
BILL-00115 5 Oct 2026 {Supplier 2 name} 125 18.62 AED 50.00 2,277.50 AED 1 18.22 18.22
BILL-00120 12 Oct 2026 {Supplier 3 name} 50 4.90 USD 0.00 245.00 USD 0.2723 4.90 17.99

A draft bill and BILL-00109, whose journal was reversed, are not listed. By supplier shows:

Supplier Last cost Lowest Highest Weighted average Total quantity Total value Bills
{Supplier 3 name} 4.90 USD, 12 Oct 17.99 17.99 17.99 50 899.74 1
{Supplier 2 name} 18.22 AED, 5 Oct 18.22 19.00 18.57 225 4,177.50 2

The weighted average for Emirates is (1,900.00 + 2,277.50) ÷ 225 = 18.566667, shown as 18.57; Pacific's base cost is 245.00 ÷ 0.2723 ÷ 50 = 17.994859. In Vendor comparison at quantity 120 on 22 October, Pacific shows Best price at 17.99 AED with a difference of 0.00, and Emirates shows a vendor price of 18.62 AED against 18.22 AED last paid: +0.40 in red, because the saved price is above what the last bill paid after its discount. The cost trend shows October 2026 with 18.22 for Emirates and 17.99 for Pacific, and September 2026 with 19.00 for Emirates.

#The Items supplied section on the supplier page

The supplier page shows Items supplied: every item with terms for this supplier, from SolaCount and, in a connected organization, from SolaStock.

  • Search matches the supplier SKU, the supplier product name, the item SKU and the item name. Status filters by All statuses, Approved, Blocked or Historical.
  • Export CSV downloads this supplier's terms; Import pricelist (with manage permission) opens the import window.
  • Columns: Item (opens the item; SKU, Preferred and Managed in SolaStock underneath), Status, Supplier SKU (and product name), Current price, Minimum order (with the purchase unit), Lead time.
  • 25 rows per page, sorted by item name. Empty: "This supplier has no item terms yet." While the connection is paused: "SolaStock connection paused — read only".

Terms are edited on the item page; open the item from this list.

#Permissions and plans

Permission (as shown in role overrides) Allows Starts out equal to
Supplier item terms: View (purchases.supplier_items.view) The item and supplier sections, Export CSV, vendor price chips on bills and purchase orders. View suppliers (suppliers.view)
Supplier item terms: Manage (purchases.supplier_items.manage) Add supplier, Edit, remove, Import pricelist. Manage suppliers (suppliers.manage)
Supplier purchase history: View (purchases.supplier_items.history) Purchase history and Vendor comparison. View bills (purchases.bills.view)
Blocked supplier: Override (purchases.supplier_items.override) Saving a bill or purchase order line with a supplier that is blocked for the item. Manage suppliers (suppliers.manage)

"Starts out equal to" means that every role keeps the access it already had until an owner sets the new permission separately in Role overrides. The built-in Purchasing role has all four, because it manages suppliers. The Sales role has none of them. Owners have all four.

Plan feature Needed for
Suppliers (tracker.manage_vendors_suppliers) Everything on this page.
Purchase Analytics (tracker.purchase_reports_by_supplier_item) Vendor comparison and its cost trend.
SolaCount and SolaStock connection (Premium or above on both apps) Seeing and editing SolaStock-managed terms from SolaCount.

#Tips and common problems

Problem Cause Fix
The sections are missing on the item page No Supplier item terms: View, or the plan has no Suppliers feature. Ask an owner to check the role and plan.
Vendor comparison is missing No history permission, or no Purchase Analytics in the plan. As above.
No price chip on a bill line The supplier is not approved for the item, has no tier valid on the bill date, or its currency differs from the bill. Check the terms and the bill currency.
A USD supplier shows No exchange rate No USD rate on or before the date. Add a rate in Multi-currency.
Add supplier is missing on a SolaStock item The connection is paused or not in the plan, or you lack manage permission. Read the notice at the top of the section.
A price was refused for too many decimals The supplier's Price decimals is lower than the price you typed. Raise Price decimals or enter the supplier's real price.
Purchase history shows a lower cost than the bill price Unit cost is after line and document discounts. Expected; compare Unit price and Discount.