Scenario:
When the user looks the balance of certain receivable account it donot match with the A/r aging report. The user has different receivales COA.
Reason:
The result of Receivables in A/R aging report is not directly shown as chart of account instead in the name of clients and here we have to sort the report based on the COA or else result may shown difference in compared to trial were balances are shown in basis od Chart of accounts.
Solution:
Customisation fo A/R aging report
1.Choose the A/R aging report .
2.Navigation: Report>Customer/Receivables>A/R aging summary.
3. Click on customise button.
4.Select Account line in filter section form add field section.
5.Choose the recievable account in the account line and save.
6.Save and run the report.
Now you get the A/R aging summary based on that specific chart of account.
Customisation of trial Balance
The customisation of trial can be done if only required as it shows the result based on COA.
- Choose Trial Balance.
- Navigation: Report>Financial>Trial Balance.
- Click on customise button
- In filter;Add field section choose Account Line-Name.
- Choose the receivable account.
- Save and Run.
Now you get the trial balace with just the selected Chart of account and you will be able cross check with A/R aging report and the amount will be same.