Skip to content
Microsoft Dynamics 365 logoERP & AP

Microsoft Dynamics 365 and Trace Global

Reconcile utility vendor invoices in Dynamics 365 Finance or Business Central and post audited invoices to the AP journal.

Vendor
Microsoft
Method
Dynamics 365 Finance OData data entities and Data Management packages; Business Central API v2.0 purchase invoices
Direction
Bidirectional
Typical setup
1 to 3 weeks

Trace Global supports both Dynamics 365 Finance and Dynamics 365 Business Central. In Finance, we read vendor invoice and payment data through OData data entities, and use Data Management Framework packages for large history loads. In Business Central, we use the standard API v2.0 purchase invoice and vendor payment endpoints.

Authentication uses a Microsoft Entra ID app registration with permissions granted by your administrator. We request read access to vendor transactions, and write access only if you want audited invoices created for you.

Outbound invoices arrive as pending vendor invoices with financial dimensions set, so they follow your existing workflow.

How the data feeds the audit

  • Find duplicate payments across legal entities for the same utility account.
  • Measure late fees by comparing settlement dates with utility due dates.
  • Spot utility invoices coded to sites that are closed in your dimension values.
  • Confirm utility credits and refund checks were recorded against the vendor.

Setup

  1. 1Register the Trace Global app in Microsoft Entra ID.
  2. 2Grant the app access to your Dynamics 365 environment with a limited security role.
  3. 3Select the legal entities and utility vendors in scope.
  4. 4Run the history load and reconcile it to captured bills.
  5. 5Enable outbound invoice creation if needed.

Data exchanged

ObjectDetail
Vendor invoicesInvoice number, vendor account, invoice date, due date and amount for utility vendors.
Financial dimensionsLegal entity, department, cost center and site dimensions per line.
Vendor paymentsSettlement records showing which payments cleared which invoices.
VendorsUtility vendor accounts mapped to utility account numbers.
Audited invoices (outbound)Pending vendor invoices or purchase invoices with the bill attached.

Microsoft Dynamics 365 questions

Yes, through scheduled flat-file exports. The API connection applies to Dynamics 365 Finance and Business Central.

Read access to vendor invoices, payments and vendors. Write access to vendor invoices is only needed for outbound posting.

Yes. We map utility accounts to legal entities and sites during onboarding.

Related connectors

SAP S/4HANAOracle NetSuiteOracle Fusion Cloud ERPWorkday Financial Management

Find out what your utilities owe you.

Connect bills for up to 50 meters. Get the findings report in about three weeks. Pay nothing unless money comes back.

Start free trialExplore demo
from bill access to first findings report
21 daysfrom bill access to first findings report
of filed claims accepted by the utility in full or in part
94%of filed claims accepted by the utility in full or in part