Skip to content

Inventory Setup ​

Inventory setup prepares stock records for controlled movement, valuation, reorder, POS, production, agriculture, and other stock-backed execution.

Open Inventory -> Setup.

Setup Goal ​

Inventory setup should make sure users can:

  • identify stock-managed items clearly
  • hold stock in valid warehouses or locations
  • link stock items to approved operational items
  • receive, issue, transfer, reserve, and count stock
  • value stock consistently
  • support supplier procurement, receiving, returns, and invoice matching
  • use stock in POS, production, agriculture, and billing workflows
  • post inventory accounting correctly where enabled

Workspace Reference ​

WorkspaceOpen FromMain Create ButtonMain Record
Item CategoriesInventory -> Setup -> Item CategoriesNew Stock Item CategoryInventory category used for policy, reporting, valuation, and accounting grouping.
Stock ItemsInventory -> Setup -> Stock ItemsNew Stock ItemInventory-managed SKU used for stock balances and movements.
WarehousesInventory -> Setup -> WarehousesAdd Warehouse Location or location create actionShared operational location used as a stock holding point.
Production SetupInventory -> Setup -> Production SetupNew BOM or New RoutingReusable material recipe and production route.

Service guides may send Production or Agriculture users here when they need a produce item, feed item, medicine item, warehouse, BOM, or routing. The owner of those masters remains Inventory: create the shared stock category, stock item, warehouse, BOM, or routing here, then let the service workflow consume it.

Operational Items Versus Stock Items ​

The operational item is the shared business identity. It can represent a product, service, material, finished good, spare part, chargeable item, or non-stock item.

The stock item is the inventory-managed record. It adds stock behavior, movement controls, valuation behavior, warehouse balances, and tracking options.

Record TypeUse It For
Operational itemShared identity reused across billing, POS, pricing, production, agriculture, events, and inventory.
Stock itemItems that need quantity balance, warehouse movement, stock take, reservation, or valuation.

Not every operational item should become a stock item. Services, subscriptions, digital offerings, and non-stock charges should remain outside inventory unless there is a real stock balance to manage.

For restaurants and similar back-office store operations, create operational items for physical materials and supplies, not menu dishes. Examples include tomatoes, chicken breast, cooking oil, bottled water, paper napkins, takeaway containers, dinner forks, dishwashing liquid, and surface sanitizer.

Item Categories ​

Stock item categories group inventory records for operational, reporting, and accounting behavior.

Click New Stock Item Category.

Use categories to control or describe:

  • stock family
  • valuation grouping
  • handling rules
  • reporting group
  • default accounting tags
  • downstream use in POS, production, agriculture, procurement, or other stock-backed workflows

Categories should be broad enough for reporting but specific enough for policy. Avoid placing unrelated stock under one category if they need different valuation, handling, or accounting treatment.

Typical restaurant categories include Fresh Produce, Meat And Poultry, Fish And Seafood, Dry Foods And Staples, Cooking Ingredients, Dairy And Chilled Stock, Beverage Stock, Table Service Consumables, Reusable Operating Items, Cleaning And Hygiene Stock, and Packaging And Takeaway Supplies.

Important category fields:

FieldMeaning
Category code or nameUser-facing category reference.
Parent categoryOptional grouping for category hierarchy.
DescriptionExplains when users should select the category.
Accounting or valuation settingsDefaults used where stock accounting depends on category policy.
Active statusWhether the category is available for new stock items.

Stock Items ​

Create a stock item only when the organisation needs inventory balance, movement, reservation, stock take, or valuation.

Click New Stock Item.

Important stock item details include:

Field Or SettingMeaning
Linked operational itemShared item identity that this stock record represents.
Item code and nameUser-facing reference used in search, movement, and reporting.
Base UOMPrimary unit used for stock balance.
CategoryReporting, handling, and accounting grouping.
Tracking behaviorLot, batch, serial, expiry, or none.
Valuation behaviorHow cost and stock value should be interpreted.
Reorder settingsMinimum, maximum, reorder level, or replenishment thresholds where used.
Active statusWhether the item can be used for new inventory activity.

Tracking rules should be configured before stock is received. Changing tracking after stock exists can make balances difficult to explain.

For expiry-sensitive stock such as fresh milk, meat, fish, vegetables, and chilled products, configure expiry and batch or lot requirements before the first receipt. For reusable operating items such as plates, cups, trays, and cutlery, choose controls that support issue, return, loss, and breakage instead of treating the items as daily consumables.

Units Of Measure ​

Inventory depends on clear UOM setup.

Before receiving stock, confirm:

  • base UOM is correct
  • purchase UOM conversions are clear
  • sale UOM conversions are clear where POS is used
  • production UOM conversions are clear where BOMs are used
  • fractional quantities are allowed only where operationally valid

Incorrect UOM setup causes price, quantity, production, and valuation errors.

Warehouse Locations ​

Warehouses are maintained through shared operational locations. Inventory uses locations that represent stock holding or stock movement points.

Open Inventory -> Setup -> Warehouses or the shared Administration -> General Setup -> Operational Locations workspace when maintaining warehouse locations.

