web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Will the Adjust Exchan...
Microsoft Dynamics NAV (Archived)

Will the Adjust Exchange Rate batch job update my account balance in the local currency?

(0) ShareShare
ReportReport
Posted on by Community Member

My company uses GBP as its LCY. We have a bank account that is denominated in USD. Transactions such as accounts payable denominated in USD are run through this account. How do I ensure that the Adjust Exchange Rate batch-job revalues this account?

Example:

USD balance is 1,000 USD

FX rate = 1 GBP = 1.25 USD

GBP balance should be 800

However, my trial balance shows 1,000 USD as the additional reporting currency and 850 GBP as the local currency.

I have tried to changing the Exchange Rate Adjustment within the GL Account Card to "Adjust Amount" and "Adjust Additional-Currency Amount" and both options don't seem to have any impact. 

Is there something that I am not considering?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    I've done some testing here and I was able to get the result you are expecting.  I did this in a Cronus (demo) company which did not have the ACY enabled before I started the test.  Even with this not being enabled from the start I was able to get the expected results.

    It is logical that the setting "Adjust Amount" and "Adjust Additional-Currency Amount" settings have no impact because when you revalue the bank account itself this results in a posting so there is nothing to do when it gets to the G/L Account.  This is only true if you do not specify a starting date (read further for the significance of this).

    However, you still have an issue so let's look at some possible causes (I suggest reading all points first):

    1. Have you checked the LCY Balance on the Bank Account Card itself?  Does this equal 800 as expected or does it equal 850 or 800.  If it equals 800 (i.e. the amount you are expecting) then I think the issue is a direct posting into the general ledger account.  If your LCY Balance on the Bank Account is equal to the G/L Account Balance, then there is no direct posting issue.

    2. Can you confirm that the starting date you are using is blank and the ending date is your period end date?  This is necessary for Foreign Customers, Vendors and Bank Accounts because you are adjusting the balance at date and not the current period.  When I ran the G/L Account revaluation with a starting date I was able to replicate the type of issue you had.

    I can't think of any other cause other than the two I have listed above.  I suggest for Foreign Customers, Vendors and Bank Accounts that you set the "Exchange Rate Adjustment" to "No Adjustment".  My thinking here is that these accounts should just be adjusted by the Revaluation against the sub ledgers.  Also, would I be correct in assuming that you would want your Income Statement accounts to be adjusted for a specific period?

    Hope this helps.

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at

    Hi, Rsatoken123

    Adjust Exchange Rate Batch job will create entry only if you have different exchange rate than before.

    just check your exchange rate table for the USD currency is it maintain the same rate of a different rate.

    for example, if you trying to value as 31/12/2016 then you need to update the exchange rate table for this date rate & if there old rate & 31/12/2016 are different then the system will pass adjustment to g/l bank account and if you maintain reporting currency you revalue that as well in the Adjust Exchange Rate Batch job.

    thanks,

    Indika

  • Community Member Profile Picture
    Community Member on at

    Hi Craig,

    Point 1 - you are correct in that the LCY balance in the GL does not match the balance on the Bank Account card. I had to have the cash entries rebooked to call out the Bank Account as I was previously posting cash entries directly to the GL account. Can you clarify why the sub-ledgers are revalued even if I set the GL account to "No Adjustment"?

    Point 2 - leaving the starting date as blank does work, however, will a blank start date revalue all prior periods that are unlocked and open for posting? For example, on the GL setup, I've disabled posting prior to 1/1/2016. If I run the batch job with an end date of 12/31/16, will it adjust all balances from 1/1/16-12/31/16?

    Thank you

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    Point 1: On the batch job you have the option to revalue Adjust Customer, Vendor and Bank Accounts.  When this is selected it will revalue the sub-ledgers irrespective of the G/L Account setting.  If you do not want to revalue the sub ledgers then you should not select this.  My view is that you should revalue this so that Balance and Balance (LCY) of the sub ledgers are based on the exchange rate at the end of the month.

    Point 2: If you leave the starting date blank it would effectively be revaluing the balance at date.  I don't think this would be correct for Income Statement accounts - I think this is where you would probably want to enter a starting date.  My suggestion is:

    - When running for Customers, Vendors and Bank Accounts do not enter a starting date because we want to revalue the balance not the movement.  

    - When running for G/L Accounts - you should enter a starting date.  

    Note: leaving the starting date blank does not cause an adjustment in the prior period.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans