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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Allow edit posting dat...
Finance | Project Operations, Human Resources, ...
Suggested answer

Allow edit posting date and exchange rate after approved the AP Invoice journal/ AP Payment journal AX 2012 R2

(0) ShareShare
ReportReport
Posted on by ThuNgo 978

Dear all,

I have a case as below:
- After approvers approved the payment journal, however the actual date that we paid the amount is difference than the posting date on Payment journal, so as a result, the posting date and the exchange rate have to change accordingly.

Is there any way/ configuration that i could do, so i could edit the posting date and exchange rate without start the whole workflow again?

Thank and best regards,

Thu,

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Allow edit posting date and exchange rate after approved the AP Invoice journal/ AP Payment journal AX 2012 R2

    Hi Thu,

    When you post the payment journal and transfer the money then there will be a

    specific exchange rate applicable on that day.

    This rate might be different from the one that is used by your bank when they execute the transfer (possibly a day or two later).

    As a result you will get an exchange rate difference / variance related to your bank account.

    In AX2012 there is no standard bank foreign currency revaluation functionality available. You have thus two choices:

    Choice A: Make a code adjustment similar to what is described here: dynamicsax-fico.com/.../

    Choice B: Run a foreign currency revaluation in GL for your bank account to get the balances right at the GL level. Note: When you are doing that, you will get a difference in the GL bank balance and the one that you see in the cash and bank module.

    Best regards,

    Ludwig

  • Suggested answer
    Pedro Tornich Profile Picture
    Pedro Tornich 955 on at
    RE: Allow edit posting date and exchange rate after approved the AP Invoice journal/ AP Payment journal AX 2012 R2

    Hi,

    The out of the box workflow process locks the record after it's approved, for obvious reasons.

    So, to allow users the change approved records you would need to change that logic through a customization.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Allow edit posting date and exchange rate after approved the AP Invoice journal/ AP Payment journal AX 2012 R2

    Good Morning Thu,

    Have you been able to make some progress here and has the issue been resolved in the meantime?

    Would be great if you could keep us updated.

    Many thanks,

    Ludwig

  • ThuNgo Profile Picture
    ThuNgo 978 on at
    RE: Allow edit posting date and exchange rate after approved the AP Invoice journal/ AP Payment journal AX 2012 R2

    Hi Ludwig,

    Sorry for late reply, our team decide to customize this case.

    Thanks and best regards,

    Thu,

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Allow edit posting date and exchange rate after approved the AP Invoice journal/ AP Payment journal AX 2012 R2

    OK.

    But test carefully and extensively before applying this customization in your live environment.

    Best regards,

    Ludwig

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,933

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 793 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 537 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans