QueryPlus version 3.2 contains a new set of fields – both Premium and Non-Premium – which are summed at the Policy level. They are useful in creating queries/reports that need policy-level totals.

In AMS360, the new fields are:

The Policy Total Cost of Insurance is the sum of Policy Total Premium and Policy Total Non-Premium.

In AFW, the new fields are:

There is no Un-Billed Non-Premium, since Non-Premium is added in the billing process.

The last 3 fields were added because of some concern about the ‘Don’t Bill’ flag in the AFW interface:

These 3 fields total all Premium without regard to the ‘Don’t Bill’ flag. Use either set of fields as desired to return the correct data for your particular query/report.