SolvexaRetail
Manual ยท Items & Inventory
All TopicsBack to app

๐Ÿ“ฆ Items & Inventory

Add products ยท Print barcodes ยท Track stock ยท Detect shrinkage ยท Never run out

How to add a new Item

Every product you sell needs one Item record. Setup takes 30 seconds for a basic item, longer if you use variants or batches.

  1. Open Items โ†’ Item List โ†’ + New Item (or click the search bar โ†’ + New)
  2. Fill mandatory fields: Item Code (auto-generated if you leave blank), Item Name, Category, UOM (Pcs / Kg / Ltr), Sales Price, GST Rate (0/5/12/18/28)
  3. Optional: HSN Code (mandatory for GST > โ‚น1.5cr turnover), Barcode, MRP, Brand, Reorder Level
  4. Click Save. Item appears in POS + Purchase pickers immediately.
๐Ÿ’ก Grocery shortcut: use Voice Item Onboarding (mic icon on Items page). Say "Coca-Cola 500ml, MRP 40, 12% GST" โ€” Saathi drafts the item in one tap.

Barcodes & label printing

If your item doesn't have a factory barcode, generate one and print thermal labels.

  1. Go to Items โ†’ Item Label Print
  2. Search + tick the items you want labels for
  3. Pick label size: 40ร—25mm (2 per row), 50ร—30mm (single), or 80mm receipt strip
  4. Set quantity per item (default 1 per SKU; type higher for bulk stock)
  5. Click Print. Browser print dialog opens โ€” send to your Zebra / TVS / Godex thermal printer.
๐Ÿ–จ Barcode format is auto-selected: EAN-13 if the code is 13 digits, otherwise Code-128 (handles alphanumeric like ITM-001).

Units of measure & multi-UOM

Buy in one unit, sell in another. Example: buy Coca-Cola in cartons of 24 bottles, sell in single bottles.

  1. On the Item form, expand Multi-UOM section
  2. Add rows: Base UOM = Bottle (1:1). Purchase UOM = Carton (conversion 24 = "1 Carton = 24 Bottles")
  3. Set Default Purchase UOM = Carton, Default Sales UOM = Bottle
  4. Save. Now PO auto-shows Carton in supplier's language; POS sells in Bottles.

Physical stock count (cycle count)

Reality check your on-hand quantity โ€” post the difference as an adjustment. Once a month at minimum; weekly for high-shrink categories.

  1. Open Stocks โ†’ Physical Stock Take โ†’ โ–ถ Start Count
  2. Pick Store + optionally filter by Category (e.g. only Dairy for a focused count)
  3. System snapshots current on-hand โ†’ generates a worksheet. Print or use on tablet.
  4. Count physically. Scan each item's barcode + enter counted qty. Enable Add-to-count mode to scan shelf-by-shelf without resetting.
  5. Review the variance table. Green = match. Yellow = overage. Red = shortage.
  6. Click Review & Post. Adjustment ItemLedger entries auto-post. Inventory table refreshed.
โš  Posting is irreversible. If you spot a counting error, do a second stock take on just that item โ€” the two adjustments will net out.

Ad-hoc stock adjustments

For expiry write-offs, damage, or opening-stock loads (not from a physical count).

  1. Stocks โ†’ Item Journal โ†’ + New Line
  2. Pick Item + Store. Pick Entry Type: Positive (add) / Negative (remove) / Transfer
  3. Enter quantity + reason (Damage / Expiry / Sample / Opening-Load)
  4. Click Post. Item Ledger + Inventory + GL (via Adjustment account) all update.

Reorder / auto-replenishment

Set a Reorder Level on each item. When on-hand drops below it, the item shows on Stocks โ†’ Replenishment Queue โ€” with a suggested order qty based on your sales velocity.

  1. On the Item form: set Reorder Level (e.g. 10) and Reorder Quantity (e.g. 50)
  2. Optional: enable ARS (Auto Replenishment System) at Stocks โ†’ ARS Setup โ€” sets levels by category based on last-30-day sales
  3. Visit Stocks โ†’ Replenishment Queue daily. Tick items โ†’ Convert to PO. Draft PO opens with your default vendor.

Allow Negative-Stock Sales (per-item flag)

Every Item has an Allow Negative-Stock Sales toggle on the Flags row (Item form โ†’ Flags). Default OFF โ€” POS refuses any sale that would drive Inventory.QtyOnHand at this store below zero. Sale rolls back cleanly with:

โš  Item PARA500 has only 3 in stock at this store; line needs 15. Reduce line qty, receive stock, or tick the item's "Allow negative-stock sales" option.

Tick ON per-item for:

Interaction with TrackInventory:

๐Ÿ’ก Schema: Item.AllowNegativeStock BIT NULL DEFAULT 0 (migration 502). Guard runs in POS sale-post BEFORE line insert โ€” no partial commits.

Batches & expiry (pharma, dairy, packaged food)

For items where different batches have different expiry dates, enable batch tracking on the Item form: Track Batches = Yes, Track Expiry = Yes.

Item Ledger (full movement history)

Every stock movement โ€” purchase, sale, transfer, adjustment โ€” creates an ItemLedgerEntry. Trace where every unit came from and went.

  1. Open Stocks โ†’ Item Ledger List
  2. Filter by Item + Store + Date range
  3. Each row shows: Entry Type, Document No, Qty, Remaining Qty (for open receipts), Source
  4. Click โค“ Excel to export for further analysis or share with auditor.
๐Ÿ’ฌ Ask Saathi: "stock of item X" ยท "low stock items" ยท "which batches expire this month" โ€” instant answers.