Dynamics 365 Finance

Currently, the exchange rate that is displayed on a printed ledger voucher (and Chinese ledger voucher) is reverse-calculated using the following formula: Accounting currency amount/Transaction currency amount.

Although this may appear correct, it may actually differ from the exchange rate in the exchange rate master and the one that was initially used in the journal or source document eg. free text invoice.

Due to the currency rounding settings in D365, the accounting currency amount will change slightly after multiplying by the exchange rate.

Hence, if you reverse calculate the rate using the formula above, it may not be equal.

This is apparently visible when there are auto-posted sales tax entries too. The exchange rate in the journal voucher lines differ for each line due to the rounding settings even though they should actually be the same.

Our users would like to see the original exchange rate that was used in the master and in the journal/source document for reporting purposes and for consistency of the exchange rate values in the journal voucher lines.

Previously, Microsoft agreed to a fix where the exchange rate factor was wrong. However, they did not agree to displaying a rate from the journal. We would like to suggest this improvement.

Description:

We have observed that the new automated foreign currency posting feature during Ledger Settlement does not currently support scenarios where transactions are settled in different currencies.

Scenario:

For example, consider the following process:

• An invoice of 100 USD is paid via our payment run, also in USD.
• Our bank account is denominated in EUR. When transferring the payment to the vendor, the bank converts 100 USD to 90 EUR and provides a 90 EUR payment confirmation.

This results in the following entries on the clearing account:

• Payment: 100 USD (converted to 95 EUR in our system)
• Bank confirmation: 90 EUR

Current Issue:

Currently, these entries cannot be fully settled automatically in the ledger, as the system does not post the realized foreign exchange gain or loss. Manual postings are required to clear the differences arising from currency conversion.

Suggestion:

We propose an enhancement to enable automatic posting of realized FX gains or losses during ledger settlements where transaction and settlement currencies differ. This would streamline the process, reduce manual work, and ensure accurate financial reporting.

We noticed, that the new feature of automated Foreign currency postings during Ledger Settlement does not work, if we want to settle transactions in different Currencies.

Example:

Invoice of 100 USD is paid through payment run with USD.

Our Bank is an EUR Bank and transfers the USD to the Vendor but translates the 100USD into 90 EUR and sents us the 90 EUR confirmation

now on the clearing account we have:

1. Payment 100 USD -> 95 EUR
2. Bankconfirmation 90 EUR

these ledger settlements cant be settled without a manual posting

Introduce functionality to conditionally display or hide specific financial dimensions in the journal entry form based on the selected main account. For example:

• When a user selects an asset account, only dimension types such as Cost Center and Location are shown.
• When an expense account is selected, only Department and Project dimensions appear.

This can be defined via configuration (e.g., in Account Structures, Advanced Rules, or in the main accounts), allowing finance teams to create a cleaner and more user-friendly data entry experience.

Benefits

• Improved User Experience: Reduces clutter and confusion for end users during journal entry by only showing relevant dimensions.
• Fewer Data Entry Errors: Limits the possibility of populating irrelevant or invalid dimension combinations.
• Streamlined Training and Adoption: Makes the system more intuitive, especially for occasional or new users.
• Enhanced Data Quality: Enforces a higher level of control over financial reporting structure without relying solely on backend validation.

Requirement:

All GL Journals should have an attachment to be possible to be posted. Without attachment, a pop-up should prevent the post.

Proposed Solution:

New Configuration to activate/de-activate this option

When activated, the control should be in place. The solution should also allow to use at the same time Workflow for Approval

When inactivated, it should work as the out-of-box solution now.

Before raising this idea, several options were assessed and all of them require a customisation.

Some of our customers wish to be able to add Attachments directly on ledger settlement lines or at least a Note. It would be very valuable especially for the partial ledger settlement.

In the ledger settlement process, when there is a minor difference—such as a penny—between the balances of accounts being settled in the accounting or reporting currency, these small discrepancies remain unresolved and are not cleared during settlement.

Customers have expressed a preference to avoid manually adjusting these decimal differences after liquidation, as this creates additional workload and inefficiencies.

We kindly request assistance in identifying a resolution or enhancement that would allow the system to automatically handle such minor differences during ledger settlement.

It would ease the job if one can add more or all companies in one go to the Legal entity overrides for both Main accounts and Financial dimension.

One option could be that when the Chart of accounts have been created and added to Ledger, to have a job that can add all companies to Legal entity overrides.

As currency revaluation causing a lot of issues posting transactions in GL,AR,AP and Banks users need a solution to be able to solve issues.

I propose to create a check on Journal level (Journal names) in General tab under Currencies section to allow posting with zero value on accounting currency or transaction currency, so users can solve currency issues and discrepancies.

Currently we are forced to post with 0.01 cent on one of the currencies and to play with exchange rate, which causing issues with currency revaluation, so we need to do it after.

Currently only currency revaluation can post with zero value on one of the currencies, but it is not perfect all the time, users need a way to correct Revaluation manually, not fully reversed revaluation and thinking how to workaround incorrect postings.

The financial dimension string to use in the excel add-in for journals is derived from the menu item Financial dimension configuration for integrating applications and is not legal entity specific. In instances where an instance has many legal entities with various financial dimensions, the use of the excel add-in becomes difficult and overwhelming for users to navigate how to enter their Main account plus relevant financial dimensions.

Proposal should be to either make this parameter legal entity specific or create a new menu item to determine which financial dimensions should be used when the excel add-in is being used to enter journal entries. In either case, this would make the use of the excel add-in more accessible and friendly for users who may not be familiar with dimension sets of all legal entities in their instance.