TRANLIST

From Wiki
Jump to: navigation, search
TRANLIST.jpg
Name Transaction Listing
Shortcut TRANLIST
Area IBA
 

See the NOVUS Walkthrough Guide for further information.


Transaction Listing

The TRANLIST program orders the transactions by transaction number (entry date), but splits the transaction into instalments (if they exist) which are ordered by the instalment date. The entry date is the day that the transaction was entered in NOVUS, not the accounting date of the transaction. The transaction number is generated by a sequence, therefore the entry date order and transaction number order are the same. Monetary values default to zero value.

Division code allows you to select a division or ALL.

Currency list allows you to select multiple currencies or ALL.

The TRANLIST program provides transaction summaries for transactions between the specified ranges:

Range Type Field name Description
Transaction Range First First transaction number in the range - defaults to 000000
Last Last transaction number in the range - defaults to ZZZZZZ
Year Range First First year in the range - defaults to 1950
Last Last year in the range - defaults to 2049
Policy Range First First policy number in the range - defaults to 000000
Last Last policy number in the range - defaults to ZZZZZZ
Date Range First First date in the range - defaults to 01-JAN-1950
Last Last year in the range - defaults to 31-DEC-2049


View Report in Grid

TRANLIST output.jpg


Right-click on a transaction or policy to go straight to other programs.

Sort results using the built-in filters or drag columns to group the results.

Add additional columns to the grid using the grid customisation button. Where no value exists in the database in respect of a monetary field this displays as 0.00. Optional columns are available to enable reporting on country code and region code for the risk and the original assured.


Report output available

Print results and save to file options allow the information displayed in the grid to be printed or saved to five different file formats.

When exported to Excel, results that contain images have 'yes' in the column to allow for filtering.

Version History

v 7.0.0 – Updated to the latest version
v 6.2.0 – Updated to the latest version
v 6.1.0 – Updated to the latest version
v4.2.0 – Updated to latest version
3.2.0 - Accounting Date column is TRANLIST was not returning data
v9K - Push button navigation sorted out.
v8J - Added policy year fileds to TRANLIST (URM 3067).
v6T - First version of this form to use the new style. No other updates except the restyle.