Document date posting error

(0) Share

Report

Posted on by Community Member 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

All responses (3)

Answers (1)

Verified answer

L Vail 65,271 on at

Like (0)

Report

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:

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.

Bottom section of Dynamics.set file.

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:

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

Kind regards,

Leslie
Community Member Microsoft Employee on at

Like (0)

Report

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 65,271 on at

Like (0)

Report

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