Advanced line pairing

Advanced line pairing is needed when the quantities, prices, and totals from the Unpaired Lines from Invoice and the Available Lines from Purchase Order tables cannot be easily reconciled. You can manually perform advanced line pairing by clicking on the he Pair (Advance) button. This button is enabled when a row from the Unpaired Lines from Invoice table is selected and at least one line from the Available Lines from Purchase Order table is selected.

However, if you attempt simple pairing and a problem is encountered, the Advanced Pairing window is displayed automatically.

For example, if 100 pens were ordered, but the invoice lists 5 packs of 20. The Invoice total adds up but the quantity and price does not. You can correct this using advanced line pairing by adjusting the quantity and price values to match the total.

After clicking the button, the Advanced Pairing window is displayed where several fields are editable.

The editable fields include:

Qty
Price
Total
Tax Code
Sub Deb

All other fields are read-only and are greyed out if you click on them.

Use this window to control how much from an invoice line is booked to an ERP line. If plausible values are selected it is possible to update the entries accordingly. This means that the ERP line totals match the invoice line total (quantity * unit price = total).

Fully booked lines are moved down to the Paired Lines table and partially booked lines are split so that the booked portion is included in the Paired Lines table and the remainder is still in the Available Lines from Purchase Order table. In both cases, the row from the Unpaired Lines from Invoice table is removed.