Aging Report not including balances in 1-30 days column when aging date set to the Invoice Bill date or Due date



Description of Issue

When running the Aging report with an aging date that equals the Invoice Bill date or Due date, the unpaid balance is not included in the 1 - 30 days unpaid column.

Unpaid balance only shows in the 1 - 30 days column when the Aging Date is at least 1 day past the bill's Bill date or Due Date.



Context
  • Accounts Receivable

  • General Billing

  • Aging Report



Cause

Aging Date is less than or equal to the bill's Due Date or Bill Date. This would indicate 0 Days Past Due.



Resolution

The Aging Report will allocate the unpaid balances into Days Past Due columns based on the number of days the specified Aging Date is past the Due Date or Bill Date. 

Be sure that the Aging Date is at least 1 day after the bill's Due Date or Bill Date for the unpaid balance to display in the 1 - 30 column.



Additional Information