Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Analytical Accounting ...
Microsoft Dynamics GP (Archived)

Analytical Accounting - set default dimension codes and percentages

(0) ShareShare
ReportReport
Posted on by Alicia Berglund 1,144

I have a customer who is considering using GP AA to track whether a cost is taxable, non-taxable or non-applicable without expanding their current COA.  If the cost is taxable, many times it is only a percentage.  The other portion/remainder needs to be coded as 'non-taxable'.  My question(s):

Does AA allow multiple default transaction dimension codes?

If so, can you assign a percentage default?

The goal is that for specific GL accounts, the transaction would not only automatically be assigned a transaction code, but multiple codes with the applicable distribution percentages?  

Please let me know if you know of any out-of-the box functionality I may be missing or if you have run into this situation and have a work-around.

Much appreciated!

Alicia

*This post is locked for comments

  • patterry Profile Picture
    patterry 107 on at
    RE: Analytical Accounting - set default dimension codes and percentages

    Good day

    I have setup 2 dimensions - Procurement and travelling. Basically I want to be able to distribute the amount captured  to account 000-2100-00 e.g. to 100% Procurement or 100% travel depending on the expense I will be capturing.

    I have captured both dimension codes under the same class and assigned the above mentioned account to the class.

    When I go to the analytical analysis transaction entry screen, how do I distribute the amount to only one dimension and make sure that one dimension is printed on my report?

     

    Thank you for your help.

     

    Regards

     

    Patience

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Analytical Accounting - set default dimension codes and percentages

    Each AA transaction dimension can have several codes on which you assign amounts of specific percentages of the whole amount, in your case, when the AP account is affected with 100, the following transaction codes could be assigned to specific percentages as you mentioned.

    Check the following Knowledge Base article for a step by step illustration on how to create the dimension along with the specific percentages.

    Steps to set up a GL Transaction Integration with Analytical Accounting in Microsoft Dynamics GP

    It's worth mentioning that those values stored under different dimension codes are only recorded for analytical purposes, while the AP account will still be affected with the whole amount 100.

    Ms. Susan suggestion is a valid option though, but still AA can be utilized to further enhanced several dimensions and relations for a certain account entry, in order to eliminate the size of Chart of Account mainly and maximize the reporting capabilities.

    Your feedback is highly appreciated, 

  • sueconrod Profile Picture
    sueconrod 337 on at
    RE: Analytical Accounting - set default dimension codes and percentages

    Just an observation here, but why wouldn't you just use the tax tables, you can have taxable, non-taxable (or exempt).   Then at the end of the month you can pull a report with the taxable and non-taxable amounts.  You can setup the percentages.

  • Alicia Berglund Profile Picture
    Alicia Berglund 1,144 on at
    RE: Analytical Accounting - set default dimension codes and percentages

    The additional data is related specifically to the codes mentioned.  For example:

    AP invoice for 100.00 - 85% taxable, 15% non-taxable.  Would like those to default - the codes as well as the percentages.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Analytical Accounting - set default dimension codes and percentages

    I am quite convinced that AA could be simply the most effective and efficient solution in several cases.

    In your case, the answer is that you could simply create several dimensions that can be linked to your current GL Accounts. For instance, you could create one dimension called (Tax Types) and the associated values are;

    Taxable, Not Taxable and Not applicable. See that this dimension is used to track the information of taxes specifically. Other dimensions can be created and linked to record further analytical details

    MVP Mohammad Daoud emphasizes on this capabilities of AA through a comprehensive yet simple case study which shows how sufficient AA could be.

    Microsoft Dynamics GP Analytical Accounting Vs. Segments

    Hope this helps,

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans