Changing PM dates that were way in the future.

(0) Share

Report

Posted on by DH-17091352-0

572

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