Open Forum

Expand all | Collapse all

"The date formula '-' should include a number." PO Expected Receipt Date

  • 1.  "The date formula '-' should include a number." PO Expected Receipt Date

    SILVER CONTRIBUTOR
    Posted Jan 04, 2019 09:19 AM
    We are on NAV 2016. One of our users is trying to change the Expected Receipt Date on a PO and continues to receive this message:

    thumbnail image

    Note: With this PO, he used the 'Copy Document' function since it was almost the same last year's order. With that said, he has copied other PO's and not had this problem. I think that is because I copied a Posted Invoice versus using an open PO in the past.

    As a super user, I tried to change the date but received the same error message.

    Any thoughts as to why he might be getting this error message and how to get around it?



    ------------------------------
    Laramie Severson
    Business Analyst
    La Crosse Seed LLC
    La Crosse WI
    ------------------------------


  • 2.  RE: "The date formula '-' should include a number." PO Expected Receipt Date

    TOP CONTRIBUTOR
    Posted Jan 07, 2019 07:47 AM
    Laramie,
    My first thought is it make sure the Accounting Period exists. If it does not, daily activities can continue however it's absence causes many odd errors none of which I have ever seen say explicitly 'Your Accounting Period does not exist.' Instead, you get unexplained error and report results like you are experiencing. It's my first go-to whenever an error comes from a date or date range, especially at the beginning of a year.  It's a quick check to just look at the Accounting Period table and make sure it has been created. If it has not, just use the ribbon function to create it. ​

    ------------------------------
    Crystal Tollison
    Consultant
    ArcherPoint Inc.
    Lawrenceville GA
    ------------------------------



  • 3.  RE: "The date formula '-' should include a number." PO Expected Receipt Date

    TOP CONTRIBUTOR
    Posted Jan 08, 2019 07:29 AM
    If that doesn't do the trick it is more than likely something to do with one of the Purchase Lines.  When you set the field in the header it updates all Expected Receipt Dates on the line.  There are 2 DateFormula fields that come into play which are "Safety Lead Time" and "Inbound Whse. Handling Time".  Go to Help, About this Page to check the data on the lines for these 2 fields to see if you can see anything weird.  Also check the "Planned Receipt Date" to make sure it is filled.

    If you have someone that can debug this error it would be quite a bit easier to figure out.  Have someone do this, if they are able.

    Also you could enter the Purchase Order manually with 1 line and compare this line (using Help, About this Page and export to excel) with one of your lines from the Purchase Order with the error.  See what is different which might give you an idea as to what is going on.

    ------------------------------
    Jason Wilder
    Senior Application Developer
    Stonewall Kitchen
    York ME
    ------------------------------



  • 4.  RE: "The date formula '-' should include a number." PO Expected Receipt Date

    TOP CONTRIBUTOR
    Posted Jan 08, 2019 08:06 AM
    I believe Jason is onto something here. In the past, I have seen "1-2D" entered into  "Safety Lead Time" and "Inbound Whse. Handling Time" fields by users.

    Check these fields on the item card. They may have been modified since the time the original PO you copied was created since you said that was a year ago.

    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------