Screen ID:
Screen Title:
Panel Number:
Report Name:
LMBRTS-01
Member Trial Balance Selection
3492
LMBRT
|
Screen ID: Screen Title: Panel Number: Report Name:
|
LMBRTS-01 Member Trial Balance Selection 3492 LMBRT |
|
Access this screen by selecting MNRPTB #1-Trial Balance Select Listing.
This is the first of several screens used to produce the Member Trail Balance Listing Report - using your credit union’s member data. This screen allows you to choose which members should be included to create either a printed report or a file containing the report results for use with Report Builder.
This application has special features that let you eliminate duplicates by member address or household number.
On this screen, you may narrow down the list of members by specifying ranges for various settings, such as ZIP codes or branch number. You may also choose to select just a single, product type, city, or state.
Make any selections desired and use Enter to proceed. If an Application type was specified, you will proceed to the Sub-Application Selection screen. If not, you will proceed directly to the Account Attribute Selection screen.
· Many of the criteria on subsequent screens will require that an Application type be specified on this screen first to define what types of accounts should be evaluated. So if you are planning to pull members based on information found in the MEMBERx account records, be sure to fill in the Application type field now.
· All of the criteria you enter on this and subsequent screens are similar to “AND” criteria—this must be true, and this, and this, etc., in order for the member to be included. The more selection options you choose, the more complicated it will be to verify that you get the right members in your list, especially since some of the criteria are “exclude” or “without” options! So as a general rule, keep it simple!
· Be sure to enter the appropriate Application Type for the criteria that you enter on subsequent screens. If the criteria is not applicable for the Application Type (i.e. Uncollected Funds for LN or OC), you may get invalid data on the report.
|
Field Name |
Description |
|
Account base |
To include a single account or a numeric range of account numbers. |
|
Account type |
To include only members who have sub-accounts within a certain range of account suffixes. |
|
Branch |
To include only members assigned to a certain branch number (member branch). |
|
Zip code |
To include only members with a certain Zip code or range of Zip codes. |
|
User Defined Field #1 |
To include only members coded with a certain code or range of codes in the Mail code 1 field (MLCD1) on the MASTER record. SEE ALSO: User Defined Fields Codes |
|
User Defined Field #2 |
To include only members coded with a certain code or range of codes in the Mail code 2 field (MLCD2) on the MASTER record. |
|
G/L account |
To include only members who have accounts tied to a particular G/L account (member G/L) or range of accounts. · This relates to the G/L for the MEMBERx account suffix, such as 906.00 for IRAs. |
|
Department |
To include only members that have a certain code (or range of codes) in the Dept/Sponsor field on the MASTER record. |
|
Employee type |
To include only members that have a certain code or range of codes in the Employee Type (EMTYPE) field on the MASTER record. |
|
Application type |
To include only members with a certain type of account, enter an Application Type code here. (This is required if you plan to use criteria on subsequent screens that looks at MEMBERx account data.) Click here for a list of valid codes. · If an application type is entered here, the next screen to appear will be the sub-account selection screen, where you can choose a single dividend application, certificate type, or loan category, depending on the code entered here. |
|
City |
To include only members with a certain city name on the MASTER record. · The city name needs to be spelled EXACTLY as it appears on the membership record, and cannot be abbreviated. (For example, if you want to locate GRAND RAPIDS, you cannot enter just GRAND.) |
|
State |
To include only members in a certain state (from the MASTER record). |
|
Mbr Designation Code |
To include specific Membership Designation Codes. SEE: Member Designation Configuration. Click the Select button to view a list of codes. Check the appropriate code or hold down the Ctrl key to select multiple codes. Then use the Select option to return to the initial screen which will then list the number of codes selected. |
Link to ID: http://www.cuanswers.com/doc/gold/gold.htm#3492g.htm
