2015 May

The following is a list of changes associated with the 2015 May release of PatronBase.

Desktop Applications

What’s On Calendar to Have Dates With a Performance On Highlighted

When the What’s On calendar is selected in the Box Office from the toolbar, dates that have a performance are highlighted in bold text.

Donor Security Isolation

The new setting has a description of "View patron donations in list form" to try to distinguish between hiding donations completely, and just not being able to see a list of them. The new property will default to OFF, so some venues will need this function enabling. Removing donations from the Sales History view isn't straightforward, because donations can be mixed in with other transactions on a single sale.

- Removed any sales which are JUST a donation

- Ensured that if a sale is a donation plus something else, the description isn't the donation

Donations are not deducted from the sale total, because then the sale total won't match the sale form.

It will still be possible to view donations without the security permissions, but the operator would have to go into each individual sale and find the donations manually.

Add Notes Field to Voucher Template

This enables venues to be able to write additional text specific to that voucher which can print differently on the ticket stub. You can now use {notes} inside a voucher template and it will be substituted with the configured notes for that voucher product.

Edit Existing Entry on Wait List

Added the capability to edit an existing entry in the wait list, perhaps to add a note or change the number of seats requested, without changing the wait list position. Double-click the entry in the Wait List to re-open the Waiting List Item form for editing

Season - Set Patron Button

A button when selling a season to allow multiple selected seats to be set with the same attending patron in one go, rather than setting each seat’s patron individually.

Issue Fix: NULL Promoter ID on Production Creation

Recurrence of previous problem. Productions which have no promoter should be able to have a NULL Promoter ID. All Advanced report needed correction to support. Run Summary needed checking for tolerance for NULL Promoter ID.

Issue Fix: Prevent Settings Form Saving with Null DefTownID

If you didn't set the default town and saved the form, NULL was saved to tblSettings.

Print Membership Card - Separate Numeric Row/Seat

If row and seat are both numeric (eg 11), add a separator eg 1-1.

Patron Day- and Month- of Birth

Allowing a From day and month and To day and month to be specified, allowing return of all patrons with DOB between 2 dates - eg 1st Jan and 15th Feb.

Layout Designer - Attending Patron Not Set

Field to allow purchasing patron to show if Attending Patron was not set.

Issue Fix: Postcodes With District of 0 Not Reported in Postcode Analysis

Ticket sales on Post Production Analysis reports did not match ticket sales on PostCode Analysis (UK) or PostCode Analysis (UK) Sales Range, as postcodes with a district of '0' (zero) were not being reported at all in those reports.

Issue Fix: NULL Values in Inside Charge Cause Errors on Post Production Analysis

When running the Post Production Analysis, if the sales contained null values in the Inside Charge column of tblsaleBooking, the system gave the following error: "The value for Column 'InsideCharge' in 'tblSaleBooking' is DBNull."

Localisation - Print Member Card

Localisation support.

Issue Fix: QuickPOS Error Loading Productions

Error reported: An error occurred while executing the command definition.

Issue Fix: Extracts > By Account Code

In orders with a mix of products / productions, the value was double (or more) counted. Where there is a transaction that has a spread of items, say a production and a product, they are split correctly by description but the sale total is in each row of the split transaction – which doesn’t jibe with identifying values to assign to a GL code.

Extracts > By Account Code - Patron Name

By Account Code had a column with the Sale Patron UID, but Patron Name is better.