CU*BASE Query: Q-Collections - Negative (COLL)

This Query is used to view information contained in the CU*BASE “COLL” file. This file stores collections information and this Query is designed to show all negative-balance (overdrawn) accounts.

Specifications

File(s) used by this Query: COLL

Access: Tool #227: Collections (COLL) - Negative Accounts

Records will be sorted alphabetically by member name. A grand total and count will be shown at the bottom of the report.

The following fields will be displayed in this Query:

• Member Name

• Account Base

• Account Suffix

• Current Balance

• Days Negative (Stale)

• Branch Number

• Last Contact Date

• Last Transaction Date

• Corporate ID

• Status

Sample Conditions

The following table lists a few sample conditions which can be used in the Collections - Negative Query.

· IMPORTANT: Notice the default condition that is already entered for this Query. Because this condition is important to perform the Query properly, be sure to leave it as is and add any other conditions below it.

Description		Field	Test	Value
Show any member accounts have stale negative balances over $50.00, that have been stale at least 20 days. Notice that the value is entered with a negative sign in front, and that the test is LT (less than).	AND AND	CMRTYP CMCBAL CMDNEG	EQ LT GE	'N' -50.00 20

 

Clickherefor complete instructions on navigating around the “Display Report” screen or using the available buttons.