Name and Address Listing (4)

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

images\kb_closed_shg.gif

LMBRNS-04

Name and Address List Selection

4614

LNBRN1, LMBRNX

Click here to magnify

 

 

Access this from the third name and address listing screen.

This screen is used to specify which members should be included on the results based on account balance parameters or miscellaneous date parameters.

How Do I Save/Retrieve My Report Settings?

This report can be used with the “Report Scheduler,” a time-saving automation feature that allows you to select and save the filters you use to run several commonly used reports and then set these reports to be run automatically by our operations staff on the first of the month.  Or you can save the settings and run them manually by yourself at any time.  To learn more refer to the first selection screen.

When ready, use Enter to proceed to the next screen.

Field Name

Description

Account Balance Selection

For these fields, specify both a low and high amount to include only members whose balances fall within those ranges.

Current balance

To include members with a certain balance range, from the current balance field (CURBAL) on the MEMBERx account record.

  • If an Application type was selected on the General Account Criteria screen, or if you also selected a dividend application, CD type or loan category on the Sub-Account Criteria screen screen, the program will only look at the balances of those accounts. If those criteria are not used, the program will look at balances for all MEMBERx accounts.

Uncollected balance

To include members with a certain amount in the Uncollected field (UNCOLL) on the MEMBERx account record (savings and checking accounts only).

  • IMPORTANT: In order for this to work properly, an Application Type of IR, SH or SD must be entered on the General Account Criteria selection screen.

Secured balance

To include members with a certain amount in the Secured field (SECBAL) on the MEMBERx account record (savings and checking accounts only). This contains both Misc. Secured Shares and shares pledged toward a loan.

  • IMPORTANT: In order for this to work properly, an Application Type of SH, SD, CD, IR, or TX must be entered on the General Account Criteria selection screen.

Minimum balance

To include members with a certain amount in the Minimum balance for dividend period field (MINBAL) on the MEMBERx account record.

  • IMPORTANT: In order for this to work properly, an Application Type of SH, SD, IR, or TX must be entered on the General Account Criteria selection screen.

YTD dividends

To include members that were paid a certain amount of dividends on share accounts during the current year. This looks at a total of the four quarterly dividends paid fields (DIV1, DIV2, DIV3 and DIV4) on the MEMBERx record.

  • IMPORTANT: In order for this to work properly, an Application Type of SH, SD, CD, IR, or TX must be entered on the General Account Criteria selection screen.

YTD interest

To include members where YTD interest paid on loans falls within this range. This looks at the YTD Interest (ANNINT) field on the MEMBERx record.

  • IMPORTANT: In order for this to work properly, an Application Type of LN or OC must be entered on the General Account Criteria selection screen.

Date Selection

For these fields, specify both a low and high date to include only members whose accounts fall within those date ranges.

Birth year

To include only members born during certain years, based on the Birth year field (BRTHYR) on the MASTER record.

  • CU*TIP: In most cases you should use either birth year or birth month/day, but not both. For example, if you enter a year range of 1930 to 1932, and a month range of 12 to 12, you will get all members born between December 1, 1930 and December 31, 1932. (Not just members born during December in the years 1930, 1931, and 1932.)

Month/day of birth

To include only members born during a certain month/day range. For example, if you want to include all members born in January, enter 01 and 01 in low fields and 01 and 31 in the high fields.

  • CU*TIP: In most cases you should use either birth year or month/day of birth, but not both. Additionally, you must enter both a month and a day for the report to process correctly.

Date account opened

To include only members with an account opened during a certain date range (looks at the date on the MEMBERx record). This should generally be used in conjunction with a selection on the previous screen to define a dividend application, certificate type, or loan category. Otherwise the system will include the member if any of his or her accounts were opened within this period.

Maturity date

To include only members with a loan or certificate. That has a maturity date within a certain date range.

  • IMPORTANT: In order for this to work properly, an Application Type of CD, LN, or OC must be entered on the General Account Criteria selection screen.

Last transaction date

To include only members with any account that shows a last transaction date within a certain date range (looks at the date on the MEMBERx record). This should generally be used in conjunction with a selection on the previous screen to define a dividend application, certificate type, or loan category. Otherwise the system will include the member if any of his or her accounts with last transaction dates within this period.

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#LMBRNS-04.htm