web
You’re offline. This is a read only version of the page.
close
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 267

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

I have the same question (0)
  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,775 on at

    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

  • Kayla Schilling Profile Picture
    Kayla Schilling on at

    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.

  • 26P2ER Profile Picture
    26P2ER 1,775 on at

    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.

  • Dedi Hermawan Profile Picture
    Dedi Hermawan 295 on at

    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

  • Mary50 Profile Picture
    Mary50 5 on at

    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.  

  • Kayla Schilling Profile Picture
    Kayla Schilling on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans