Ideal Online Documentation

25664 A/R LISTS, REPORTS AND FORMS
AR5-07 Credit Management

 

PURPOSE

 

The credit management report prints pertinent credit management information for each A/R customer. The report can also be used to print "credit to purchase" customer information. Credit to purchase customers are temporary customers generated through the sales order entry program. This report can be printed at any time during the month and does not necessarily have to be included in your month end procedures.

 

Credit Management Report is access from:

  • A/R Report and Month End menus

 

PROCEDURE

 

When you select Credit Management Report from the A/R Report or Month End menu the following prompts display.

 

** WHICH FILE ? (CR=MASTER, 'C'=CREDIT TO PURCHASE):

 

[Enter] to use the regular accounts receivable master file.

 

This is the usual option.

 

 

"C" to use the credit to purchase master file.

 

Credit To Purchase customers are generated in the Sale Order Entry program.

 

 

** STORE ? (CR FOR ALL):

 

Enter the desired store code.

 

If a store code is specified, only customers that reference that store code will be printed.

 

 

[Enter] for all stores.

 

** ALPHA OR NUMERIC SEQUENCE ? (A/N):

 

"A" to print in alpha code sequence.

 

"N" to print in numeric code sequence (if applicable).

 

** STARTING CUSTOMER CODE (CR FOR FIRST):

 

Enter the starting alpha or numeric customer code.

 

[Enter] for the first customer.


** ENDING CUSTOMER CODE (CR FOR LAST):

 

Enter the ending alpha or numeric customer code.

 

[Enter] for the last customer.

 

** SALESMAN ? (CR FOR ALL):

 

Enter the desired salesman code.

 

If a salesman code is specified, only customers that reference that salesman code as being their responsible salesperson will be printed.

 

 

[Enter] for all salesmen.

 

** CREDIT SELECTION ? (A/E/P):

 

"A" to print all accounts.

 

"E" to print only accounts exceeding their credit limit.

 

"P" to print only accounts within a specified percentage of their limit.

 

The following prompt displays if you select "P".

 

 

** ENTER PERCENTAGE (NO DECIMALS):

 

Enter the desired percentage of the credit limit.

 

This is the percentage of the credit limit. Only accounts with balances within this percentage of the credit limit will print. Only whole percentages are permitted.

 

 

** ENTER AGING CATEGORY (CR=ALL):

 

[Enter] to print all accounts.

 

"1" to print only accounts with a 30 to 60 day balance.

 

"2" to print only accounts with a 60 to 90 day balance.

 

"3" to print only accounts with an over 60 days balance.

 

"4" to print only accounts with an over 90 days balance.

 

** MONTHLY STATUS SELECTION ? (-,*,a,b,c,d,0,A,B,C,D) OR CR FOR ALL:

 

Enter the desired status code.

 

If a status code is selected, you will be prompted FOR HOW MANY MONTHS.

 

 

** FOR HOW MANY MONTHS ? (1 TO 24):

 

Enter the desired number of months.

 

The report will select accounts only if their monthly status string indicates that they have had the selected code status for the past selected number of months.

 

 

[Enter] for all status codes. 


** PRINT MONTHLY STATUS FLAGS (Y/N):

 

"Y" to print the monthly status flag string.

 

"N" to not print the monthly status flag string.

 

** PRESS CR TO CONTINUE:

 

[Enter] to continue to print selection menu.

 

[F4] to exit to menu.

 

 

PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

An example Credit Management Report printout follows.

  



                                                      IDEALWARE - ALL STORES
07/25/95  10:29:17                                                                                          PAGE: 1
                                                   A/R CREDIT MANAGEMENT REPORT
                                             FOR ACCOUNTS OVER AND UNDER CREDIT LIMIT
                                                         FOR ALL ACCOUNTS

-------------------------------------------------------------------------------------------------------------------
ALPHA / SL IN                        CREDIT/    BALANCE/ LAST PAY$/  HIGH BAL/ YTD SALES/ YTD DISC$/  HIGH MTH
NUMBER  GP TP  NAME                  OPENED    COMMITTED    DATE    LAST SALE  MTD SALES  YTD SERV$   BAD DEBT
-------------------------------------------------------------------------------------------------------------------

BALKIT  5  30  BALDWIN KITCHENER   10,000.00        .00      28.84     976.74      26.95        .00     976.74
                                    03/01/94        .00   08/17/94   06/07/94        .00        .00
               STAT: 0Ba00A------------------

BAZGOR  1  30  GORDON BAZZLE        2,000.00   5,131.56     366.99   5,131.56   5,431.48        .00   5,131.56
                                    05/16/89      86.10   08/15/94   09/25/94   4,722.44        .00 SIN:666-111-222
               STAT: aaaa0baa0aaa000-a-------

BOSCON    4 30 CONNY BOSLEY        20,000.00   7,968.60        .00   7,968.60   6,936.00        .00   7,968.60
                                    07/28/94        .00   00/00/00   08/15/94        .00      67.86 NEW
               STAT: ba----------------------

DIVCON    2 60 DIVINE CONSTRUCTION 40,000.00  18,646.25   2,000.00  86,516.07  50,520.26        .00  86,516.07
                                    03/06/87  11,840.79   09/15/95   08/17/94        .00   1,749.78 Q44111
               STAT: ddddddddcbaaaaabd-------
                                  ========== ==========            ========== ========== ==========

TOTALS:                               64,000     31,746               201,186  3,223,540
                                                 35,741                            5,466      1,818

NUMBER OF RECORDS PRINTED: 5


FIELDS:

SL GP       sales group
IN TP       interest type
CREDIT      credit limit
OPENED      date account opened
BALANCE     current balance
COMMITTED   amount committed in current sales
LAST PAY$   last payment amount
DATE        last payment date
HIGH BAL    highest ever balance
LAST SALE   date of last sale
YTD SALES   year to date sales dollars
MTD SALES   month to date sales dollars
YTD DISC$   year to date discount dollars
YTD SERV    year to date service charges
HIGH MTH    highest ever monthly balance
BAD DEBT    creditel number
STAT        monthly status string