Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I am facing the issue with the SOP duplicate document number in GP 2010.When i create an new order the master number is duplicated.I created a stored proc to get the next available master number, but my issue is I don't when and where to call this stored procedure to get the available master number and adding new order to the available number.
Please suggest me on this issue.where to call the stored procedure to get the available master numbers in SOP Entry.
This is NOT SUPPORTED. This is what I use when I must:
DECLARE @NXTMSTNO int
SELECT @NXTMSTNO=NXTMSTNO FROM SOP40100 WHERE DEX_ROW_ID=1
UPDATE SOP40100 SET NXTMSTNO=NXTMSTNO+1 WHERE DEX_ROW_ID=1
This should be done only when others are not in Sales Transaction Entry and not SOP Integration is being done.
Another more supported suggestion is the SPROC in your Company Database:
sopGetMasterNumber @O_iOUTMasterNumber int, @O_iOUTErrorState int
While I know Tim is providing good advice, when ever you do something in the system where the outcome is in question, be sure that you have a good backup prior.
I can not tell you how many times a backup has saved us, when we are certain that nothing could go wrong with what we are doing in SQL.
Just poking my nose in . . .
Thanks for you response.
Actually I am automating the workflows for the GP.In Automation i want to trigger the storedproc to get the master number. My issue is when I need to call this storedproc and how to trigger this.
Please help me out in this.
I am sorry but I don't exactly understand your question, it's your workflow, you know you have to create sales document, then how can anyone of us tell you when to call stored procedure.
Thanks for you replies.
I encountered this today, this is the answer that I came up with
I know Tim is providing good advice, when ever you do something in the system where the outcome is in question, be sure that you have a good backup prior.
I can not tell you how many times a backup has saved us, when we are certain that nothing could go wrong with what we are doing in SQL. My Fed Loan
Business Applications communities