Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Accounting currency ba...
Finance forum
Suggested answer

Accounting currency balance = 0, reporting currency balance = 1.70

(1) ShareShare
ReportReport
Posted on by cjohnson300 166
Hi
 
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!
Categories:
Financial Management
  • BillurSamdancioglu Profile Picture
    BillurSamdancioglu 13,739 Most Valuable Professional on at
    Accounting currency balance = 0, reporting currency balance = 1.70
    Please share some screen shots with amount, currency and exchange rate.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,878 Super User 2024 Season 2 on at
    Accounting currency balance = 0, reporting currency balance = 1.70
    I think I'd submit a ticket to Microsoft on this.  It's possible the FX logic needs some tweaking on customer transactions.
  • cjohnson300 Profile Picture
    cjohnson300 166 on at
    Accounting currency balance = 0, reporting currency balance = 1.70
    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, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,878 Super User 2024 Season 2 on at
    Accounting currency balance = 0, reporting currency balance = 1.70
    I think before you can correct it, you need to determine what caused it.  Perhaps revaluation would correct it?
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,004 Super User 2024 Season 2 on at
    Accounting currency balance = 0, reporting currency balance = 1.70
    reporting currency adjsutment is only for ledger. For Customer balance to make zero can you try using remainder feature?
     
    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
     
  • cjohnson300 Profile Picture
    cjohnson300 166 on at
    Accounting currency balance = 0, reporting currency balance = 1.70
    Hi 
     
    It is indeed with customer, how can I correct it to make it zero?  Is there a way?!
     
    Thanks!
  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 20,819 Most Valuable Professional on at
    Accounting currency balance = 0, reporting currency balance = 1.70
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,435 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,317 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans