Invoice Matching Report Fields

Key Client or Client Group or leave both blank and click All Clients checkbox.

Key Product or Product Group or leave both blank and click All Products checkbox.

Key Media or leave blank and click All Media checkbox.

Key Media or leave blank to click the All Media checkbox.

To sort by edition, key or select the edition code.

To sort by Zone, key the zone code.

Optional. Key the Start and End Dates to define the date range for this report.

Lists a summary of activity by month for selected criteria. An aging breakdown is provided of the discrepant activity. To include vendor detail on this report, click to check the Detail Report check box.

Lists detailed activity for selected criteria. On this report, items which were matched with a cash discount discrepancy are flagged with * in the CD column.

Choose between Client/Vendor  or Vendor/Client from the dropdown.

To route this report to a user by having the userID print on the top of each page, key the user ID.

Leave the Print User ID in Heading blank and only click All User IDs to report, on its own page, the name of each User who keyed and saved entries in clearances. Each user page will report that user's entries.

Used in conjunction with Match UserID Against Invoice. If checked, a user ID must be entered in Print User ID in Heading field or all user IDs must be checked.

Default.  Or Match User ID against the Buy.

Discrepancies where the invoice items matched as Unapproved because they do not match the amount ordered.

Discrepancies where the invoice item was unapproved because there is no buy on file showing it was ordered.

Buying activity that is over 30 days old (from report requested date) but not yet matched to an invoice.

Buying activity that was matched but not yet cleared.

Click the Exclude CD Adjustments check box to exclude discrepant buys that are only cash discount adjustments.

To limit the report to buys with a cash discount, click the Cash Discount Buys Only check box.