The Microsoft documentation for Date Compression states that "Currency Code" is always retained after compression. However, for G/L Entries posted with a Source Currency (e.g. EUR posted in a DKK company), the Source Currency Code and Source Currency Amount are silently dropped during compression — this is a separate field from Currency Code and is not mentioned as a retained field in the documentation. Reference: https://learn.microsoft.com/en-nz/dynamics365/business-central/admin-manage-documents Steps to reproduce: 1. Post G/L entries on a balance account using a foreign source currency (e.g. EUR) 2. Note the source currency balance before compression (e.g. 800 EUR — correct) 3. Run Date Compress G/L Entries on the same period/account 4. After compression: - Source Currency Code (EUR) is missing from the compressed entry - Source Currency Amount is incorrectly merged with the LCY amount - "Balance to Date (source currency)" on the G/L Account is now wrong (e.g. shows 300 EUR instead of the expected 800 EUR) Expected behavior per the documentation: Currency Code is retained — but Source Currency Code (a distinct field on the G/L Entry table) should equally be retained and grouped on, so that source currency integrity is preserved after compression. Suggested fix: - Include "Source Currency Code" as a grouping key during G/L date compression - Retain and correctly sum "Source Currency Amount" per currency group - Document Source Currency Code as a retained field — or add it to the "Retain Field Contents" options so administrators can explicitly choose to keep it Impact: Companies posting G/L entries in foreign source currencies cannot use Date Compression without corrupting their source currency balances, making the feature unusable for multi-currency balance sheet reporting.
