Clear Beginning Balance of No Customer/Job in A/R Aging Report
Published on
September 29th, 2023
Scenario
Customer wanted to clear the beginning balance of No Customer/Job in A/R Aging Report throughTransactions > Financial > Make Journal Entries.
Solution
- Create Dummy Customer record
- Navigate toLists > Relationships > Customers > New
- Name:EnterDummy Customer
- Save
- Transfer the balance of No Customer/Job to Dummy Customer
- Navigate toReports > Customer/Receivables > AR Aging
- Click the total of No Customer/Job
- OnOpen Balancecolumn, click the amount to see theAccount Receivable that used for the journal
- Navigate toTransactions > Financial > Make Journal Entries
Sample Journal Entry:
ACCOUNT | DEBIT | CREDIT | NAME |
A/R Account (from Step 2.3) | XXXXX | Dummy Customer | |
A/R Account (from Step 2.3) | XXXX |
- Save
Note:If you go back toReports > Customer/Receivables > A/R Aging>ClickRefresh, you will notice that No Customer/Job will not appear in the AR aging report and DummyCustomer is added in A/R Aging report.
- Clear the Balance of No Customer/Job
- Navigate toTransactions > Customers > Accept Customer Payments
- Customer: EnterDummy Customer
- A/R Account:SelectA/R account used in creating journal entry
- Go toApply tab> Tick the box
- Save
- Navigate toTransactions > Customers > Accept Customer Payments
Note:If you go back toReports > Customers/ Receivables > A/R Aging>ClickRefresh, you will notice that No Customer/Job and DummyCustomer are not appearing in A/R Aging Report.