web
You’re offline. This is a read only version of the page.
close
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) / the date is missing or...
Microsoft Dynamics GP (Archived)

the date is missing or invalid Error when posting invoice

(0) ShareShare
ReportReport
Posted on by Barbara Salazar 1,415

We are posting batch with July 12 batch date, July 12 transaction date, July 12 document date.

July 12 is open (2011 is closed).

Our positing is by transaction date.

On user defined fields, we set up billing dates in 2011.

We are getting ERROR: The date is missing or invalid.

COULD YOU PLEASE PROVIDE DETAIL INSTRUCTIONS ON HOW TO FIX IT?

Many thanks in advance!

 

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    I'm interested in what the User Defined fields have to do with your process.  Is this message part of some extended (custom) logic that someone has buit for you? 

  • Barbara Salazar Profile Picture
    Barbara Salazar 1,415 on at

    I believe user-defined field, such as billing period, should not case error: The date is missing or invalid.

    We set up posting by transaction date?

    Am I wrong?

  • Tim W Profile Picture
    Tim W 2,925 on at

    Can you run a batch edit on the batch?  

    Follow-up question, are these transactions typed in or integrated in some fashion?

    Also assuming this is a GL batch.

  • Barbara Salazar Profile Picture
    Barbara Salazar 1,415 on at

    Many thanks!

    Those are sales batch (invoices).

    Those invoices are typed.

    Could you please give instructions on how to run a batch edit on the batch?

  • Tim W Profile Picture
    Tim W 2,925 on at

    Sure.

    Open Sales -> Sales Batches

    Look up your Invoice Batch

    Press the Printer Icon in top right of the window

    (The Sales Document Print Options window will open)

    Change the highlighted 'Print:' dropdown from Document to Edit List

    Print

    This will do a non-post of the batch as if it was posting and will spew fourth any batch posting errors.

    Quick Comment, It's possible that someone has keyed in a date that passed the window edit but is out of posting bounds (such as : 08/30/2212) but typically that will not interrupt a sales batch posting instead that transaction will just not go other will.  This leads me to question a bit your description of the details of the issue and at what part of the process you receive this error.  If you can detail the steps you take to post and then where this error occurs it might be easier to understand the issue.  I'd almost think someone has opened the Sales Batches window, keyed into the posting date field some weird date and the logic preventing you from entering a weird date wont let you even begin the posting process.

    If the posting date field is grayed out you are set to post by document date, if not then it will be enabled and the error is caused as it cant post to 1/1/1900.

    Sorry, I probably have more questions then answers on this but I'm pretty sure it's a user or process issue.

     

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans