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 / Finance | Project Operations, Human Resources, ... / How can run the AP &am...
Finance | Project Operations, Human Resources, ...
Answered

How can run the AP & AR Revaluation without setting the Default dimension on Main A/C

(0) ShareShare
ReportReport
Posted on by Neelu K Bhojwani 90

Segments-and-allowed-values_5F00_ngo1.xlsx

Hello Community,

I am having issues while i run the AP/AR Revaluation on DAX since the VEX vendor exchange and CEX Customer exchange voucher is new posting system show the error on the AP/AR Main account without financial dimensions.

The aim is the run the AP & AR Revaluation without manual interference of me making the Financial Dimension as fixed on the mail a/c default by entity wise.

Once the AP/AR Revaluation is completed i go ahead and remove the fixed dimension to unfixed dimensions.so it picks the original Financial Dimension coming form the original document from end user.

NGO1-Revaluaiton-ap-_2600_-ar-July-20.xlsxs coming from user.

Appreciate your response.

Br, Neelu k Bhojwani

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Why is the AP/AR main account posted without financial dimensions?

    What is the underlying reason for this?

    Why and what financial dimensions do you want to have posted for the revaluation gains/losses?

    Would be great if you could provide some additional information on your system setup.

    Many thanks and best regards,

    Ludwig

  • Neelu K Bhojwani Profile Picture
    Neelu K Bhojwani 90 on at

    Hello Ludwig,

    Why is the AP/AR main account posted without financial dimensions?

    Not sure if we've missing setting on the AP/AR Revaluation posting profile or the setup for Revaluation

    What is the underlying reason for this?

    System should pick the variance on the exchange rates and posting in the reporting currency. Invoice value in the document value remains same as is but system should refer the financial dimension posting on the original document while running revaluations for particular open invoice and i guess this is not happening on our system.

    Why and what financial dimensions do you want to have posted for the revaluation gains/losses?

    DAX should post the revaluation with the FD's of original open invoice which is getting revaluated on vendors and customer subledgers.

    Would be great if you could provide some additional information on your system setup.

    we've 10 layers of Financial Dimensions' but it seems on system we do not have default dimension set up for ap and ar main a/c. or the set up is incomplete for revaluation. Let me know if i am unable to explain this to you clearly.

    Thanks Ludwig,

    Neelu

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Neelu,

    Thanks for that.

    I assume that you have different account structures that you use for balance sheet and P&L accounts is that right?

    Best regards,

    Ludwig

  • Neelu K Bhojwani Profile Picture
    Neelu K Bhojwani 90 on at

    Hello Ludwig,

    No we've one a/c structure for P/L & B/S. I've attached NGO1 A/c structure on main post.

    Br, Neelu

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Neelu,

    The Excel does not really help me.

    I would rather like to see screenprints of the account structures used.

    Irrespective of this, can I ask you what selection you make when you run the revaluation?

    There is a specific parameter 'dimensions' that defaults to none.

    Alternatively you can select table or posting.

    What do you select in this field?

    Best regards,

    Ludwig

  • Neelu K Bhojwani Profile Picture
    Neelu K Bhojwani 90 on at

    NGO1-Parameters.docx

    Hello Ludwig,

    See attached parameters used for Revaluation.

    Br, Neelu

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    OK. Cool. Many thanks.

    This setup should make sure that the findims from the original postings are used.

    Now the question is how do your original postings on the customer/vendor summary account look like?

    Do they always have the findims included that you need for your revaluation account?

    What would help a lot is if you could share a screenprint of your account structure configuration for the balance sheet and P&L accounts.

    Many thanks.

    Ludwig

  • Neelu K Bhojwani Profile Picture
    Neelu K Bhojwani 90 on at

    Account-Structure-_2D00_-ISS.docx

    Hello Ludwig,

    Original Posting to vendor & customer is with Financial Dimensions. Branch, Facility, Line of Business, Segment and Sub-Segment is mandatory and rest all are option based on the requirement.

    Do they always have the findims included that you need for your revaluation account?

    I guess this is what we're missing on the set up for revaluation.

    I've attached the screen shot of the findims on the account structure as well as parameters used while the ap&ar revaluation is run on the the DAX System.

    Many Thanks,

    BR, Neelu

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Neelu,

    Based on what you describe and shared I would consider this as a bug.

    If the original transaction is not one resulting from a data migration or any other 'special' event then I would suggest upgrading to the latest D365FO version and if you are already running this latest version, to open a support case with MS.

    Best regards,

    Ludwig

  • Neelu K Bhojwani Profile Picture
    Neelu K Bhojwani 90 on at

    Thanks Ludwig, we will open a support ticket with MS.

    Br, Neelu K Bhojwani

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans