Voucher History Report

This report allows you to generate a history of all invoice and manual check records that meet specified criteria. The report can be run by inventory item number (or a range) to see all of the vendors from whom you have purchased an item. If you include voucher detail, you can compare prices, and see how they have changed over time.

The report provides drill-down capabilities for Batch Code and Vendor Name.  

Values for credit memos will show as negative numbers; there will be no dollar values displayed for zero-check-type manual checks.

By default the report only displays vouchers that have not been voided; optionally, you can select the "Show Voided Only" checkbox to view only those vouchers that have been voided.

Report Options

The options screen appears similar to the following:

Use the following options to customize your report:

Note: If you do not specify either an Invoice Date Range or an Apply Date Range, all vouchers that meet your criteria for all dates are included on the report.

Tips and Tricks
This feature can help in tracking down incorrect purchase unit to inventory unit conversions. For example, assume you purchase beer by the case, and you inventory beer by the case, but you accidentally indicate a container to inventory unit conversion factor of 24 (instead of 1). Then you purchase a case of beer and enter the price as $18. Because the conversion factor is incorrect, the price per inventory unit is incorrectly set to $18/24 = $0.75. When you enter an inventory count, each case of beer will have a cost of 75¢ . Obviously, this will throw off your valuations. Running the Voucher History report with the Show Inventory Price option should allow you to identify items with incorrect conversion factors.

Note: If you discover that a voucher has been entered with items that have incorrect purchase unit to inventory unit conversion factors, you will need to either fix or void each voucher. For more information, see the topics Adjust Posted Vouchers, Void Invoices/Credit Memos, Void Manual Checks, and Manual Checks.

 

Note: The Export to Excel option is available directly from the Report Options screen.  After selecting your options, click the Export to Excel button to create a flat file format of all report data.

Report Data

You can generate a wide variety of reports depending on the options selected; Figure 1, Figure 2, and Figure 3 below show some examples.

Note: The Check # column in the examples below are empty because this column is only used by manual checks; other vouchers go by Doc #.

Figure 1. Voucher History (summary) for a Particular Vendor

 

 

Figure 2. Voucher History (detail) for Particular Inventory Items

 

 

Figure 3. Voucher History  for a Range of Accounts