Finance | Project Operations, Human Resources, ...

Accounting currency balance = 0, reporting currency balance = 1.70

(4) Share

Report

Posted on by cjohnson300

213

I have a customer who has a zero balance in the accounting currency of EUR, but an outstanding balance of 1.70 in the reporting currency of USD.

How do I correct this? I have looked at "Reporting currency adjustment journals" but can't see a way to post the adjustment to the customer subledger?

Many thanks in advance!

All responses (11)

Answers (0)

Sort by

Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Reporting currency adjustment journals cant be used with Subledger, I am thinking for your case you have balance in customer? if so probably this is something to do with forex gain/loss.
cjohnson300 213 on at

Like (2)

Report
Copy link

Link copied!

Hi

It is indeed with customer, how can I correct it to make it zero? Is there a way?!

Thanks!
Suggested answer

saurabh bharti 15,059 Moderator on at

Like (2)

Report
Copy link

Link copied!

reporting currency adjsutment is only for ledger. For Customer balance to make zero can you try using remainder feature?

https://exploredynamics365.home.blog/2020/06/21/settle-remainder-with-specific-ledger-transfer-to-another-vendor-customer-for-open-invoices-in-microsoft-dynamics-365-finance-and-operations-hidden-gem/

Not sure weather it will allow you to adjust only reporting or not but try it out?

Also its worth checking how reporting currency has balance but not accounting
Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (2)

Report
Copy link

Link copied!

I think before you can correct it, you need to determine what caused it. Perhaps revaluation would correct it?
cjohnson300 213 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your responses!

It was definitely caused by F/X changes but going back a number of months. The difference has fluctuated over time but now the customer's account is completely clear, it is most obvious. I have tried doing a currency revaluation, but because all of the invoices are "closed", there is no transactions to revalue so it makes no difference (at least that is my working assumption!).
Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

I think I'd submit a ticket to Microsoft on this. It's possible the FX logic needs some tweaking on customer transactions.
BillurSamdancioglu 21,473 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Please share some screen shots with amount, currency and exchange rate.
cjohnson300 213 on at

Like (1)

Report
Copy link

Link copied!

Is this enough of a screen shot?

The top is the "Customer balance list" and the bottom is "Customer aging" report
Suggested answer

BillurSamdancioglu 21,473 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Did you settle the open transactions? If not can you settle?
Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think you need to raise a ticket, you mentioned your transactions are closed hence there is no point of revaluation.