General

Modify OnPost event for tables where we track create date/time so when we import from Excel, any new records have a correct creation date/time.

Make sure that if a user has Excel folder and/or Root folder set that those folders exist at startup; if not revert to default settings.

Fix issue where the Document Number table from split periods prior to the current one were not being reindexed when requested.

When performing a deletion of data for billing period(s) and user has elected to use Local data and has not ticked the option to Sync from Live to Local, make sure we delete from Local not Live.

When we reindex a table during the database update process where we find an inadequate index, make sure that if the user has elected to use Local data and has not ticked the option to Sync from Live to Local, the reindex occurs on the local table not live.

When validating or reindexing a table, display the path to the table in the progress bar.

Fix an issue where the Local Database update root folder is a single character which resulted in a root folder that did not have a backslash after the folder name.

If the user has elected to use Local data and has not ticked the option to Sync from Live to Local, when we validate the database at startup make sure we validate the local database.

HOT Load

Fix issue when reindexing ticket history tables at the end of HOT Load where we reindex unnecessary tables from the first slit period in the year.

If not calling Reindexr app for Local Database Update, still generate a file copy list so the user can redo the copy from local to live if the process fails during the update process. Make sure that in this case that the copy is not done twice if the setting to restart AirConnect after Database Update is active.

Incentive Contracts

For incentive contracts, tickets that are refunded or exchanged by airline will be set to Ineligible.

Statistics

Modify column headings for Cancelled Flight export spreadsheet.

Add Original Issue date Range Comparison to Pivot report using the comparison parameters for Issue Date.

Add fields to Ticket History database to track initial date of issue, document number and amounts as well as the same fields for the "original" ie immediately previous document and to the total so far. (Controlled by a license permission)

Ticket Inquiry

For Tickets Refunded and Exchanged by airline, make sure in Ticket Inquiry that the refunded/exchanged indicators are set on the ticket image but with a red border and text.