Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Analytical Accounting ...
Microsoft Dynamics GP (Archived)

Analytical Accounting Budget tree

(0) ShareShare
ReportReport
Posted on by Rahul Gupta 350

Hi,

Can somebody share their knowledge on whether it is possible to create the analytical accounting budget tree with the node named as the Transaction Dimension Code rather than Transaction Dimension Description.

It is defaulted to build the tree based on Transaction Dimension Code Description which is not the unique key in my budget spreasheets.

Feel free to ask question if you need more clarification.

Thanks in advance to look into it and replying

Regards

Rahul Gupta

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Analytical Accounting Budget tree

    I have tested uploading budget for dimension codes with same description and it was uploaded successfully. There is no other way to import Analytical Accounting budget in GP. You can try writing SQL scripts to insert budget data in SQL tables directly.


     

  • Rahul Gupta Profile Picture
    Rahul Gupta 350 on at
    Re: Re: Analytical Accounting Budget tree
    Thanks Rubal, I have transaction dimension codes. In fact that is my prefered way of uploading the budget data. But because GP builds the budget tree based on Transaction Dimension Code description its hard to upload as the description are not unique. Is there any other way to upload the budget with codes but not the description ? Rahul
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Analytical Accounting Budget tree

    GP displays only the AA Dimension Code Description with Budget tree. You can try to add the Dimension codes in your spreadsheet. Table aag00902 has the AA Transaction Dimensions Code IDs for the budget trees nodes. Table aag00401 has Transactions Dimension Code IDs and Transactions Dimension Codes ID. 

     The way data is stored in Table aag00902 is bit complicated. The parent Code ID stores code ID for the parent node, you can use it locate the nodes. Check out if you can use this table to add Transaction Dimension codes in your spreadsheet.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans