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) / Product 309 does not s...
Microsoft Dynamics GP (Archived)

Product 309 does not support upgrading from version 8.0.0.

(0) ShareShare
ReportReport
Posted on by Angel Cintron Morales 50

   Hello, I make a upgrade  from GP 9.0 SP4 to Dynamics GP 2010 SP2 then applied the following features, Analitical Accounting, Encumbrace, Fixed Asset and Safe Pay.  When run utilities show then following message upgrade failed go to duinstall.log. then got to duinstall.log the error is Product 309 does not support upgrading from version 8.0.0. when remove the Fixed Asset feature utilities run fine.

  I need install the Fixed Asset feature, if someone know something about this problem please write me.

*This post is locked for comments

I have the same question (0)
  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    HI Angel,

    If you need to upgrade 309/Fixed Assets and keep the data for that module you have to restore the databases back to GP 9 SP4 and then upgrade Fixed Assets (I would guess it was not installed during this upgrade). Otherwise if you do not need the FA data you can use the following scripts to reinstall the module:

    1. UPDATE DYNAMICS..DB_Upgrade SET db_verOldMajor=0, db_verOldMinor=0, db_verOldBuild=0, db_status=0 WHERE PRODID=309 and db_name = 'xxx'

    2. Delete DYNAMICS..DU000020 WHERE PRODID=309 and companyid = 'x'

    3. Run the following scripts against the company database:

    A. Drop table FA41000

    B. Drop table FA00200

    C. Drop table FAINST01

    You can find the db_name and companyid in the SY01500 table.

    Let me know if you have any other questions.

    Thanks,

    Jonathan

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

    Thank you so much Jonathan.

    In my case I needed this to be applied to all entities.

    I made use of your path to peace of mind.

    In addition I replaced the DDLs with the below:-

    For A

    SELECT 'Drop table '+rtrim(INTERID)+'.dbo.FA41000'

    from sy01500

    Used the resulting SQL and ran the SQL.


    For B

        SELECT 'Drop table '+rtrim(INTERID)+'.dbo.FA41000'
        from    sy01500
        Used the resulting SQL and ran that SQL.

     

    For C

        SELECT 'Drop table '+rtrim(INTERID)+'.dbo.FAINST01'
        from    sy01500  

    Used ths resulting SQL and ran that SQL.

     

    Thank you so much for the help.

    Regards

     

    Ven

     

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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