IdealWare Online Users Manual

AP5-18 A/P LISTINGS, REPORTS AND FORMS
24768 Supplier Ledger

 

PURPOSE

 

The supplier ledger report program prints the same information that is available through the supplier ledger inquiry program. See 24594 SUPPLIER LEDGER INQUIRY.

 

Ideal recommends you include supplier ledger report in your month end/year end routine to provide you with a detailed listing of all outstanding invoices. Together with your aged trial balance it will give you an accurate picture of money owed at month end.

 

Supplier Ledger Report is accessed from:

  • Account Payables Month End menu

 

PROCEDURE

 

Select Supplier Ledger Report from the Account Payables Month End menu.

 

** START AT ? (CR=FIRST):

 

Enter the supplier code begin the report.

 

[Enter] for first supplier code.

 

[F4] to exit to menu.

 

** END AFTER ? (CR=LAST):

 

Enter the supplier code with which to end the report.

 

[Enter] for last supplier code.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** INCLUDE INVOICES FROM HISTORY? (Y/N): N

 

[Enter] or "N" to not include invoices from history.

 

This is the default setting.

 

 

"Y" to include invoices from history.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** GUARANTEED ONLY ? (Y/N/CR):

 

"Y" for guaranteed only.

 

"N" for not guaranteed only.

 

[Enter] for Both.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** PRINT UNPAID INVOICES UP TO WHAT DATE? (CR=PERIOD ENDING DATE): MMDDYY

 

Enter the last date to include unpaid invoices.

 

[Enter] for end of current period.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** PRESS CR TO CONTINUE:

 

[Enter] to generate the report.

 

[F3] to re-enter previous field.

 

[F4] to exit to 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 Accounts Payable Supplier Ledger Report follows.

  



                                             IDEAL BUILDING SUPPLIES LTD.
07/25/96  13:50:34                                                                                          PAGE: 1
                                              A/P SUPPLIER LEDGER REPORT
                                          (BOTH GUARANTEED & NOT GUARANTEED)

----------------------------------------------------------------------------------------------------------------------
                                  INVOICE   SOURCE HLD DISCOUNT    DUE      $       GROSS       DISCOUNT         NET
FOLIO# YRD  REFERENCE               DATE    BATCH  FLG   DATE      DATE    TYP      AMOUNT     AVAILABLE        AMOUNT
----------------------------------------------------------------------------------------------------------------------

ACKLA     ACKLANDS

000001  01  123456                09/26/94  PI0001     10/20/94  10/20/94  CN     2,129.30                    2,129.30
000006  01  INV#1234              06/15/94  PI0005     07/20/94  07/20/94  CN       128.40                      128.40
000007  01  INV#543211234         06/02/94  PI0005     07/20/94  07/20/94  CN       214.00                      214.00
011851  01  4368168192            08/10/94  PI0343     09/20/94  09/20/94  CN        46.38                       46.38
011855  01  4368-167678           08/02/94  PI0343     09/20/94  09/20/94  CN        38.56                       38.56
012049  01  4368-167896           08/04/94  PI0349     09/20/94  09/20/94  CN       291.48                      291.48
012172  01  4368168994            08/24/94  PI0349     09/20/94  09/20/94  CN       580.69                      580.69
012173  01  16/8939               08/23/94  PI0349     09/20/94  09/20/94  CN       249.67                      249.67
012299  01  4368169297            08/29/94  PI0353     09/20/94  09/20/94  CN         9.23                        9.23
012324  01  4368169308            08/30/94  PI0353     09/20/94  09/20/94  CN        80.30                       80.30
012365  01  5640069677            08/25/94  PI0354     09/20/94  09/20/94  CN       267.66                      267.66
                                                                                ----------    ----------    ----------
                                  RECORDS: 11                                     4,035.67                    4,035.67

CINDU     CANADIAN INDUSTRIAL

011857  01  541783                08/08/94  PI0343     09/20/94  09/20/94  CN         6.53                        6.53
012168  01  541980                08/15/94  PI0349     09/20/94  09/20/94  CN       403.39                      403.39
                                                                                ----------    ----------    ----------
                                  RECORDS: 2                                        409.92                      409.92

MACMI     MACMILLAN BLOEDEL

000016  01  A61244                06/10/96  PI0013     07/15/94  07/15/94  CN     4,815.00         45.00      4,770.00
000017  01  514423                06/11/96  PI0014     07/15/94  07/15/94  US     3,076.25         28.75      3,047.50
                                                                                ----------    ----------    ----------
                                  RECORDS: 2                                      7,891.25         73.75      7,817.50

TAIGA     TAIGA FOREST PRODUCTS LTD

000018  01  614144                06/11/96  PI0014     07/15/96  07/15/96  CN     3,994.68         37.33      3,957.35
012391  01  10-78943              09/01/94  PI0355     10/15/94  10/15/94  CN    27,592.09        257.87     27,334.22
                                                                                ----------    ----------    ----------
                                  RECORDS: 2                                     31,586.77        295.20     31,291.57

 TARCO     TARGET CONCRETE PRODUCTS

012029  01  01-68584              08/08/94  PI0347     09/20/94  09/20/94  CN     1,347.69                    1,347.69
012030  01  01-68583              08/04/94  PI0348     09/20/94  09/20/94  CN     1,014.36                    1,014.36
012253  01  01-69112              08/19/94  PI0352     09/20/94  09/20/94  CN     1,347.69                    1,347.69
012290  01  01-68774              08/09/94  PI0353     09/20/94  09/20/94  CN       462.24-                     462.24-
012291  01  01-69246              08/22/94  PI0353     09/20/94  09/20/94  CN       346.68-                     346.68-
012307  01  01-69589              08/31/94  PI0353     09/20/94  09/20/94  CN     1,347.69                    1,347.69
012308  01  01-69426              08/29/94  PI0353     09/20/94  09/20/94  CN       374.37                      374.37
012309  01  01-69470              08/31/94  PI0353     09/20/94  09/20/94  CN       197.82                      197.82
012434  01  01-69523              08/29/94  PI0356     09/20/94  09/20/94  CN       191.34                      191.34
                                                                                ----------    ----------    ----------
                                  RECORDS: 9                                      5,012.04                    5,012.04

GRAND TOTALS:                     RECORDS: 26                                    48,935.65        368.95     48,566.70
                                                                                ==========    ==========    ==========


FIELDS:

FOLIO#               invoice number
YRD                  yard code
REFERENCE            reference
INVOICE DATE         date of invoice
SOURCE BATCH         source batch
HLD FLG              hold flag set?
DISCOUNT DATE        discount date
DUE DATE             due date
$ TYP                currency code
GROSS AMOUNT         gross amount
DISCOUNT AVAILABLE   amount of discount available
NET AMOUNT           net amount