Finance | Project Operations, Human Resources, ...

Issue with foreign currency ledger settlements

(0) Share

Report

Posted on by Community Member

Hi All,

We are facing issues with ledger settlements especially with foreign currencies.

The issue is occurring when foreign currency transactions are posted on one day and are settled a few days/few months after. Foreign currency revaluation has been run but there is a difference and we cannot settle these transactions as it doesn't balance.

What would be the process to settle these types of transactions? Is there something I'm missing?

Hoping someone can advice and help me with this.

Many thanks,

Amrita

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Rahul Mohta 21,042 on at

Like (0)

Report
Copy link

Link copied!

pls see if this helps

community.dynamics.com/.../913855

Was this reply helpful? Yes No
Suggested answer

Sten Baumgarten 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Amrita

The amount in accounting currency don't have the same amount in debit and credit at cannot be settled. In the example I pasted in the reply you have the same transaction amount but a different amount in accounting amount and I get an error when I try to settle the two amounts.

Best regards

Sten

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Amrita,

How many different exchange rates are there from 6-30 to 7-21 for currency NZD?

Do you run revaluation for all transactions in different rates in your first screenshot?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello amrita bb,

As Sten mentioned further above, you have to ensure that the total of all rows marked adds up to zero.

Otherwise, D365FO won't allow you to settle those transactions.

In case you expect an automatic posting/settlement of the difference (0.68 ct) a modification is needed.

Best regards,

Ludwig

Was this reply helpful? Yes No