Skip to content
Guide

Preparing an ERP extract for a supply chain audit.

The two exports the audit needs, and the extra tables worth pulling later, for SAP, Dynamics, Oracle, Odoo or a plain spreadsheet.

By Roufaida Bouchamha, founder18 September 20269 min

For the supply chain audit: two exports

  • Stock by item: part number, location, usable quantity on hand, unit cost and, if you have it, usage over the last 4 to 12 weeks.
  • Open orders: PO number and line, part number, supplier, open quantity, promised date (blank if unconfirmed) and status.

Later, for deeper analysis

  • Goods receipts for the last 12 months.
  • Sales / shipments for the last 24 months.
  • Item master: unit, lead time, safety stock, supplier.
  • Open production orders and BOMs.
  • Freight invoices with shipment references.

Format

CSV or Excel, one file per object. Before analyzing anything, WERISCO shows which fields are missing or inconsistent, and what that blocks.

Run the Risk, every week.

One supply-chain shock, decoded in numbers, and what a data-driven plant does about it.

Keep readingAll resources
  1. 01The cost hiding between your ERP and your spreadsheets.Your ERP records what happened. Your spreadsheets decide what happens next. The money leaks in between.11 August 20266 min
  2. 02Where mid-market supply chains leak money.A structured model of the seven cost pools between the ERP and the P&L, and how to size each one with your own data.30 July 202614 min
A container terminal at night

Supply chain audit

See where your supply chain is exposed.

A 20-minute call and two file exports: stock by item and open orders. You see the inventory and order value exposed. No integration, no savings estimate, and an NDA if you need one.

Book a supply chain audit