Dave's Auto Center
Parts & inventory3.8

You are Curtis, in parts1 purchase order still to receive. Booking one in records the invoice number the bookkeeper matches against.

Parts

Parts: committed and received

RFP 3.8

Two things happen on this screen, and a person causes both: the customer's approval takes parts off the shelf, and booking a delivery in records the invoice number accounting will need.

1969 Ford Bronco Wagon302 ci V8
RO #4473Ray WhitakerVIN U15GL81234576,412 mi
11-char VIN · entered manually

Here — committed on approval

$1,859.30

17 parts came off the available count on Jul 10 at 9:42 AM, the moment Ray approved the work. Everybody in the shop has seen the true figure ever since.

Today — deducted at close and payment

$0.00

This repair order has been open 21 days and is not paid, so on paper those 17 parts are all still on the shelf. That gap is the reason a second stock system exists alongside the first.

Inventory value

$2,048.13

At cost, on hand

Committed

$285.60

3 approved jobs across the shop

Below minimum

2

After commitments, not before

Awaiting receipt

1

Purchase orders still open

What repair order 4473 needs

Every line traced to the job that asked for it

PartForSourceQtyCost
Master engine rebuild kit, 302MRK-302-69Engine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noisePO-2 · Summit Racing1$612.00
Main & rod bearing set (.010 under)CLE-MS590PEngine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noisePO-2 · Summit Racing1$184.50
Timing set, double rollerCLO-9-3100Engine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noisePO-2 · Summit Racing1$96.50
Oil pump, high volume, with pickupMEL-M68HVEngine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noisePO-2 · Summit Racing1$88.00
Full gasket setFEL-KS2601Engine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noiseoff the shelf1$142.30
Cam bearing setDUR-SH290SEngine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noisePO-2 · Summit Racing1$34.90
Freeze plug set, brassDOR-565-021Engine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noiseoff the shelf1$18.75
Rear main sealNAT-4525Engine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noiseoff the shelf1$12.40
Motor mounts, pairANC-2288Engine overhaul — R&R, machining, reassemblyfrom “Abnormal engine noisePO-2 · Summit Racing2$49.00
Water pumpGAT-43012Cooling system refreshfrom “Radiator flow & temperature dropPO-1 · WorldPac1$62.40
Thermostat & housing gasketSTA-33629Cooling system refreshfrom “Radiator flow & temperature dropPO-1 · WorldPac1$14.20
Radiator, 3-row copper/brassCSF-2456Cooling system refreshfrom “Radiator flow & temperature dropPO-1 · WorldPac1$268.00
Upper & lower hose setGAT-CHS-69BCooling system refreshfrom “Radiator flow & temperature dropPO-1 · WorldPac1$32.80
Coolant, gallonPEA-1211Cooling system refreshfrom “Radiator flow & temperature dropoff the shelf2$28.00
Front brake pads (set)BOS-0986Front brake servicefrom “Front pad thicknessoff the shelf1$84.15
Front rotors, pairRAY-580-267Front brake servicefrom “Front pad thicknessPO-3 · PartsTech2$123.00
Brake fluid DOT 3, quartVAL-601442Front brake servicefrom “Front pad thicknessoff the shelf1$8.40

Decline a job on the customer’s screen and its parts come straight back into the available count. Nothing stays held for work that was not agreed.

Purchase orders

Receiving captures the invoice number and date

  • PO-1Received

    WorldPac

    4 lines · RO-4473

    invoiceWP-884213· Jul 11

  • PO-2Received

    Summit Racing

    6 lines · RO-4473

    invoiceSR-2210447· Jul 12

  • PO-3Received

    PartsTech

    1 line · RO-4473

    invoicePT-55190· Jul 11

  • PO-4Ordered

    O'Reilly

    1 line · RO-4468

    records the invoice number and date

This is where accounting gets its key

Those invoice numbers are what the monthly supplier statement is matched against. Same field, two screens, three weeks apart.

See the reconciliation

Reorder

Available has fallen below minimum

  • Front brake pads (set)

    BOS-0986 · 1 available, min 4

  • Freeze plug set, brass

    DOR-565-021 · 0 available, min 2

Stock across the shop

Visible to every employee, without asking anyone

Part #NameBinOn handCommittedAvailableMinVendor
FEL-KS2601Full gasket set, SBF 302M-043122WorldPac
NAT-4525Rear main seal, SBFM-046154WorldPac
PEA-1211Coolant, gallonF-01142128O'Reilly
BOS-0986Front brake pads (set)B-112114PartsTech
DOR-565-021Freeze plug set, brassM-071102Summit Racing
VAL-601442Brake fluid DOT 3, quartF-03996O'Reilly
MOB-1-M1Motor oil 5W-30 (5qt)F-02222212O'Reilly
AC-D8617Oil filterF-05313115O'Reilly

Live, and open to everyone. No separate application, no licence somebody has to be given, no walking to the counter to ask what is on the shelf.