Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Changing PM dates that were way in the future.

(0) ShareShare
ReportReport
Posted on by 2

Our client had several transactions entered with dates way in the future.  (Yes, we have now turned on the PSTL tool.)  We ran the following script in both the PM20000 and the PM30200 tables (these transactions were all in the PM30200 table)

Update PM20000 set DOCDATE = '2009-11-19' WHERE DOCTYPE = 1 AND VENDORID = 'ARR01' AND DOCNUMBR = 'T74090684'

We then ran check links and reconcile on the necessary PM tables.

Now when we run our Historical ATB the payments, relating to these transactions are all showing.  In the inquiry window it appears they are fully paid.

Is there another table I need to be looking at?

Thanks for any help!

Debra

*This post is locked for comments

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans