We are on GP 2010 SP3 and we use Manufacturing. I'm having some difficulty using the Item Number Combiner and Modifier. The item numbers I'm trying to change are not in BOMs and are buy items in the Engineering Item Data. When I try to use the combiner, I receive an error message:
[Microsoft] [SQL Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'on'.
When I click OK, I get this message:
The stored procedure TACalltemCombine returned the follwoign results: DBMS: 156, Microsoft Dynamics GP: 0.
I tried some of the other tools to make sure the rest of them were working, and I'm only getting this type of message when I use the Inventory Item Number Combiner and Modifier.
Any ideas/suggestions on why this is happening and how to fix it?
*This post is locked for comments