Date > Points > Statement

Selections:

  • Date range

This report shows points activity within the selected date range. Records are sorted by patron name.

Information included is:

  • Patron ID
  • Patron name
  • Opening balance
  • Earned points
  • Redeemed points
  • Refunded points
  • Manual items points
  • Expired points
  • Adjustments
  • Closing balance

The opening balance is any unexpired points and points whose expiry is greater than the start date, earned/recorded prior to the start date.

Earned points are those earned from a sale (Source = E) within the date range.


Redeemed points are any points redeemed (Source = R) within the date range whose value is less than or equal to 0.


Refunded points are any points refunded (Source = R) within the date range whose value is greater than 0.


Manual items are any points manually created (Source = M) within the date range.


Expired points are any points whose expiry date falls within the date range.


A points record can be edited and any changed points values are un-audited in the database. Points are flagged as 'Adjusted' to indicate that there has been a change in an earned or manual item (Source = E or M) record that may compromise a statement reconciliation (period to period). The change could be to the points value or simply a change to the expiry date. The flag is set if the changed date falls within the period and the changed date is <> the Date. The idea of the flag to caution the user as to the integrity of the statement record.


The closing balance includes unexpired points and points whose expiry is greater than the end date, i.e. points recorded prior to the end date.