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

Notifications

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) / How to Reverse Adjust ...
Microsoft Dynamics NAV (Archived)
Unanswered

How to Reverse Adjust Exchange Rate batch job?

(0) ShareShare
ReportReport
Posted on by Community Member

 

Hello,

One of my client accidently did an adjustment for vendor and customer entry with Adjust Exchange Rate batch job in Dynamics Nav 4.0. How could they reverse this posting to reach the original state of the vendor and customer entries?

I know that is possible to run again this rutin. The problem is that this batch job adjusted different vendor and customer invoices on different dates from diferent exchange ratest to on given exchange rate. And know I don't know how can I restore the original exchange rates in this invoices.

Please help.

Many thanks

Tamás

*This post is locked for comments

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

    There is no automatic way to reverse the entries of the 'Adjust Exchange Rate' batch job.

    Recommend you review the GL Registers to see the entries posted to the control accounts and also review the Exchange Rate Adjustment Register.  This will let you know which vendors customers entries have been updated.

    The client will need to update the exchange rate currency table with the old exchanges.  This is a manual process and does not guarantee for the figures will be correct.  If the client had a backup of the rates prior to the running the Adjust Ex Rates batch job - this may help - but actually what you really want is what was the exchange rates as of the last successful run of the adjust exchange rate batch job.

    Would recommend you re-run the batch job upto the end of the last period (month) - but remove(delete) any exchange rates relating to this period - you will need to do this 1st and then re-run the 'adjust exchange rate batch job.

  • Community Member Profile Picture
    Community Member on at

    Many thanks for your answear Paul. Actually I don't unterstand exactly. 

     I can collect the all customer and vendor invoices which was adjusted from the registers (you wrote), and I can calculate the original exchange rates of each invoices from the detailed vendor or customer entries. So I have the information that what kind of exchange rate would be used the given invoice.

     

    I can write these rates to the exchange rate currency table (you wrote). It's ok.

     What I don't understand is your recommendation:

    "Would recommend you re-run the batch job upto the end of the last period (month) - but remove(delete) any exchange rates relating to this period - you will need to do this 1st and then re-run the 'adjust exchange rate batch job."

    So Should I run the ajdust exchange rate batch job without no exchange rate in the exchange rate currency table? I think in this case it will give an error that it can't find any exchange rate on the given ending date of the report, no?

    The problem here from my point of view is that this job wants to adjust all open entries to the exchange rate on the ending date of the report. But I want to give different rates to different invoices on different posting dates.

    Hmmm but if I am lucky the original exchange rates of invoices on the same posting date are the same. In this case I can run the job on each posting dates separetly. I can give the begining and endig date of the report the given posting date. What do you think?

     

     

     

  • Community Member Profile Picture
    Community Member on at

    How often does your client run the "adjust Exchange Rate' batch job.  Most clients run this at month end to work out gains and losses.

    Lets say the last time it was officially run was used with ending date 31 Oct.  So when they rate the routine '"adjust Exchange Rate' batch job - they entered starting date 1st Oct, ending date 31 Oct, and Posting date of 31 Oct.

    You will always need exchage Rates in the exchange rate table. So do not delete all the exchange rates.  You just need to ensure the rates are correct.

    If you go to the vendor or customer ledger entries - and zoom on the lines - you will find the Original Currency Factor - for when the document was 1st posted.

     I think you will need to talk to your client.

    One important thing to understand is - when you run the routine - it does not just look at entries from a specified Start<>End date.... it looks at ALL open entries - that where OPEN during your Start Date and End Date, so lets say you put the 15th Oct as the Start & end Date... if there is a new or updated exchange rate for the 15th Oct- then the batch job will look at ALL open entries Prior to the 15th Oct & Open entries on the 15th Oct. And then work out the unrealised gain/loss and create a new Value entry on the customer or vendor account.

     

  • Community Member Profile Picture
    Community Member on at

    Just going back to your original message.

    Recommend - you update the exchange rate table with the correct rates that the client wants.

    Then re-run the batch job.  The system will then see that there are updated rates and will update the vendor ledger entry with the exchange rate of the routine Posting Date.

    You will need to advise the client - that you can not revert back to what they were - as the routine is real time and should be run as part of the Month End routine.

  • Community Member Profile Picture
    Community Member on at

     Ok I see your concept. The different is that in my county you can't do revaluing any time, only at the end of the year and only if the difference is bigger than a given amount. So this is the reason that I need to restore the original state, becuse it is an absululty wrong posting.

    Maybe it's not a problem that is will adjust the all open entry. It happened nowdays so I think I can be ensured that the same invoices will be opened (maybe I have made some application reverse). My other idea is to see the C/Al code of the report, maybe it's possible to filter it a given document no.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans