Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How to exclude particular dimension in MR reports using GP2013

(0) ShareShare
ReportReport
Posted on by 829

Hi All,

I'm getting problem in Trial Balance report in MR.

Actually We have below dimension in GP AA.

Account group,Account category,Account number,activity,department,location,order no

 

I need to exclude order no dimension in Trail balance report which showing in TB report but unable to find any solution to do this.

tb.JPG

Regards,

Danish

*This post is locked for comments

  • Danish Viqar Profile Picture
    829 on at
    RE: How to exclude particular dimension in MR reports using GP2013

    Actually I don't want to exclude any dimension.I Just want to summarize my entry like below

    Currently I'm getting data like this:

    Account                              Debit                Credit

    5-01-04-C-E-K-00010       100

    5-01-04-C-E-K-00020       200

    5-01-04-C-E-K-00030       100

    But I need data like this in report and not require row repetition on my last dimension(bold)

    Account                              Debit                Credit

    5-01-04-C-E-K                   400

    Regards,

    Danish

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    10 on at
    RE: How to exclude particular dimension in MR reports using GP2013
    Hi, Please add all other dimensions with the plus symbol and you can remove the dimensions you want to exclude and try again.
  • Danish Viqar Profile Picture
    829 on at
    RE: How to exclude particular dimension in MR reports using GP2013

    Hi,

    I did below changes as per your suggestion but no data populate after subject changes.

    Please have a look in attachment,may be I did wrong.5381.1.JPG

  • Danish Viqar Profile Picture
    829 on at
    RE: How to exclude particular dimension in MR reports using GP2013

    Thanks Baskaran.

    Let me check it and revert back to you.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    10 on at
    RE: How to exclude particular dimension in MR reports using GP2013

    Danish,

    Go to column and add filter dimension to exclude order no add negative symbol.

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

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

Featured topics

Product updates

Dynamics 365 release plans