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) / Management Reporter - ...
Microsoft Dynamics GP (Archived)

Management Reporter - Column Defintion - Attribute category list.

(1) ShareShare
ReportReport
Posted on by Community Member

Hi,

We are converting our Frx reports to Management Reporter.. We used to have an attribute category called ORMSTRNM to display the vendor name. With MR, I should be able to just find the Vendor Name from the attribute category list according to documentation but for some reason, my attribute category list seems very limited compared to what I saw online.. So my question is, how is this attribute category list is being populated?  I'm using the legacy data provider, not the data mart.. Could this be the reason?

Thanks

*This post is locked for comments

  • JoshP Profile Picture
    JoshP on at
    RE: Management Reporter - Column Defintion - Attribute category list.

    Hello Kathy,

    In previous versions of Management Reporter, data providers displayed all attribute values that were listed in the ERP database, regardless of context or functionality. This included attributes that were not associated with transaction data. When you use the data mart integration, Management Reporter 2012 now displays only the attribute values that are associated with a transaction. This improves report generation and data analysis. So if you see a listing of attributes for your ERP but you do not see it as an option in your environment, it is likely that there are no transactions posted that include the attribute.

    For Dynamics GP, you would not use the attributes named Customer/Vendor; however, you would use one of the attributes such as "Originating Master Record Name" (from the ORMSTRNM GL column) in the GP company database to display the vendor associated with the GL transaction. Note that the attribute you want to report on has to be included as part of a transaction and be listed in the GL tables (GL10xxx, GL20xxx, GL30xxx).

    Also, I see a question was asked regarding MR 2012 with Dynamics AX. Please note that unfortunately, the information about the Vendor and Customer attributes no longer being available is incorrect. There was a change around CU10 where Vendor and Customer are in the "AttributesToIgnore" list by default. This can be easily modified in a config file by the MR Administrator. If you have further questions regarding MR 2012 with Dynamics AX or enabling these attributes, please start a new thread in the Dynamics AX forum.

    Thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter - Column Defintion - Attribute category list.

    So, does this mean that these Attributes are no longer available for selection?  I specifically would like to create a report that uses the Country from the Vendor Card and the Country from the Customer Card.  Would this still be possible?

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter - Column Defintion - Attribute category list.

    Zaza,

    The Customer and Vendor attributes were deprecated in later versions.  This would require a developer to customize MR.

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter - Column Defintion - Attribute category list.

    I am on Microsoft Dynamics AX and I am on Management Reporter CU10 and I used to have an attribute categories for customer name and vendor name in MR CU9 but these are no longer visible in MR CU10.  Is this a know bug?

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter - Column Defintion - Attribute category list.

    I am on Management Reporter CU10 and I used to have an attribute categories for customer name and vendor name in MR CU9 but these are no longer visible in MR CU10.  Is this a know bug?

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter - Column Defintion - Attribute category list.

    Thanks Harry for your answer.. My reports are showing the vendor name now.   I'm just wondering how this list gets populated.  The list you posted looks very much the same as the one I see but in 'how to' videos for MR, their attribute category list is quite different.. I'm just wondering how I can add items to that list.  Do you know?

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Management Reporter - Column Defintion - Attribute category list.

    Zaza,

    The Attribute Category you reference from FRx is Originating Master Record Name, and it corresponds to Vendor and Customer Names for transactions originating in the Purchasing and Receivables modules.   You can accomplish this and much more by defining a column in the column layout as ATTR, where you would normally put DESC, FD or CALC then select the appropriate Attribute Category in the Row below.

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... 293,112 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,893 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans