Credit Limit Change

Training Outline

Definition:

All credit limits can be changed within the expanded view at the member level, however the system can process a mass credit limit change with an import file. The file must contain the account number/suffix and new credit limit for the import to successfully process. A memo transaction line can be added, however it will also default to a system generated message if one is not indicated.

Upon a successful update, a report will be generated and stored in the Report Warehouse to itemize all changes that occurred.

Roles:

Navigations

Import File

Credit Limit Change Processing Report Warehouse

Permissions

Reports Available:

• Credit Limit Change Report
  

Procedure:

File Preparation:

1. The file must have the extension .clc to process correctly within the core
   

2. To start, open Excel (will save to a .csv and then change to .clc)
   

3. The file layout is as follows (use exact in row 1):
   

1. Field A1- Limit Change
   

2. Field B1- Account Number
   

3. Field C1- Credit Limit
   

4. Field D1- Note Message
   

5. Field E1- Memo Message
   

6. Starting A2 (entire column)- Detail
   

7. Account number format (14 total digits)
   

1. (8) digits for the account number
   

2. (4) digits for the account suffix
   

3. (2) digits for the suffix sequence
   

December 2015    Page 1 of 6

Credit Limit Change

4. Any of the (account or type) is not a total of 8/4 characters, uses spaces to designate a character
   

5. The credit limit is the NEW limit that will be updated on the account
   

6. Note Message- ???
   

7. Memo Message- the message that will be displayed in the memo transaction on the member’s account
   

1. If the spreadsheet it blank, the message on the member’s account will default to “Credit Limit Change From ___ to ____”
   

8. Note, as this is a comma delimited file, do not use a comma within the credit limits or messages, as this will interrupt the file spacing and exception out with the import file.
   

• Navigation: F3- File Import: Credit Limit Change Processing
  

15. This first step is optional, but should be used if a Credit Limit Change has previously been processed within the system. This will remove all records and clear the table to import and process the correct credit limit change file.
    

December 2015    Page 2 of 6

Credit Limit Change

Select the REMOVE OLD RECORDS button. A

message will appear that all old records were

removed. Press ESCAPE to exit.

• From the main menu,
  

• Navigation: F3- Back Office/EFT: Import File
  

December 2015    Page 3 of 6

Credit Limit Change

Use the ellipsis to

search for a file.

After the correct file has been located and is

in the FILE NAME, hit OK to proceed.

Click the UPLOAD button to import the file.

December 2015    Page 4 of 6

Credit Limit Change

This system should automatically direct to Credit Limit

Change. Select PROCESS RECORDS. Note- not

immediately directed, used F3 and type credit limit

change.

A message will appear under the Old Records button to

validate the file has been processed.

• To view the report of the processed accounts, this will automatically be generated when the file is processed and can be located in the Report Warehouse.
  

• Navigation: F3- Other: Report Warehouse
  

There will be (2) files in the warehouse:

The originally imported file (can only save and/or vault). The Report name will be the imported file name.

Credit Limit Change Report- will have a list of all accounts that will include Account Number, Old Limit, New Limit, and any Message if the account was not able to be processed.

December 2015    Page 5 of 6

Credit Limit Change

Copy of report where account(s) were successfully

processed. The Message indicates that there was an

issue processing the credit limit change.

December 2015    Page 6 of 6