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) / Master number in sopentry
Microsoft Dynamics GP (Archived)

Master number in sopentry

(0) ShareShare
ReportReport
Posted on by Lavanya Manimuthu 340

When GP sales order is created via econnect it automatically takes the next master number. 

Is it possible to specify a master number explicitly in the xml schema , so that a GP sales order is created with specified master number.

Please help me.

*This post is locked for comments

I have the same question (0)
  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at

    Lavan,

           Next Master number is taken from SOP set up (table SOP40100). I don't know why you want change this number?

    If you want to cange the master number,go SOP set up and change the next master number. I think it is not possible to specify a master number explicitly in the xml schema.  

    Regards

    Jeganeedhi

  • Lavanya Manimuthu Profile Picture
    Lavanya Manimuthu 340 on at

    Actually i have created a sale sorder ORD2247 in GP which has the master number 560(Eg)

    I am trying to create a Fulfilment order FULORD5567 through econnect for ORD2247. At this point the next master number 561 is used for FULORD5567. But i want 560 to be the master number for FULORD5567.

    Help me for this scenario.

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at

    Lavan,

        I am not wrong, You are going to transfer the Order to Fulfilment order.

    I think you have used the taSopHdrIvcInsert schema(eConnect not contain any separate schema for SOP transfer).

    If you used this schema , MSTRNUMB element is available for the Master Number.

    Regards

    Jeganeedhi

  • Lavanya Manimuthu Profile Picture
    Lavanya Manimuthu 340 on at

    Yes, I am trying to pass master number explicitly for <MSTRNUMB> node of taSopHdrIvcInsert schema.

    The scenario is to create a FO using Econnect :

    Order number ORDST2227 with master number: 560

    The FO must be created such that the orignumb as ORD2227 and mstrnumb as 560.

    <ORIGNUMB>ORD2227</ORIGNUMB> is of no issue.

    Problem is with MSTRNUMB.-  I could not explicitly assign, it automatically takes the next number 561.

    How can i achieve this using Econnect?

     

  • Community Member Profile Picture
    Community Member on at

    I'm facing the same issue... can you please share the idea on how it is resolved?

     Are you able to restrict the new master number creation?

    Thanks in advance.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    The Master Number is a unique, unchanging number assigned to a sales TRANSACTION.  Each and every document in the transaction has the same master number.  Sales order documents in transactions are linked in several manners, one of which is the Master Number.  There is also the originating document number chain to consider.

    Creating a new document with the same Master Number as another document assumes you are transferring the transaction from the original document to the new document.  You need to update the line items of the original document to show them transferred (ordered, invoiced, backordered, etc), reduce the remaining open order amount in the header of the original, move items to history, et cetera, et cetera, et cetera.

    Why not just transfer the document using GP Code?

    PS  You CANNOT create a NEW transaction with the same master number.  And, you are asking for problems if you have multiple master number ranges when the ranges eventually overlap.

     

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Richard is correct! The master number was clearly designed to be an application internal control number to chain a complete SOP Transaction flow, this is, from a quote, all the way to an invoice, excluding returns (you cannot link a return to a sales invoice, hence returns have their own master numbers). I actually don't even understand why it is exposed to the interface or why users are allowed to modify it. It should be an internal system control.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    I print the master number on all sales transactions.  It allows a user researching an issue to have a starting point that will expose the entire transaction rather than looking at an invoice and then the next document and then the next one and the next one........(shades of National Treasure!)

  • Community Member Profile Picture
    Community Member on at

    The scenario is to create a FO using Econnect.

    I am trying to pass master number explicitly for <MSTRNUMB> node of taSopHdrIvcInsert schema, with the master number value of its order, which is throwing error.

    Problem is with MSTRNUMB.-  I could not explicitly assign.

    Removal of this node creates a new master number.

    How can i achieve this using Econnect?

  • Community Member Profile Picture
    Community Member on at

    Whats an 'FO'.

    Consider the following: Will the master number not default? Why not just accept the default? If its a new transaction then you get a new Master Number, if its an existing transaction being modified / updated / moved along, then the existing master number will default and should be used. Either way, you don't need to worry about it. You should not be trying to interfere with this field (even if it looks like eConnect lets you).

    With the above in mind, do you still have a problem? or have I missed something?

    Best regards,

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