Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

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

Posted on by 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

  • HRF Profile Picture
    HRF 470 on at
    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 Profile Picture
    Mahmoud Saadi 32,738 on at
    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,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans