Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Missing GL Accounts in MR 2012 after using PSTL

(0) ShareShare
ReportReport
Posted on by 75,776 Moderator

We re-arranged a few accounts in the GL using PSTL. I am running the P/L and we have a few accounts that are now missing from the report. Oddly enough, the accounts that are missing are ones that were NOT changed. I have refreshed the cache, I can pick these accounts from the list and I even tried creating new rows and selecting the accounts and they will not appear on the report. What else can I check? It appears to be something tied to these accounts. I also ran GL reconcile. Would check links be the next thing to try. If so, I will wait until everyone leaves and perform a backup first.

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,776 Moderator on at
    RE: Missing GL Accounts in MR 2012 after using PSTL

    Thanks Keith, as I was driving today the idea of the datamart hit me. I will be on site on Saturday and will give this a shot.

  • Verified answer
    Keith Vogt Profile Picture
    Keith Vogt on at
    RE: Missing GL Accounts in MR 2012 after using PSTL

    Hi Richard,

    Note that after the PSTL account modifier has been run on your GP databases, you will be required to rebuild the Management Reporter data mart database.

    You will not be prompted for doing this, but the reason for this is that the transaction information in the data mart will be tied to the old combination of dimensions (account segments) and you will notice incorrect balances in reports after the change.

    This is not a standard operation in the Dynamics GP client so the data mart has not been designed to pick up this type of modification; however, rebuilding the data mart will correct this problem.

    You can rebuild the data mart with the following steps:

    a. Open the Management Reporter Configuration Console.

    b.  Click on the GP integration under ERP integrations

    c. Click Disable Integration

    d.  Click Remove in the upper-right corner to get rid of the integration

    e. Exit the Configuration Console

    f. Open SQL Server Management Studio

    g. Backup the DDM database

    h. Delete the DDM database

    i. Open the Configuration Console

    j. Go to File | Configure

    k. Choose "Add Microsoft Dynamics GP Data Mart"

    l. Follow the steps for the Dynamics GP provider at:

    Microsoft Management Reporter: Installation, Migration, and Configuration Guides

    www.microsoft.com/.../details.aspx

    m. When finished, be sure to click the "Enable Integration" button in the Configuration Console

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans