We recently transitioned from GIT and carried over some old journal entries that were booked to the AR clearing account, which has since been set to inactive. Both invoices and credits were posted as journal entries, tagging the customer as part of the migration. However, since these are journal entries and not actual invoices or credit memos, they continue to appear in our AR aging detail.
During the migration, we utilized three GL accounts: AR Trade, AR Clearing, and Cash. The AR clearing account serves as a temporary account to hold transactions while they are being matched or settled. Unfortunately, the implementation team did not clear the credits from the AR clearing account. Even after offsetting the invoice and credit journal entries on the accepted customer page, I still see a balance associated with the customer.
I reactivated the AR clearing account and created a journal entry to offset it while untagging the customer. This seems to resolve the issue. We have multiple customers experiencing this problem, and I’m exploring ways to automate the cleanup of the old journal entries. There appears to be an enhancement request 95241 for bulk clearing of these journal entries. Any suggestions for automating this process would be greatly appreciated.