2018 Migrated trial balances without assigning a c...
# administrationk
Kumar
03/02/2022, 11:20 PM2018 Migrated trial balances without assigning a customer name column/field on Journal Entry lines that affected Accounts Receivables. This resulted in a balance showing at the top of the Aging Report with “No Customer” assigned to the amount. How can we solve it?
k
KevinJ of Kansas
03/03/2022, 12:25 AMDoes it net to zero?
👍 1
k
Kumar
03/03/2022, 11:23 PMno
Kumar
03/03/2022, 11:24 PMk
KevinJ of Kansas
03/04/2022, 12:03 AMOk - you probably have done one of a few things
👍 1
KevinJ of Kansas
03/04/2022, 12:03 AM1) your data detail load for open invoices didn't match your GL history - so the reversing entry didn't net to zero at the end, or someone forgot to do the reversing entry.
🙏 1
KevinJ of Kansas
03/04/2022, 12:04 AM2) you are seeing an additional account, such as allowance for doubtful accounts in your rollup
🙏 1
KevinJ of Kansas
03/04/2022, 12:04 AM3) you have had someone post journal entries to the AR account without flagging a customer. after go live
🙏 1
KevinJ of Kansas
03/04/2022, 12:05 AMThe answer in #1 is to get your reversing entry fixed, or find the missing invoices.
The answer for #2 is to make a version of your A/R Aging report that excludes allowance for doubtful accounts.
The answer for #3 is to post a JE the way you describe.
🙏 1
4 Views