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

Committed the moment the customer approved

PartSourceQtyCost
Master engine rebuild kit, 302MRK-302-69ordered · Summit Racing1$612.00
Main & rod bearing set (.010 under)CLE-MS590Pordered · Summit Racing1$184.50
Timing set, double rollerCLO-9-3100ordered · Summit Racing1$96.50
Oil pump, high volume, with pickupMEL-M68HVordered · Summit Racing1$88.00
Full gasket setFEL-KS2601off the shelf1$142.30
Cam bearing setDUR-SH290Sordered · Summit Racing1$34.90
Freeze plug set, brassDOR-565-021off the shelf1$18.75
Rear main sealNAT-4525off the shelf1$12.40
Motor mounts, pairANC-2288ordered · Summit Racing2$49.00
Water pumpGAT-43012ordered · WorldPac1$62.40
Thermostat & housing gasketSTA-33629ordered · WorldPac1$14.20
Radiator, 3-row copper/brassCSF-2456ordered · WorldPac1$268.00
Upper & lower hose setGAT-CHS-69Bordered · WorldPac1$32.80
Coolant, gallonPEA-1211off the shelf2$28.00
Front brake pads (set)BOS-0986off the shelf1$84.15
Front rotors, pairRAY-580-267ordered · PartsTech2$123.00
Brake fluid DOT 3, quartVAL-601442off 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.