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) / SOP10100.ORDRDATE Popu...
Microsoft Dynamics GP (Archived)

SOP10100.ORDRDATE Population

(0) ShareShare
ReportReport
Posted on by RyanBarrus

How is SOP10100.ORDRDATE populated? 

Because in my database for nearly all records in SOP10100 ORDRDATE=DOCDATE, and all of those are SOPTYPE = 3 (invoices) I assumed that ORDRDATE was also populated by the "Date" field in the Sales Transaction Entry window, and when an SO was transferred to an Invoice the ORDRDATE remained while the DOCDATE became the user date at the time in which the transfer occurred.

However I have some data in SOP30200 where SOP30200.ORDRDATE <> SOP30200.DOCDATE AND SOP30200.SOPTYPE = 2 (Sales Order)

*This post is locked for comments

  • RyanBarrus Profile Picture
    RyanBarrus on at
    RE: SOP10100.ORDRDATE Population

    Finally, the answer to my question:

    If the user presses the blue expansion arrow (button, to immediate right), the Sales Date Expansion screen will open  and allow the user to edit/view dates.

  • Verified answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: SOP10100.ORDRDATE Population

    The user does have the opportunity to change some of the dates.  On the SOP entry screen, the user sees the DOCDATE field presented as Date: (editable).  If the user presses the blue expansion arrow (button, to immediate right), the Sales Date Expansion screen will open  and allow the user to edit/view dates.  For an order document, Order Date is populated with the current user date and is not available to edit.  The user can change the Requested Ship Date which is used as a default date for the lines of the order.

    Orders are created from Backorders via the transfer process, the same way Invoices are created.  Backorders can also be transferred to Orders.  Quotes can be transferred to Orders.  Dates will be set according to the same behaviors as if the user entered the documents (without over-riding defaults).

    Richard's answer comes directly (cut and paste) from the document I referenced.

    Tim

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: SOP10100.ORDRDATE Population

    I would agree Ryan. There is no way to enter that date value on the screen so you are left with what GP does by default.  Depending on your exact needs perhaps you could add a trigger to update the value to what you need or some SQL job. You have to be careful at update time to insure this does not prevent a successful upgrade.

  • RyanBarrus Profile Picture
    RyanBarrus on at
    RE: SOP10100.ORDRDATE Population

    Thank you for your response.

    I will go ahead and say that you answered my question. However, I'm sure that you can see that the value is useless for "user reference only" unless the user understands where the value is populated from.

    For example, a former IT employee developed an SSRS report for our company which compares the ORDRDATE vs ReqShipDate which in theory represents the lead time on an order. However, if users don't have the opportunity to enter the order date into the sales transaction entry window, or have any other means of populating the field, then the field does not have the expected meaning.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: SOP10100.ORDRDATE Population

    Here are a few of the date fields and their meanings.

    Document Date:                   The date associated with this transaction.

    Quote Date:                           The date of the Quote document. Required for Quote documents only.

    Order Date:          The date the order was placed. This field is for user
                         reference only.

    Invoice Date:                         The date of the Invoice document. Required for Invoice documents only.

    Back Order Date:                  The date of the backorder document. Required for Back Order documents only.

    Return Date:                          The date the Return document type. Required for Return documents only.

    Requested Ship Date:  Date the items should be shipped. Defaults with the Document Date on Invoice Entry.
     Fulfillment Date:                    The date the last of the line items for the document were fulfilled.

    Actual Ship Date:                   This is the date the last of the line items for the document were shipped.

    Created Date:                         This field contains the system date of the first save of a document.

    Modified Date:                       Updated with system date each time document is saved.

  • Community Member Profile Picture
    Community Member on at
    RE: SOP10100.ORDRDATE Population

    Thank you for your response.

    I don't currently have access to the SDK.

    When they were posted to SOP30200 they were not back-orders as their SOPTYPE is 2 and not 5. I'm uncertain of how they might have been created from back-orders.

    I'm not particularly concerned about determining the reason why these entries exist. My goal is to better understand the distinction between these similar dates in the SOP tables:

    DOCDATE 

    CREATDDT 

    ORDRDATE

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: SOP10100.ORDRDATE Population

    The definitive answer is in the Dynamics GP SDK (available on install media or Customer Source GP2010 SP4 = mbs.microsoft.com/.../Software%20Development%20Kit%20(SDK)%20for%20Microsoft%20Dynamics%20GP%2010%201

    Look for the SOP Integration Document in Table Integration >> Design Documents and Transaction Flows >>Sales Order Processing >> SOP Transaction Entry Transaction Flows

    GP 2015

    Order Date: The date the order was placed. This field is for user reference only.

    Were the orders created from Backorders?

    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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans