Announcements
No record found.
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 ReturnThen that button for Reason CodeThanks.
*This post is locked for comments
Hi Rinno
The table you are looking for is the SVC05502
SVC_RMA_Reason_Code
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.
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.
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
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.
Thanks for the update Rinno.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
