Skip to main content

PO Matching - one invoice item line to multiple PO lines

Match a single invoice line to several lines on the same purchase order

R
Written by Ryan Goetz

Overview

An invoice line sometimes covers more than one line on a purchase order. A vendor may bill a product in one line that the PO lists at two or more unit prices, or one invoice line may cover several related PO lines, such as the same chair ordered in three colors.
​

In Manual Match Mode, you can match one invoice line to several PO lines on the same PO. Vic.ai splits the invoice line's quantity across those PO lines, checks the line against your tolerance rules once, and shows it on the invoice as a single grouped line.

This applies to line-level PO matching only. Document-level invoices use the standard manual match functionality.


Getting started

If you'd like to enable this feature, please contact your Vic.ai account representative or Vic.ai Support to enable this feature.

How to match an invoice line to multiple PO lines

  1. Open an invoice with a PO.

  2. Make sure the PO lines are expanded (View PO is switched on and shows green).

  3. Click Enter Manual Match Mode.

  4. On the invoice line you want to match, click Find Match.

  5. In the match window, find the PO lines the invoice line covers. Search or filter the candidate PO lines by item ID, description or unit price. Search and filters cover every candidate line, not only the lines on the current page.

  6. Tick each PO line the invoice line covers. To select related lines in one step, tick a line, then click a shortcut (Item ID, Description, Unit Price or Quantity). Vic.ai adds every PO line in the current filter that shares that value with the ticked line. You can untick any line afterward.

  7. Review the summary before matching. It shows the number of selected PO lines, the target PO, the selected lines' available quantity compared with the invoice quantity (fully covered, partially covered or over-covered), and the quantity-weighted PO unit price next to the invoice unit price.

  8. Click Match selected. The invoice shows "Matching POs…" while Vic.ai makes the match, and the result appears without reloading the page.

Selection rules

  • All selected PO lines must be on the same PO. Once you tick a line, lines on other POs are unavailable until you clear your selection.

  • A shortcut is unavailable, with a hint, when no other PO line in the current filter shares that value with your ticked lines. A PO line with a unique value is never added by a shortcut; tick it directly.

How the quantity is split

Vic.ai allocates the invoice line's quantity across the selected PO lines in PO line order, filling each PO line's available quantity before moving to the next. Any selected PO lines left over once the invoice quantity is covered stay unmatched.

If the selected lines don't have enough available quantity to cover the invoice line, the line is partially matched and the shortfall is shown.

Allocation is by quantity only. An invoice line with a quantity of 1 is matched to one unit on one PO line. Vic.ai splits the invoice line by quantity, not by amount. If an invoice line is billed as a single total with a quantity of 1 (for example, “Installation services – $5,000”), it’s matched to one unit on one PO line. It can’t be spread across several PO lines by dollar amount.

If two people match against the same PO lines at the same time, each match uses only the quantity still available, so a PO line is never over-consumed.

How grouped lines appear on the invoice

  • The grouped invoice line appears as one row with its total matched quantity and matched line amount.

  • Expand the row to see each PO line with its allocated quantity and amount. Large groups open in a scrollable, searchable window.

  • Quantity, unit price, and amount comparisons appear once, on the grouped line. The individual PO line rows show their allocated values without comparison markers. Item ID and description are compared for each PO line separately.

  • Invoice line pages never split a group across two pages.

Tolerances and mismatch approvals

Vic.ai checks your PO tolerance rules once for the grouped line:

  • Unit price is compared using the quantity-weighted price of the PO lines the invoice line was allocated to. For example, 4 units at $10.00 and 6 units at $12.00 give a weighted price of $11.20. This is the same price shown in the summary before you match.

  • Quantity and line amount are compared against the full quantity and amount of each PO line in the group, not only the portion this invoice line used.

If the grouped line is outside tolerance, Vic.ai raises one mismatch approval for the whole line. The approval is attached to the group's first PO line (the lowest PO line number), which is always listed first.

  • The approval status and the Get Approval, Cancel, Approve and Reject actions appear on the collapsed grouped row and, when the row is expanded, on the first PO line row. The other PO line rows show their own status, such as Matched or Pending Receipts, with no approval action.

  • The approval popup names the invoice line and the number of PO lines it is matched to.

  • On the PO approval page, the approver sees the grouped line as one row with the approval actions.

  • If your mismatch flow is set to start approval automatically, the approval starts when the match is made, as it does for a single PO line match.

PO lines that require receipts

PO lines that require receipts can be part of a group. Each PO line shows Pending Receipts based on its own received quantity.

When goods are recorded against a PO line in the group, Vic.ai re-matches the invoice line and checks it against your tolerance rules again. If no discrepancy remains, the line clears for posting on its own. Any earlier mismatch approval on the line is replaced by the result of this check, and another approval is raised only if a discrepancy remains. Single PO line matches that are waiting only on receipts clear the same way.

Grouped lines track receipts at the PO line level. You can't select individual receipt lines for a grouped invoice line, and an invoice line that is already matched to receipt lines can't be matched to multiple PO lines.

PO line dimensions

If your company copies PO line dimensions onto matched invoice lines, a grouped invoice line receives a dimension only when every PO line in the group has the same value for it. If any copied dimension differs across the group, no dimensions are copied and the invoice line keeps its existing values. Locked dimensions follow your company's existing locked-dimension setting.


Changing or unmatching a grouped match

  • Unmatch removes the whole group at once, along with any copied dimensions.

  • Editing the invoice line's quantity re-allocates it across the same PO lines and re-applies copied dimensions.

  • If a PO line in the group changes in your ERP, Vic.ai unmatches the group and runs automatic matching for the invoice line again.

  • If a PO line in the group is deleted, the group is unmatched. Match the invoice line again in Manual Match Mode.

  • Deleting the invoice removes the group and any approval on it.

Automatic matching for products at several prices

Some POs list the same product at more than one unit price. Because those lines share a description, automatic matching can place an invoice line on the wrong price tier. With price-aware matching, Vic.ai gives more weight to how close the invoice line's unit price is to each PO line's price, so each invoice line is matched to the PO line at its own price.

  • Automatic matching still links one invoice line to one PO line.

  • If an invoice line's item ID or description identifies the product, it is matched to the PO line with the closest price, and your unit price tolerance rule flags any gap for approval.

  • If an invoice line's price is far from every candidate PO line and its item ID and description don't identify the product, it may stay unmatched so you can match it manually.

  • Price-aware matching applies to line-level PO matching only.

Tips for success

  • Filter first. On large POs, filter by unit price or item ID before ticking lines so the selection stays focused.

  • Check the summary. A partial or over-covered result before you match usually means a line is missing or extra.

  • Use the Unit Price shortcut for price tiers. It selects every line at the same price as the line you ticked.

  • Act on approvals from the grouped row. There is only ever one approval per grouped invoice line.

Frequently asked questions

Can one group include lines from more than one PO?

No. All PO lines in a group must be on the same PO.

Can I match a credit note to multiple PO lines?

No. Credit notes need to be matched to a single PO line as usual.

Why can't I match an invoice line to multiple PO lines?

The invoice line needs a unit price, it can't be a credit note, and it can't already be matched to receipt lines. Lines that don't meet these conditions can still be matched to a single PO line.

Why does my grouped line show a quantity or amount under the PO?

Quantity and line amount are compared against the full quantity and amount of every PO line in the group. If the invoice line uses only part of the last PO line, the invoice shows as under the PO rather than an exact match.

Did this answer your question?