Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP Entry duplicate Ma...
Microsoft Dynamics GP (Archived)

SOP Entry duplicate Master number

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

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.

Thanks

*This post is locked for comments

  • William914 Profile Picture
    William914 5 on at
    RE: SOP Entry duplicate Master number

    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

  • Steve Gray Profile Picture
    Steve Gray 25 on at
    RE: SOP Entry duplicate Master number

    I encountered this today, this is the answer that I came up with

    dynDeveloper.com/.../0WX0

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP Entry duplicate Master number

    Hi all,

    Thanks for you replies.

     

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: SOP Entry duplicate Master number

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP Entry duplicate Master number

    Hi All,

    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.

    Thanks!

    Bindu.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: SOP Entry duplicate Master number

    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 . . .

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: SOP Entry duplicate Master number

    Another more supported suggestion is the SPROC in your Company Database:

    sopGetMasterNumber @O_iOUTMasterNumber int, @O_iOUTErrorState int

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: SOP Entry duplicate Master number

    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.

    Tim

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans