Export guide · Prophet 21
What to export from Prophet 21
Five lists from Prophet 21, as CSV or Excel, are enough for the health check and the order plan. Here is where each one lives and how to export it.
The five lists, and where to find them
Export these lists as CSV or Excel, as far back as your ERP allows (two years of sales is best):
Items, with their cost, unit and supplier.
Where · The item master (inv_mast).
Stock on hand by branch, with the minimum and maximum if you use them.
Where · Inventory by location (inv_loc), with the minimum and maximum.
Sales lines (or the item ledger’s sales entries), with date, branch and quantity.
Where · Invoice lines (invoice_line).
Purchase order lines and receipts, with the dates.
Where · PO lines (po_line) and receipt lines (inventory_receipts_line).
Suppliers, with their usual lead time.
Where · Vendors, and the item suppliers (inventory_supplier) for lead times.
How to export
In Prophet 21, run the report or the data export of each list and save it as CSV.
Your IT person or your Prophet 21 partner can also export the tables named here with a read-only query and save each one as CSV.
- Column names in English or French both work: you rename nothing.
- Report footers and totals are left out by our reader; nothing is parsed in your browser.
Send your exports for a free health check
We read them, ask you what the data cannot tell us, and send back a report of the stock you could return, sell down or stop buying, each figure as a range.
Get your free health check