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
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
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.
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
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.
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 ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156