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)

Copy Analytical Accounting Setup to another company

(0) ShareShare
ReportReport
Posted on by 14,855

Dear 

I need to copy the Analytical Accounting setup(Including Dimension and Dimension Codes) from one company to another

I don't think backing up and restore of the company DB will be enough as there are a lot of AA tables on the Dynamics Database that needs attention.

any idea how to do this ?  

Your feedback is much appreciated

*This post is locked for comments

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

    I suggest you to build and use Macros to copy the information from one company to another.  You can use AA smartlist and the tables aaTrxDimMstr(AAG00400), aaTrxDimCodeSetp(AAG00401) and aaUserAccessToCodesSetup(AAG02000).

    Make sure you have the option to use AA in  SmartList Integration window for accessing the smartlist.

  • Suggested answer
    Andrew Hall Profile Picture
    190 on at

    Hi you could create a DTs package to copy across the below setup tables:

    AAG00400 aaTrxDimMstr (dimensions)

    AAG00401 aaTrxDimCodeSetp (codes)  

    AAG00402 aaTrxDimCodeNumSetp

    AAG00403 aaTrxDimCodeBoolSetp  

    AAG00404 aaTrxDimCodeDateSetp

    AAG00405 aaTrxDimRelation

    AAG00406 aaTrxDimCodeRelation  

    AAG00407 AA Trx Dim Adjustment Option

    AAG00500 aaDateSetup

    AAG00600 aaTreeMstr

    AAG00601 aaTreeNodeMstr  

    AAG00602 aaTreeNodeLink

    AAG00603 aaTreeNodeUserWork

    AAG00605 aaTreeMstrDupe

    AAG00700 aaOptionSetp

    AAG00200 aaAccountMstr  

    AAG00201 aaAccountClassMstr

    AAG00202 aaAccountClassDim

    AAG00900 AA Budget Tree Master  

    AAG00901 AA Budget Tree Trx Dim Master

    AAG00902 AA Budget Tree Trx Dim Code Master  

    AAG00903 AA Budget Master  

    AAG00904 AA Budget Tree Balance  

    AAG00905 AA Budget Tree Account Balance

    AAG00906 AA Budget Tree View Work  

    AAG01000 AA UDF Setup option

    AAG01001 AA UDF Trx Dim Setup

    AAG01002 AA Trx Dim CodeUDF Maintenance

    How ever if AA has not already been installed into the company that you are copying into you will need to run the install routine first to make sure the appropriate entries are created in the Dynamics database.

    Once this is done and AA has been activated you need to update the AAG00102 table on the Dynamics database with the appropriate next numbers otherwise you will get primary key issues when you try and post.

    Microsoft provide a script to do this on a KB article: 997280

    mbs2.microsoft.com/.../kbdisplay.aspx

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