SOP10100.ORDRDATE Population

(0) Share

Report

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

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Tim Foster 8,515 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
RyanBarrus on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Tim Foster 8,515 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RyanBarrus on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No