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

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) / Update of GL10110 and ...
Microsoft Dynamics GP (Archived)

Update of GL10110 and GL10111 failed in GP10 to GP2010 Update

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

When we updated from GP10 to GP2010 the tables GL10110 and GL10111 failed the update to the point that when I look at them, there are no correct values in the Actnumber_1, 2,3,4 columns, but the Dollar Values and the ACTINDX seem to be intacted.

Can some one provide me with a script that would look at the GL00100 and populate the GL10110 and GL10111 with thecorrect ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3 values based on the Join of the two tables on the ACTINDX.

I know what I need / want, and I could do it for each ACTINDX one at a time, but I dont have the understanding of how to do that for each line of the two tables.

The GL10111 has some 35,000 records, while the GL10110 has some 3000 records.  Not something to do by hand.

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    What versions of GP 10 and GP 2010 are you using? I ran into the same issue. I needed to upgrade to GP 2010 RTM first and then the rest of the way.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    I had to - for Payroll - update to the 11.00.2292 Version of the GP2010.

    I dont think there is a way to go back and update short of that version due to the need for the Payroll Year end feature.  Plus the Payroll - which converted just perfect has been processed and the Payables, which converted perfectly have been updated, the issue here or at least now, is that when they try to print a Trial Balance it is blank - due to the Actnmbr_x fields are blank in the GL10110 and GL10111 table.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Am I confused or did I miss something here.  When I go back to the V10 database (old server) and look at the table GL10110 there are no values in the ACTNMBR_x fields and there is a value in the ACCATNUM.

    I am comparing the two tables in both versions and they have exactly the same data in them, except that GP2010 table has the LEDGER_ID column.

    So my request to add data does not make sense anymore.

    I was thinking that somewhere in the conversion the data in ACTNMBR_x fields were all deleted / dropped and that somehow the value was stuffed in ACCATNUM - not the case.

    So, I have tried the following solution.

    I have DROPPED and CREATED the GL10111 and GL10110 in the GP2010 database

    I have used the following script to insert the data back into the GL10110 - the GL10110_backup was made during the conversion when it failed on the update and it contained data.

    /*

    begin transaction

    INSERT INTO [HFLTD].[dbo].[GL10111]

              ([ACTINDX]

              ,[YEAR1]

              ,[PERIODID]

              ,[PERDBLNC]

              ,[ACTNUMBR_1]

              ,[ACTNUMBR_2]

              ,[ACTNUMBR_3]

              ,[ACCATNUM]

              ,[CRDTAMNT]

              ,[DEBITAMT]

              ,[DEX_ROW_ID])

    SELECT [ACTINDX]

         ,[YEAR1]

         ,[PERIODID]

         ,[PERDBLNC]

         ,[ACTNUMBR_1]

         ,[ACTNUMBR_2]

         ,[ACTNUMBR_3]

         ,[ACCATNUM]

         ,[CRDTAMNT]

         ,[DEBITAMT]

         ,[DEX_ROW_ID]

     FROM [HFLTD].[dbo].[gl10111_backup]

    This failed first time so I dropped the DEX_ROW_ID from both sides and all imported without error.  The two tables are now the same.

    I then went in and set the LEDGER_ID to = 1 which is what it is set to in the TWO database which works at this time.

    I think I have to be on the right path, but, I am not sure where I am falling short on this one.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    To add to the confusion - when I look at the Finanical >> Cards >> Account >> Summary for a specific account there is data.  However, now when I run the Trial balance for the same account it is blank.

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

    The update process would be GP 10 to GP2010 RTM and then from GP 2010 RTM to GP 2010.00.2292. You just have to do the upgrade in two hops. This is the exact same issue I had run into when I did it. Hopefully you are in a test environment and can start over.

  • Derek Albaugh Profile Picture
    Derek Albaugh Microsoft Employee on at

    Hello Bill,

    I didn't see what build of Dynamics GP 10.0 that you're upgrading from, to Dynamics GP 2010, so I can't state what options you have going to Dynamics GP 2010 as in what build.

    If you haven't already done so, there is a 'Updating to Microsoft Dynamics GP 2010' hot topic on CustomerSource that gives you those options and other important information regarding the upgrade.

    As for the GL10110 and GL10111 tables, normally when we see these tables fail, it is because their structure is incorrect. These two tables, among about 30 others, get setup with a specific number of columns to correspond with the account framework you have setup for Dynamics GP.

    For example, if your account framework is setup to have 7 segments with a length of 5 per segment, in these two tables, you should see the columns ACTNUMBR_1 through ACTNUMBR_7, with each of these 7 columns having a length of 5.

    Your account framework information is held in the SY003001 and SY00302 tables in the DYNAMICS system database.

    There is a Account_Framework_Validation script in the 'Known Issues' section of the Dynamics GP 2010 upgrade guide that you also may want to run. This script specifically checks the GL10110, GL10111, GL70500 and GL70501 tables for the account framework setup, in all companies you have listed in the SY01500 table. If everything is correct, no records should be returned.

    The ACTNUMBR_# columns hold the account number information so, while you may have 7 segments available, as per this example, the account numbers being used in the actual company database may not be using all 7 segments, so you may only see data in the first 3 or 4 columns, depending. This information is held in the SY00300 table for each company database. It tells what segments are being used for account numbers in that database.

    Let us know if you have any further questions regarding the upgrade to Dynamics GP 2010.

    Thank you,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans