Issue/Symptom/Question

The Vendor Payment Summary report (Legacy) and the Vendor Purchase History report (Workbench) show different Total Payment Amounts. Why is there a variance and which report is accurate?

Applies To

PENTA for Windows

PENTA Reports by Module > Accounts Payable > Vendors > Vendor Payment Summary

Workbench

AP: Accounts Payable Reporting Center > Vendor Purchase History 

Resolution/Fix/Answer

The two reports are not identical and therefore show different Total Payment amounts.

Vendor Payment Summary report (Legacy) 

• Provides a summary of payments made to a vendor in a specified date range. 
• The report uses the distribution date of the check to determine which payment amounts it includes. 

Vendor Purchase History report (Workbench)

• Provides vendor purchase history information; it includes all invoices (open or paid in full) that fall in the selected date range. 
• Use this report to determine how much you purchased from selected vendors over a period of time.
• This report uses the "Begin Date" and "End Date" to determine which purchase amounts it includes. A panel filter lets you choose between the distribution date or posting date of the invoice as the basis for determining which invoices it includes.