Microsoft Dynamics GP (Archived)

SOP Next Number was changed to the same next number as another document id, no user intervention

(0) Share

Report

Posted on by HRF

470

Hi,

I'm not sure how to phrase this question but I hope you guys can assist me.

We have two document ids for Return. One is Credit and other is RA for return authorization. They both have their own running number. RA has a prefix and then the next number while the credit only have numbers. Today, the next number for the RA changed to the same next number as the Credit. I checked the table SOP40200 and the modified date for both Credit and RA is 2012. So not sure how to troubleshoot this. When we do RA, we do it from Sales Transaction entry from Additional >> Create Return so we cannot change the number because it's coming from SOP Setup. I was trying to recreate it but no success.

I am new here and I don't know if there are triggers or anything that might be doing this. Have any of you experience this? Please advise.

Thanks.

*This post is locked for comments

All responses (2)

Answers (0)

HRF 470 on at

Like (0)

Report

RE: SOP Next Number was changed to the same next number as another document id, no user intervention

Thank you for your response Mahmoud.

You are correct the other return type is from Sales Order Processing. OK I will check that. I also checked the SOP40200 for when it was last updates and it's last 2013. So I'm not sure how this is happening.

There has been some weird things happening as well in our posting setup as it is also changing without users updating it. I was trying to use Activity tracking but its not getting any updates on Posting setup. Do you have any suggestion on how this can be traced? Thanks!
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: SOP Next Number was changed to the same next number as another document id, no user intervention

There is a tiny part that I would like to be clear about in your inquiry, you said you have to documents IDs for return, one is credit and the other is RA.

The RA apparently is one reached through "Additional > Create Return". As for the first one, is it the usual "Return" document type checked on the sales transaction entry window ?

As for the RA, you need to check the setup from (Microsoft Dynamics GP > Tools > Setup > Field Service > Return Setup) Click on the "Return" button, and you will find the next number setup for RMA Entry. The RMA setup is stored in (SVC00999) under field (RETDOCID)

As for the return of the sales transaction entry, it is stored under SOP40200 which you already mentioned.

I have tried different possible scenarios to change the RMA entry number but in vain. Check any possible triggers by considering the following select statement,

SELECT * FROM SYS.ALL_OBJECTS WHERE type_desc LIKE '%trigger%'

Never hesitate to share any further inquiries,