Insights
Data Extract
The base data behind every module, as a spreadsheet, on demand. These are the same rows the screens are computed from rather than a report built over the top of them, so a figure on a page and a figure in the download are the same number.
Sales and receivables
One row per order, with kilograms, value in the order's currency and in AUD, cost and margin.
One row per line: grade, pack, kilograms, the rate charged and whether it came off an agreement or the price list.
The quotation book with its status and the order raised against it.
Every invoice with its terms, due date, GST, AUD value and how many days it is overdue.
Accounts with ABN, terms, credit limit, price list, rebate and trading status.
Every card on the board with its stage, owner, source, indicative volume and next action.
Supply chain and payables
Every order with the method, incoterm, ETA, currency, who raised it and who approved it.
Suppliers with country, currency, terms, lead time and whether they must be prepaid to clear customs.
Container by container, with sea freight, insurance, duty, brokerage, cartage, fumigation and wharfage broken out.
Every item code with reorder points, weighted average cost, list price, value and the split across every stock point.
Manufacturing and quality
Planned and actual kilograms with materials, labour and overhead applied, and the value carried in work in process.
One row per raw material consumed, with the lot number and the cost it was issued at.
Every batch made, what is still on the floor, where it sits and which customers it went to.
Every release with a column per test: yield, peak temperature, fusion time, moisture, colour and the rest.
Ledger
Every journal written during this walkthrough, line by line, account, debit and credit.
Quality results can also be filtered to one test and one grade from the quality trends screen, which downloads the run behind whatever is on the chart.