435
When I run the Detail Historical Aged Trial Balance for Receivables it shows items that have been in History for years. I ran the historical and regular aged trial balance with a date of today and there are several items on the historical that are not on the regular. Any ideas how to remove them from the historical report so it will be accurate?
Thanks for your help!
*This post is locked for comments
Hi Bill.
Not so much as detailed above for that but probably there are issues with the MC020102 table which holds the currency values for MC transactions. If you query it against the documents in question you will probably see those records misrepresented there.
Tim, do you know if the same would apply to Multicurrency transactions? We have a case from a client with ZERO in the Functional Currency, but showing amounts in the Reporting currency.
Thanks for the feedback
I did paid transaction removal and it didn't make a difference. The items are already listed as history, they do not show open. Yet they show on the trial balance report even though they have been in history for years.
Hi Daisy,
Did you try to remove paid transaction removal from Tools-->Routines-->Sales-->Paid Transaction Removal.
Please do this R&D on your test enviornment and before running Paid Transaction Removal on Production keep good backup.
It will move all your fully paid transactions into Historical tables.
Thanks
Sandip
Start by verifying that both reports are excluding the same values in report options window. I would exclude Fully Paid Documents, Zero Balance, No activity. Also, make sure that both reports have the same selection as Historical Trial balance can be by Document Date while AR Trial Balance with Options is by GL Posting Date and no other restrictions are selected. Reprint reports. Check the totals. If there is a difference between the two, then you may have missing apply records or may have damaged records in your historical apply tables. The ATB pulls from the open table. The HATB pulls from the Open and History tables.
There are some number of rogue apply records or missing records in ether RM20201 or RM30201 (or both) which cause this issue and I've seen it a number of times.
If you query RM20201 and RM30201 where APTODCNM = <one of the several items> you will see that the totals of the actual apply records (as opposed to the current trx amount in RM20101 RM30101 which would say zero) wont add to the document total.
When GP does the HATB it takes the document amount then subtracts off the applied amounts it finds within the date you specify so it can do an 'As Was' report. I've even seen the document amount go negative in the report when there were 'extra' apply records. I've decided that the Apply/Un-Apply/ Remove Paid Transactions processes are not done in a transaction state so you are at the mercy of the process completing correctly. I've seen this issue come up like this many times over the years.
I've always had to fix this from SQL both inserting missing records (that's pure pain) and deleting extra ones, I've never had checklinks fix this issue but others here might have a different experience.
Best
Tim
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
