Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Insert Rows from Dimensions not detecting all accounts

(0) ShareShare
ReportReport
Posted on by 145

Hello,


I'm trying to run a trial balance from MR which captures all accounts from both entities. I click Insert Rows from Dimensions, then &&&, etc. Once generating the report, it's missing 10 or so expenses from my 2nd entity. I had to manually add them in, but I'm curious why Insert Rows didn't detect them? I made sure they're listed in the 1st entity, as someone told me this may work.

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Insert Rows from Dimensions not detecting all accounts

    Hi accountinguser2018,

    It seems that you ended in the wrong forum.

    This one is for AX.

    As you seem to work with GP, I will move this thread to the GP forum.

    Best regards,

    Ludwig

  • accountinguser2018 Profile Picture
    accountinguser2018 145 on at
    RE: Insert Rows from Dimensions not detecting all accounts

    Hello - they've been set up in our 2nd entity for a very long time. There's been activity for years. I set them up in the first entity just in case it needs it in the 1st one as well to pull into MR. I ran a fresh "insert from row dimensions" in MR after adding to the 1st entity. I also had restarted GP just to be safe/sure that the updates may be reflected.

    What do you mean open a row structure and available selections? Is it possible to provide a visual?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Insert Rows from Dimensions not detecting all accounts

    Hi,

    Have those accounts been setup recently?

    If you open a row structure and open the available selections, do you have those accounts available for selection in the drop downs?

    Best regards,

    Ludwig

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans