All guides
Guide · Purchases – A/P

Supplier items — what you buy from each supplier

The supplier's own item numbers, descriptions and prices, the primary supplier for an item, prices that keep themselves up to date from your bills, and how a purchase order fills itself in.

3 min read

Each supplier has its own name for what it sells you, its own price, and often its own pack size. BeanDish keeps one record for each item you buy from each supplier, so a purchase order fills in what the supplier expects to see and the price you last paid.

Where to find them

Open a supplier and go to its Items tab to see everything you buy from them. Open an item and go to its Purchases tab: the Suppliers list above its orders shows every supplier you buy it from.

Each row shows the Supplier item #, the supplier's description, the Price / unit, the Level, the average lead time in days and the date it was last purchased.

Adding one

Click Add item on the supplier, or Add supplier on the item, and fill in:

  • Supplier item # — the supplier's own code, printed on your purchase orders.
  • Supplier description — fills the purchase order line when set; otherwise the item's own description is used.
  • Price per purchase unit and Purchase unit — what the supplier charges, in the unit they sell in, such as a case.
  • Level — Primary or Secondary.

You don't have to add every row by hand. Sending a purchase order or posting a bill adds a row for any item bought from that supplier that has none yet, unless the line is one-time.

Primary, secondary and last

An item has at most one Primary supplier, and it is the same thing as the item's Preferred supplier: change one and the other follows. Making a supplier Primary moves any other to Secondary.

Last is not something you set. It is a badge on the supplier the item was most recently bought from.

Prices that keep up

When a bill is posted, each item line updates that supplier's price for the item, converted to the row's purchase unit. A row added automatically, with no price yet, takes the bill line's own unit and price.

Some lines never change a price: a debit memo, a line at $0.00, and a line ticked One-time. Tick One-time on a purchase order or bill line for a rush order or a special price — it doesn't update the supplier's price or lead time.

The average lead time is worked out from the last five deliveries: the days from each purchase order's date to its receipt. One-time purchases and scheduled deliveries on dated lines are left out.

A purchase order fills itself in

On a purchase order, picking an item fills the line from that supplier's row: its description, and its purchase unit and price together. Changing the unit converts the price. Change the supplier on a draft and each line is re-priced for the new supplier, in the unit it already has.

With no price on file for the supplier, a line starts at the item's last purchase cost, or its standard cost.

The purchase order page and the printed purchase order show the supplier's item number beside yours.

Importing a price list

To load a supplier's price list in one go, open Tables – Utilities › Import data and choose Supplier price list. Each row adds a supplier item or updates the one already there. Blank cells leave what is stored alone.