New Features - 12-2

Welcome to Collect! Version 12.2. This latest version has several new features and functionality, as well as several optimizations and enhancements to existing features.

64 Bit Computing

Collect! now has the ability to run in either 32 bit mode or 64 bit mode. The Collect\bin folder contains the 32 bit version and the Collect\bin64 folder contains the 64 bit version. To use the 64 bit version of Collect! simply set your shortcut to point to Collect\bin64\cv12.exe.

SQL Queries In The Report Writer

The report writer now supports SQL queries in either an array or into a single variable. Examples:

@tvarArray[][] = @SQL(SELECT * FROM &de WHERE &de.mo = 'A'
AND (&de.li BETWEEN '@tsr.fr' AND '@tsr.to') ORDER BY &de.li )

You can then output the array or parse through it to further filter data.

@tvarTotalPaid = @SQL(SELECT SUM(&de.pa) FROM &de JOIN &cl
ON cl_rowid = de_rowid_ client WHERE &de.mo = 'A' AND (&de.li BETWEEN '@tsr.fr' AND '@tsr.to'))

The variable can then be output in the report.

Any reference to the '&' will tell the report writer to use the database table/field name (Ex: &de will return debtor; &de.na will return de_name )

Any reference to the '@' will tell the report writer to use the database values (Ex: @de.fi will return 1400 )

Optimized CBR File Creation Process

Optimized account Re-reporting process to generate a complete file. It will now take 1/10th of time to run.

Field Masking

Added a new check box to the Operator Level Rights form named 'Mask Field'. When this switch is turned on by the operator level rights the field becomes READ ONLY and everything up to the last 4 non-white space characters are masked with the '*' character.

Variable Interest On The Debtor

An enhancement has been added to Collect! that allows you to specify a variable interest rate file at the debtor level. Any file set here will overwrite the variable interest rate file in the client settings.

Web Host Enhancements

All major loops have been replace with SQL queries for faster processing and to allow more control with the data results.

The user level security has been enhanced to give more control.

Clients, debtors, and the WIP can now be sorted by up to 3 criteria.

Added the ability to hide/show columns in the WIP list.

Changed web host to use form authentication rather than http basic authentication.

Upgrading To This Build

Please refer to How to Upgrade Collect! for details about upgrading your existing Collect! system to take advantage of the features and optimizations in this latest release.

If you are upgrading from Version 11 or earlier, this is a major revision and considered a paid upgrade.

Latest Features

Latest Features