4Reports and Inquiry
Option 4Transaction History Report
Use this function to print transaction history information for your vendors. You also have the option to include current transactions on this report. If you have selected to include the current transactions but no historical transactions exist for a vendor, no transactions are printed for the vendor. The following processing steps accomplish this job.
- Step 1This function checks to see whether the end user has chosen to keep Transaction History, before executing any function that requires the file.
- Step 2This function allows you to choose to include current transactions in addition to historical information on the Transaction History Report.
On the following pages, the screen displayed by this function is shown.
The screen shown below allows you to choose to include current transactions (information from the Transaction file) on the report.
Transaction History Report screen
Data items for the preceding screen are described below:
- Include Current Transactions?
Y or N Default N Required
Indicate whether or not to include the current transactions in this report.
- Y
- Provided that Transaction History records exist for the vendor, include both Transaction History and Current Transactions data on the report.
- N
- Only Transaction History information is included on the report.
Press ENTER to save the information on this screen.
- Step 3In preparation for performing a sort/selection process on the Transaction History information, this step provides you with a default sequencing of data records by Liability Account, Vendor and Apply To, giving additional sort order choice by Post Month and Post Year, with the option to change modifiable parameters at run time. Selection of data records is provided by Liability Account, Vendor, Apply To, Operator ID, Post Month and Post Year, with the option to enter user-specified comparisons at run time.
- Step 4This disposition type is used for all standard Accounts Payable reports.
- Step 5According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 6In order to print the Transaction History Report, this step formats the Transaction History information. The following data items are shown: Operator ID, Control Number, Transaction No, Post Month, Post Year, Apply To, Invoice/Check Number, Transaction Type Abbreviation, PO No, Transaction Date, Transaction Desc, Discount Amount, Retention Amount and Amount. As appropriate, group headings appear whenever a change occurs in Post Month, Liability Account or Vendor. If requested, totals appear whenever a change occurs in Vendor, Liability Account or Post Month. When totals are specified, the following items are accumulated: Discount Amount, Retention Amount, Amount and Total Balance. Grand totals print at the end.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 09:58 LGG Page: 1
Transaction History Report
Op Cntrl Trx Post Invc/ Trx Trx Discount Retention
ID No No Mo / Yr Apply To Chck No Typ PO No Date Description Amount Amount
Amount
=================================================================================================================================
Account 2010001001 Accounts Payable, Sales
Vendor 00000010 Miscellaneous Supplier ( ) - FAX ( ) -
SRR 1 13 06 / 89 254 254 INV 06/30/89 Plumbing repairs .00 .00 387.90
SRR 4 6 07 / 89 254 5205 PMT 07/10/89 Plumbing repairs .00 .00 387.90-
SRR 0 5 05 / 89 418-6 418-6 INV 05/01/89 supplies .00 .00 222.00
SRR 2 4 06 / 89 418-6 5103 PMT 06/01/89 supplies .00 .00 222.00-
SRR 0 1 04 / 89 89121000 89121000 INV 04/28/89 tables .00 .00 600.00
SRR 4 7 07 / 89 89121000 5206 PMT 07/10/89 tables .00 .00 600.00-
SRR 0 2 05 / 89 90011000 90011000 INV 05/08/89 file cabinets .00 .00 200.12
SRR 4 8 07 / 89 90011000 5207 PMT 07/10/89 file cabinets .00 .00 200.12-
SRR 0 3 05 / 89 987987 987987 INV 05/10/89 office painting .00 .00 1500.00
SRR 2 5 06 / 89 987987 5104 PMT 06/01/89 office painting .00 .00 1500.00-
SRR 0 4 05 / 89 HO/88 HO/88 INV 05/03/89 Calculators .00 .00 156.50
SRR 4 9 07 / 89 HO/88 5208 PMT 07/10/89 Calculators .00 .00 156.50-
____________
— Vendor Total —> .00
============
Vendor 00000020 Pool and Associates (206) 555-4778 FAX (206) 555-4777
SRR 0 6 05 / 89 101 101 INV 05/07/89 brochures .00 .00 985.36
SRR 4 12 07 / 89 101 5211 PMT 07/10/89 Pool and Associates .00 .00 985.36-
SRR 0 7 05 / 89 108 108 INV 05/19/89 advertising .00 .00 6685.32
SRR 1 4 06 / 89 108 703 PMT 06/22/89 payment .00 .00 6685.32-
SRR 0 8 04 / 89 112 112 INV 04/15/89 brochure development .00 .00 1000.00
SRR 2 7 06 / 89 112 5106 PMT 06/01/89 Pool and Associates .00 .00 1000.00-
SRR 0 9 05 / 89 202 202 INV 05/19/89 ads .00 .00 987.66
SRR 2 7 06 / 89 202 5106 PMT 06/01/89 Pool and Associates .00 .00 987.66-
SRR 0 10 04 / 89 203 203 INV 04/02/89 brochures .00 .00 3521.44
SRR 2 7 06 / 89 203 5106 PMT 06/01/89 Pool and Associates .00 .00 3521.44-
SRR 1 1 06 / 89 40512 40512 INV 06/15/89 Summer magazine ad .00 .00 3321.56
SRR 4 12 07 / 89 40512 5211 PMT 07/10/89 Pool and Associates .00 .00 3321.56-
SRR 2 1 06 / 89 89061000 89061000 INV 06/10/89 Advertising Retainer .00 .00 500.00
SRR 4 12 07 / 89 89061000 5211 PMT 07/10/89 Pool and Associates .00 .00 500.00-
SRR 0 11 04 / 89 98566 98566 INV 04/10/89 mailers .00 .00 1051.31
SRR 2 7 06 / 89 98566 5106 PMT 06/01/89 Pool and Associates .00 .00 1051.31-
___________
— Vendor Total —> .00
============