Run a Detail Receivables by Date or Register Report That Includes Interest



Description of Issue

Need to run a Detail Receivables by Date or Detail Receivables Register report that includes interest calculated to a specific date. 



Context
  • Accounts Receivable 

  • Property Tax Billing 

  • General Billing 

  • Detail Receivables by Date (arthrudt)



Cause

A report of bills with interest is needed for balancing or another internal process. 



Resolution
  1. Navigate to the Detail Receivables by Date program either by searching or using the following path: Property Revenues > Accounts Receivable > Inquiries and Reports > Detail Receivables by Date 

  2. Enter all other selection criteria as desired.

  3. To include interest on the report, make sure to use the following criterion: 

    1. Check the box to Include interest (includes held interest only). 

    2. Check the box to Include on-the-fly penalty and interest amounts to calculate interest to a specific date on the report. 

      1. Check the box to Include on-the-fly discount amounts as well if desired. 

    3. On the left side of the screen, underneath Activity Date Range select AR effective date range. 

    4. Choose an AR effective date range method like Thru today or Specify dates to customize the date range. 

      1. If Specify dates was chosen, enter the date to use for interest calculation on the report. 

  4. Finish defining and run the report as usual. Interest should calculate for the bills and display on the report up through the specified AR Effective Date. 



Additional Information