This is a part of the AP Invoices feature of Smart Ops. Click here to learn more about Smart Ops.


The Link Purchase Order button within the Smart Ops AP invoice sidesheet enables users to link a purchase order to an AP invoice directly from the invoice. Once clicked, users can preview and then choose the desired purchase order based on the location or the location and vendor selected. A linked purchase order will then populate the AP invoice and display any issues between the AP invoice and purchase order.


Managers should have the necessary AP Invoice Security to access this function.


TABLE OF CONTENTS



To link a Purchase Order to a new AP Invoice, click the 'Link Purchase Order' button within the 'New AP Invoice' sidesheet. A list of all available Purchase Orders will open.

  • Note: If a Vendor is selected before 'Link Purchase Order' is clicked, then only POs for that Vendor will be listed.



View the listing for the desired Purchase Order and click 'Link PO' next to it to populate the AP Invoice with its details. To view the details of a Purchase Order before linking it to the AP Invoice, click the PO Number of the corresponding Purchase Order.


Note: Once a PO is linked, it cannot be unlinked unless the AP Invoice is deleted.



The details of the Purchase Order will then be displayed in the 'Details' grid. Additional items can be added to this grid by clicking the '+ Add Item' button and entering the name of the item. Click here to learn more about adding items to the 'Details' grid.


R365 purchase orders and AP invoices can autolink when both the purchase order and the AP invoice meet specific criteria. Once an AP invoice is created, it will be matched to a submitted purchase order that follows the automap logic. 


A submitted PO will automap to an AP Invoice when:

  • The PO and AP invoice have the same vendor.

  • The PO and AP invoice have the same location.

  • The PO total and AP invoice total are within a certain % variance, and the PO delivery date and invoice date are within a certain number of days. These are dependent on the tiered matching rules. 



Matching Rules


When the vendor and location on both the submitted PO and AP invoice are the same, the system will follow these tiered matching rules (in order) to search for matches:


Rule 1

PO Number matches the reference PO number (via EDI import) 


Important Note: Matching Rule 1, which automaps with EDI imports is only for McLane. All other customers matching rules start at Rule #2.

Rule 2

The invoice total amount is within 10% of the PO total, and the invoice date is within 1 day of the PO delivery date.

Rule 3

The invoice total amount is within 10% of the PO total, and the invoice date is within 3 days of the PO delivery date.

Rule 4

The invoice total amount is within 30% of the PO total, and the invoice date is within 1 day of the PO delivery date.

Rule 5

The invoice total amount is within 30% of the PO total, and the invoice date is within 3 days of the PO delivery date.



The purchase order and AP invoice below will be automapped using the logic from Rule 2.


Click an image to enlarge.




Once the AP invoice is marked as complete. The Link Purchase Order button will automatically update to reflect the purchase order number that the system has linked the invoice to. 



AP Invoice Date


When a purchase order is linked to an AP invoice, the invoice date may be either of the following:

  • The date listed on the AP invoice or
  • The purchase order delivery date

This is dependent on the Invoice Date setting on the Vendor Additional Tab of the Vendor Record.



When set to AP Date, the date on the invoice will remain as it was entered. 



When set to PO Delivery Date, the date on the invoice will update to match the delivery date from the purchase order that was linked to the invoice. 


Alerts Tab



If any issues arise between the Purchase Order and the AP Invoice, an 'Alerts' tab will appear. From this tab, Users can view the reasons for the alert, which include:

  • Item on PO Not on Invoice - The corresponding item is listed on the PO but not on the invoice
  • Item on Invoice Not on PO - The corresponding item is listed on the invoice but not on the PO
  • Price Difference from PO - The amount entered for the corresponding item's 'Each Amt' field is different between the invoice and the PO
  • Quantity Difference from PO - The corresponding item's UofM on the invoice does not match to the UofM on the invoice
  • Contract Violation [Description] - The corresponding item's 'Each Amt' is outside of the acceptable variance set for the contract price on the Vendor Item record
    • Note: This will only be enforced for an item with the same UofM on the invoice and PO


Click here to learn more about the 'Alerts' tab on the AP Invoice.