SQL Table for RMA Reason Code Lookup

(0) Share

Report

Posted on by Rinno Ray

Hi,

Anyone knows the table where the Reason Code Values are being stored?

We're trying to create a return from Sales Transaction Entry > Additional > Create Return

Then that button for Reason Code

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

twelvestrikes 3,657 on at

Like (0)

Report

RE: SQL Table for RMA Reason Code Lookup

Hi Rinno

The table you are looking for is the SVC05502

SVC_RMA_Reason_Code

Was this reply helpful? Yes No
Rinno Ray 75 on at

Like (0)

Report

RE: SQL Table for RMA Reason Code Lookup

Thanks Jefferey. Once I create a return, would you know if there's a table that links the reason code to SOPNUMBER?

basically what we want to achieve is create a smartlist or SSRS report that will show the reason code of the return.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SQL Table for RMA Reason Code Lookup

Hi Rinno,

Were you able to create the SmartList showing the Returns with Reason Code.

I could not find any column in the SOP tables for the reason code so as per my understanding there is no advantage of using the reason code in returns and having the data available in table SVC05502.

It seems the developers created a table SVC05000 for this purpose, however, could not complete their work as the table has no records.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: SQL Table for RMA Reason Code Lookup

or maybe these tables are used by some other modules such as Field service or Return management which does not come out of the box with GP. Technically, Microsoft should not have the reason code box available to the user if the user does not have the corresponding module

Was this reply helpful? Yes No
Rinno Ray 75 on at

Like (0)

Report

RE: SQL Table for RMA Reason Code Lookup

Thanks Zafar. We didn't have a resolution and we just ended up abandoning the project. I checked with a consultant and they verified the table is empty. Seems like it's being saved on a temp table or something.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SQL Table for RMA Reason Code Lookup

Thanks for the update Rinno.

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: SQL Table for RMA Reason Code Lookup

For anyone still looking for the table , can get values from fields from below table

select SVC_RMA_Reason_Code, SVC_RMA_Reason_Code_Desc,* from SVC05000

Was this reply helpful? Yes No