Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Document date posting error

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

My AP has posted an AP invoice with document date Jun 9,2019 but posted on Jun 7, 2017 in which the posting date is fine. I am trying to void the invoice and post it to the correct document date Jun 9, 2017. However, our year-ended is June 30, 2017. What should I do to make sure the AP aging and GL are ok ?

Thanks!

Louise

*This post is locked for comments

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Document date posting error

    :The PSTL tools should have been install by whomever installs/updates your software. It is an item on the feature list of GP. If you do not have it, you can use Programs & Features option in Control Panel to modify the installation. Each workstation needs the product installed if it is not. Here's the add Features window that will launch from the Programs & Features selection if you choose Change:

    change-dates-in-ap-void.png

    To check the installation, edit the Dynamics.set file with notepad. The PSTL product will be listed as product 1838. It is named Technical Service Tools:

    Top of Dynamics.set file.

    technical-service-tools.png

    Bottom section of Dynamics.set file.

    Set-file-showing-PSTL.png

    To address your second question. Whether or not it will post to the GL on a specific date is totally under your control. What der ate do you want to use for the post? GP will properly roll over any transaction that you post to history. The void window contains two dates, both are editable so you can change them. The dates are marked below:

    change-dates-in-ap-void.png

    I hope this helps answer your question. Please let us know.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Document date posting error

    Thanks Leslie. May I ask where can I find PSTL tools?

    Secondly, our year-ended is on June 30 and the posting date was in last fiscal year. If I void in current year, Aug 10, 2017, will the opening balance be affected? (we have already roll over the book into new fiscal year as well)

    Thanks,

    Louise

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Document date posting error

    Hi,

    The first thing I would do is go into the PSTL tools and check the box next to 'Doc Date Verify' in the Misc Tools section. This will keep the problem from happening again.

    Next, you will need to create the 2019 year so that you can void the entry in payables. Since your GL is fine, you'll need to change the posting option for this transaction such that it doesn't 'post through' to the general ledger. After the void, you can entry the vendor invoice into the correct date.

    If you want to clean up your books, you can remove transaction history (in Utilities) for the 2019 entries and then use SQL to remove year 2019 from the SY40100 and SY40101 tables.

    Kind regards,

    Leslie

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans