AP Check History Report That Includes Voided Check

AP Check History Report That Includes Voided Check

Q - Is there a flag that would allow me to view all AP checks including voided checks and the original checks that were voided?.

A - Under A/P -> Reports -> Check History Report -> Print, there are three different kinds:
  1. Check History Report
  2. All Checks History Summary
  3. All Checks History Detail
You can see all check records, including the voided checks in 2 and 3 - All Checks History Reports.  The following are brief descriptions of these three different versions of Check History Reports:

Check History Report
This report is the legacy implementation of check history based on A/P Open Item table (APOPNFIL).  Since voided checks are not in A/P Open Item table, this report will not print voided checks.  Also, if the A/P Open Item table is purged (sometimes you do this to get rid of old fully paid vouchers), then you will not see those purged checks on this report either.  See sample report below:



All Checks History Summary
This report is based on the new table APCHKHST. We introduced this table in October 2014 because we realized the limitations of the legacy check history report.  All checks print, including:
  • Those voided because multiple check forms are required for check stubs.
  • Those voided after the check is posted.
Those voided checks are stored in this table. It is a complete history of all AP checks.  The summary version is printed by check number sequence with one line per check. See sample report below:




All Checks History Detail
Similar to "All Checks History Summary," this report is based on the new table APCHKHST.  The summary report will only print one line per check and is by the check number sequence.  The detail version prints by vendor number sequence. It will show the vendor name, as well as the voucher details of the check.  See sample report below:






    • Related Articles

    • How to Find a Voided AP Check in Check History Report

      Release Date: 6/14/17 Q - When I VOID an AP check and run the CHECK HISTORY report, the voided check does not show up on the Check History Report. Where can I find the settings to correct this? A - There are three different Check History reports. The ...

    • Feature - AP Check History CSV Creation

      Release date: 11/21/17 In AP --> Reports --> Check History --> Print --> Checks History report, the ability to create a CSV file has been added: Fields on the CSV include: Vendor#, Name, Check#, CheckDate, Voucher#, PO#, Invoice#, InvoiceDate, ...

    • AP11S1 Accounts Payable Check History Report

      Check History Report Application Overview The Check History Report accesses the A/P Open Item File for check information. The A/P Open Item File contains information since the last purge date (date for which the Purge A/P Open Item File was last ...

    • Feature - Do Not Allow AP Check To Be Voided If It Is Already Reconciled

      Release Date: 12/12/22 Version: 8.5 and Above This feature allows you to control whether reconciled Accounts Payable checks can be voided if already reconciled. To support this feature, a new option has been added to Global Setup, Acct, A/P Global ...

    • Values in APCHKHST (AP Check History) Status Column (APCHKHST_STATUS)

      Release Date: 1/10/2018 Q - I see the value of "M," "C" and "P" in the column of the APCHKHST_STATUS column in the APCHKHST table. I presume "C" means computer check, "M" means manual check. What does "P" mean? If a check is cancelled is there a code ...