Stuck With a Weird Date on a GP Transaction? Here’s the Fix

We’ve all done it. You’re moving fast, you key in a payables transaction, and somehow the document date lands on something like 04/16/2042 instead of 04/16/2024. You don’t notice right away — but that little typo shows up on your Trial Balance month after month, quietly haunting your reports long after the invoice has been paid.

Maybe you have one sitting out there right now. Taunting you.

The good news: Microsoft Dynamics GP has had a built-in safeguard for this for years, and most teams just don’t have it switched on. It takes about thirty seconds to enable.

Turn on Doc Date Verify in PSTL

Open the Professional Services Tools Library (PSTL) and check the box for Doc Date Verify. That’s it. No script, no customization, no consultant hours.

From that point on, GP will pop up a warning anytime someone tries to post a transaction with a date that falls outside a valid open posting period. The user’s only options are to correct the date or open the period — which means bad dates get caught at the keyboard instead of at month-end close.

Where it works

Doc Date Verify covers the transaction windows where typos do the most damage:

• Payables Transaction Entry

• Payables Manual Payment Entry

• Receivables Transaction Entry

• Invoice Entry

• Sales Transaction Entry

• Cash Receipts Entry

• Inventory Transaction Entry

• Purchase Order Entry

• Receivings Transaction Entry

• Purchasing Invoice Entry

A quick note on PSTL — and on GP itself

PSTL is free for GP customers on an active enhancement plan, so if you don’t have it installed, there’s no reason not to. If you’d like a hand turning it on, we’re happy to walk through it with your team.

The bigger picture

Tips like this still matter — GP is going to be running general ledgers for a long time yet. But it’s also worth saying out loud: Microsoft has announced the end of new GP version releases, and mainstream support is winding down over the next several years. If your team is starting to ask “what’s next?”, that’s a healthy conversation to have early rather than late.

At eIS Business Solutions, we help finance and operations leaders evaluate their ERP path — whether that’s tightening up the GP environment you have today, planning a move to Dynamics 365 Business Central, or weighing other options against the way your business actually runs. No pressure, no pitch. Just a clearer picture.

In the meantime: go enable Doc Date Verify. Your future self, closing the books at 9 p.m. on the last day of the month, will thank you.