Solavel Docs
English

Customer items

Last updated

Customer items record what you agreed with one customer about one item: the customer's own code and name for it, an agreed price with optional quantity tiers and dates, a discount, and whether you may sell the item to that customer at all. SolaCount uses them to price sales document lines for that customer, to warn about items blocked for a customer, and to show what each customer actually paid.

Linking an item to a customer never stops other customers from buying it, and an agreement never changes a document that was already issued.

Typical users: sales staff who keep customer prices up to date, and accountants who check selling prices before posting.

#Where to find it

Screen How to open it What you do there
Customer page, Items section AR (Sales) → Customers → open a customer, below the profile Add, edit and remove this customer's item agreements; export them.
Customer page, Sales price history Same page, under Items Posted sales of every item to this customer.
Item page, Customers section Products & Services → open an item Every customer with an agreement for this item; add a customer.
Item page, Sales price history Same page, under Customers Posted sales of this item to every customer.
Sales document forms Lines of new or edited quotes, sales orders, invoices and sales receipts The agreed price, the price source, the last price sold, and the blocked-item check.

The sections appear only when your plan includes price lists (Premium and above) and your role has Customer item terms: View. The history sections also need Customer sales history: View. See Who can do what.

#Add or edit an agreement

On the customer page click Add item (or on the item page Add customer), choose the item or customer, fill in the form and click Save. Click Edit on a row to change it, or Remove to delete it ("Remove this customer–item agreement? Documents already issued are not changed.").

Field Required Rules Meaning
Status Yes Approved, Blocked or Historical. See Statuses.
Customer item code No Up to 100 characters. The customer's own code for the item, for example from their purchase orders.
Customer item name, Customer item description No The customer's own name and description.
Print on documents No Tick box. Marks that the customer's code and name should be shown on printed documents.
Currency No An enabled currency, or Any currency. Leave it empty to use the agreed price in any document currency. A price is never converted between currencies.
Discount % No 0 to 100. Taken off the tier price.
Price decimals No Organization default, or 2 to 6. How many decimals the agreed prices may have. More decimals than allowed are refused, never rounded: "Use at most 3 decimal places for this agreement."
Pricing rules No Tick box, on by default. "Do not apply pricing rules on top of the agreed price." Untick it to let your pricing rules still apply.
Contract reference, Contract start, Contract end No The end must be on or after the start. For your reference.
Notes No Internal notes.
Price tiers No Minimum quantity greater than 0, Unit price 0 or more, optional Valid from / Valid to, Active. Each tier applies from its minimum quantity. Two active tiers with the same minimum quantity cannot overlap in dates. Without a tier the agreement only sets the customer's code or the status.

A customer can have only one agreement per item ("This customer already has an agreement for the item. Edit the existing agreement instead."). If someone else changed the agreement while you were editing, you see "Someone else changed this agreement. Reload and apply your change again." Every change is kept in the agreement's history.

Export CSV on either section downloads the agreements and their tiers.

#Statuses

Status Meaning Effect on sales documents
Approved The agreed price is used on new sales documents. The line is priced from the agreement.
Blocked You must not sell this item to this customer. The line shows "This item is blocked for this customer." and saving is refused unless you may override.
Historical Kept for reference only. Not used for pricing.

#How the agreed price is chosen

When you pick an item on a line for the customer, SolaCount looks for an Approved agreement and uses:

  1. the active tier that is valid on the document date,
  2. with the highest minimum quantity that is not above the line quantity,
  3. less the agreement Discount %,
  4. only if the agreement currency is empty or equals the document currency.

The agreed price comes before any price list (document, customer, customer group or default list) and the item's own price. Under the line SolaCount shows Agreed price with the tier, the Price source (for example Customer agreement, Customer price list or Item price) and, when the customer bought the item before, Last sold … on … with Apply. The last price is only used if you click Apply.

A price you type by hand is kept (Manual price kept) and is never silently replaced when you edit the document later. If you are not allowed to override prices, changing an agreed price is refused: "You are not allowed to change the agreed customer price. Keep the agreed price or ask someone allowed to override prices."

#Selling a blocked item

Without Blocked customer item: Override, a line with an item blocked for the customer is refused: "This item is blocked for this customer. Choose another item or ask someone allowed to override blocked customer items."

With the permission, click Override block… on the line, give a Reason (required) and click Confirm override. The override is recorded in the agreement history with your reason. Undo removes it before you save. Documents issued before the item was blocked are never checked again.

#Sales price history

The history comes from posted invoices and sales receipts only: drafts, voided or reversed documents, recurring templates and retainers are left out. The unit price is the line amount after discounts and before tax, divided by the quantity; the base price divides by the document's exchange rate. Credit notes are not counted as prices; returned quantity is shown separately.

Filter by date (From, To) and search. The summary per customer (or per item) shows Documents, Total quantity, Total value, Last price, Lowest, Highest and Weighted average, all in your base currency. If a document line did not store a unit, the item's current unit is shown.

#Worked example

{Organization name} agrees with {Customer 3 name} to sell A4 Copy Paper 80gsm (SKU PAP-A4-80) at AED 21.00 a ream, or AED 19.50 from 50 reams, from 1 November 2026, with a 2% discount. On {Customer 3 name}'s page, under Items, the accountant clicks Add item, picks the paper, leaves Currency empty, enters Discount % 2 and two tiers (from 1 at 21.00, from 50 at 19.50, valid from 2026-11-01) and saves.

On an invoice dated 5 November for 60 reams the line is priced at 19.50 × 0.98 = AED 19.11, with Agreed price 19.11 AED (tier from 50) and Price source: Customer agreement. For 10 reams it is 21.00 × 0.98 = AED 20.58. An invoice for another customer is priced as before from the price lists.

#Who can do what

Action Permission Starts out equal to
See agreements and the price hints on forms Customer item terms: View View customers
Add, edit, remove and export agreements Customer item terms: Manage Manage price list product prices
See sales price history Customer sales history: View View invoices
Sell an item blocked for a customer Blocked customer item: Override Override resolved transaction prices

Owners have all four. Change them in Role overrides; see Roles and permissions.

#Common problems

Problem Why What to do
The Items or Customers section is missing Your plan has no price lists, or your role lacks Customer item terms: View. Ask an owner.
The agreed price is not used The agreement is not Approved, no tier is valid on the document date or quantity, or the agreement has another currency. Check the status, tiers and Currency.
A line is refused as blocked The item is Blocked for this customer. Choose another item, or ask someone with Blocked customer item: Override.