web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP Next Number was ch...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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,

  • HRF Profile Picture
    HRF 470 on at

    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!

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans