Skip to main content

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​

RoleWhat they can do
Super admin, AdministratorCreate and edit items, suppliers, purchase orders and goods receipts. Mark orders as ordered, post receipts, record opening balances.
Executive, HR admin, Payroll master, Office staffView 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

MenuUse it to
ItemsManage ingredients, packaging and miscellaneous supplies
Stock levelsSee how much of each item is on hand at each location
Stock ledgerSee every stock movement, newest first
SettingsOpen Units, Item types, Brands, Locations and Suppliers

Procurement

MenuUse it to
Purchase ordersPlan and track orders to suppliers (optional step)
Goods receiptsReceive 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:

  1. Units (kg, g, sack, box, pcs)
  2. Item types (Ingredients, Packaging and Miscellaneous Supplies already exist) and Brands (optional but recommended)
  3. Locations (Main Warehouse should already exist)
  4. Suppliers
  5. Items, including each item's purchase units
  6. Opening balance for stock you already have on the shelf
  7. 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.

Items​

Go to Items and select New item.

Item details​

FieldNotes
SkuOptional. Must be unique if you enter one.
NameRequired. Names are shown in Title Case.
BrandOptional. Only active brands are listed.
Item typeOne 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).
BarcodeOptional.

Purchase units​

Add one row for each way you buy the item.

FieldNotes
Purchase unitFor example sack, box, case.
Base qty per purchase unitHow many base units are in one purchase unit.
SupplierOptional.
Quoted price (PHP) and Additional cost (PHP)Optional starting prices.
Default purchase unitThe 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​

SwitchMeaning
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:

FieldNotes
Item and Purchase unitCannot be changed after saving. Create a new quote instead.
Quoted price (PHP)Price per purchase unit.
Package quantityDefaults to 1.
Is preferredMarks the preferred quote.
Effective from / Effective untilLeave 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.

  1. Go to Stock levels.
  2. Select Record opening balance.
  3. Choose the Item and Location.
  4. Enter the Quantity in the item's base unit. Optionally enter Unit cost (PHP) and Notes.
  5. 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​

  1. Go to Procurement → Purchase orders and select New purchase order.
  2. Under Order details, check Receive into (defaults to Main Warehouse), set an Expected date, and add notes if needed.
  3. 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.
  4. Save. The PO starts as Draft.

PO statuses​

StatusMeaning
DraftCan still be edited. No stock effect.
OrderedSent to supplier. Waiting for goods.
Partially receivedSome quantity has been posted on receipts.
ReceivedEverything ordered has been received.
CancelledClosed without receiving.

Status moves to Partially received or Received automatically when you post receipts.

Actions on the PO page​

ButtonWhen it showsWhat it does
EditDraft onlyChange the order
Mark as orderedDraftConfirms the order. It needs at least one line.
Receive goodsOrdered or Partially receivedCreates a draft goods receipt for the remaining quantities
Cancel orderDraft or OrderedCancels 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​

  1. Open the PO and select Receive goods.
  2. A draft receipt opens with the remaining quantities filled in.
  3. For every line, enter the Batch number (it starts empty). Enter the Expiry date if the item tracks expiry.
  4. Change Quantity (purchase unit) if only part of the order arrived.
  5. Check Unit cost (PHP) and Additional cost (PHP), then save.
  6. Open the receipt and select Post receipt. Confirm.

Receive without a PO​

  1. Go to Procurement → Goods receipts and select New goods receipt.
  2. Leave Purchase order (optional) empty.
  3. Set Receive into and Received at.
  4. Add lines with supplier, item, purchase unit, quantity, costs and batch number (and expiry if required).
  5. 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:

ColumnMeaning
SKU, Item, LocationWhat and where
On handQuantity in stock (base unit)
Reserved, In transitHidden by default. Use the column toggle to show them. In transit is stock sent to a branch and not yet accepted.
AvailableOn hand minus reserved
Avg costAverage 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​

MessageCauseFix
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 recordedThe 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.