Before using a warehouse, confirm:

  • it is active
  • it belongs to the correct business unit or operating area
  • users understand whether it is a physical store, storage room, processing site, vehicle, quarantine area, damaged-goods area, or virtual holding area
  • transfer routes or movement responsibilities are clear

Do not create duplicate warehouses for the same physical location unless finance and operations need separate stock responsibility.

For restaurant department reporting, create locations for responsibility, not just walls and rooms. A branch can have one real Main Store and several operating stores such as Local Food Store, Harakat Store, and Barista Store. Stock should be received into the Main Store, transferred to the operating store, and consumed from the operating store. This lets Inventory reports show which kitchen consumed which stock without forcing departments to become business units.

Important warehouse fields:

FieldMeaning
Location name or codeUser-facing warehouse or store reference.
Location typeShould identify the location as a warehouse or stock-holding point where applicable.
Business unit or ownerOperating area responsible for stock held there.
Parent locationOptional hierarchy such as branch, building, store, room, or zone.
Active statusWhether the location can be used for new stock activity.

Tracking: Batch, Lot, Serial, And Expiry ​

Use tracking when users need to know which exact stock was received, sold, consumed, returned, or expired.

Tracking TypeUse It When
Batch or lotStock is received and issued in identifiable production or supplier lots.
SerialIndividual units require unique tracking.
ExpiryStock can expire or become unusable after a date.
NoneItem can be controlled by quantity only.

Tracking improves control but adds operational work. Use it where it is genuinely needed.

Batch and lot numbers should come from supplier packaging, delivery documents, or a controlled internal receipt reference. They should not be random values. If no supplier value exists, use a consistent internal pattern such as REC-20260305-NAKASERO-001 so later issues, supplier returns, and stock counts can be traced back to the receipt.

Production Setup ​

Production setup defines reusable manufacturing or assembly structures.

Open Inventory -> Setup -> Production Setup.

Use:

  • BOMs to define input components for an output item
  • Routings to define operational steps, resources, labour, quality checks, or execution sequence

Production setup can support POS kits, apparel production, agriculture processing, food production, assembly, and general manufacturing. Agriculture may consume these shared BOMs or routings for processing flows, but it should not maintain a second service-owned production master.

Before using a BOM:

  • confirm output item is correct
  • confirm input items are active stock items
  • confirm quantities and UOM are correct
  • confirm waste, scrap, or yield assumptions
  • confirm routing steps are operationally realistic
  • confirm cost absorption expectations

Important production setup fields:

FieldMeaning
Output itemStock item being produced.
Component itemInput material consumed by the BOM.
Component quantity and UOMExpected material requirement.
Wastage, scrap, or yield assumptionExpected production loss or output assumption.
OperationProduction step in the routing.
SequenceOrder of production steps.
Resource or resource typeCapacity used by the operation where configured.
Default BOM or routingNormal recipe or route used when several versions exist.

Accounting Readiness ​

Inventory can affect accounting when receipts, issues, adjustments, write-downs, landed costs, or production movements post value.

Before go-live, confirm:

  • inventory asset accounts are mapped
  • cost of goods or consumption accounts are mapped
  • adjustment and write-down accounts are mapped
  • wastage, spoilage, breakage, and stock variance accounts are mapped
  • supplier return and debit-note accounting treatment is clear
  • landed cost treatment is clear
  • production variance or absorption treatment is clear
  • control-account tracking is available where required
  • posting periods and approval rules are understood

Cost of goods sold is normally a direct expense category, not a separate foundation account type. It should be presented separately from operating expenses where the income statement needs gross profit.

Setup Checklist ​

  • Shared operational item exists where needed.
  • Stock category is correct.
  • Stock item uses the right UOM and valuation behavior.
  • Warehouse location is active and correctly scoped.
  • Tracking requirements are configured before stock is received.
  • Reorder settings are reviewed where used.
  • BOM components and routing steps are reviewed before production orders use them.
  • GL tags and posting rules are reviewed for stock movements and valuation changes.
  • Procurement document types and approval workflows are reviewed before supplier purchasing starts.
  • Supplier party roles are ready before creating purchase orders or goods receipts.
  • POS, production, agriculture, and billing users know which shared stock items and warehouses they should use.

Common Mistakes ​

MistakeBetter Practice
Creating duplicate item identities across POS, production, or agriculture.Use shared operational items and create stock items only where stock is managed.
Treating Agriculture as the owner of produce-item or warehouse setup.Keep those masters in Inventory and let Agriculture consume them as context.
Enabling serial or batch tracking after stock exists.Decide tracking before first receipt.
Using warehouse locations without business ownership.Assign locations clearly to operating areas.
Ignoring UOM conversion.Confirm purchase, sale, stock, and production UOM rules.
Using random batch, lot, or source references.Use supplier references or controlled internal receipt references.
Treating restaurant menu dishes as back-office stock items.Create raw materials, consumables, reusable operating items, and supplies.
Treating non-stock services as inventory.Keep services as operational or billable items outside stock management.
Treating a stock transfer as COGS.Transfer only moves stock responsibility; issue, wastage, disposal, or adjustment records consumption.
Duplicating stock categories per kitchen for COGS reporting.Use stock locations or operating stores for the kitchen split, because the same stock category can be consumed by several kitchens.

Pinkapple ERP by Stat Solutions Network