Accounts Payable > Accounts Payable Invoice > AP Invoice Reports

The PO Line Items Matched to AP Invoice Report provides detailed information on the PO line item receipts that are yet to be matched with AP invoices though you may also opt to show in the report the PO receipts that are fully matched against AP invoices.

This report has the following uses:

•To reconcile the received goods liability account balance in the General Ledger

•To determine the total PO receipts quantity and amount for which no AP invoices have been posted yet

•To verify purchase tax calculated for each purchase order transaction

Note: The purchase tax displayed in the this report does not include tax adjustments recorded when the AP invoice is posted.

To print the PO Line Items Matched to AP Invoice Report, follow these steps:

1.Access the PO Line Items Matched to AP Invoice Report function from the AP Invoice group under the Reports main menu of the Accounts Payable module.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Select the report sorting option by clicking the List box button next to the Sort By field.

4.In the Layout field, click the List box button to select the report layout you want to use in generating the report.

To show multi-currencies in the report, select the option with 'multi-currency' in the layout name. Note that this layout option is only available if the multi-currency feature is activated.

5.In the Report Configuration area, define the desired report filters. Mark the Individual checkbox if you want to generate the report for a single vendor record or purchase order number, and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the appropriate criteria in generating the report.

6.If applicable, mark any or all of the following checkboxes:

oInclude Fully Matched Items

Mark this checkbox if you want the report to include the PO receipts that are fully matched with AP invoices.

Note: The receipt transaction is fully matched when either of the following has occurred:

•The PO receipt is fully matched with an AP invoice using the AP Invoice Transactions function.

•The entire PO receipt transaction is cancelled using the Cancel Received Goods function.

oShow Reference Account

Mark this checkbox to display the Inventory GL Account ID (and description) to which the PO line item transaction is posted.

oShow Multi-Currencies

Mark this checkbox if you want the report to display the PO receipts that are unmatched with AP invoices as expressed in the vendor’s foreign currency. Note that this checkbox is only available if the multi-currency feature is activated.

7.Select which of the following transactions you want to include in the report:

•All Receipts

•Accrued Receipts Only

•Unaccrued Receipts Only

8.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The PO Line Items Matched to AP Invoice Report function also provides you with flexibility to perform the following:

•Set up user-defined sort option

•Set up user-defined report layout

•Include notes in the printed report

•Export the report to various supported file formats

•Send the report as attachment to an email

•Include time and printed by information

•Drill-down on certain fields in the report:

oPO #

AccountMate displays the purchase order/quote document when you double click the purchase order number in the report.

oVendor #

AccountMate displays the Vendor Profile when you double-click the vendor number in the report.

oItem #

AccountMate displays the Item Profile when you double-click the item number in the report.

PO Line Items Matched to AP Invoice

PO Line Items Matched to AP Invoice

See Also