LIVE DEMO · Laravel 13 · PHP 8.4 · SQLite · no JavaScript framework Laravel 13 · PHP 8.4 · SQLite Built by Zohaib Ahmad →
M Mehran Distributors

← All stock

PVC Pipe 6" x 20ft

PVC-6-20 · Pipes · sold by the length

On hand
104 length
64 above reorder level
Value at cost
PKR 400,400
3,850 per length
Margin
16.7%
sells at 4,620
Free to sell
104
0 committed to open orders
On order
0
nothing on the way
Status
OK
reorder at 40

Count and adjust

When the shelf disagrees with the screen, the fix is not to type the new number over the old one — that destroys the only thing that makes a stock figure trustworthy. Enter the count you actually made and the system works out the difference, writes it to the ledger below, and requires a reason. An unexplained correction is the one thing this refuses.

Stock ledger 3 movements

When Source Reason Document Change Balance after
02 Oct 2026, 17:00 Sales order Dispatched on SO-2451 SO-2451 -12 64
29 Sep 2026, 00:00 Purchase order Received on PO-0101 PO-0101 +40 104
13 Sep 2026, 10:41 Adjustment Opening balance — +76 76

The ledger is append-only. Nothing edits a quantity directly — the figure above is whatever the last movement left behind, which is why it can always be explained.