Lab briefing · A supplier and invoice load

Load suppliers, then invoices against them — IN THE WRONG ORDER FIRST, so you can read the failure — then correctly, with reconciliation. The wrong order is the instructive half. Load the invoices before the suppliers exist and read the rejection carefully: note that it names a COLUMN and not the missing prerequisite, and note how little it would help somebody who did not already know the dependency. That is the message you will meet on a real conversion at eleven at night, and recognising it in two seconds is what this lab buys. Then correctly. Suppliers first, checked in the interface tables before importing. Then invoices, with a batch identifier in a searchable column, split into at least two batches on a natural boundary. Reconcile before you call it done: row counts both sides, one control total, and three named records opened and compared field by field. Write the…

In this module: Module 7 · FBDI: the file-based loader end to end

1. 1The FBDI sequence, and why order mattersFree preview
2. 2Finding and reading the right template
3. 3Mandatory columns, and the ones that only look optional
4. 4Preparing the file without corrupting it
5. 5Loading the interface tables
6. 6Running the import and reading the output
7. 7Errors: finding the row that failed
8. 8Correcting and reloading safely
9. 9Master data versus transactional loads
10. 10Volume: loading a hundred thousand rows
11. 11Proving the load landed
12. 12Rollback, and why there usually is not one
13. 13What breaks: six FBDI failures
14. 14Lab briefing · A supplier and invoice load