Finance | Project Operations, Human Resources, ...

Reconciliation between ledger and sub ledger

(0) Share

Report

Posted on by Community Member

we have a AR / AP to GL reconciliation report which shows info in accounting currency.

there is a requirement to see info in transaction currency as well.

my question is - is that something MS would be rolling out in the near future?

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 304,449 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Alijoo01,

There are, as far as I know, no plans for this. I wonder about the purpose. Customer and vendor transactions for example, are settled in the transaction currency.

If you have a business case, you can post your requirement as idea on the Dynamics Experience site: https://ideas.dynamics.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Thanks for your quick response.

We have been recently facing some challenges to match Foreign currency balances on the Sub-ledger to GL as there is no proper report to get the information. We are unable to see at a transaction level the differences from the SL to GL and it’s causing a lot of issues. We can easily see accounting currency but we worry the revaluations may be incorrect and cannot prove either way at present.

We are currently assuming the subledgers are correct and it’s the GL that is incorrect but I would like to be able to back this up with a proper reconciliation.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,449 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I do understand your concern. Can you provide a clear example where you see an issue? Is it with customer or vendor transactions? Are you using the foreign currency revaluation jobs and which ones?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Se example below where we have a difference from a GL perspective. So this main account is the AR account and you can see we have the amount in the accounting currency column, but not in the transaction currency column.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Just to add the above company currency is GBP and transaction is done in USD.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you select the voucher for those transactions, what transaction and posting type can you identify?

From the voucher identified can you drill down to the transaction origin and see the underlying transaction that created the different vouchers?

Can you share details of those findings?

Many thanks,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 304,449 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you also share what exact screenshot you shared? I'm not able to understand where this data comes from or what it represents. I do see amounts, but don't know why you think it is a difference.

Was this reply helpful? Yes No
Ingeborg Heinrich Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

As far as I can recognize, the account 57210 = Customer summary account (Posting profile in Sales ledger).

If the values in the screenshot represent a single transaction, then it is obvious, that it is a currency revaluation transaction. Because exchange adjustments impact only values in accounting currency.

If the values in the screenshot represent a balance of zero in Transaction currency, then it is based on a scenario like this:

customer invoice transaction = Debit 1000 USD - 800 GBP

customer payment transactions = Credit 1000 USD - 850 GBP

In that scenario no settlement between the invoice and the payment transaction was done.

If both transactions would have been settled, an additional transaction would have been generated: Debit Customer summary account / Credit Exchange adjustment (gain/loss) 0 USD - 50 GBP

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank for all the responses. Just so that I am clear here -

My question here is basically we have a standard report called as the "Customer to GL reconciliation" in the AR module. Now, when we run that particular report we are seeing this difference between Ledger and subledger in accounting currency. To further drill down to see the differences, we need to see this at a Transaction currency level, which is not possible at the moment.

is there any update from MS to see this on the same report an if not, Is there any other way / report that we can use to see this level of details - in any user friendly manner (excel format)?

Was this reply helpful? Yes No
Ingeborg Heinrich Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

1. there is no reconciliation report for amounts in transaction currency available

2. if you want to verify the differences in the report first check the voucher. Have a look at the field Posting type - is there any transaction with type 'Customer balance'?

On the voucher transactions form click button Transaction origin.

Here you can see in the first colunt 'Account type' if the transaction was generated for Customer.

The results in your report look as if the ledger account 57210 was selected in a journal and no according customer transaction was created (because no customer accuont was selected).

Then these transactions are posted with Posting type General journal.

3. Is it possible, that the Summary account on the setup of the Customer posting profile was changed?

Was this reply helpful? Yes No