Why it exists
The workbook is right until two people open it.
A parts library in one spreadsheet and a BOM file per job will carry a shop a surprisingly
long way. It falls over in the same four places every time: nobody can say what is free to
use, the buyer re-keys the same part onto a PO, the floor takes stock nobody wrote down, and
the job cost is a guess made after the fact.
VisualShop was built around those four holes, and nothing else. It is not an ERP. There are
no quotes, no sales orders and no vendor invoices — those stay in the accounting package
that already handles them.
Follow a part through the system
One library
One PartID per part, with every vendor, every manufacturer number and
the last six prices paid. No more “is this the same breaker?”
One number for free stock
On hand, less what is allocated to a released work order, less what is
tagged to another job. Worked out once and used everywhere.
Cost, not an estimate
Material at what it cost coming off the shelf, outside services at what
the vendor charged, labour at the shop rate. Projected while the job is still open.