Blog

Proposal for a shorter EndToEndId in pain.001, or a 3-letter hash for RecId

Dynamics 365 Finance builds the ISO 20022 EndToEndId from voucher, RecId, and attempt counter. Because RecId adds little entropy and can exceed length limits (e.g., India’s 16-character rule), it can be removed or replaced with a deterministic 3-letter base-26 hash derived from its last four digits for safer, shorter identifiers.

February 15, 2026 No Comments

Luxembourg VAT Declaration for D365FO in PDF

ER-Consult delivers a full Luxembourg VAT Declaration for D365FO, finally covering a country long missing from Microsoft’s standard VAT reports. Built entirely with Electronic Reporting and output as an AED-compliant PDF, it includes all required declaration boxes with a configurable tax-code mapping and no hard-coding

November 18, 2025 No Comments

Matching own payments in Modern bank reconciliation

Reconciling outbound ISO20022 pain.001 payments with Camt.053 statements in Dynamics 365 isn’t straightforward. Modern Bank Reconciliation struggles to match vouchers using the EndToEndId field. This article explains how to adjust the ABR Camt.053 ER format and mapping to achieve accurate matching of your own payments.

October 23, 2025 No Comments

Manipulate PDF files in Dynamics 365 with iText

When handling PDF invoices in Dynamics 365 Finance and Supply Chain Management, we may need to adjust the generated files before sending them out. With iText 7 for .NET, we can open a PDF in stamping mode, flatten its form fields so the values remain visible, and return the result

September 26, 2025 No Comments

Customer invoice falsifier for D365 for Finance

This article demonstrates how to use Dynamics 365 for Finance Electronic Reporting to export, adjust, and re-import posted customer invoices. By updating only selected header values such as subtotal, charges, and VAT, you can reprint invoices with revised figures while leaving the original ledger totals untouched.

August 12, 2025 No Comments

Filling PDF Forms with Electronic Reporting in Dynamics 365 for Finance

Dynamics 365 Electronic Reporting supports fillable PDF forms, enabling automated population of static templates like tax returns or invoices. While less dynamic than Excel outputs, PDF forms work well with fixed field sets. This guide explains naming conventions, field grouping, and practical tools to streamline PDF integration using ER.

July 29, 2025 No Comments

Dynamics 365 Intercompany Cost+ pricing

In Dynamics 365 SCM, the “Unit price equal to cost price” setting enforces intercompany sales at cost. Updates occur during order creation, reservation, and warehouse release. Due to transfer pricing rules, Microsoft introduced intercompany markup functionality. For stricter audit needs, customizations and workarounds like negative discounts and tailored GL transactions

April 11, 2025 No Comments

Amend GDPdU = GoBD = FEC

Extending the audit export file in Dynamics 365 for Finance is a straightforward task that power users can accomplish independently. A common audit requirement is adding a system date column to track the actual posting date of invoices, particularly for DATEV applications. This can be achieved using Electronic Reporting (ER).

March 18, 2025 4 Comments

Dynamics 365: Migrating fixed price projects and WIP balances

Migrating fixed-price projects in Dynamics 365 requires up to 14 entities and 18 steps, some manual. Ensure employees are bookable resources before importing. Import project data in sequence, starting with contracts, funding sources, and project structures. On-account transactions must be manually copied into D365. Work Breakdown Structures and budgets need

February 27, 2025 No Comments