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) / MR: add new company in GP
Microsoft Dynamics GP (Archived)

MR: add new company in GP

(0) ShareShare
ReportReport
Posted on by Kaylasch 249

Hello,

After adding a new company into GP, I have always rebuilt the data mart, because some of my clients would report, the reports wouldn't have the new company data in them after transactions were entered for the new companies, if I didn't rebuild it. I have been told by a consultant that you need at least one transaction in the company before you can rebuild the data mart. Is it OK to rebuild the data mart right after you create the company, or should you wait until there are transactions in the company?

*This post is locked for comments

  • Kayla Schilling Profile Picture
    Kayla Schilling on at
    RE: MR: add new company in GP

    I have had the same experience as Mary50 so I put rebuilding the DM as part of a new company creation task. I will stop doing this, and if a customer reports that the transactions for the new company are not showing up, I will note the CU.

  • Mary50 Profile Picture
    Mary50 5 on at
    RE: MR: add new company in GP

    It could possibly be that they are on an older CU when this happens, diebestetest.de but I wanted to see if there was some guidance on when or if you needed to rebuild the data mart after adding a company. I have been doing it as part of a new company creation because we have ran into clients that reported the new company transactions are not showing unless we rebuild the DM.  

  • Dedi Hermawan Profile Picture
    Dedi Hermawan 295 on at
    RE: MR: add new company in GP

    Try this simulation

    How to Add new Company to Report Designer on Management Reporter on my blogs

    www.dynamicszr.web.id/.../how-to-add-new-company-to-report.html

  • 26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: MR: add new company in GP

    Kayla - Absolutely we upgraded from CU12 to CU14 and we have rebuilt the datamart only twice in 3 years. We have issues with the repository as it has become a behemoth now, but that is a different topic.
    We had issues with CU12, thats why we converted to CU14.
    Once we upgrade our GP to the 18r2 we will upgrade MR to cu16.

    It has gotta be the CU that you are on.

    Best to you.

  • Kayla Schilling Profile Picture
    Kayla Schilling on at
    RE: MR: add new company in GP

    Hello Ven,

    We add the company to MR, and you can see it in the DataMart, but sometimes with some clients, the transactions in the new company do not get picked up until we do a data mart rebuild. It could possibly be that they are on an older CU when this happens, but I wanted to see if there was some guidance on when or if you needed to rebuild the data mart after adding a company. I have been doing it as part of a new company creation because we have ran into clients that reported the new company transactions are not showing unless we rebuild the DM.

  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: MR: add new company in GP

    Hi Kaylasch:

    Looks like you already have the data mart built that holds financials data from other GP companies.

    Have you tried adding this new company to the current data mart? That is not the same as rebuilding the data mart.

    You can do this from MR Configuration console by adding this new company to the integration. The only thing you need to be sure of is a functional currency in the new company in GP. These days, MR will give you a visual cue if that is the case.

    Rebuilding the data mart is required only when there is a disconnect between what you see in GP (Trial balance report or Summary Inquiry) and MR for the same account.

    Cheers

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,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans