IdealWare Online Users Manual

AP5-05 A/P LISTINGS, REPORTS AND FORMS
24755 Cash Requirements

 

PURPOSE

 

The Cash Requirements Report is used to determine the amount of your outstanding payables.

 

Cash Requirements Report is accessed from:

  • Accounts Payable Processing menu

 

PROCEDURE

 

Select Cash Requirements Report from the Accounts Payable Processing menu.

 

** STARTING SUPPLIER CODE (CR FOR FIRST):

 

Enter the code of the supplier from which you wish to begin the report.

 

[Enter] to begin at the first supplier on file.

 

[F5] to access supplier codes inquiry for selection.

 

** ENDING SUPPLIER CODE (CR FOR LAST):

 

Enter the code of the supplier at which you wish to end the report.

 

[Enter] to End at the last supplier on file.

 

[F5] to access supplier codes inquiry for selection.

 

** ACCRUED ONLY, PAYABLES ONLY OR BOTH? (A/P/B):

 

[Enter] to include both trade (accruals) and non-trade payables.

 

This is the default value.

 

 

"A" for accrued payables only.

 

"P" for non-trade payables only.

 

** STATUS ? (1=ON HOLD, 2=NOT ON HOLD, 3=BOTH, 4=PAYABLE):

 

Indicate the status of invoices to include.

 

"1" for on hold only.

 

"2" for not on hold only.

 

"3" for both on hold and not on hold.

 

"4" for invoices that are due immediately.


** SELECT BY TRANSACTION DATE OR DUE DATE? (T/D):

 

[Enter] to accept the default value.

 

"D" to select by due date.

 

"T" to select by transaction date.

 

You may divide the payables in up to four separate groups according cutoff dates.

 

** SELECTION DATE 1 (F2 FOR ALL):

 

Enter a date in MMDDYY format as the cutoff for the first group.

 

[F2] to include all invoices regardless of date.

 

** SELECTION DATE 2 (CR TO END, F2 FOR ALL AFTER DATE 1):

 

Enter a date in MMDDYY format as the cutoff for the second group.

 

[Enter] for no additional groups.

 

[F2] to include all invoices dated after the first date.

 

** SELECTION DATE 3 (CR TO END, F2 FOR ALL AFTER DATE 2):

 

Enter a date in MMDDYY format as the cutoff for the third group.

 

[Enter] for no additional groups.

 

[F2] to include all invoices dated after the second date.

 

** SELECTION DATE 4 (CR TO END, F2 FOR ALL AFTER DATE 3):

 

Enter a date in MMDDYY format as the cutoff for the fourth group.

 

[Enter] for no additional groups.

 

[F2] to include all invoices dated after the third date.

 

** PRINT SUMMARY OR DETAIL? (S/D):

 

[Enter] to accept the default value.

 

"S" to print a summary report.

 

"D" to print a detail report.

 

** PRESS CR TO CONTINUE:

 

[Enter] to generate the report.

 

[F4] to exit to the menu.

 

You are taken to the print 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 Cash Requirements Report follows.

  



                                             IDEAL BUILDING SUPPLIES LTD.
10/11/96  16:06:24                                                                                          PAGE: 1
                                    A/P CASH REQUIREMENTS REPORT BASED ON DUE DATE

----------------------------------------------------------------------------------------------------------------------
         FOLIO#/   INV REF#/    RECEIPT      INV DATE/                             UP TO      >DEC 31/94       AFTER
TYPE     RECEIPT   REC P.O.  PACKING SLIP#   REC DATE/  DUE DATE       TOTAL     DEC 31/94   <=DEC 31/95     DEC 31/95
----------------------------------------------------------------------------------------------------------------------

ACKLANDS                  (ACKLA)
---------------------------------

INVOICE  000001    123456                    09/26/94  10/20/94     2,129.30      2,129.30           .00           .00
         000006    INV#1234                  06/15/94  07/20/94       128.40        128.40           .00           .00
         000014    61555                     05/27/96  06/20/96       562.82           .00           .00        562.82
         000028    234598                    08/08/96  09/20/96       492.06           .00           .00        492.06
         000029    3456                      08/08/96  09/20/96     2,293.36           .00           .00      2,293.36
         000044                              02/15/96  03/20/96       107.00           .00           .00        107.00
         011851    4368168192                08/10/94  09/20/94        46.38         46.38           .00           .00
         011855    4368-167678               08/02/94  09/20/94        38.56         38.56           .00           .00
         012049    4368-167896               08/04/94  09/20/94       291.48        291.48           .00           .00
         012172    4368168994                08/24/94  09/20/94       580.69        580.69           .00           .00
         012173    16/8939                   08/23/94  09/20/94       249.67        249.67           .00           .00
         012299    4368169297                08/29/94  09/20/94         9.23          9.23           .00           .00
         012324    4368169308                08/30/94  09/20/94        80.30         80.30           .00           .00
         012365    5640069677                08/25/94  09/20/94       267.66        267.66           .00           .00
                                                                  ----------    ----------    ----------    ----------
                                             INVOICE TOTALS:        7,276.91      3,821.67           .00      3,455.24

RECEIPT  000016              12354           08/09/95  09/20/95       500.00           .00        500.00           .00
         000019    100048    12345           01/11/96  02/20/96       120.00           .00           .00        120.00
         000023    100059    123456          01/30/96  02/20/96     1,706.80           .00           .00      1,706.80
         000024    100061    1234567         01/30/96  02/20/96    12,588.38           .00           .00     12,588.38
         000027    100067    141251515       04/19/96  05/20/96       321.07           .00           .00        321.07
         000028              1231414         04/19/96  05/20/96     2,690.68           .00           .00      2,690.68
         004309                              08/02/94  09/20/94       130.98        130.98           .00           .00
         005241                              08/17/94  09/20/94       197.15        197.15           .00           .00
                                                                  ----------    ----------    ----------    ----------
                                             RECEIPT TOTALS:       18,255.06        328.13        500.00     17,426.93
                                                                  ----------    ----------    ----------    ----------
                                             SUPPLIER TOTALS:      25,531.97      4,149.80        500.00     20,882.17
                                                                  ----------    ----------    ----------    ----------
                                             GRAND TOTALS:         25,531.97      4,149.80        500.00     20,882.17
                                                                  ==========    ==========    ==========    ==========




FIELDS:                                  

TYPE                     type of payable (invoice or receipt)
FOLIO#/RECEIPT           folio # (for invoices) / receipt # (for receipts)
INV REF#/REC P.O.        invoice # (for invoices) / purchase order # (for receipts)
RECEIPT  PACKING SLIP#   receipt # (for invoices) / packing slip # (for receipts)
INV DATE/ REC DATE/      invoice date / receiving date
DUE DATE                 payment due date
TOTAL                    total amount payable