I have an issue where the HATB does not balance to other A/R reports for a specific customer. There is 1 specific invoice causing an issue. This invoice has been fully paid and has been moved to history. Checklinks and Reconcile have been run but did not find any issues. I have looked at the RM Open and RM Open Apply tables (RM20101 and RM20201) and as expected the invoice was not there. I checked the RM History table (RM30101) and the invoice is there, however the CURTRXAM was the amount of the invoice not zero. I also checked the RM Apply History (RM30201) table and found that the invoice is missing from this table. I know I can update the CURTRXAM amount in the RM30101 table but this will not affect the HATB. Is there a way I can update the RM30201 table?
Thanks
Kathie
*This post is locked for comments