Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Product version error ...
Finance | Project Operations, Human Resources, ...
Answered

Product version error in Fixed Assets Module

(0) ShareShare
ReportReport
Posted on by Jozy 385

Dear All,

When I trying to install Fixed Assets module in Dynamics GP 2016 R2 It occur product version error and I check GP_LoginErros_logs file It showing below detail:

Product Name: Fixed Assets Database Version: 140524 Client Version: 160802
Product Name: Analytical Accounting Database Version: 9030 Client Version: 160705
Product Name: Grant Management Database Version: 90116 Client Version: 160552
Product Name: Fixed Assets Database Version: 140524 Client Version: 160802
Product Name: Analytical Accounting Database Version: 9030 Client Version: 160705
Product Name: Grant Management Database Version: 90116 Client Version: 160552

Any help would be appreciated.

Thanks

Categories:
Microsoft Dynamics GP
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Product version error in Fixed Assets Module

    Hopefully you have been able to upgrade successfully.

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Product version error in Fixed Assets Module

    Thank you Richard for your kind help.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Product version error in Fixed Assets Module

    Did you reset all your databases back to prior to the upgrade? This will allow you to completely start over. After it upgrades the DYNAMICS database you will be presented with a list of company databases. Unselect the GC company.

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Product version error in Fixed Assets Module

    I tried this but all company up gradation is necessary for login GP . otherwise it does not allow me to login

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Product version error in Fixed Assets Module

    Put GM back. When you run GP Utilities unclick GC as a company to upgrade. It will upgrade all the others.

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Product version error in Fixed Assets Module

    Yes, but when I added grant management I can not log in other company as well. There was some grant management table exist in GC database and they do not allow me to install fixed assets due to product error so I drop all the GM table from GC and install fixed assets successfully without GM and GM is not exist in DYNAMICS.SET file as well.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Product version error in Fixed Assets Module

    How can that be? You said you added it and the other companies were fine. Do you see it in your DYNAMICS.SET file?

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Product version error in Fixed Assets Module

    Grand Management is not exist in product list.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Product version error in Fixed Assets Module

    I would log into any company and go to Microsoft Dynamics->Maintenance->SQL -> choose GC as your database and Grant Management as the product. Mark everything and then click Drop Auto Procedure and Create Auto Procedure and then click Process. This will rebuild all the Grant Management stored procedures. You may need to do this on the old GP before upgrading but try it first on the new GP.

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Product version error in Fixed Assets Module

    Hi Richard,

    Now I am able to install FA but without Grand Management when I add GM and run the GP utilities it occur below error only in GC compnay.

    The following SQL statement produced an error:

    CREATE PROC dbo.zDP_GTM20002VF_1 (@aaBudgetID_RS int, @YEAR1_RS smallint, @aaFiscalPeriod_RS smallint, @aaBudgetID_RE int, @YEAR1_RE smallint, @aaFiscalPeriod_RE smallint) AS  set nocount on IF @aaBudgetID_RS IS NULL BEGIN SELECT TOP 25  aaBudgetID, aaBudget, YEAR1, aaFiscalPeriod, aaTrxDim, aaTrxDimCode, STRTDATE, ENDDATE, Balance, PERIODDT, DEX_ROW_ID FROM .GTM20002V ORDER BY aaBudgetID ASC, YEAR1 ASC, aaFiscalPeriod ASC END ELSE IF @aaBudgetID_RS = @aaBudgetID_RE BEGIN SELECT TOP 25  aaBudgetID, aaBudget, YEAR1, aaFiscalPeriod, aaTrxDim, aaTrxDimCode, STRTDATE, ENDDATE, Balance, PERIODDT, DEX_ROW_ID FROM .GTM20002V WHERE aaBudgetID = @aaBudgetID_RS AND YEAR1 BETWEEN @YEAR1_RS AND @YEAR1_RE AND aaFiscalPeriod BETWEEN @aaFiscalPeriod_RS AND @aaFiscalPeriod_RE ORDER BY aaBudgetID ASC, YEAR1 ASC, aaFiscalPeriod ASC END ELSE BEGIN SELECT TOP 25  aaBudgetID, aaBudget, YEAR1, aaFiscalPeriod, aaTrxDim, aaTrxDimCode, STRTDATE, ENDDATE, Balance, PERIODDT, DEX_ROW_ID FROM .GTM20002V WHERE aaBudgetID BETWEEN @aaBudgetID_RS AND @aaBudgetID_RE AND YEAR1 BETWEEN @YEAR1_RS AND @YEAR1_RE AND aaFiscalPeriod BETWEEN @aaFiscalPeriod_RS AND @aaFiscalPeriod_RE ORDER BY aaBudgetID ASC, YEAR1 ASC, aaFiscalPeriod ASC END set nocount

    "ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'PERIODDT'."

    Thanks

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans