Main Warehouse Inventory and Procurement Manual
Last Updated: October 2026
Audience: Main Warehouse administrators and office staff using the Admin panel
This manual explains how to keep the Main Warehouse stock up to date: set up items and suppliers, order from suppliers, receive goods, and read stock levels and the stock ledger. It covers the work done in the Admin panel before stock is sent to bakery branches. For branch deliveries, see the Branch Supply Manual for the Main Warehouse.
What you can do
| Role | What they can do |
|---|---|
| Super admin, Administrator | Create and edit items, suppliers, purchase orders and goods receipts. Mark orders as ordered, post receipts, record opening balances. |
| Executive, HR admin, Payroll master, Office staff | View Stock levels and Stock ledger (read only). |
If a button described below is missing, your role does not have permission for it.
Where to find things
Open the Admin panel and use the left sidebar.
Ingredients & Packaging Inventory
| Menu | Use it to |
|---|---|
| Items | Manage ingredients, packaging and miscellaneous supplies |
| Stock levels | See how much of each item is on hand at each location |
| Stock ledger | See every stock movement, newest first |
| Settings | Open Units, Item types, Brands, Locations and Suppliers |
Procurement
| Menu | Use it to |
|---|---|
| Purchase orders | Plan and track orders to suppliers (optional step) |
| Goods receipts | Receive goods and add them to Main Warehouse stock |
First-time setup order
Set things up in this order so dropdowns have the choices you need:
- Units (kg, g, sack, box, pcs)
- Item types (Ingredients, Packaging and Miscellaneous Supplies already exist) and Brands (optional but recommended)
- Locations (Main Warehouse should already exist)
- Suppliers
- Items, including each item's purchase units
- Opening balance for stock you already have on the shelf
- Normal work: Purchase orders and Goods receipts
Units, item types, brands and locations
All four are under Ingredients & Packaging Inventory → Settings.
Units
Each unit has:
- Code: a short stable name such as
kilogram. It cannot be repeated. - Name and Symbol: the symbol shows beside the name in dropdowns (for example
kg). - Dimension: Mass, Volume, Count or Container.
- Base unit for dimension: turn on for the smallest standard unit of that dimension (for example gram for mass).
Use Container for things bought in packs such as sacks, boxes or cases. A container unit only works for an item once you tell the item how many base units are inside one container (see Items).
Item types
An item type says what kind of thing an item is. Three exist from the start: Ingredients, Packaging and Miscellaneous Supplies. Add your own with the New button.
Each item type has:
- Name: shown wherever you pick or see an item type.
- Can be used in recipes: turn on for types whose items go into a recipe, such as ingredients and packaging.
- Active: inactive types cannot be picked for new items. Items that already use the type keep it.
You can rename a type at any time. A type can only be deleted while no item uses it.
Brands
Each brand has a Code, a Name and an Active switch. Inactive brands do not appear when you create items.
Locations
Each location has a Code, Name, Location type, an optional Branch, and switches for Active and Default for branch.
- Main Warehouse is the location used for all purchasing in this manual.
- Branch stock rooms are created for each bakery branch. See the Branch Supply Manual for the Main Warehouse.
Items
Go to Items and select New item.
Item details
| Field | Notes |
|---|---|
| Sku | Optional. Must be unique if you enter one. |
| Name | Required. Names are shown in Title Case. |
| Brand | Optional. Only active brands are listed. |
| Item type | One of the types under Settings → Item types, such as Ingredients, Packaging or Miscellaneous Supplies. |
| Base unit (smallest UOM) | Required. All stock quantities are stored in this unit. Pick the smallest unit you track (for example gram or piece). |
| Barcode | Optional. |
Purchase units
Add one row for each way you buy the item.
| Field | Notes |
|---|---|
| Purchase unit | For example sack, box, case. |
| Base qty per purchase unit | How many base units are in one purchase unit. |
| Supplier | Optional. |
| Quoted price (PHP) and Additional cost (PHP) | Optional starting prices. |
| Default purchase unit | The unit pre-selected on purchase orders and receipts. |
Example: Flour has base unit gram. One sack holds 25,000 grams, so enter Base qty per purchase unit = 25000. Receiving 4 sacks adds 100,000 grams to stock.
You can always buy in the base unit itself. The base unit appears in the purchase unit list automatically.
Tracking
| Switch | Meaning |
|---|---|
| Track inventory (default on) | The item keeps stock levels. Items with this off cannot be ordered or received. |
| Track batches (default on) | Receipts record a batch number. |
| Track expiry (default off) | Receipts must include an expiry date. |
| Is active (default on) | Inactive items are hidden from order, receipt and opening balance lists. |
Purchase price history
Open an item and select the Purchase price history tab to see past prices. You can add a price by hand (supplier optional, unit price, effective date, notes). Prices are also added automatically when you post a goods receipt or save a supplier catalog quote. When you pick an item on a purchase order, the unit cost is filled in from this history when a price exists. You can still change it.
Suppliers and catalog quotes
Go to Settings → Suppliers and select New supplier. Enter a Code (unique), Name, and keep Is active on.
Open a supplier and use the Catalog quotes tab to record what they sell:
| Field | Notes |
|---|---|
| Item and Purchase unit | Cannot be changed after saving. Create a new quote instead. |
| Quoted price (PHP) | Price per purchase unit. |
| Package quantity | Defaults to 1. |
| Is preferred | Marks the preferred quote. |
| Effective from / Effective until | Leave the end date empty for an open quote. |
Saving a quote also adds a price to the item's purchase price history.
Record an opening balance
Use this once per item and location to enter stock you already have on the shelf.
- Go to Stock levels.
- Select Record opening balance.
- Choose the Item and Location.
- Enter the Quantity in the item's base unit. Optionally enter Unit cost (PHP) and Notes.
- Submit. You will see Opening balance recorded.
If the item already has stock at that location, you will see Opening balance already recorded. Stock adjustments are not available yet, so an opening balance cannot be used to correct stock that is already on hand.
Purchase orders
A purchase order (PO) is optional. Use it when you want to track what you ordered against what arrived. One PO can include lines from several suppliers.
PO numbers look like PO-20261013-000001.
Create a PO
- Go to Procurement → Purchase orders and select New purchase order.
- Under Order details, check Receive into (defaults to Main Warehouse), set an Expected date, and add notes if needed.
- Under Lines, add at least one line:
- Supplier
- Item (picking an item fills the default purchase unit and, if known, the unit cost)
- Purchase unit
- Quantity ordered
- Unit cost (PHP) (cost per purchase unit) and Additional cost (PHP). The unit cost is worked out from the item's latest price for the purchase unit you picked, and changes if you change the supplier or the purchase unit. You can type over it.
- Save. The PO starts as Draft.
PO statuses
| Status | Meaning |
|---|---|
| Draft | Can still be edited. No stock effect. |
| Ordered | Sent to supplier. Waiting for goods. |
| Partially received | Some quantity has been posted on receipts. |
| Received | Everything ordered has been received. |
| Cancelled | Closed without receiving. |
Status moves to Partially received or Received automatically when you post receipts.
Actions on the PO page
| Button | When it shows | What it does |
|---|---|---|
| Edit | Draft only | Change the order |
| Mark as ordered | Draft | Confirms the order. It needs at least one line. |
| Receive goods | Ordered or Partially received | Creates a draft goods receipt for the remaining quantities |
| Cancel order | Draft or Ordered | Cancels the PO. It is blocked once any quantity has been received. |
If the PO has remaining lines from more than one supplier, Receive goods asks which supplier you are receiving from. Create one receipt per supplier.
Goods receipts
A goods receipt adds stock to the Main Warehouse. Receipt numbers look like GRN-20261013-000001.
Receive against a PO
- Open the PO and select Receive goods.
- A draft receipt opens with the remaining quantities filled in.
- For every line, enter the Batch number (it starts empty). Enter the Expiry date if the item tracks expiry.
- Change Quantity (purchase unit) if only part of the order arrived.
- Check Unit cost (PHP) and Additional cost (PHP), then save.
- Open the receipt and select Post receipt. Confirm.
Receive without a PO
- Go to Procurement → Goods receipts and select New goods receipt.
- Leave Purchase order (optional) empty.
- Set Receive into and Received at.
- Add lines with supplier, item, purchase unit, quantity, costs and batch number (and expiry if required).
- Save, open the receipt and select Post receipt.
If you choose a PO, the form lists only POs that are Ordered or Partially received and fills the lines for you. Supplier, item and unit are locked on lines that come from a PO.
What posting does
Posting cannot be undone from the screen. The dialog says: This will create inventory batches and ledger entries.
- Stock at the receiving location increases, in the item's base unit.
- A batch is created for each line, with its batch number and expiry.
- The PO line's received quantity goes up and the PO status updates.
- A price is added to the item's purchase price history.
- The ledger shows a Purchase receipt entry.
Cost per base unit = ((unit cost × quantity) + additional cost) ÷ quantity in base units.
Only Draft receipts can be edited or posted.
Stock levels and the stock ledger
Stock levels
Go to Stock levels. Columns:
| Column | Meaning |
|---|---|
| SKU, Item, Location | What and where |
| On hand | Quantity in stock (base unit) |
| Reserved, In transit | Hidden by default. Use the column toggle to show them. In transit is stock sent to a branch and not yet accepted. |
| Available | On hand minus reserved |
| Avg cost | Average cost per base unit in PHP |
Filter by Location or Item, or search by SKU or name. Stock levels are read only, apart from Record opening balance.
Stock ledger
Go to Stock ledger for the history of every movement. Entries are never edited. Each row shows the entry number (ILE-20261013-000001), date and time, transaction type, item, location, quantity and who recorded it. Quantity is green for stock in and red for stock out. Filter by Transaction type, Location or Item.
Common messages and what to do
| Message | Cause | Fix |
|---|---|---|
| Each receipt line must have a batch number. | A line has no batch number. | Enter one on every line, then post again. |
| Expiry date is required for item SKU. | The item tracks expiry. | Enter the expiry date. |
| Cannot receive more than the remaining ordered quantity. | Receipt quantity is more than what is left on the PO line. | Lower the quantity. |
| Goods receipt must have at least one line. | Receipt has no lines. | Add a line. |
| Cannot post a receipt against a cancelled purchase order. | The PO was cancelled. | Create a new receipt without a PO or a new PO. |
| Only draft goods receipts can be posted. | Receipt is already posted. | Nothing to do. Check the stock ledger. |
| Cannot cancel a purchase order that already has received quantity. | Goods were already posted. | Leave the PO as is. |
| Purchase order must have at least one line. | Marking as ordered with no lines. | Add a line and try again. |
| No item-specific package conversion for item SKU. / No global conversion defined for unit code. | The chosen purchase unit has no conversion to the base unit. | Add the unit under the item's Purchase units with Base qty per purchase unit. |
| Opening balance already recorded | The item already has stock at that location. | Do not repeat it. |
Frequently asked questions
Do I have to use purchase orders? No. You can post a goods receipt without a PO.
Can one PO have lines from different suppliers? Yes. Receive each supplier's goods on its own receipt.
Why is an item missing from the item dropdown? It must be Active and have Track inventory on.
Which unit are stock quantities in? The item's base unit. Orders and receipts use purchase units and are converted on posting.
Can I undo a posted receipt? Not from the screen. Ask a system administrator before trying to correct posted stock.
What is not covered yet? Stock at bakery branches is covered in the Branch Supply Manual for the Main Warehouse. Recipes and bakes are covered in the Production Recipes Manual for the Main Warehouse. Wastage, damage, stock corrections and sales deductions are not available yet.