Every year, the same ritual. The 60-person food processing company would lock its office for three weeks during audit season. Cartons of paper invoices, glue-stained spreadsheets, and a finance manager who slept at work while the auditors chased document after document. The owner once joked: “we spend more time proving what we did than actually doing it.” Nobody laughed.
What the auditors were really asking for
They wanted traceability. Which batch of raw material went into the batch of jam that shipped to which customer on which date. When asked a simple question like that, the team needed hours, sometimes days, because the answer lived across three different record-keeping habits.
ERPNext Consulting started not with the finance team but with the production manager. The traceability trail had to begin at the receiving dock: batch number, expiration date, storage location — and then link through production, packaging, and delivery to a customer order.
A trial in one product line first
We picked a single high-volume product, tested the full trail for a month, and only then rolled it out across the other 12 products. The pilot revealed three places where labels were written by hand and the handwriting decided what got logged — a headache no software could fix on its own.
- Replace handwritten batch labels with printed labels containing a batch number and date, generated right at the receiving dock.
- Log every quality check result against the batch number within the same day, not in a weekly summary that arrives too late.
- Generate delivery documents straight from the batch-managed stock record, so the customer and the lot always travel together.
Audit season turned into audit week
The next annual audit started on a Tuesday and finished that Friday. The finance manager took a day off instead of a vacation at the office. Traceability questions that used to take a full day now take minutes, and the production manager finally knows exactly which raw material batch is tied to which delivery.
The most fragile link in any audit trail isn’t the system; it’s the habit of recording at the moment of movement. The ERPNext Consulting setup worked here because the team changed their routine, not just their software. If your audit season makes your staff dread Q1, start with one product line, prove the trail works, and let the results drag the rest of the company along.