- Select File, Configuration
- Select the Templates tab and the statement location is listed.
- Download statement.xml and save it to the location listed in step 2.
- On the Templates tab, select statement.xml
- Before the billing cycle is closed, run the script in the Store Operations database, which copies the price in the comment field for all the entries in the transaction entry table to show on statements.
- Select Store Operations Administrator
- Select Query, then New
- Copy the following statement and paste into the query page
- Update transactionentry set comment = '$' + CONVERT(nchar(10), price )
Connect and collaborate with fellow Blackbaud users.