A/P PO Reconciliation

Menu Path: None

To use A/P PO Reconciliation, click the Reconcile button in the ribbon in Voucher Entry, Voucher Edit, or Voucher PO Selection.

Purpose

Reconcile received purchase order line items.

Overview

Use A/P PO Reconciliation to select received purchase order line items to reconcile for a voucher, and add any additional charges associated with the purchase order(s). For information on reconciling a purchase order, see Accounts Payable Process Flows.

Ribbon Home Tab Buttons

Button

Description

OK

Click this button when you have completed the process of reconciling purchase orders with the voucher.

Show Data

Click this button to refresh data in the Receipts grid.

As Is

Click this button to reconcile a voucher as is with the displayed receipt quantities, unit costs, and extended costs. When you click this button, the check box in the Fully Invoiced column is selected for all receipts in the Receipts grid.

Select Receipts

Click this button to display A/P PO Select Receipts, which allows you to reconcile to only specific receipts. By default, all receipts for the displayed purchase order's line items are available for reconciliation.

Quality Control Detail

Click this button to display Quality Control Detail Inquiry, which allows you to view defective product information for a purchase order. This button is only available if the Items tab is displayed. The icon for this button includes a check mark if defective products exist for a purchase order.

Receipt Notes

Click this button to display Notes Entry, which allows you to view and enter notes for a selected receipt.

Line Item Notes

Click this button to display Notes Entry, which allows you to view and enter notes for a selected receipt.

Update

Click this button to display Reconciliation Charge Maintenance, which allows you to manually assign voucher and pay amounts to a selected additional charge. This button is only available if you click the Additional Charges tab.

Items Tab Fields and Buttons

Field or Button

Description

Receipts

This grid displays all receipts to date for the selected purchase order(s). This grid includes the following columns:

  • Fully Invoiced - Select the check box in this column for a receipt if the receipt, voucher, and pay quantities are equal.

  • Purchase Order Number - This column displays the purchase order number for all purchase orders' line items that have been receipted and can be reconciled.

  • Receipt # - This column displays all receipt numbers associated with the purchase order(s) being reconciled.

  • Shipment # - This column displays the shipment number for each line item.

  • Container Code - This column displays the container code for each line item.

  • Container Name - This column displays the container name for each line item.

  • Receipt Date - This column displays the date of each receipt against the displayed purchase order(s).

  • Line # - This column displays the line item number for each purchase order.

  • UM - Enter the unit of measure for each line item.

  • Voucher Quantity - Enter the supplier's invoice quantity for each line item you want to reconcile. If you change this quantity, the corresponding quantity in the Pay Qty column also changes.

  • Voucher Unit Cost - Enter the cost of each line item from the supplier's invoice. This column's data defaults from the purchase order's unit costs.

  • Voucher Cost Adjustment - Enter a cost adjustment against the unit cost entered in the Voucher Unit Cost column.

  • Voucher Total Cost - This column displays the voucher total cost for each line item, which is equal to the Voucher Quantity column multiplied by the sum of the Voucher Unit Cost and Voucher Cost Adjustment columns.

  • Pay Qty - Enter the pay quantity for each line item you want to reconcile. The quantities in this column default to the quantities entered in the Voucher Quantity column.

  • Pay Unit Cost - Enter the unit cost you want to pay the supplier for each line item. The costs in this column default to the costs in the Voucher Unit Cost column.

  • Pay Cost Adj - Enter a cost adjustment against the unit cost entered in the Pay Unit Cost column.

  • Pay Tot Cost - This column displays the total payment cost for each line item, which is equal to the Pay Qty column multiplied by the sum of the Pay Unit Cost and Pay Cost Adj columns.

  • Expected Qty - This column displays the quantity expected to be reconciled for each line item. These are the receipted quantities.

  • Exp Unit Cost - This column displays the expected unit cost for each line item. This cost is established on the purchase order and cannot be changed.

  • Exp Cost Adj - This column displays any adjustments to the cost in the Exp Unit Cost column for each line item. This cost adjustment is established on the purchase order and cannot be changed.

  • Exp Tot Cost - This column displays the expected total cost for each line item. This total cost is established on the purchase order and cannot be changed.

  • Release # - This column displays the release number for blanket purchase orders.

  • Release Line # - This column displays the release line number for blanket purchase orders.

  • Product Code - This column displays the product code for each purchase order's line item.

  • Product Name - This column displays the product name for each purchase order's line item.

  • Supplier Product Code - This column displays the supplier's product code if assigned. If one does not exist, it displays Not Available.

  • Exp Total Weight - This column displays the expected total weight for each line item. This can be updated for unconfirmed drop-ship purchase orders for catch weight products.

  • Voucher Weight - Enter the invoiced weight for each line item.

  • Pay Weight - Enter the weight for which you are paying the supplier for each line item.

  • Exp Unit Cost Per Weight - This column displays the expected unit cost per weight for each line item.

  • Voucher Unit Cost Per Weight - Enter the invoiced unit cost per weight for each line item.

  • Pay Unit Cost Per Weight - Enter the unit cost per weight you are paying for each line item.

  • Defective Quantity - This column displays the defective quantity for each line item.

  • Catch Weight Product - The check box in this column is selected for catch weight products.

Note Voucher values should correspond with the supplier's invoice, and are informational only. Pay values should correspond with the actual payment to the supplier, and will affect accounting entries.

Total Cost

This field displays the total cost associated with the payment to the supplier.

Additional Charges Tab Fields and Buttons

Field or Button

Description

Supplier Type

Additional charges can be created on purchase orders payable to the supplier of the purchase order or to a different supplier. Select one of the following options :

  • PO Supplier - Display charges associated with the purchase order from the supplier of the products on the purchase order. Each charge is payable to the supplier associated with the purchase order. This option is selected by default.

  • Charge Supplier - Display charges associated with the purchase order, but not from the supplier of the products. The charge is payable to a supplier other than the supplier of the purchase. An example of this type of charge is customs or duty charges, which are usually payable to customs clearing agents.

PO #

This field displays the purchase order being reconciled. This field defaults to the first purchase order on the Items tab. Click the Lookup button to select another purchase order (if valid).

Receipt #

This field displays the receipt against the displayed purchase order. Click the Lookup button to select another receipt, if valid.

Line #

Click the Lookup button to select the a line item for which you want to display additional charges.

Voucher Charge Amount

Enter an additional charge amount from the voucher that you want to distribute to multiple receipts.

Apply

Click this button to apply the amount entered in the Voucher Charge Amount field to receipts for the selected additional charge in the Charges grid, based on the distribution settings for the additional charge. When you click this button, amounts in the Voucher Amount and Amount columns are updated for each row with the selected charge in the Charges grid.

Charges

This grid displays all additional charges for the selected purchase order or line item number. This grid includes the following columns:

  • Charge Type - This column displays the charge type for each additional charge.

  • Description - This column displays the description for each additional charge.

  • Purchase Order Number - This column displays the purchase order number associated with each additional charge.

  • Receipt # - This column displays the receipt number associated with each additional charge.

  • Shipment # - This column displays the shipment ID associated with each additional charge.

  • Container Code - This column displays the container code associated with each additional charge.

  • Container Name - This column displays the container name associated with each additional charge.

  • Release # - This column displays the release number associated with each additional charge.

  • Release Line # - This column displays the release line number associated with each additional charge.

  • Receipt Date - This column displays the receipt date associated with each additional charge.

  • Line # - This column displays the line item number for each additional charge.

  • Amount - This column displays the pay amount for each additional charge.

  • Voucher Amount - This column displays the voucher amount for each additional charge.

  • Exp Amount - This column displays the expected amount for each additional charge.

  • Fully Invoiced - The check box is selected in this column for fully invoiced additional charges.

  • Product Code - This column displays the product code associated with each line item additional charge. This column is blank for an additional charge associated with an entire purchase order.

  • Product Name - This column displays the product name associated with each line item additional charge. This column is blank for an additional charge associated with an entire purchase order.

  • Product Description - This column displays the product description associated with each line item additional charge. This column is blank for an additional charge associated with an entire purchase order.

Total Cost

This field displays the total cost associated with the payment to the supplier.

VAT Tab Fields and Buttons

Field or Button

Description

VAT

This grid displays all VAT line items for the supplier. This grid includes the following columns:

  • Supplier Code - This column displays the supplier code for the purchase order for each VAT line item.

  • Purchase Order Number - This column displays the purchase order number for each VAT line item.

  • Receipt # - This column displays the receipt number for each VAT line item.

  • VAT Exempt Reason Code - Enter a VAT exempt reason code if the VAT line item is exempt from VAT.

  • Shipment # - This column displays the shipment number for each VAT line item.

  • Container Code - This column displays the container code for each VAT line item.

  • VAT Rate - This column displays the VAT rate for each VAT line item. This defaults to the rate calculated from the VAT class. For regular and blanket purchase orders, the VAT rate is based on the rate as of the receipt date. For drop-ship orders, the VAT rate is based on the rate on the purchase order line items.

  • Base Amount - This column displays the amount on which VAT is based for each VAT line item.

  • VAT Supplier Code - This column displays the VAT supplier code for each VAT line item.

  • Release # - This column displays the blanket purchase order release number for each VAT line item that is for a blanket purchase order release.

  • Receipt Date - This column displays the receipt date for products received for each VAT line item.

  • Product Code - This column displays the product code for each VAT line item.

  • VAT Class Code - Enter the VAT class for each VAT line item.

  • Pay Amount - Enter the pay amount for each VAT line item.

  • Voucher Amount - Enter the voucher amount for each VAT line item. If you change this amount, the corresponding amount in the Pay Amount column also changes.

  • Exp Amount - This column displays each VAT line item.

  • Charge Line Num Char - This column displays the charge line number charge.

  • Fully Invoiced - Select this check box if the VAT amount is fully invoiced.

  • Expected Qty - This column displays the expected quantity of received product for each VAT amount.

  • Voucher Quantity - Enter the supplier's invoice quantity for each VAT amount you want to reconcile. If you change this quantity, the corresponding quantity in the Pay Qty column also changes, and the amounts in the Pay Amount and Voucher Amount columns change.

  • Pay Qty - Enter the pay quantity for each line item you want to reconcile. The quantities in this column default to the quantities entered in the Voucher Quantity column.

  • Manual - Select the check box in this column if you want to manually change voucher/pay quantities and amounts for a VAT line item.

  • Voucher # - This column displays the voucher number for each VAT line item.

  • Release Line # - This column displays the release line number for each VAT line item associated with blanket purchase orders.

Total Cost

This field displays the total cost associated with the payment to the supplier.