Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

management reporter insert rows from dimensions

(0) ShareShare
ReportReport
Posted on by

Hi,

My client is on GP2013 and MR 2.1.1032.3

In MR Row Definition I click on Edit - Insert Rows from Dimensions and convert two segments to All &&&. Then I enter my ranges on those two segments and click OK. I get the error "no rows could be added based on the specified criteria." As you can see in the screenshot behind, I can manually key the two segments. I can only use the Insert Rows feature if I do NOT use more than one segment. 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: management reporter insert rows from dimensions

    I have a client that is experiencing this issue, and they have GP2015 version 14.00.0952 (R2) and use the Data Mart with MR. I don't have the issue, and I have GP2015 version 14.00.0817 (R2) and use the Data Mart with MR. I don't see in the responses what resolved this issue. If someone could let me know, I would be very grateful. Thanks in advance!

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,054 Super User 2024 Season 1 on at
    RE: management reporter insert rows from dimensions

    Hi Heidi,

    I just did a test with our PROD system MR2012 which happens to be still on CU10 and uses the Legacy connector.. I had no problem to select 2 segment ranges with account numbers and department numbers.. I'm going to run some more tests Monday when back in the office on my GP2015 TEST system where I've to install the latest CU14 with the DataMart.

    2016_2D00_02_2D00_26_5F00_175851.png

    resulted in :

      2016_2D00_02_2D00_26_5F00_175851.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: management reporter insert rows from dimensions

    Thanks Beat,

    The customer is on MR 2012, CU13 and using the DataMart. We've tried several things but at this point didn't have time to upgrade.

    I also didn't see anything in the CU14 fix list that included a resolution for that. No biggie, just thought I'd see if anyone had a better answer :)

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,054 Super User 2024 Season 1 on at
    RE: management reporter insert rows from dimensions

    Hi Heidi,

    Which version of MR2012 are you running ? You may want to do some testing with the Legacy connecctor vs. the DataMart after updating to the latest CU14.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: management reporter insert rows from dimensions

    Hi Melissa,

    Thank you for your email. I would have thought the same thing, but we verified several accounts that DID have activity in the current year that it still excluded. We ended up just manually keying the lines we needed.

    NOT HAPPY ABOUT THAT!! :)

    Thanks again.
    Heidi

  • Melissa Brown Profile Picture
    Melissa Brown 190 on at
    RE: management reporter insert rows from dimensions

    I found out it is by design that Management Reporter will exclude any accounts without activity when using "Add Rows from Dimensions."  So, check if the accounts that are missing have any activity.  

  • Linda Brock Profile Picture
    Linda Brock on at
    RE: management reporter insert rows from dimensions

    hi - sadly this was too long ago for me to recall what happened. :-(

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: management reporter insert rows from dimensions

    Did anyone get an answer for this? I have a customer who is having a similar issue. They aren't getting an error when using more than just the "main" segment, but it doesn't populate every single account if using anything more than just the main segment.

    It brings in most of the accounts but not all. Any ideas here?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: management reporter insert rows from dimensions

    Hello,

    I am having the exact issue reported.  MR 2.1.7044.43 -  i can only use the edit insert on the main segment, not all for my trial balance report

  • Melissa Brown Profile Picture
    Melissa Brown 190 on at
    RE: management reporter insert rows from dimensions

    I just went from RU5 (which was fine) to CU8 at a client and now I'm getting this same behavior.  I also am using a DataMart.  Any way to get around this?  Has this been reported as a bug?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans