Skip to main content

Inventory Costs Overview

How SubBase values inventory: average unit cost, on-hand value, what a job is charged when stock is pulled, and how asset rent and losses are charged.

Written by Gabby Gutman

With inventory costing turned on, warehouse stock carries a cost. Consumables are charged to the job when they are pulled, and assets charge rent to the job while they are out.

Before you start

  • Your company must have inventory costing turned on. Ask your Admin, or contact us.

  • You see costs only with Enable price visibility, on the Orders permissions in Company Settings.

  • Setting a cost, revaluing it and editing asset rates also need Set & Revalue Costs, on the Inventory permissions.

Where costs show

  • Stock tab: a Unit cost for consumables, a Rate for assets, and an On-hand value per item. The total above the list is the Warehouse value.

  • The item drawer: a Cost tab on consumables and a Rates tab on assets.

  • Requests: a Cost on each line and a Request total above the lines. Once anything comes back, Returned and Job cost show beside it.

  • On site tab: the Rate each asset went out at, and its Charge to date.

How consumable cost works

Each consumable has an average cost per warehouse, material and unit. It is a weighted average of PO line prices; freight, fees and tax are not included. A PO receipt into the warehouse blends its price into the average. So does an Add on the Add/Remove tab when you enter a Unit cost.

A pull is costed once, at the average of the moment the stock leaves the warehouse, and that cost never changes afterwards. Returning pulled stock brings it back at the cost it was pulled at.

An item with no cost yet shows Needs cost. Its pulls are uncosted until someone sets one.

Set or revalue a cost

  1. Open the item from the Stock list and go to the Cost tab.

  2. Click Set cost, or Revalue if it already has one.

  3. Enter the Unit cost.

  4. On a revalue, enter a Reason. It is required.

  5. On a first cost, tick the box to apply it to earlier uncosted pulls, if you want to.

  6. Click Set cost or Revalue.

A revalue changes the average from now on. Pulls already made keep the cost they were charged.

How asset rent works

On an asset's Rates tab you set a Daily, Weekly and Monthly rate, and a Purchase cost.

  • Each unit out adds the daily rate per day, but never more than the weekly rate in a week or the monthly rate in a month, counted from the checkout day.

  • The checkout day counts as day 1, even if the unit comes back the same day. The day it comes back is not charged.

  • Days follow your company's time zone. Charges post to the job and cost code overnight, so a day's charge shows the next morning.

  • Rates lock when an asset goes out. A rate change applies from the next checkout.

  • The purchase cost is used for on-hand value and lost-asset charges. It is never charged as rent.

Lost assets

When Charge lost assets to the job is on, an asset reported lost charges its purchase cost to the job and cost code it was out on. It is in Other Settings in Company Settings, and each warehouse can override it in its own settings.

Notes and limits

  • On-hand value counts available, committed and on-hold units. Rejected units are not counted.

  • Warehouse value covers every costed item in the warehouse, whatever your search or filters. Items that need a cost are left out.

  • A unit cost must be above $0.

  • An asset with no daily rate when it went out shows No rate and accrues no rental charge.

Best practices

  • Set a cost before an item's first pull. Until then its pulls go to the job uncosted, and they only pick up a cost if you tick the box when you set the first one.

  • Do not revalue to fix what a job was charged. Past pulls keep their cost, so a revalue only changes what is pulled next.

  • Keep the weekly rate below 7 days at the daily rate, and the monthly below 30 days of the rates above it. Otherwise the cap never applies, and the Rates tab warns you that it never applies.

If this doesn't work

Start a chat from the Messenger in the bottom-left of this page, or email [email protected]. Include the order or project number and what you expected to happen.

Related

Did this answer your question?