OMS – New Outlet PO

Purchase orders linked with ordering. Edit any cell and the totals update.

Status0% available
Stock valueRM0.00
Done (received)RM0.00
Pending (waiting)RM0.00
Purchased so farRM0.00
ReturnedRM0.00
Warehouse stock valueRM0.00
Outlet stock valueRM0.00
Overall stock valueRM0.00
Overall marginRM0.00
Margin %–
In warehouse over 14 days0
1000 product (items)0
JSH (items)0
New outlet order PO (items)0
No-sales alerts0
Received, not in outlet stock0 items
Money stuck in stockRM0.00
New outlet order PO (link with ordering) / purchase out
CodeItem nameSupplierOrder qtyPurchase qtyPurchase costPurchase valueReturn qtyReturn valueTypeRemarksExtra 1Extra 2StatusCost (RM)Stock valueMain categorySub categoryBrandBrand company1000 productJSH (Jimat Setiap Hari)New outlet order PO
Total

Monthly sales review

Type pcs sold each month. After 3 months it tells you: continue, review or discontinue.

% sold = pcs sold ÷ pcs bought. Money stuck = pcs left × cost. Bought = Purchase qty (or Order qty if Purchase qty is empty), minus Return qty. Outlet stock = Sent to outlet − Sold. Overall stock value = Warehouse stock value + Outlet stock value. Type the selling price per pc: Margin per pc = selling price − purchase cost, Margin % = margin ÷ selling price, Overall margin = margin per pc × pcs sold. Middle option: for a MIDDLE – REVIEW item pick Extend (wait 1 to 3 more months of sales before deciding), Continue or Discontinue. Return % = return ÷ purchase. Stock cover = Bought (net) ÷ average monthly sales; a high number means overbought. Sent to outlet = pcs you already sent out; Warehouse stock = Bought (net) minus Sent, so purchase minus return that is not yet sent to outlets. Example: bought 100, sold 20 a month, after 3 months 60% sold = MIDDLE with the default limits. “Apply to Remarks” sets GOOD to ACTIVE and NO GOOD to DISCONTINUE.

Stock value = order qty × cost. DONE = stock received. PENDING = ordered, still waiting for stock. Status % is the share of stock value marked DONE. Everything is saved on the server and shared with the team (the box at the bottom right shows Saved ✓).