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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / DocID's get switch...
Finance | Project Operations, Human Resources, ...
Unanswered

DocID's get switched in SOP40200

(0) ShareShare
ReportReport
Posted on by Jason Lukens 5

Has anyone ever experienced the 'SOPNUMBE' getting changed in the SOP40200 table when transferring to an Invoice?  The SOP40200 table looks like this before hand:

DOCID SOPTYPE SOPNUMBE
STDINV          3 STDINV0278085        
STDBK           5 STDBK0000001         
STDORD          2 STDORD825443         
RENORD          2 RENORD2297505        
RENEWAL         1 RENI701527           
STDRET          4 STDRET0026724        
STDORDW         2 STDORDW825424        
RTVORD          2 RTVORD825400         
TRNORD          2 TRNORD825352         
TRNORDW         2 TRNORDW791873        

Then somehow behind the scenes the table gets changed to:

DOCID SOPTYPE SOPNUMBE
STDINV          3 RENORD2297438        
STDBK           5 STDBK0000001         
STDORD          2 STDORD825443         
RENORD          2 RENORD2297430        
RENEWAL         1 RENI701527           
STDRET          4 STDRET0026722        
STDORDW         2 STDORDW825424        
RTVORD          2 RTVORD825400         
TRNORD          2 TRNORD825352         
TRNORDW         2 TRNORDW791873        

This has happened 3 times so far this year.  Once early March, then twice in the last week.  I've added a trigger to try and capture when this is happening and by what process, but it hasn't happened since I put it in place.

Has anyone ever seen this before?

Thanks! 

Categories:
Microsoft Dynamics GP
  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Jason,

    I have only seen this when there are customizations in place. Never on an out-of-the-box GP installation. Do you have any customizations/modifications around your SOP transactions? If so, that would be the first place to look.

    Unfortunately, when it's sporadic and you can't force it to happen, it's extremely difficult to track down. We've tried similar things in the past with triggers, but even knowing what user caused it to happen and when, there was nothing we were able to figure out specifically as to what they did or what they could do differently.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 495 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 432 Super User 2026 Season 2

#3
CU10121822-0 Profile Picture

CU10121822-0 366

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans