Inventory and Raw Materials
Introduction
Inventory is where your stock sits before it is sold or used. Each department has its own stores. Goods you buy arrive in the Main Store. Ingredients move from there to Production before they are cooked. Raw materials, the ingredients and supplies you buy but never sell directly, are defined on the Raw Materials tab.
Both live on the Suppliers page. They need the Open Suppliers permission and the Premium plan. The sidebar highlights Suppliers whenever you are on an inventory page. Everything shown is for the department you are working in.
Note
Inventory (the stores) is different from the POS > Stock tab. The Stock tab is what the till sells from. Stores hold what is kept behind the scenes. See Stock.
The Inventory Tab
Open Suppliers > Inventory. It has three tabs: Dashboard, Manage Inventories and Transactions. The first time you open it, your department gets a Main Store and a Production store automatically.
Dashboard
The Dashboard shows one card per store: its name, a badge for the type (Main, Production or Sales), the number of Items and the Total Value in KES. The value is each item's quantity times its buying price, added up. Click a card to open that store's items.
Manage Inventories
This tab lists your stores with Name, Type, Department, Item Count and Total Value.
- Create Inventory: type the Inventory Name (for example "Kitchen"), choose the Type (Main Store, Production or Sales) and the Department, then press Create. You see Inventory created successfully.
- ⋯ > Edit changes a store. You see Inventory updated successfully.
- ⋯ > Delete asks you to confirm "This action cannot be undone." A store with items cannot be deleted: Cannot delete inventory with existing items.
Most businesses only need the Main Store and Production stores that are created for them.
Transactions
The Transactions tab is the log of every stock movement in your department's stores. Newest first, 20 per page.
Filter with the search box (reference or item name), All Inventories, All Types, Date From and Date To. The columns are Date, Type, Inventory, Item, Quantity, Buying Price, Total Value, Reference and Created By.
The Type is one of: Receive, Issue, Transfer In, Transfer Out, Adjustment, Production Use, Production Output, Move to POS.
Items in a Store
Click a store card on the Dashboard to see its items. The page is titled "Main Store - Inventory Items". Search by name, or click the Item heading to sort A to Z or Z to A. The columns are Item, Quantity, Unit, Buying Price, Total Value and Actions.
Total Value is the quantity times the buying price. Buying Price is a weighted average, so it moves each time you receive stock at a different price. For raw materials each delivery is also kept as its own priced batch (see Costing).
Receiving Stock into a Store
Normally the Receive step of a purchase order puts stock into the Main Store for you (see Suppliers and Purchase Orders). To add stock by hand:
- Press Receive Stock at the top of the store page.
- Choose an Item, type the Quantity and the Buying Price, and press Add to list. An item can be listed only once (That item is already in the list.).
- Add a Reference (for example "GRN#123" or "Opening stock") and Remarks if you like.
- Press Receive 2 item(s) at the bottom. You see 2 item(s) received successfully.
You can also receive a single item with ⋯ > Receive on its row.
Issue, Adjust and Transfer
On any item, ⋯ > ... opens a window with the Quantity, Buying Price, Reference and Remarks (press Save):
| Action | What it does |
|---|---|
| Receive | Adds the quantity |
| Issue | Takes the quantity out, for example to use it in the hotel |
| Transfer | Moves it to another store of the same department. You pick the Destination Inventory. The store's log shows Transfer Out and the other store's log shows Transfer In. |
| Adjust | Sets the quantity to a new count. Zero is allowed. |
Quantities must be above zero, except for Adjust. A transfer larger than the stock says Insufficient stock for Raw Beef. On success you see Transaction completed successfully. If something goes wrong you see Transaction failed: with the reason.
Transfer to Production
Only on the Main Store page. Use it to move several items to the Production store in one go, the usual step before cooking.
- Press Transfer to Production.
- Choose an Item and Quantity, and press Add to list. If the Main Store does not have enough you see The Main Store does not have enough stock.
- Add a Reference (for example "Production issue #123") and Remarks.
- Press Transfer 3 item(s) at the bottom. You see 3 item(s) transferred to Production.
Move to POS Stock
On the Main Store page, stock items (not raw materials) have a ⋯ > Move to POS Stock action. It takes the quantity out of the store and adds it to the till's stock as a new batch at the buying price shown. The log records it as Move to POS.
Note
Stock items received through a purchase order arrive in the Main Store only, so use Move to POS Stock to make them available at the till. They are counted once: in the store until you move them, then in POS stock.
Only Main Store stock items can be moved: Only Main Store stock items can be moved to POS stock.
Raw Materials
A raw material is something you buy and use in making things, such as flour, raw beef or cooking oil. It is never sold at the till, so it does not appear on the POS or the Stock tab. It is stocked in your stores, ordered on purchase orders, and used in recipes (see Recipes).
Open Suppliers > Raw Materials. The list shows the Name, Unit, In stock (the quantity in the department's Main Store), and Reorder level. A Consumable badge marks supplies. Search by name.
Adding a Raw Material
- Press Add Raw Material.
- Type the Name, for example "Raw Beef". It must not match another product's name.
- Choose the Unit (or No unit). Optionally set a Reorder level.
- Optionally enter an Opening quantity and a Buying cost (cost per unit) for the stock you already have in the Main Store.
- Press Add. You see Raw material saved.
With an opening quantity, the stock goes into the Main Store as the first priced batch. A cost without a quantity only saves the price, so purchase orders can pre-fill it.
To change one, use ⋯ > Edit. You can change the name, unit, reorder level and the Consumable switch. The Buying cost here is the current cost used to price new purchase orders.
⋯ > Delete asks Delete this raw material? A raw material used in a recipe or combination cannot be deleted: This raw material is used in a recipe or combination and cannot be deleted. You see Raw material deleted. when it works.
Consumable Supplies
Switch on Consumable supply for things that are issued to where they are used rather than cooked: bed sheets, detergent, sauces. They are bought, stocked and costed like any raw material, but are kept out of recipe ingredients. Use Issue on the store page to hand them out.
Costing
Raw materials use first in, first out (FIFO) costing. Each delivery is kept as its own batch with its own price, and the oldest batch is used first. The cost of what you use is therefore what you actually paid, not an average.
Note
Changing a raw material's Buying cost on the edit window only changes the price used to fill new purchase orders. It does not change the cost of batches already received.