OMS – New Outlet PO
Purchase orders linked with ordering. Edit any cell and the totals update.
| Code | Item name | Supplier | Order qty | Purchase qty | Purchase cost | Purchase value | Return qty | Return value | Type | Remarks | Extra 1 | Extra 2 | Status | Cost (RM) | Stock value | Main category | Sub category | Brand | Brand company | 1000 product | JSH (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 ✓).
Outlet report
Same report as Overall, but for one outlet. Tick one or more locations. With one location you can type pcs sent, status and sales; with several you see the combined total. The totals flow back into the Overall report.
All outlets summary
Outlets are listed in order (B01, B02, B03 and so on). Click an outlet name to open it.
| Outlet | Sent | Sold | Left | Stock value | Sold % | Reading | Budget | Budget left | Budget status |
|---|
Reading uses the GOOD and MIDDLE limits from the Overall report: FAST = sold % at or above the GOOD limit, MIDDLE, SLOW = below the MIDDLE limit. Selling price and cost come from the Overall report. Budget is compared with Outlet stock value (stock left × cost). Tick the locations, type the budget and press Set budget; a red warning shows when a location is over budget.
Supplier visits and salesman attendance
Click a supplier to see its items, PO quantity, sales, last visit and when to call. Add a new supplier below.
| Link | Company (supplier) | Status | Remarks | Items | Visiting days | Last visit | Next visit | Days left | Call on | Salesmen | Present today | Attendance % |
|---|
| Company name | |
| Salesman name | |
| Contact number | |
| Visiting days |
| Visiting reminder | |
| Delivery reminder | |
| Purchase entry | |
| Purchase return | |
| TAKE ORDER | |
| RETURNS |
| Visited date | Next visit | Visiting reminder | Returns | Take order | Delivery date | Delivery reminder | Delivered date | Purchase entry number | Purchase entry reminder | Purchase return number | Purchase return reminder |
|---|
PO items
| Code | Item | Order qty | Purchase qty | Return qty | Sold | Left | Sold this round | Received at warehouse |
|---|
Items here are the same items as the Overall report. Type the quantity of the PO. Type pcs sold in Sold this round and press Enter; it is added to the monthly sales automatically.
Salesmen attendance
Click a name to type the real salesman name. Click a day to change it: empty, then P (present), A (absent), L (leave), then empty again. Attendance % = P ÷ days marked.
Staff login
Type your ID and PIN.
Warehouse flow: order, pick, load, deliver
One cycle for every outlet. Click an outlet on the board, add it to today’s schedule, then tick each step as it is done.
Loading schedule (by lorry and trip)
Delivery schedule (by lorry and trip)
Same layout as the route sheet: rows are the lorries (D1 to D4), columns are Trip 1, 2 and 3, and each box is one outlet in stop order. Click an outlet to open it.
All outlets board
LOADING
DELIVERY
Not on today’s list Waiting Loaded Delivered Problem (step skipped)
Today’s route, by trip
| Driver | Stop | Outlet | Picked and scanned | Loaded | Delivered | In stock at outlet | Load order | Problem | Note |
|---|
Click a Picked, Loaded or Delivered cell to tick it. Load order: the last stop is loaded first, so the first stop is at the door of the truck.
Weekly schedule
Set which days each outlet gets delivery, or upload your weekly schedule. Each day the list fills itself from this.
Show the weekly table (outlets and days)
| Outlet | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Trip | Stop | Driver |
|---|
Upload columns: Outlet, Mon, Tue, Wed, Thu, Fri, Sat, Sun (put 1 or ✓ on delivery days), Trip, Stop, Driver (D1, D2 ...). Malay day names (Isnin, Selasa, Rabu...) also work. A file with columns Outlet and Day (one row per delivery) also works.
Not delivered from earlier days
Logins
Add each person here with their own ID and PIN. Warehouse staff see only their own job: asingkan barang, loading, delivery or stock in. Admins see the whole app.
How this solves the problems
- Items separated (scan items out on the invoice): tick Picked and scanned. Loading is blocked until this is ticked.
- Loading done or not: the LOADING board turns blue when loaded and stays yellow when still waiting.
- Loaded goods delivered or not: the DELIVERY board turns green when delivered. Anything not delivered shows in the earlier days list, and you can move it to today.
- Deliver B5 and load B3 at the same time: put B5 in Trip 1 and B3 in Trip 2. While Trip 1 is on the road, the loading team loads Trip 2. The route table tells them when.