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 / Finance | Project Operations, Human Resources, ... / Management Reporter
Finance | Project Operations, Human Resources, ...
Unanswered

Management Reporter

(0) ShareShare
ReportReport
Posted on by Sunil Chhabra 1,938

How can I  print in my row definition a complete account number.  Dept-Costcenter-Object   

001-100-6000 Salaries

001-100-6010 Fringe Benefits  

......................

Thanks

Categories:
Microsoft Dynamics GP
  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Reporter

    That is correct.  There is not a way to combine the account from the row with the account from the tree.  The ACCT will only display the account number that is in the row definition.  

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,938 on at
    RE: Management Reporter

    Greg - you are correct and this how it is setup. It only shows the MAIN account as the MAIN account is in the Row Format. The problem with the Drill Down is,  it only Drills on the account that you select not all accounts.   The only way I can list  all accounts 100-01-1000 is  if I define it in the Row Definition.

    I was looking for an alternate way to print the entire string even if the Row Definition has MAIN account only. For ex: the Reporting Tree has 100-01   and the MAIN account is 1000 - I take it there is no way in the Report to combine the Row (MAIN Acct 1000) with the Tree 100-01

    Thanks

  • Frank_Heslin Profile Picture
    Frank_Heslin 895 on at
    RE: Management Reporter

    Bill is correct!  In the Column Definition, the first row below the Header rows (this number can vary) is the Column Type.  Inf you want the account number at the beginning, in the first column choose ACCT as the Column Type.  To add the account description, in the second column choose DESC as the Column Type.

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Reporter

    Adding an ACCT column to the column definition will show the account number, but only as it appears in the row definition.  If the row has 1100, then the ACCT column will display 1100.  To see the full account number you could drill down to the account detail level.  

    If you row had 001-100-6000, then the ACCT column would show that.

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Management Reporter

    The easiest way would be to add a column at the start of the page that is set to display the Account Number.

    It has been a bit since I had to do this, but I believe there is a choice in the drop down for the column type to choose the account number format.

    Hope this is (1) right and (2) helpful.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,606 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,551 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans