Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Bank Revaluation on Ze...
Finance forum
Suggested answer

Bank Revaluation on Zero Balance

Posted on by 5

Hello,

I have a bank account that is in a different currency than my accounting and reporting currency.  At the end of the month, I have reconciled my bank to zero because the account closed.  I have also ran revaluation but the balance in transaction and reporting currency still remains.  Shouldn't the revaluation be done based on the bank balance of zero?

Anyone else experiencing this?  Any insights?

Thanks,

MA

Categories:
  • RE: Bank Revaluation on Zero Balance

    Hi MA,

    Without knowing what version or build you are currently on, I would suggest you take a look at issue 401224. If you do a search for that in LCS, you will see two issues come up. One is considered a duplicate of the other. The one that is considered a duplicate sounds like the issue you are seeing. It looks like this issue is resolved in version 10.0.11.

    Jeremy Driscoll

    Microsoft Support Engineer

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: Bank Revaluation on Zero Balance

    Hi MA,

    Or ensure there is a balance, or you would need a customization here. You can ask a developer for the options and the impact.

  • macruick Profile Picture
    macruick 5 on at
    RE: Bank Revaluation on Zero Balance

    This is exactly....it skips the zero bank balance accounts so it doesnt run the reval to zero out the accounting and reporting.  How do we change this?

  • macruick Profile Picture
    macruick 5 on at
    RE: Bank Revaluation on Zero Balance

    We run the reval in the bank module and have the main account marked to not allow for GL reval.  The bank to ledger reconciliation agrees.

  • macruick Profile Picture
    macruick 5 on at
    RE: Bank Revaluation on Zero Balance

    It is marked to not allow for reval at the GL level as we reval the bank accounts in the SL.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Bank Revaluation on Zero Balance

    Hi MA,

    Where have you run the revaluation (GL or bank module)?

    Do you see a difference in the bank to ledger reconciliation report?

    Best regards,

    Ludwig

  • Suggested answer
    Maverick Blogger Profile Picture
    Maverick Blogger 60 on at
    RE: Bank Revaluation on Zero Balance

    Hi,

    May be obvoious but have you enabled the "Foreign currency revaluation" flag on the ledger account linked to bank account.

    If bank balance is zero but ledger balance is showing, it might not be enabled for reval.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: Bank Revaluation on Zero Balance

    Hi MA,

    Not completely sure, but it might be the case that a zero balance will be skipped for revaluations. Can you possibly try in a test environment what happens if you have e.g. the original balance, then revaluate and after the revaluation reconcile to zero?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans