Stock ledger
Current stock and movements
Current balances are stored for speed, but the movement ledger is the source of every stock change.
Current stock by warehouse
| Product | Warehouse | Qty on hand | Average cost | Stock value |
|---|---|---|---|---|
| LUMI-FACE | Main Warehouse | 120 | Rp 50.000 | Rp 6.000.000 |
| LUMI-FACE | Secondary Warehouse | 30 | Rp 50.000 | Rp 1.500.000 |
| LUMI-NAJU | Main Warehouse | 70 | Rp 62.000 | Rp 4.340.000 |
| MED-DEVICE-001 | Main Warehouse | 8 | Rp 240.000 | Rp 1.920.000 |
| COSMETIC-001 | Sample / Marketing Stock | 250 | Rp 18.000 | Rp 4.500.000 |
Movement ledger
| Date | Product | Warehouse | Type | Qty | Unit cost | Total cost | Memo |
|---|---|---|---|---|---|---|---|
| 2026-06-19 | LUMI-FACE | MAIN | OPENING | 100 | Rp 50.000 | Rp 5.000.000 | Initial stock |
| 2026-06-19 | LUMI-FACE | MAIN | IN | 50 | Rp 50.000 | Rp 2.500.000 | Purchase receipt |
| 2026-06-19 | LUMI-FACE | MAIN | OUT | 20 | Rp 50.000 | Rp 1.000.000 | Sales shipment |
| 2026-06-19 | LUMI-FACE | MAIN | TRANSFER_OUT | 30 | Rp 50.000 | Rp 1.500.000 | Move to secondary warehouse |