RMA Reason Codes

(1) Share

Report

Posted on by Katie Pieczynski

3,225

We are using the reason codes when creating returns. I have created a smartlist for our CSR's to pull up all returns and I would like to have the reason code on the smartlist but I can not seem to find what table it pulls from. Can someone help me please?

Thank you,

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: RMA Reason Codes

Try the SOP10106. That's where our return reason codes are stored

Was this reply helpful? Yes No
Kody Kiefer 5 on at

Like (0)

Report

RE: RMA Reason Codes

Hi Katie,

Have you ever received an answer on how to do a SmartList Builder to get reason codes? We are having the same issue. Thanks.

Was this reply helpful? Yes No
tcxgarcia 105 on at

Like (0)

Report

RE: RMA Reason Codes

Hi all. I have the same situation here. I did some research on it and cannot find a solution.

First things first: When you create a Return via the menu command in the SOP Entry window, you are using RMA functionality that is being leveraged from the Field Service module. However, this functionality is not being used completely (unless you really use the FS module - more on this later). My research (until proven wrong here) points to the fact that the reason code entered is not being stored anywhere is the system, as incredible as it may seem. I ran a SQL trace during the creation of the return and the SVC05502 table is summoned only for the Return Code selection process, but nothing else, as it is a master table. The SVC05000 is simply not used at all so the return is not really "recorded" in the Field Service module.

The customer I was testing this for does not have the Extended Pack in GP2013. You need extended pack to be able to use Field Service. I then tested this on a demo environment with the Extended Pack and the behavior of the "Create Return" window opened from SOP is very telling: By default, the "RMA Type" field is enabled and "Create RMA" checkbox is checked. If you uncheck the "Create RMA" checkbox the system will disable BOTH the "RMA Type" and the "Reason Code" Field. To me, this means that the intention is that if you do not create an RMA in field service (which I don't want to) then you cannot use the Reason codes. For some reason the development team left the Reason Code field enabled when not registered for Field Service.

If anyone has another idea, I welcome it. In the meantime, I am going to "force" the issue by taking the selected Reason code and populating one of the sales user defined fields via some programming.

Regards,

Thomas.

Was this reply helpful? Yes No
Katie Pieczynski 3,225 on at

Like (0)

Report

RE: RMA Reason Codes

Hi Richard,

I see that the SVC table is in the Field Service Series which I do not show when I am creating a smartlist out of smartlist builder........would you happen to know why?

Thank you,

Katie

Was this reply helpful? Yes No
Katie Pieczynski 3,225 on at

Like (0)

Report

RE: RMA Reason Codes

Maybe I am using RMA??? I am not sure but I do have the option for a reason code.

When I am in Sales transaction I can go to additional < create return < and when I fill that out it gives me the options to put in reason codes.

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

RE: RMA Reason Codes

Or a third party product? Or modified code?

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

RE: RMA Reason Codes

OOOOOH!!!! RMA Reason code Yell Field Service to me. Sorry!

Out of the box GP SOP does NOT have reason codes. Do you perhaps have an Extender Window for these? Or are you using one of the User Defined fields to pick from a list (and re-label it Reason Code)?

Was this reply helpful? Yes No
Katie Pieczynski 3,225 on at

Like (0)

Report

RE: RMA Reason Codes

I am using the Sales order processing module.

Thank you,

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,615 Super User 2025 Season 2 on at

Like (0)

Report

RE: RMA Reason Codes

Katie, are you creating Returns in the Returns Management module or in the Sales Order Processing module?

Was this reply helpful? Yes No
Katie Pieczynski 3,225 on at

Like (0)

Report

RE: RMA Reason Codes

I am having trouble finding those fields or the table. Do you happen to know the display name?

Was this reply helpful? Yes No