Supply chain | Supply Chain Management, Commerce

Posting Discrepancy in D365 for revaluation of Bank Accounts

(2) Share

Report

Posted on by Danny Bilodeau

4,346 Moderator

We have a Canadian company (lets call it Acme) with 2 Divisions (Financial Dimensions 31 & 32) that each have their own USD Back Accounts.

Let’s take the US bank account of Acme division 32 (GL 111060) as an example. This account is unique to division 32, so there should only be transactions with the Financial Dimension “Division” set to 32 (111060.32). However, due to the way the chart of accounts and financial dimensions are set up in D365, the combination 111060.31 (with the Financial Dimension “Division” set to 31, corresponding to Acme company division 31) also exists.

When performing a revaluation of the Bank Accounts at the end of the month, the system performs the correct currency revaluation calculation (USD to CAD) and arrives at a correct total amount. However, for reasons unknown, when the system creates its entry/voucher, part of the entry is posted with the Financial Dimension “Division” set to 32 and another part with “Division” set to 31 even if there was no transactions in that Bank account related to Division 31. This is what we are unable to understand.

What is the logic used by D365 to calculate its revaluation for each Financial Dimension. Could there be “pending” USD transactions linked to division 31 that are being revalued in CAD?

Below are the Cash and Bank Management Parameters.

Categories:

Dynamics 365 Supply Chain Management

All responses (4)

Answers (0)

Suggested answer

Arvind Bharti 284 on at

Like (1)

Report

Posting Discrepancy in D365 for revaluation of Bank Accounts

Hi Danny,

At any point 31 had a transaction with respect to trasfering from 31 to 32 like inter unit payable/receivable?(If you are using balancing dimension on ledger setup) and that can cause the some adjustments
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (1)

Report

Posting Discrepancy in D365 for revaluation of Bank Accounts

Hi Danny,

Thanks for the additional information. I think I start to understand the question. You have a single main account for two bank accounts. Both are maintained in USD, but your accounting currency is CAD.

In case there were no transactions for one of the bank accounts, there might be a balance that can be revaluated. Probably that can cause these postings on both Divisions?
Danny Bilodeau 4,346 Moderator on at

Like (2)

Report

Posting Discrepancy in D365 for revaluation of Bank Accounts

Hello André, and thanks for the reply.

Sorry for the delay, I had to obtain more info from the Finance team.

This the Main Account GL for the US Bank account used only by division 32. You see the voucher entries for revaluation for division 31.

And here is the voucher details, again showing the entries for division 31.
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

Posting Discrepancy in D365 for revaluation of Bank Accounts

Hi Danny,

Can you elaborate on what you experience as part on dimension 32 and part on 31? Is it splitting amounts or is one account on 32 and the other on 31? Maybe you can share a screenshot with the voucher transactions showing the accounts, dimensions and amounts?