Three Way Match

Three Way Match

Three Way Match
 
 
 Three Way Match allows the input of invoicing data to cross reference against purchase orders and receivers.  This ensures   that your orders are being properly received and invoiced.  Any discrepancies between the order, receiver or invoice are   highlighted so they are easily identified.    
 
This module is optional and must be enabled by your Implementation Specialist.
  
To start your three way match, select Three Way Match within the Finance module of OpSuite.  Here you will see all pending purchase orders.
 
 
Select the Purchase Order you want to start the match on.  This will open the three way match.  The information on the three way match will be identical to your purchase order.  You will see at the bottom that all line items are shaded red.  This is because no items have been received yet.  

 
Once you have at least a partial receiver completed, you can start matching your order.  You will see that two (2) of the columns have been updated with your quantity received to date, and also the quantity to invoice.  
 
Using the invoice provided by your vendor, you can enter the quantity they have charged you for in the order.  Select the NEW button within the Invoices box to start entering the invoice information.  Enter the Invoice number from the supplier, as well as the date invoiced.  Next you will enter the cost at which each item was invoiced, as well as the quantity they are invoicing you for.  Should there be an item on the invoice that was NOT on the original purchase order, you can add the item by selecting the Add Item not on PO nor Receiver.  

  
 
 
Once your Invoice information has been entered, it must be approved.  Once approved, no edits can be made to the Invoice.
 
 
 
 
 
 Any items that have differences in quantity or cost between the Purchase Order, Receiver or Invoice will be highlighted in red.  To view details of the differences for a single item, select the arrow to the left of the sku.  This drop down will show you the difference in quantity ordered vs received vs invoiced, as well as any differences in cost between the order, receiver and invoice.  

 
 
Once you have entered all invoices, you must select Complete at the bottom of the page.  This will save and log all information regarding the three way match.
 
If you use a 3rd party accounting software, the 3-way match invoices can be exported as a CSV to import into your software.  Click the Export Invoices button located at the bottom of the screen.  The file will download and you can view the file immediately.

 

    • Related Articles

    • Data Management

      Data Management Data Management is a phenomenal tool that allows you to filter a large set of items at once. By doing this, you can easily download a file containing only the information you want. This tool goes hand in hand with Data Imports, which ...

    • Physical Inventory

      Physical Inventory Physical Inventory module is designed to provide a fast, accurate, and flexible way to perform Full Store physical inventory counts, or a series of cycle counts throughout a period, to help manage and maintain inventory. Physical ...

    • Device Groups

      Device Groups Device Groups are another way to group certain devices together within a location or across locations within an Enterprise. Every device in the device group will have the same device settings. These settings can be changed within Device ...

    • Item Distribution

      Item Distribution Item Distribution allows you to create multiple transfers from a single, or multiple purchase orders, transfer orders, or receivers. You can also manually add items from the source location to distribute to multiple locations (much ...

    • Print Labels

      Label Printing Within the Labels section of OpSuite, is another feature that will allow you to print multiple labels, for multiple items at one time. This includes items from a purchase order, transfer order, receiver, manually added or scanned ...