Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

AR Revaluation

Posted on by 434

Guys,

I would like to ask, i setup 2 posting profiles, STD and FCR in my customer Posting Profile.  For the purpose of when run my AR revaluation, i want it to post the AR revaluation to my FCR control account (AR - Un-realize gain/loss)

Below is the parameter then i run of my AR  revaluation 

I am getting an expected result when i run my AR revaluation but when i make full payment, i found the the entries to un-realize gain/loss does not reverse

Below is my scenario

Double-Entry.png

AR-Reval.png

I found that when i post my AR payment to settle my invoice, my AR revaluation posted to my FCR posting profile did not reverse.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR Revaluation

    Excellent.

    Please keep us informed here what they find :-)

    Many thanks and best regards,

    Ludwig

  • Dexin Profile Picture
    Dexin 434 on at
    RE: AR Revaluation

    Hi Ludwig,

    Thanks for your help.

    Will log a case to MS for them to look into it.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR Revaluation

    Hi Dexin,

    You are right.

    If I select this option then I get the same problem.

    Can you open a support case with MS for this issue?

    To me this looks like a bug that should be fixed asap.

    Many thanks and best regards,

    Ludwig

  • Dexin Profile Picture
    Dexin 434 on at
    RE: AR Revaluation

    Ludwig,

    Appreciate so much to your help

    Below is the print screen

    AR Parameter

    1777.png

    Customer posting profile

    4401.png

    When post invoice is using the STD posting profile, when post AR revaluation is using FCR

    I found that the issue could be due dimension option in AR revaluation form

    When select dimension = None i am getting the expecting result

    When select dimension = Posting i am getting a wrong reversal posting

    7571.png

    5488.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR Revaluation

    Hello Dexin,

    Many thanks for those screenprints.

    I tried replicating this in my demo machine but did not get the same result :-(

    Can you help me with the following:

    1. I would like to know what posting profile is setup in the AR parameters

    2. I would like to know the summary accounts that are setup for the different posting profiles that you use. Especially the FCR one and the one that you use for ordinary invoice recordings.

    3. Can you also let us know what posting profile was used when the original opening balance transfer was posted?

    Some additional screenprints would be great.

    Many thanks and best regards,

    Ludwig

  • Dexin Profile Picture
    Dexin 434 on at
    RE: AR Revaluation

    Hi Ludwig,

    Please find below is my simulation

    1. Created a opening invoice @ 1000EUR. Posted to 73060 control account

    7041.png

    2. Run AR revaluation on 30/11/19, select different posting profile

    6403.png

    3. The un-realize gain/loss was posted to 73331 control account

    61141.png

    4. When post AR payment to settle the invoice, all voucher transaction doesn't show it reverse from 73331 to post to 73060

    2474.png

    as a  result the amount still sitting in my 73331 account

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR Revaluation

    Hi Dexin,

    Can you please share

    (a) a screenprint of the original invoice voucher from AX

    (b) a screenprint of the payment voucher including all related vouchers from AX.

    Some information about your account names and the posting types used would help.

    Many thanks,

    Ludwig

  • Dexin Profile Picture
    Dexin 434 on at
    RE: AR Revaluation

    Hi Ludwig,

    I did checked the All related voucher from my payment voucher.

    I can see all the posting entries but none of it is from FCR.

    I don't see the reversal from FCR

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR Revaluation

    Hi Dexin,

    Can you please open the payment journal and from there the voucher.

    Once you are there identify the 'all related voucher' button and you should also see the transactions posted on the summary account that is linked to your FCR posting profile.

    Best regards,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AR Revaluation

    Many thanks.

    This seems to be the latest one. As a result, the 'old' bugs that are listed on LCS should not be relevant.

    Let me check this and come back to you

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans