[Denise Lewis]

We recently ran Check Links and then reconciled purchase orders via the Reconcile Purchasing Documents window. I don’t know if either or both of them is what caused this issue but now we have issues on the PM historical aged trial balance. This report is now showing old payments when no payments should even be on the report. We think the system locked up when these old payments were being ran, but don’t know why that would cause them to be on this report now. I was able to find one of the payments in the PM10201 table and it has a weird doc date (1/20/4717) instead of 2/6/20018 like it should, but that was the only issue I found with any of the payments. Has anyone had an issue like this? Any suggestions on what to do?

Thanks!

——————————
Denise Lewis
Manager of Accounting
Folience
Cedar Rapids IA
——————————

[Bruce Strom]

?Whenever the historical aged trial balance does not balance, but the regular trial balance does balance to the GL,
usually the culprit is incorrect or missing data in the Apply To file, for both payables and receivables tables.
To find out what data is incorrect, simply run both the regular and HATB trial balances as of today, and note the differences.
You need to have someone write a SQL query to fix the data.
Whenever I do this, I simply look at the bad data, and a set of similar proper trx apply transactions,
and try tinkering with/adding to the apply-to dollar fields.
This does not affect the running of the system, these are passive history files,
but I always make a copy of the data before I start tinkering with it.
I wrote an article on this in GPUG awhile back, you can find many HATB topics in past discussions.

Thanks,
Bruce

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida / Supervalu
sunrise FL
——————————
——————————————-