Skip to main content

Bring in your opening stock

Record the stock already on your shelves at what it really cost, in a bin your team can pick from.

Opening stock tells Brahmin Solutions what's already there and what it cost you. Do it after products and vendors, before your first sales order.

​

There are two ways in: receive a purchase order, or post an adjustment that adds stock with its cost. If your accounting system is already connected, ask your bookkeeper which way to use. Either way, enter quantity and cost per base unit (each), not per case.

​

With a purchase order

  1. Create a purchase order with the quantity you hold and the unit cost you paid on every line. See Create a purchase order.

  2. Confirm it. See Confirm a purchase order.

  3. Receive it. In Location, choose a bin your team picks from, such as Storage, not Receiving. See Receive a purchase order.

​

Choosing Storage on the receive form

​

With an adjustment

  1. In the top menu, click Inventory, then under Inventory Movement click Inventory Adjustment (New).

  2. Under Details on the right, check the Warehouse is the one the stock is in.

  3. Search for the item and click it.

  4. Click Add location and choose a pickable bin, such as Storage. Type the quantity in Adjust.

  5. The Cost box starts at the item's current average cost, which is 0.00 for a new item. Replace it with what one unit really cost you.

  6. Click Post adjustment, check the confirmation, and post it.

​

Full steps, including lot numbers and expiry dates, are in Add or remove stock with an adjustment. On a purchase order, see Receive items with a lot or batch number and Receive items with an expiry date.

​

Put it in a pickable bin

Stock in a bin that isn't Pickable, such as Receiving, can't be picked for an order. Available and Can pick still count it, so the numbers won't warn you. Check the bin on the item's Inventory tab. A bin's setting is in Settings, Warehouses & Locations, Areas & bins. To fix it, see Move stock to another bin.

​

Why 0.00 hurts

The cost you enter becomes the item's average cost (MAC), which every sale takes its cost from. A 0.00 cost drags the average down for everything you hold:

​

Step

On hand

Average cost

Add 10 at $5.00

10

$5.00

Add 10 more at $0.00

20

$2.50

​

Now every unit sells at a cost of $2.50, not $5.00, so each sale shows $2.50 more profit than it really made.

​

How to know it worked

Open the item from Inventory, Inventory. On hand shows the quantity, MAC shows the cost per base unit (for example per each, if you bought in cases), and the Inventory tab shows the bin. A fully received purchase order shows Fulfilled.

​

If a cost went in wrong, see Correct an item's average cost (MAC).

​

Related articles

Did this answer your question?