In certain business scenarios, it may become necessary to update and reprint customer invoice Dynamics 365 with corrected or intentionally adjusted figures. By selectively mapping only specific invoice header and invoice line fields for update, the configuration enables targeted adjustments without triggering recalculations of dependent totals. The electronic reporting configurations may also be used as a tutorial for the Excel imports in D365.

Check the above screenshot: assuming we’ve initially issued an invoice with 19% VAT instead of the reduced 7% VAT, the SalesBalance and SumTax may be shifted while keeping the total invoice amount the same. Beware: to reflect the VAT manipulations in the tax books a separate [cumulative] GL journal must be posted manually. Please ensure any misaligned invoice reprints are clearly marked as adjusted copies to avoid confusion or compliance issues, though.

The underlying method uses the Electronic Reporting import configuration capabilities in Dynamics 365 for Finance. You may download the ER configurations here:  CustInvoiceUpdater.zip. Unpack and import into the ER tree one by one, starting with the model. Use it at your own risk!

Key elements include:

1. Data Model – definition of the conceptual invoice structure (header amounts, line amounts, tax values, etc.).
2. Model Mapping for export and a model mapping To destination for the import (both in the same model mapping ER configuration) – links the data model fields to the relevant Dynamics 365 tables and columns.
3. Formats – define the export file structure (Excel) and the same import file structure and maps the file’s data to the model fields.

For a detailed description of the ER import concept and practical configuration guidance, check Electronic Reporting in Data Migration.

The process follows a three-step cycle:

1. Export – Extract invoice data from Dynamics 365 into an Excel using the “CustInvoiceJourDump format” ER export configuration.

2. Adjust / Transform – Modify the extracted data in Excel, changing selected amounts while leaving others untouched.

3. Import – Re-import the adjusted file by selecting the “CustInvoiceJour mapping” in the ER tree, clicking Designer, then Run at the “To destination” mapping, and uploading the Excel file. If the file is well formed and there is a match for the RecId of the invoice header/line, it updates the table in Dynamics 365 and says “Operation completed“.