4Reports and Inquiry
Option 6Vendor History Report
Use this function to print a monthly history of the amount of purchases made from, payments made to, and discounts received from each vendor. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Vendor History by Month information, this step provides you with a default sequencing of data records by Liability Account, Vendor Alpha, Vendor, Year and Month, giving additional sort order choice by Vendor Type, with the option to change modifiable parameters at run time. Selection of data records is provided by Liability Account, Vendor, Vendor Type, Year and Month, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all standard Accounts Payable reports.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Vendor History Report, this step formats the Vendor History by Month information. The following data items are shown: Month, Purchases, Disbursements and Discounts. As appropriate, group headings appear whenever a change occurs in Liability Account, Vendor or Year.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 09:59 LGG Page: 1
Vendor History Report
Mo Purchases Disbursements Discounts
=================================================================================================================================
Account 2010001001 Accounts Payable, Sales
Vendor 00000040 Albert Materials, Inc.
Fisc Year 90 Jun 8145.95 6628.78 130.00-
Jul 6619.85 16353.63 158.41-
Aug 4958.55 11538.01 180.53-
_____________ _____________ _____________
— Year Subtotals —> 19724.35 34520.42 468.94-
============= ============= =============
Fisc Year 89 Aug 1289.63 1489.44 35.35
Sep 874.20 569.33 22.14
Oct 1345.65 1586.32 31.68
Nov 662.39 810.47 19.62
Dec 544.45 449.98 18.54
Jan 1104.40 996.27 24.17
Feb 895.25 996.14 27.12
Mar 1002.55 1165.56 30.51
Apr 2265.42 1564.87 30.22
May 2014.60 1687.44 28.55
_____________ _____________ _____________
— Year Subtotals —> 11998.54 11315.82 267.90
============= ============= =============
Vendor 00000070 Insurances Unlimited
Fisc Year 90 Jun 254.80 6500.00 .00
Jul 254.80 254.80 .00
Aug .00 254.80 .00
_____________ _____________ _____________
— Year Subtotals —> 509.60 7009.60 .00
============= ============= =============
Fisc Year 89 Sep 8000.00 8000.00 .00
Dec 8000.00 8000.00 .00
Apr 8000.00 8000.00 .00
_____________ _____________ _____________
— Year Subtotals —> 24000.00 24000.00 .00
============= ============= =============
Vendor 00000080 Sam Jones
Fisc Year 90 Jun 2410.36 .00 .00
Jul 4253.38 2410.36 .00
Aug 2216.90 4253.38 .00
_____________ _____________ _____________
— Year Subtotals —> 8880.64 6663.74 .00
============= ============= =============
Vendor 00000010 Miscellaneous Supplier
Fisc Year 90 Jun 8595.67 5488.55 .00
Jul 2212.25 1344.52 .00
Aug 2559.50 9237.97 .00
_____________ _____________ _____________
— Year Subtotals —> 13367.42 16071.04 .00
============= ============= =============
Fisc Year 89 Feb 2500.00 2836.58 .00
Apr 7097.40 4731.40 .00
May 120.00 120.00 .00
_____________ _____________ _____________
— Year Subtotals —> 9717.40 7687.98 .00
============= ============= =============