web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to exclude particu...
Microsoft Dynamics GP (Archived)

How to exclude particular dimension in MR reports using GP2013

(0) ShareShare
ReportReport
Posted on by Danish Viqar 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

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Danish,

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

  • Danish Viqar Profile Picture
    Danish Viqar 829 on at

    Thanks Baskaran.

    Let me check it and revert back to you.

  • Danish Viqar Profile Picture
    Danish Viqar 829 on at

    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

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    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
    Danish Viqar 829 on at

    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

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans