Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales Transaction Entr...
Microsoft Dynamics GP (Archived)

Sales Transaction Entry - Order

(0) ShareShare
ReportReport
Posted on by rcurry 210

Can anyone explain (or point me to a resource) that explains the relationship of the 4 fields marked in the picture below?  What I am particularly wondering is:

  1. Do I have the correct fields from SOP10200?
  2. What auto calculations after the document is submitted (and can this be avoided)?

I think these are the correct fields (although I could be wrong):

  1. Qty Ordered: QUANTITY (I am suspicious of this)
  2. Qty to Deliver: ATYALLOC (I am suspicious of this)
  3. Qty Fulfilled: QTYFULFI (confident)
  4. Qty to Back Order: QTYTBAOR (confident)
I am new to GP.  I am trying to use eConnect to update a document using taSopLineIvcInsert_ItemsTaSopLineIvcInsert 
Here is the reason I am asking:  I have some C# code that loops through the LNITMSEQs.  Let's hypothetically use a scenario where we have 2 LNITMSEQs
16384
Qty Ordered: 1
Qty to Deliver: 0
Qty Fulfilled: 0
Qty to Back Order: 1
32768
Qty Ordered: 2
Qty to Deliver: 0
Qty Fulfilled: 0
Qty to Back Order: 2
If I want to fulfill the 1 back ordered of the 16384 line, I add 1 to 'Qty Fulfilled' and subtract 1 from 'Qty to Back Order'.  This is the result I get:
16384
Qty Ordered: 1
Qty to Deliver: 1 ==> Not sure how this was populated
Qty Fulfilled: 1
Qty to Back Order: 0
I think that result is correct, but I want to understand it.
I am pretty sure I have some bad logic in my code that causes the 2nd LNITMSEQ (32768) to populate wrong.  I say that because, even though I have not tried to edit this line), 32768 results with the following:
32768
Qty Ordered: 4 ==> this went from 2 to 4? How?  I have no logic adding/increasing QUANTITY
Qty to Deliver: 2 ==> this went from 1 to 2? How?  I have no logic adding/increasing ATYALLOC
Qty Fulfilled: 0
Qty to Back Order: 2
I appreciate any help you can provide. Let me know if you need more info. Thanks!

*This post is locked for comments

  • rcurry Profile Picture
    rcurry 210 on at
    RE: Sales Transaction Entry - Order

    Do either of your books specifically discuss eConnect and specifically how taSopLineIvcInsert_ItemsTaSopLineIvcInsert and/or EConnect.ProcessEconnectXML() modifies tables?

    I found them on Amazon, but the table of contents were not provided.

    Thanks!

  • rcurry Profile Picture
    rcurry 210 on at
    RE: Sales Transaction Entry - Order

    Are these the correct fields?

    Qty Ordered: QUANTITY (I am suspicious of this)

    Qty to Deliver: ATYALLOC (I am suspicious of this)

    Qty Fulfilled: QTYFULFI (confident)

    Qty to Back Order: QTYTBAOR (confident)

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Sales Transaction Entry - Order

    This is a complex question.  We have a couple of books specifically on GP that should help.  These would be Understanding Sales Order Processing and Information Flow and Posting.

    The fields you selected work perfectly unless there is a custom process that is changing them.  The quantity ordered should be the total quantity on the order originally.  The quantity allocated should not be set by an outside process but by the GP business logic allocating or reserving the items.  Changes need to be made in inventory tables as well as SOP tables for allocated quantities.  Quantity to Invoice and to Backorder are filled in when the order is fulfilled or prepared to be transferred to an invoice.

  • rcurry Profile Picture
    rcurry 210 on at
    RE: Sales Transaction Entry - Order

    Thanks for your guidance!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Sales Transaction Entry - Order

    If you are on the SOP transaction entry screen you will see Options at the top of the screen. One of these options is allocate and fulfill. Start reading at page 126 in the SOP manual you will see how the allocate and fulfill process works in GP. You can't have a qty backordered and fulfilled at the same time. It is one or the other. There is also an option is SOP setup regarding using separate fulfillment process. I would click on the option box and then press F1 then click on Setting up Orders and then look at line 8. There will be a link there that describes the various allocation options. I think a thorough understanding of how GP allocates and fulfills will aid you in your code development.

  • rcurry Profile Picture
    rcurry 210 on at
    RE: Sales Transaction Entry - Order

    I reposted this because this was hard to read.  Sorry for the duplicate, but I do not see an option to edit/delete posts.

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans