A/P Invoice Upload Report

How to print: The system generates this report through the CDC job (WPBJ). The report is generated for the user who started the CDC job when the job processes any uploaded invoices that are not in error. Until you end this job, the report is in OPN status and you cannot view or print it. The system also generates this report when you select Process at the Work with A/P Invoice Upload Screen (WAPU) and produce open or suspended A/P invoices.

For more information: See the sample report in PDF format.

Contents: This report lists each suspended and open batch produced through the A/P invoice upload. If there are A/P invoice upload records for multiple companies, the report includes each company, starting each on a separate page. The system puts an uploaded invoice in open status if the A/P Invoice Upload Auto Accept Batch (H73) system control value is selected, and if the entire invoice passes each of the checks against additional charges and unit or cost variance described below. For each batch, the report includes:

• A/P batch number

• vendor number

• for the A/P invoice total:

• vendor number

• invoice number

• purchase order number

• invoice date (the date specified by the vendor, as opposed to the date that the invoice was uploaded)

• merchandise total for all included detail lines

• total of all header-level and detail-level freight, handling, and other charges

• for each A/P invoice detail line, header or detail charge:

• vendor number

• invoice number

• purchase order number

• invoice date (the date specified by the vendor, not the date that the invoice was uploaded)

• item number. Charges are identified as:

• HDRFRTCHG = header-level freight charge • HDRHNDCHG = header-level handling charge • HDROTHCHG = header-level other charge • DTLFRTCHG = detail-level freight charge • DTLHNDCHG = detail-level handling charge • DTLOTHCHG = detail-level other charge

• SKU, if any

• quantity specified in the uploaded invoice (for header or detail charges, the quantity is 1)

• original units shipped on the purchase order

• unit cost specified in the uploaded invoice

• original unit cost from the purchase order

• indication whether the particular invoice line has breached a threshold. The system performs the checks described below only if the A/P Invoice Upload Auto Accept Batch (H73) system control value is selected. These checks are performed only on regular (debit) invoices. Possible breaches are:

• VND-HDRFRT = The header-level freight charge exceeds the limit specified for the vendor. • VND-HDRHND = The header-level handling charge exceeds the limit specified for the vendor. • VND-HDROTH = The header-level "other" (miscellaneous) charge exceeds the limit specified for the vendor. • VND-DTLFRT = The detail-level freight charge exceeds the limit specified for the vendor. The system checks the vendor’s limit if there is no limit specified for the vendor item, or if the vendor item limit is not exceeded. • VND-DTLHND = The detail-level handling charge exceeds the limit specified for the vendor. The system checks the vendor’s limit if there is no limit specified for the vendor item, or if the vendor item limit is not exceeded. • VND-DTLOTH = The detail-level "other" (miscellaneous) charge exceeds the limit specified for the vendor. The system checks the vendor’s limit if there is no limit specified for the vendor item, or if the vendor item limit is not exceeded. • VIT-DTLFRT = The detail-level freight charge exceeds the limit specified for the vendor item. • VIT-DTLHND = The detail-level handling charge exceeds the limit specified for the vendor item. • VIT-DTLOTH = The detail-level "other" (miscellaneous) charge exceeds the limit specified for the vendor item. • COST VAR % = The unit cost exceeds or falls short of the A/P transaction cost by the A/P Invoice Upload Cost Variance Percent (H75). • UNIT VAR % = The unit quantity exceeds or falls short of the A/P transaction quantity by the A/P Invoice Upload Unit Variance Percent (H74).