Microsoft Dynamics GP (Archived)

GP 2016 - Extended Price Error

(0) Share

Report

Posted on by SteveWhyte

583

I am trying to enable the Extended pricing under Sales – Setup – Extended Pricing and get the error below:

[Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid Object Name: 'RTW_PRICELIST_DELETE'

Any suggestion on how to handle this?

*This post is locked for comments

All responses (4)

Answers (0)

Tim Wappat 5,703 on at

Like (0)

Report

RE: GP 2016 - Extended Price Error

Interesting. If you open up a few of the stored procedures, are there any comments in there or clues in the tables they interact with, as to what they belong to.

I simply am not familiar with whatever module uses RTW so I'm reaching the end of my usefulness.

I still think you have a module or 3rd party product with a corrupt installation that needs fixing up before you can move forward.

Tim.
Rennecia Barran on at

Like (0)

Report

RE: GP 2016 - Extended Price Error

Hi Tim,

I am seeing a lot of Stored Procedures with the RTW in it. What is RTW?
Tim Wappat 5,703 on at

Like (0)

Report

RE: GP 2016 - Extended Price Error

I am guessing there is a GP addin or modification by RTW involved here, or someone has added a database hack?

Have you any 3rd party products installed, or could have had something installed in the past?

Curious to know what results you get it if you run the following SQL against the company database which should look for any objects named RTW.

select object_name(object_id) as object_name,definition

from sys.sql_modules

where definition like '%RTW%'

Does it find any RTW_ named objects?

You could also look for the call for this object and see where is it by searching the DB- it might not be there, it might be in code.

SELECT DISTINCT

o.name AS Object_Name,o.type_desc

FROM sys.sql_modules m

INNER JOIN sys.objects o ON m.object_id=o.object_id

WHERE m.definition Like '%RTW[_]PRICELIST[_]DELETE%'

ORDER BY 2,1

Tim
Rennecia Barran on at

Like (0)

Report

RE: GP 2016 - Extended Price Error

Did you get this resolved?