Open Forum

Expand all | Collapse all

Wrong Due Date in the Message Setup Window

  • 1.  Wrong Due Date in the Message Setup Window

    GOLD CONTRIBUTOR
    Posted Sep 12, 2019 12:35 PM
      |   view attached
    Hi:

    In GP 2018 R2 (18.00.0628), the Due Date for NET 30 terms within the Message Setup window for Sales Invoices is showing the same date as the Document Date rather than thirty days from the Document Date.

    It's almost as if this field is pulling the Due Date from the corresponding Sales Order, rather than from the Sales Invoice.

    Below is a screenshot, of this window.  We have temporarily removed the {%Due Date%} field, until we can figure out how to fix this.

    Why would this not show the correct Due Date, from the Sales Invoice?  As a workaround, is there some sort of programming that can be conducted on this window and for this field to add thirty days to the date where the terms are NET 30?

    I have inserted an image of this window below, but I have also attached is in case the image doesn't come clear.

    Thank you!

    John
    Message Setup


    ------------------------------
    John Ellis
    The Dynamics Bulldog
    S2 Technology
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Wrong Due Date in the Message Setup Window

    TOP CONTRIBUTOR
    Posted Sep 12, 2019 01:56 PM
    Hey @John Ellis

    I'm not sure you've given enough screenshots for us to help out!   Can you copy in the results that you are seeing?​

    ------------------------------

    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Wrong Due Date in the Message Setup Window

    GOLD CONTRIBUTOR
    Posted Sep 12, 2019 01:58 PM
    Edited by John Ellis Sep 12, 2019 01:59 PM
    Hi There, Jo!!!

    What is seen in the outgoing e-mails is essentially what displays in the Message Setup window.

    But, below is an excerpt from an example of an outgoing e-mail.  I cannot provide the name of the customer after the word "Dear", for obvious reasons.

    John

    Dear customer,

    Attached find your Invoice.

    Invoice Number: ORD0007545
    Invoice Date: Sep 11 2019
    Due Date: Sep 11 2019
    P.O. Number: FRANK


    ------------------------------
    John Ellis
    The Dynamics Bulldog
    S2 Technology
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Wrong Due Date in the Message Setup Window

    SILVER CONTRIBUTOR
    Posted 30 days ago

    Hi John

    As first step I would go and see what is the Due date in the SOP invoice. If the due date is correct on the SOP document it's time to go deep and look at the table WF40202 and see what is linked to that field.
    (https://support.microsoft.com/en-ca/help/3091940/workflow-2-0-tables-used-with-microsoft-dynamics-gp )



    ------------------------------
    Pierre Deschênes
    Groupe Dynamite
    Montréal QC
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Wrong Due Date in the Message Setup Window

    GOLD CONTRIBUTOR
    Posted 30 days ago
    Edited by John Ellis 30 days ago
    Hi Pierre:

    How's it going?  :)

    Yes, I checked the Due Date on the invoice yesterday and it was displaying correctly.

    I just took a look at WF40202 for the Due Date field and it is pulling from SOP10100.

    I'll check with the client.  But, if this holds true, then that is the reason for the issue.  I believe that the client is sending these e-mails for historical invoices.  If the Due Date is pulling from SOP10100, then that explains it.

    Thanks, Pierre!

    John

    ------------------------------
    John Ellis
    The Dynamics Bulldog
    S2 Technology
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Wrong Due Date in the Message Setup Window

    SILVER CONTRIBUTOR
    Posted 30 days ago
    Edited by Pierre Deschênes 30 days ago
    Hi John

    I'm doing great

    Wrong table, try [DYNAMICS].[dbo].[SY04907], in the conditions you might have to add SOPTYPE to make sure to get the invoice and not the sales order

    ------------------------------
    Pierre Deschênes
    Groupe Dynamite
    Montréal QC
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: Wrong Due Date in the Message Setup Window

    GOLD CONTRIBUTOR
    Posted 30 days ago
    Great!  I had already told the client about the other table and gave that other explanation.

    SY04907 is not telling me one blame thing.

    I'm open to suggestions (from anyone).


    ------------------------------
    John Ellis
    The Dynamics Bulldog
    S2 Technology
    ------------------------------

    Conference-GPUG_200x200


  • 8.  RE: Wrong Due Date in the Message Setup Window

    SILVER CONTRIBUTOR
    Posted 30 days ago

    Hi John

    The fact that the SOPTYPE is not a condition in SY04907 allows the system to pick to Sales Order or the Invoice, both documents can be in that table at the same time.  In fact you could have up to six different documents with the same SOPNUMBER since the key for that table is a combination of SOPTYPE and SOPNUMBER.

    SOPTYPE 1 = Quote
    SOPTYPE 2 = Order
    SOPTYPE 3 = Invoice
    SOPTYPE 4 = Return
    SOPTYPE 5 = Back Order
    SOPTYPE 6 = Fulfillment Order

    Try go back in the sales order and change the Due date to see if it fixes the problem.



    ------------------------------
    Pierre Deschênes
    Groupe Dynamite
    Montréal QC
    ------------------------------

    Conference-GPUG_200x200


  • 9.  RE: Wrong Due Date in the Message Setup Window

    GOLD CONTRIBUTOR
    Posted 30 days ago
    Edited by John Ellis 30 days ago
    Change the Due Date?  The document has already been posted.  And, even that does "fix the problem", that's not a permanent solution.

    ------------------------------
    John Ellis
    The Dynamics Bulldog
    S2 Technology
    ------------------------------

    Conference-GPUG_200x200


  • 10.  RE: Wrong Due Date in the Message Setup Window

    SILVER CONTRIBUTOR
    Posted 30 days ago
    I'm still trying to find the problem :)

    Here's the list of the possible solutions that I can think of :
    - Try changing the Conditions in SY04907 to add the SOPTYPE (risky and might not be possible since we don't know the syntax of that field)
    - See with your customer to change the SOP Numbers by documents types to add a prefix and avoid to have the same SOP Document Number (won't fix the past, but bright and sunny days ahead, but again not sure 100% that this is the problem source)
    - Contact Microsoft
    - Build some triggers in SQL to recalculate the Due Date before it goes in the temp table (SY04911)


    ------------------------------
    Pierre Deschênes
    Groupe Dynamite
    Montréal QC
    ------------------------------

    Conference-GPUG_200x200


  • 11.  RE: Wrong Due Date in the Message Setup Window

    Posted 30 days ago
    I do not see Due Date in your screenshot.  I think that is what Jo was referring to as well.  Did you remove it, or am I missing a screenshot?

    ------------------------------
    Stefanie Christiana
    Glidewell Laboratories
    Irvine CA
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role