Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Suggestion to validate Document Date in A/P Entry (and other windows)

Posted on by Microsoft Employee

We had a client that entered a credit memo in the year 8021 in the document date field. The system did not complain because the posting date is by batch and so the posting date is set to year 2013 and the transaction posted fine.

Later the client created a check batch and chose to automatically apply credit memo because she wants to print a remittance for that vendor. She got a weird error message. The problem she is encountering is documented in this KB article: support.microsoft.com/.../855322

By the time I had a chance to help her out, restoring the backup was not an option and I had to spend over 2 hours trying to fix the data and make everything post correctly because there are other transactions in the batch that posted and others are still stuck in that batch.

Anyways, the client and I think that it would be great if the document date also validates against the fiscal periods table to make sure the year is setup in there. Can you please add that as a suggestion please? Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggestion to validate Document Date in A/P Entry (and other windows)

    Thank you!

    Sanjay

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggestion to validate Document Date in A/P Entry (and other windows)

    I should have paid attention when I read your blog blue moon ago

    dynamicsconfessions.blogspot.com/.../tools-available-from-professional.html.

     

    Leslie,  my email address is sanjaykumar.rajarao@live.com

     

    Thanks

    Sanjay

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Suggestion to validate Document Date in A/P Entry (and other windows)

    before gp 2010, the doc date verify tool was a separate tweak you needed to download. I think it's called 'Doc Date Verify'. It's available on PartnerSource. If you can't find it, let me know what version you have and I can e-mail it to you later today. Of course, I'll need your e-mail address. Mine is leslievail@earthhhhlink.net

    Kind regards

    Leslie

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Suggestion to validate Document Date in A/P Entry (and other windows)

    I would suggest considering the Professional Service Toll Library tool, it is the precis solution for preventing backdated transactions within periods that are not setup !

    PSTL Tool, Add control for posting dates

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggestion to validate Document Date in A/P Entry (and other windows)

    Leslie,

    Interesting, how is it done ?

     

     

    Thank you

    Sanjay

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Suggestion to validate Document Date in A/P Entry (and other windows)

    Hi,

    you need to mark the option to verily the document date in the pstl tools

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Suggestion to validate Document Date in A/P Entry (and other windows)

    Jackson,

    This is what you need to do, and it is written by none other than David Musgrave.

    blogs.msdn.com/.../preventing-backdated-transactions-using-visual-basic.aspx

    In this article David explains how to prevent back dating  in sales entry transaction, all  you need to do is apply the same principle for Payables transactions.

    Cheers!

    Sanjay

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans