The Invoice Summary to Workfile Control Report

You use the Invoice Summary to Workfile Control Report (R48S751) to verify that the amounts in the Billing Detail Workfile and Billing Workfile History tables (F4812 and F4812H) match the amounts in the Invoice Summary Work File table (F4822).

The system uses either table F4812 or table F4812H, depending on the current status of the invoice in the F4822 table. For invoices that have not been processed by the Create A/R Entries program (R48199), the system uses table F4812. The system uses table F4812H for invoices that have been processed by the Create A/R Entries program.

For each record in the F4822 table, the report selects the corresponding F4812 or F4812H records and totals the amounts. Any discrepancies between the totals of the F4812 or F4812H records and the F4822 record are listed on the error report.

The report compares amounts from these fields:

Fields from the F4812 table or the F4812H table	Comparison	Fields from the F4822 table
Amount - Invoice (ITOL)	should equal	This Period (THPD)
Amount - Foreign Invoiced (CITL)	should equal	This Period - Foreign (FHPD)
Amount - Invoice Tax (ITAM)	should equal	Amount - Tax (STAM)
Amount - Foreign Invoice Tax (CITX)	should equal	Amount - Foreign Tax (CTAM)

In addition, when the Tax Explanation code for the F4822 record is E (Value Added Tax Exempt) or blank, the report compares the amounts from these fields:

Fields from the F4812 table or the F4812H table	Comparison	Fields from the F4822 table
Amount - Invoice Taxable (ITXA)	should equal	Amount - Non-Taxable (ATXN) or Amount - Taxable (ATXA)
Amount - Foreign Invoice Taxable (CITA)	should equal	Amount - Foreign Non-Taxable (CTXN) or Amount - Foreign Taxable (CTXA)

You can print the report in summary or detail mode. The summary report includes invoice information from the F4822 table. The detail report includes both invoice information from the F4822 table and the corresponding information from the F4812 or F4812H tables. You use the processing options to specify whether to print the summary or detail report.