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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Analytical Accounting

(0) ShareShare
ReportReport
Posted on by

Hi, we have set up a number of Transaction Dimension Codes within GP 2013 r2. We discovered that the codes were listed in alphabetical order and so to aid users, those that were used most often we preceded with *** so they always appeared top of any lists when users selected the relevant AA code.

Unfortunately we have now discovered that any of our Dimension Codes that are preceded with *** don't work in Management Reporter for reporting purposes. They are deemed invalid.

The solution seems to be to replace the *** with AAA so they are still top of the list. Does anyone know how to rename Dimension Codes that have been used since the box is greyed out in Transaction Dimension Code Maintenance.

Failing that I can set up new ones but it would be good to move any balances recorded against the old AA codes, is this possible as a second option?

Thank you for any help.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    Although this would never be officially supported or recommended solution, you may try to have a full back up into a test environment so that you may do any proposed suggestions safely. The transaction dimensions and dimension codes have IDs which identifies them, you may try to update the AAG00401 table, aaTrxDimCode column.

    I do recommend thorough testing for such updates and changes before any change to apply on your live environment. Furthermore, please be aware that dimension code order can be manipulated, check this article for further insight.

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    on at

    Thank you, that seemed to work perfectly. Much appreciated.

  • Mahmoud Saadi Profile Picture
    32,738 on at

    Make sure to test well

    Good luck,

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans