web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10 Syncing GL00100...
Microsoft Dynamics GP (Archived)

GP 10 Syncing GL00100 and GL0105

(0) ShareShare
ReportReport
Posted on by Truitt Bradly 510

We use a 3rd party Budgeting/Reporting system, Prophix and it pulls the GL data direct from GP's SQL server back end.  Prohix uses the table GL00105 which is the GL_Account_Index_MSTR to build the account segments into a single account number.  This table is not in sync with GL00100 which is the GL_Account_MSTR.

It there a routine in GP to sync the master with the index master?  If not is it safe to make update thru SQL or to update manually?

 

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,633 Moderator on at

    Truitt, have you run Check Links yet on the Account Master tables?  That would be my first step.  I definitely would not update via SQL.  How many records do you have out of sync?

  • Truitt Bradly Profile Picture
    Truitt Bradly 510 on at

    Frank, there are 452 records in GL00105 where the ACTNUMBR_3 segment does not match the GL00100 table and the total record number for each table is the same.  I have not run Check Links on the Account Master tables yet.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    They should be writing to the GL00100 not the GL00105 table. Assuming the GL00100 has the correct accounts, you can then delete records out of the GL00105 table then run check links. This will make sure the GL00100,GL00105 and GL40200 tables are all in sync. Make sure you do a backup before attempting this.

  • Truitt Bradly Profile Picture
    Truitt Bradly 510 on at

    Richard,

    They are only reading from GL00105.  I'll try Check Links after hours.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Truitt, the GL00100 is the master GL account master. Running check links on the GL Master table will recreate the GL00105 and GL40200 tables. You can check out this KB. It is best to empty the GL00105 and GL4020 table prior to running check links. After you run check links you will get  a lengthy report telling you all the additions that were just performed.

    support.microsoft.com/.../855963

    So if they are reading the GL00105 you want to make sure it is in sync with the GL00100.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    One added piece of information, you can 'empty' the Account Index Master using Microsoft Dynamics GP > Maintnenance > Clear Data. Be sure to change Display to Physical so that you are dealing with an individual table instead of a table group.

    Richard,

    Why would we want to clear the Segment Description Master GL40200?

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    I only suggested the GL40200 to clean away any bad records. If that table is clean then there is no need to empty that table. I have a customization for clients that populates new companies with a standard chart of accounts. I use that routine to populate the GL00100 and then check links takes care of the GL00105 and GL40200 tables.

  • Community Member Profile Picture
    Community Member on at

    I need to delete accounts from the GL00100 account. what other tables do I need to delete from so that when I run Check Links, they don't reappear?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    You can delete records out of the GL00105 and GL40200. If you then delete records out of the GL00100 table Check Links will rebuild the GL00105 and GL40200. Now you should not be deleting any records out of the GL00100 table if any transactions have been posted to those accounts. Make a backup before you do anything or better yet have a test company until you are sure you have achieved the desired results.

  • Community Member Profile Picture
    Community Member on at

    Thanks, Richard!  I did delete one account out of the GL00100 and then out of the GL00105. When I run "check links," I get an error message that says acctindx  xxxxxx needs to be recreated. How do I resolve so that I do not get that error message in the future

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans