Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

PSTL Item number modifier - error invalid object name IVR10015.location

Posted on by 890

When using the Professional Service Tools - Item Number Modifier I get an "invalid object name IVR10015.location" error. Can anyone give me some tips on how/ where to troubleshoot. 

Thank you

*This post is locked for comments

  • martink Profile Picture
    martink 890 on at
    RE: PSTL Item number modifier - error invalid object name IVR10015.location

    Thank you for the suggestions, although they didn't work.  What I did was create the new part number with minimum requires data, then Used PSTL Item Number Combiner instead of Modifier. That worked, some data didn't transfer to the new item number but we were able to manually add it. All good now.

  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: PSTL Item number modifier - error invalid object name IVR10015.location

    Hi Martin!

    I have tried to research that error however I am not showing anything in our internal database on the error. Do you have any third parties installed? The table could be a third party table as I am not able to find much on it.

    I would try disabling all third parties to see if this resolves the issue. If it does I would enable each third party one at a time to see if you can replicate the issue.

    **Any testing of troubleshooting steps in a test company prior to a live company to verify the results.

    871973 Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, or SQL Server 2012

    support.microsoft.com/.../en-US

    **Create a backup of the live database prior to running any troubleshooting steps on the live company.

    872087 Steps to disable third-party products or temporarily disable additional products in the Dynamics.set file in Microsoft Dynamics GP

    support.microsoft.com/.../en-US

    Please let me know if this helps!

    ~Thomas Newcomb

    ------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • martink Profile Picture
    martink 890 on at
    RE: PSTL Item number modifier - error invalid object name IVR10015.location

    Yes I am trying to rename an item number.  Yes I know the table name is locncode but the error says 'IVR10015.location' The value that is in the IVR10015.locncode looks correct.

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: PSTL Item number modifier - error invalid object name IVR10015.location

    Hi Martin,

    Are you trying to rename an Item ? the IV10015 table is one element of the Manufacturing BOM tables.. There is a field LOCNCODE, but no LOCATION..  Have you tried to re-install the PSTL for that company ?

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans