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 / 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

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

    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,

  • Alicia Berglund Profile Picture
    Alicia Berglund 1,144 on at

    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.

  • sueconrod Profile Picture
    sueconrod 337 on at

    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.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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, 

  • patterry Profile Picture
    patterry 107 on at

    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

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans