EDI Viewer - Invoice Detail Variance Report

Description: The Invoice Detail Variance Report is designed to compare 2 invoices and show the variance percentages between them. It compares the most current month of both invoices to each other. It is designed to help find any errors that may be on the invoice.

For example, if you chose to run this report on your March 1999 invoice, the report would compare production month 1999-03 on the March invoice to the 1999-02 production month on the February invoice.

If you enter a percentage at the top of the report in any of the 6 variances, the report returns those streams that are greater or lower than those percentages. The right side of the window gives you have 3 choices for variance percentages:

(+/-) if 10% was entered, this would return data that is greater than 10% or less than 10%, eg. current month is 10% higher or 10% lower than previous month
(+) if 10% was entered, this would return only data that is greater than 10%, eg. current month 10% higher than previous month
(-) if 10% was entered, this would return only data that is less than 10%, eg. current month 10% lower than previous month

The example above would only show data where:

  • the crown volume is 10% higher or lower and
  • the gross royalty is 30% higher or lower and
  • the net royalty is 30% higher or lower

than the previous month invoice data.

You can use 1 variance, 2 variances, or any combination of variance percentages to return data to help find any exceptions on the invoice.
Report Totals: No summary totals on this report.
Sort Order: Client code, Facility, Stream ID code, and Product code
Page Breaks: Client code - a change of client code will start on a new page.
Columns on the Report: Please see EDI Viewer - Column Definitions for a description of the columns on the report