How can I correct a bad record in the PM Historical Aged Trial Balance?

(1) Share

Report

Posted on by Community Member Microsoft Employee

I have a client who has a vendor that, when they print the HATB for them, shows a phantom payment record that appears nowhere else. The current balance is zero, which shows correctly everwhere except the HATB. I have searched every PM transaction table in SQL, can find nothing for this voucher number or the amount.

*This post is locked for comments

All responses (2)

Answers (0)

veeyeskay on at

Like (1)

Report

Re: How can I correct a bad record in the PM Historical Aged Trial Balance?

Hi Matt

Make sure you have all the users logged out of GP.

Then run the following script in SQL Server.

DELETE FROM DYNAMICS..ACTIVITY

DELETE FROM DYNAMICS..SY00800

DELETE FROM DYNAMICS..SY00801

DELETE FROM tempdb..DEX_LOCK

DELETE FROM tempdb..DEX_SESSION

Then try running checklinks for the following options on the Purchasing Series.

1. Payables History Logical File

2. Payables Reprint Journals Logical File

3. Payables Transaction Logical File

4. Payables Void Logical File

Let us know if this fixed the problem (or) if you need further assistance.
Community Member Microsoft Employee on at

Like (0)

Report

Re: How can I correct a bad record in the PM Historical Aged Trial Balance?

Have you tried running checklinks on payables tables?