Onaro™ONARO
OverviewImplementationExtraction guides

← All systems

Dynamics 365 Finance — Data Extraction Guide

Zero-Access pack. Follow each section, export the file, and return it to Onaro or upload it in the Meridian profile wizard. Verified as of 2026-09-13; vendor menus change.

Download Dynamics 365 Finance PDF

General journal entity (DMF) template

Verified as of 2026-09-13

Steps

  1. Sign in to Dynamics 365 Finance with access to the Data management workspace.
  2. Open Data management → Export (or create an export project).
  3. Add the entity named General journal (AOT: LedgerJournalEntity). Choose Excel or delimited CSV as the file format.
  4. Run the export (even with no/minimal sample rows) and download the package or file — this is your header template.
  5. Alternative for interactive line entry: open a general journal → Open lines in Excel and note the template columns your legal entity uses.
  6. Upload the downloaded headers into Meridian’s Export Profile wizard.

What you should have

Excel/CSV with General journal entity columns (e.g. JOURNALNAME, JOURNALBATCHNUMBER, LINENUMBER, ACCOUNTTYPE, ACCOUNTDISPLAYVALUE, TRANSDATE, VOUCHER, CURRENCYCODE, DEBITAMOUNT, CREDITAMOUNT, DESCRIPTION).

Gotchas

  • ACCOUNTDISPLAYVALUE must match your Financial dimension configuration for integrating applications.
  • Do not set Journal batch number or Voucher to Auto-generated on the import map when using Meridian files.
  • Business Central is a different product — this guide is for Finance (F&O) / DMF.

Source documentation

Trial balance / financial report export

Verified as of 2026-09-13

Steps

  1. Ask your Dynamics administrator which trial balance or financial reporter / Management Reporter definition your close uses.
  2. Run that report for the Meridian reconciliation period and legal entity.
  3. Export to Excel or CSV.
  4. Upload into Meridian’s Import Profile wizard (artifact: trial balance).

What you should have

Excel/CSV trial balance or account balances for the period.

Gotchas

  • Legal entity and ledger matter — export the same books Meridian chargeback will post to.
  • Paths vary by Financial Reporter vs inquiry reports — follow your close checklist.

Source documentation

Vendor invoice / AP export

Verified as of 2026-09-13

Steps

  1. Ask your AP lead for the vendor invoice / open invoice list export used for spend analysis (often Accounts payable → Invoices → Invoice journal or a related inquiry).
  2. Filter to the assessment period for the correct legal entity.
  3. Export to Excel or CSV with vendor, date, amount, and main account when available.
  4. Upload into Meridian’s Import Profile wizard (artifact: AP / vendor bills).

What you should have

Excel/CSV vendor invoice or AP detail for the period.

Gotchas

  • Prefer the export your integration or AP team already produces for audits.
  • Exclude payment instrument / bank secrets — invoice-level detail is enough.

Source documentation

Chart of accounts / financial dimensions

Verified as of 2026-09-13

Steps

  1. Ask your administrator for a Main accounts export and the financial dimension value lists used for AI spend (department/cost center, etc.).
  2. Typical starting areas: General ledger → Chart of accounts → Main accounts; and General ledger → Chart of accounts → Dimensions (or Organization administration dimension value pages).
  3. Export to Excel/CSV.
  4. Upload into Meridian’s Import Profile wizard.

What you should have

Excel/CSV main accounts plus dimension values.

Gotchas

  • Dimension structure is legal-entity / shared-company specific — export what Meridian will post against.
  • ACCOUNTDISPLAYVALUE segment order must match integrating-applications configuration when mapping JE exports.

Source documentation

Budget export

Verified as of 2026-09-13

Steps

  1. Ask whether budgets live in Budgeting module plans, Excel, or another planning tool.
  2. Export the filed budget for the periods Meridian will variance against.
  3. Upload into Meridian’s Import Profile wizard (artifact: budget).

What you should have

Excel/CSV budget by period and dimension.

Gotchas

  • External Excel budgets are acceptable — include provenance in the filename.

Source documentation