enalog.si

EN

Spare parts under control: stock, purchase orders and goods receipt in a small workshop

Spare parts under control: stock, purchase orders and goods receipt in a small workshopExample from practice
Foto: Pexels / Pixabay

Take a car repair shop with four mechanics. Filters, oils, brake pads and bulbs sit on shelves behind the workshop, and mostly the manager knows how much of each there is. When the oil runs out, it shows mid-service; orders go by phone and delivery notes end up in a drawer. At year-end the stock count takes two days and nobody knows why the numbers do not match.

This is an illustrative example many workshops will recognise. Below is how you organise stock in the eNalog warehouse: articles with barcodes, goods receipt, automatic deduction from work orders and purchase orders to suppliers.

What was getting in the way

  • ✓Stock lived in one person’s head, not in records.
  • ✓Parts used were written off from memory, or not at all.
  • ✓Phone orders left no trace, so it was unclear what had already been ordered.
  • ✓The stock count was long and the differences unexplained.

Spare parts under control: stock, purchase orders and goods receipt in a small workshop

Articles once, then just scanning

In Warehouse the manager uses New article to enter the name, code, barcode (EAN), unit, purchase and sales price, VAT rate and minimum stock. If the list already exists in Excel, it is saved as CSV and loaded with Import CSV. Articles with the same code or EAN are updated, so the import can be repeated.

Warehouse labels prints a label with a QR code for the shelf. When someone scans it with a phone, the stock of that warehouse opens. Barcodes are read by a USB scanner, or on a phone by the camera.

Goods receipt

When a delivery arrives, someone in the workshop books it in a few minutes:

  1. 1Clicks Goods receipt.
  2. 2Optionally enters the supplier and the delivery note number.
  3. 3Adds articles by scanning the barcode or searching, and enters quantity and purchase price.
  4. 4Confirms. Stock goes up and the purchase value is recalculated at the moving average price.

Work order: parts used from the warehouse among the items

Work order: parts used from the warehouse among the items

Usage on work orders and stock counts

The mechanic adds an article from the warehouse to the work order or scans its barcode. When the order gets the status Completed, stock goes down automatically. If the order is reopened, the articles go back into stock, so the stock is always right. Work is never blocked: even when stock runs out, the article can still be added to an order.

Articles below minimum stock are marked red, and the Running low filter shows them in one place. For a stock count the manager clicks Stock count and enters what was counted; scanning adds one piece to the article. Only the differences are booked.

Purchase orders to suppliers

In the Premium plan the warehouse also has Purchase orders and Suppliers tabs. Parts on open work orders are reserved, so each article shows the reserved, free and already ordered quantity. The Purchase orders tab shows at the top what is going to run out and suggests a quantity.

The manager checks the suggestions and clicks Prepare purchase orders: a draft is created for each supplier. They adjust quantities, enter the expected delivery date and click Send to supplier, and the supplier receives the order as a PDF. When the goods arrive, the manager opens the order, clicks Receipt and Book receipt. If only part arrived, the order is Partly received and the rest waits for the next delivery.

If a part is not in stock, the mechanic clicks Find at supplier on the work order and the search for that code opens in the supplier’s shop.

If spare parts are also kept in a van, a second warehouse is added in the Warehouses tab, for example the main warehouse and the van. One is the default, and work orders take parts from it. Each article shows its stock per warehouse, and a transfer moves stock from one to the other along with its purchase value. On receipt you choose where the goods arrived, and for a stock count which warehouse is being counted.

Dashboard: open work orders that reserve parts

Dashboard: open work orders that reserve parts

What changed

Stock is no longer in one person’s head but in records that update with every receipt and completed work order. The manager sees what is running low before it runs out, orders leave a trace, and the stock count shows only real differences. The workshop no longer waits for oil in the middle of a service.

Try eNalog in your workshop

Free for 14 days, no card required.

Try free for 14 days

← All articles