This article outlines the steps on how to customize the A/R Aging report to remove transactions that do not have any Customer Name associated with them.
Solution
Open the A/R Aging report
Total Open Balance: Click Total Open Balance
Note: This will lead to the A/R Aging Detail Report. Take note of the transactions (which normally are Journal Entries) and use Global Search using Document Number to open the transactions.
Open the Transaction record
Click Edit
Click Line subtab
Name: Select a Customer Name
Note: Assign a Customer under the Name column on the A/R account line in the Journal.
Click Save
Create a Journal Entry
Navigate to Transactions > Financial > Make Journal Entries
Fill up all required fields
Note: A/R account that is the same as the existing transaction with an opposite balance (if the existing is debit A/R, the new journal should have a credit A/R account. Assign the same Customer as in step 2.
Accept the offsetting Journals as a Customer Payment
Navigate to Transactions> Customers> Accept Customer Payments
Customer: Select the same Customer Name as inputted in the Journal
Click Apply subtab
Apply: Enter the checkmark on the same Journal in step 2
Click Credits subtab
Apply: Enter the checkmark on the same Journal in step 3
Click Save
Note: The accounting period of the existing transactions should still be Open to be able to edit them. A dummy Customer can be assigned in the transactions if existing customer records cannot be used