Open Forum

Expand all | Collapse all

get/change error on a not currently used company - GP2015 R2

  • 1.  get/change error on a not currently used company - GP2015 R2

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hello Everybody,

    We have an old GP company (empty dbase) that I was going to open up for use (testing and potentially using) - -

    When I login as sa I see the attached error message.
    Curious to know what it means? And possibly how to correct.

    If it's not worth correcting we'll ask that a new company be setup for our needs.

    Kind regards,
    Maria.


    ------------------------------
    Maria Frandzeskakis
    IT Manager
    MIP Inc.
    Anjou QC
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: get/change error on a not currently used company - GP2015 R2

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hi Maria -

    A quick google search indicates the particular table is from Collections Management.   Do you know if you were using Collections Management at one time?

    ------------------------------
    Sean Reynolds
    IT Accounting Manager & MS Dynamics GP System Administrator
    MIC Global Services
    Plano TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: get/change error on a not currently used company - GP2015 R2

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hi Maria,

    The 2 errors below indicates that GP is not able to find the autoprocedure / SQL table:
    • could not find stored procedure zzz.dbo.zdp_cn04000L_1
    • invalid object name CN04000
    As per Sean's suggestion, you would want to check if you are currently using Collections Management (or was using it before)...
    ... and if you are actually to use it for this company...

    Also, when does the error come in? Immediately after logging in to GP? There might be an item in your "Startup" folder (in the left menu / Navigation pane)...

    At any rate, an option that can be taken would be to use SQL Maintenance* and have it recreate the table and autoprocs (below is a screenshot):
    * that's assuming you can find it listed there / I don't have Collections Management installed
    * CN04000 // Collections - Days Sales Log


    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: get/change error on a not currently used company - GP2015 R2

    GPUG ALL STAR
    Posted 12 days ago
    Looks like you have installed Collections into your system, but not performed the install on that company, so the tables and other SQL objects are missing.

    You might need to contact Professional Advantage for support on installing Collections.

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: get/change error on a not currently used company - GP2015 R2

    TOP CONTRIBUTOR
    Posted 12 days ago
    Hello @Sean Reynolds, @Ryan Galang, and @David Musgrave,

    Yes - we do have Collections Management - -
    And the error was occurring at login.

    I was able to ​​​find the Installation and Registration window and create the necessary tables and stored procedures.

    I believe this has solved my issue.

    Thank you all very much !!
    Have a terrific weekend.
    Maria.

    ------------------------------
    Maria Frandzeskakis
    IT Manager
    MIP Inc.
    Anjou QC
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role