Difference between revisions of "Spectrum Product Reports"

From Vital Soft Wiki
Jump to: navigation, search
Line 20: Line 20:
 
name=SAFE-DEPOSIT-BOX|
 
name=SAFE-DEPOSIT-BOX|
 
h1=Created in LIST.  Reports all Rented and Non-rented Safe Deposit boxes.|
 
h1=Created in LIST.  Reports all Rented and Non-rented Safe Deposit boxes.|
h2=N/A|
 
 
link=SAFE-DEPOSIT-BOX.ctx|
 
link=SAFE-DEPOSIT-BOX.ctx|
 
created=2016/09/01|
 
created=2016/09/01|

Revision as of 19:39, 23 February 2022

VISA 10 PCT OVER CREDIT-BAL

  • Visa Accounts More Than 10% Over Credit Limit
  • This report is designed to select all members who are 10% or more above their credit limit on their Visa Loans. This version selects VISA loans, suffix 96.
Sample Report Output
Date: 02/23/2022                                                                             Page:     1
                                   Visa Accounts 10% + Over Credit Limit
                                                                                              # of Days
 Account     Name and Address                 Credit Limit      Balance    %Over    Due Date   Past Due
========================================================================================================
 47842       KEVIN H SIMONDS                     $3,000.00   $12,470.00  315.66%  10/31/2006       5594
             3517 LASSEN AVE
             PHILADELPHIA, PA 19102
 
 5138        STANLEY W JOHNSON                   $5,000.00   $12,470.00  149.40%  07/31/2006       5686
             3456 S.E. ALDERSON
             MANCHESTER, NH 3108
 
 1032        CHRIS MANZUK                        $5,000.00    $5,615.38   12.30%  12/31/2006       5533
             2233 11TH AVE
             PANAMA CITY, FL 32413
 
========================================================================================================
             Grand Totals ->                    $13,000.00   $30,555.38  135.04%

Download VISA 10 PCT OVER CREDIT-BAL
Created: 2016/09/01

BALANCE-GREATER-THAN-CREDIT-LIMIT

  • This reports specified loans where the balance is greater than the credit limit.
  • This REPORT pulls all loan suffixes (MEMBRS.LOAN-FILE.SUFFIX), where the balance is greater then the credit limit (MEMBRS.LOAN-FILE.BALANCE > MEMBRS.LOAN-FILE.CREDIT-LIM) and members that have been over the their credit limit more then once (MEMBRS.LOAN-FILE.OVERLIMIT-CNT > 1). To specify suffixes, add to the begining of the search criteria: membrs.loan-file.suffix = ??,??,?? AND ...etc
Sample Report Output
DATE: 02/23/2022                                                                                     PAGE:     1
TIME: 11:35 AM                            VITAL SOFT CREDIT UNION
                                         ACCOUNTS OVER CREDIT LIMIT
****************************************************************************************************************
 
 ACCOUNT:        5138                          CDT LMT: $5,000.00   LAST PYMT:    09/30/2002   LOAN BEACON: 800
 SFX    : 96                                   CUR BAL: 12,470.00   DUE DATE:     07/31/2006   APR:     9.7500%
 NAME   : STANLEY W JOHNSON                    AMT OVR: $7,470.00   DATE OVR LMT: 09/04/1996   MBR BEACON:  734
                                                 % OVR:   149.40%
                                             TIMES OVR:        12   PMT HISTORY: 2-2-2-2-1-1-1-0-1-1-1-1
 ---------------------------------------------------------------------------------------------------------------

Download BALANCE-GREATER-THAN-CREDIT-LIMIT
Created: 2016/09/01

SAFE-DEPOSIT-BOX

  • Created in LIST. Reports all Rented and Non-rented Safe Deposit boxes.
Sample Report Output

Download SAFE-DEPOSIT-BOX
Created: 2016/09/01


Back to Context Library