Help Center : How the As Of Date works on reports

Created by Claudia Linquanti-Sue on Sep 22, 2023

How does the “As Of Date” filter work on CTS reports?

For reports which use an As Of Date parameter, an Invoice will only display on the report if all of the following criteria are met:

  • Invoice Date is on or before the As Of Date

  • Payment Date is after the As Of Date (or Payment doesn't exist)

  • Invoice Void Date is after the As Of Date (or Invoice is not voided)

  • Payment Void Date is on or before the As Of Date

The Invoice Adjustment Date that plays a role when the Invoice details on the report are different than expected. The changes will only show on the report if the Adjustment Date is on or after the As Of Date.

The same rules apply to the As Of Date field on the Invoices search / list (under the main Accounting menu).

© 2023 CoStar Group