Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Clean up Migration JEs
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.