Open Payables and Receivables are what let you pay suppliers and collect from customers on day one. This guide covers migrating open AP and AR to Oracle Fusion via FBDI — which items to bring, the invoice/payment templates, and reconciling sub-ledger control accounts to the GL.
You migrate open items, not full history: unpaid/partially-paid supplier invoices and uncollected customer invoices as of cutover, so operations continue — with closed history archived.
Suppliers and customers are loaded first; then open AP invoices and open AR invoices (and any required on-account receipts/payments) load via their FBDI templates referencing those masters. Amounts, due dates, tax and remaining balances must carry exactly.
The reconciliation that matters is sub-ledger to GL: the AP and AR control-account balances in Fusion must equal the migrated open-item totals and tie to the GL opening balances you loaded.
What to get right.
Unpaid/uncollected invoices at cutover; archive closed history.
Suppliers/customers must exist before their invoices load.
Carry remaining (not original) amounts for partially-paid items.
AP/AR control balances must tie to the GL.
Tax lines and foreign-currency amounts must be preserved.
Aging and payment scheduling depend on accurate dates/terms.
The mechanical sequence.
Ensure suppliers and customers are migrated and active.
Extract unpaid AP and uncollected AR as of the cutover date, with remaining balances.
Populate the Payables and Receivables invoice import templates with tax and currency.
Import and review rejections (missing masters, tax, currency, terms).
Tie AP/AR control-account balances to the migrated open-item totals and GL opening balances.
Confirm aging buckets and due dates match the source for collections/payments.
What trips teams up.
Invoices fail if the supplier/customer isn't loaded first.
Partially-paid items must carry remaining, not original, amounts.
Sub-ledger totals must tie to the GL — reconcile both.
Tax lines and rates must be valid in Fusion.
Foreign-currency amounts and rates must be consistent.
Pre-built extraction and FBDI with sub-ledger-to-GL reconciliation.
Load suppliers and customers first, then extract open (unpaid/uncollected) invoices as of cutover with remaining balances, generate the Payables and Receivables invoice-import FBDI files, load to a sandbox, clear validation errors, and reconcile the AP/AR control accounts to the migrated totals and the GL.
No — migrate only open items so operations continue, and archive closed AP/AR history for retention. Loading full transaction history into Fusion bloats the system unnecessarily.
Carry the remaining balance (not the original amount) with correct due dates and terms, so aging and payment scheduling are accurate from day one.
The AP and AR control-account balances in Fusion must equal the migrated open-item totals and tie to the GL opening balances. This sub-ledger-to-GL reconciliation is the sign-off gate.
Yes — Syntra ETL automates open-item extraction, AP/AR FBDI generation and the sub-ledger-to-GL reconciliation.
Tell us your source system and we'll migrate open Payables and Receivables into Oracle Fusion, reconciled to the GL.