Search This Blog

Friday, September 10, 2010

MS GP: How to fix an error in a receivables inquiry window for a particular user?

User1 gets an error: The stored procedure rmTransactionInquery returned the following result: DBMS: 515, Microsoft Dynamics GP:0 when opening an inquery window for a customer.

Run the following script against a company database to compare view types:

SELECT * from MC40500 where SERIES = 3 and USERID = 'user1'
SELECT * from MC40500 where SERIES = 3 and USERID = 'user2'

If the type is different:

UPDATE MC40500 set viewtype='3' where SERIES = 3 and USERID = 'user1'

Note:
VIEWTYPE' values:
FUNCTIONAL = 3 ORIGINATING = 4 REPORTING = 5

MS GP: How to unlock a user in SQL?


Go to SQL Managemnt Studio -> Security -> User -> Properties -> Status
Uncheck lock box