When showing the summary page for Products and Billing Items on the Aged Accounts Receivable Report, the total balance is lower than the sum of each balance for each product and billing item listed. This summary pages shows each product and billing item and lists the amounts due under each aging period as well as the total balance.
We resolved this issue in version 7.82.104, patch 13. Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.
Note: If you have marked the checkbox to Reduce balances by Unapplied Payments and Credits on the General tab of the report parameter, your Account balances will be reduced by those unapplied payments and credits. However, the Billing Item Summary total does not factor in unapplied payments in the total because they are not associated with particular Products or Billing Items.
If you run an Unapplied Payment Report filtering on the same dates as the Aged Accounts Receivable Report, the difference in the balance of the summary pages of the Products and Billing Items report and the total of the Account balances should match the total of the Unapplied Payment Report.