Use this screen to print AP history information for a single vendor or for a group of vendors by voucher.
The report includes the: Vendor, Vendor Name, AP Acct/Org, Voucher, Entry User ID, Invoice (Number), PO (Number), Invoice Date, Invoice Amount, Discount Amount, Amount Due, Trans Currency, Check Number, Check/Void Date, FY, Pd, Subpd, Pay Vendor ID, Cash Account (Number), Cash Organization, Discount Taken, Amount Paid, and Pay Currency.
This report is particularly useful in the following situations:
A vendor requests that you send them their invoice and payment history.
An auditor requests a printout of the AP History.
A manager requests that a vendor's history include both the vouchers and the corresponding checks that were cut to pay those vouchers.
To have the most up-to-date information, post the vouchers and print the checks in question.
The report will list the AP history information by voucher and any checks that were printed against that voucher, including voided checks. Unrealized gains and losses will also be included in the report as part of the Vendor Total Voucher amount.
Select this radio button to print the history report by AP voucher. This is the default selection.
Select this radio button to print the history report by PO voucher.
Select this radio button to print the history report by travel voucher.
The report will include a subtotal for each voucher - if a vendor has more than one voucher and each voucher has a check history
If you use Costpoint Multicurrency, the report will also include the transaction currency code, the pay currency code, and the functional currency code.
The Total/Unrealized Gain/Loss amount added to the Vendor Total Vouchers amount equals the Vendor Total Paid amount since the amount paid includes the realized gains/losses.
Realized gains and losses are part and parcel of vendor payments. They arise from variances in the currency exchange rates that are used to calculate the translation from transaction to functional currency for Accounts Payable vouchers.
Select this radio button if you need to have only basic voucher information on your report (i.e., voucher number, vendor name, invoice number, invoice date, and invoice amount). This is the default selection.
Select this radio button if you need to have more detailed information on your report. This selection will include all of the information contained in the Vendor History Summary
Use the options in this drop-down box to specify how the report will be organized. The choices are "Vendor" or "Vendor ID."
Use this drop-down box to select the range of vendors to be included. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting vendor for the range you want to include. If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
Enter, or use Lookup to select, the ending vendor for the range you want to include. If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
Select this checkbox to insert a page break after each vendor.
Use this drop-down box to select the range of periods to be printed. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Use this drop-box to select the fiscal year for which you want the report printed. You can print a check register for only one fiscal year at a time. If more than one fiscal year is required, you need to print the report once for the first fiscal year, then again for each of the remaining fiscal years.
Use this drop-down box to select the starting period for the report. If you selected "All" or "From Beginning" in the Range Option field, this field will be inactive.
Use this drop-down box to select the starting subperiod for the report. If you selected "All" or "From Beginning" in the Range Option field, this field will be inactive.
Use this drop-down box to select the ending fiscal year for the report. If you selected "All," "One," or "To End" in the Range Option field, this field will be inactive.
Use this drop-down box to select the ending period for the report. If you selected "All," "One," or "To End" in the Range Option field, this field will be inactive.
Use this drop-down box to select the ending subperiod for the report. If you selected "All," "One," or "To End" in the Range Option field, this field will be inactive.
Use this drop-down box to select the range of vouchers to be printed. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting voucher for the range you want to include. If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
Enter, or use Lookup to select, the ending voucher for the range you want to include. If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
This group box will only be enabled if you select the Vendor History Detail radio button in the Report Format group box.
Select this checkbox if you want your report to contain voucher line notes.
Select this checkbox if you want your report to contain the vendor labor history.
Select this checkbox if you want your report to contain account names.
The following tables are accessed by this report:
VCHR_HDR_HS (Voucher Header History)
VCHR_LN_HS (Voucher Line History)
VCHR_LAB_VEND_HS (Voucher Labor Vendor History)
VCHR_LN_ACCT_HS (Voucher Line Account History)
VEND_CHK (Vendor Check)
VEND_CHK_VCHR (Vendor Check Voucher)
AP_UNREAL_G_L_HS (AP Unrealized Gain/Loss History)