Invoice reconciliation

Three types of reconciliation are available in Vendor Invoice Center Entry: line, back order, and item. You can change the type after an invoice has been updated and re-run final update to try reconciling using a different type.

Line reconciliation is the default reconciliation method in Vendor Invoice Center Entry and requires you to cost purchase orders line by line. You must enter the purchase order number, purchase order suffix, and line number when using this method, or you receive an error.

Back order reconciliation is similar to line reconciliation. The main difference is that you do not have to enter the correct suffix. With back order reconciliation, all purchase orders are matched against suffix –00 in Vendor Invoice Center Entry. The reconciliation process looks at all suffixes to find the quantity on the invoice.

Item reconciliation only requires that you enter a purchase order number and product. You do not have to enter the line number or suffix. This reconciliation method is also used for items added through EDI with the EDI Entry Processing Invoices Report. When reconciling items added from the EDI Entry Processing Invoices Report, the purchase order number, suffix, and line number entered in Vendor Invoice Center Entry are reviewed first. If there is a quantity left over, all suffixes are reviewed for that line number. If there is still a quantity left over, all lines on the purchase order are reviewed for the same product. If you use the item reconciliation method, specify the PO number, product, quantity and cost. Reconciliation does the rest of the work automatically. This method works well when the invoice has one line but product is on multiple lines on the purchase order.

You can run more than one Vendor Entry Batch Reconciliation Report at a time. Purchase orders are flagged as in use when being matched, so they cannot be picked up by more than on Vendor Entry Batch Reconciliation Report at a time.