Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Document Date and Posting Date is showing 00/00/0000

Posted on by 35

Hi,

Please find the srceenshot attached. Here the document date and posting date is 00/00/0000. What caused this and how do I rectify this?

It is showing posted in 00/00/0000. It hasn't affected the bank. Applied invoices are blocked and it does not allow to apply other payment.

Awaiting your expert advise.

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Document Date and Posting Date is showing 00/00/0000

    This is definitely a result of a posting corruption. Correcting this should be done on the SQL level. Initially, you need to check the tables in which this document is stored, this can be done through the search all db stored procedure. Then, you can check the records retrieved and update the date fields accordingly.

    Remember, you need to get your partner involved. Never forget that back up is a must.

    Let us know if you need any further inquiries, 

  • Chanpreet Profile Picture
    Chanpreet 35 on at
    RE: Document Date and Posting Date is showing 00/00/0000

    Here is the screenshot guys! Forgot to attach previously.

    Issue Screenshot

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans