Select Page
Paying the Piper in Epicor E10, Kinetic & Prophet 21

Paying the Piper in Epicor E10, Kinetic & Prophet 21

Best Practices for Paying Supplier Invoices in Epicor ERP

There are many challenges when it comes to paying supplier invoices in Epicor E10, Epicor Kinetic (E11), or in Epicor Prophet 21. In simple terms, a company purchases goods from a supplier according to pre-established and carefully-specified terms. In most cases, a company needs to pay them within the specified terms, waiting as long as possible, as to keep the cash flow within the confines of the company’s banking system for as long as possible. 

But the payment must not be so late as to incur the wrath of the supplier and avoid the inconveniences that credit hold will place on subsequent purchases. And the company may elect to take advantage of an early payment discount, if one exists.

Sounds simple enough. But a company also must ensure that invoices are accurate. The amount invoiced must correspond to the quantities that were actually delivered. Some many-to-one complexities muddle the water a bit, given that a supplier invoice may cover several purchase orders and that each PO could be dozens or even hundreds of lines in length.

Supplier Invoices Epicor Kinetic ERP Cloud

Automating the Three-Way Matching Process

At this point, we haven’t even begun to validate the amount that was on the original purchase order. Such is the magic of the three-way match: cross-referencing the information that was on the PO with the information on the receipt and matching both of these with the invoice from the supplier.

The matching process differs by company, as many companies have different rules and tolerances that govern the matching process. This can make the process laborious and time consuming for accounts payable staff, and it’s not uncommon for many accounting departments to spend inordinate amounts of time matching invoices and cutting checks for routine purchases. 

Given that the three-way matching process is largely mechanical in nature, one would think that it could be automated. But what would it look like for a system to perform some of the heavy lifting, allowing your AP staff to focus on the critical few problems, without having to grind thought the invoices that went through without a hitch?

  • Firstly, the system would need to read the invoice. It would need to read and digitize supplier invoices, whether they’re sent as PDFs Word documents, or in some other format.
  • Secondly, it would need to validate the invoice. It would need to review the past POs and match the invoice lines with the corresponding PO lines, whether they come from multiple Purchase Orders or a single PO.
  • Thirdly, they’d need to perform the three-way match. Using the rules that your company has configured, the system would need to compare line items from the purchase order, the invoice, and the actual receipt of goods.
  • Finally, the system would need to generate payment vouchers with the click of a button.

The benefits of such a system should be self-evident. Automation works to secure your supplier relationship, while minimizing invested time and effort. Moreover, such a system would be the kind of repetitive and rigorous data-driven analytical work that computers are made to do:

  • Processing matched invoices
  • Kicking out exceptions

Automation allows skilled staff to focus on the real work, not the grunt work. 

Are you in search of such a solution? Our supply chain automation partner SourceDay will be presenting a webinar entitled “3-Way Matching Success Through AP Automation” with Epicor ERP software solutions expert Jim Frye.  

SourceDay Logo

The webinar will focus on the final stage of the purchase order process: paying supplier invoices. Anyone who’s navigated the perils of accounts payables in Epicor knows the burden of matching purchase orders and invoices. There has to be a better way!

Join Epicor ERP expert Jim Frye to learn how SourceDay helps Epicor customers reduce the time and effort it takes to pay supplier invoices, resulting in early payment discounts, efficiency gains, and hard cost savings. The webinar will cover the following:

The challenges of paying supplier invoices in Epicor
The measurable benefits of faster invoice payment
How to increase operational efficiency and automation

Learn more about Epicor software by attending an EstesGroup Summit! Whether you’re a small business or a global manufacturer or distributor, our world-class enterprise resource planning (ERP) consultants can help you with everything from raw materials management to ERP cloud migration. Our Epicor consulting team can help you move from the paper based systems of the past to the cloud based applications of the future.

Brad Feakes SVP of Professional Services

BRAD FEAKES

SVP or Professional Services

EstesGroup

Jim Frye SourceDay Epicor Expert

JIM FRYE

Enterprise Sales Director & In-House Epicor ERP Expert

SourceDay

Phillip Pavelka SourceDay Supply Chain Expert

PHILLIP PAVELKA

Solutions Engineer

SourceDay

Leveraging Union Queries in Epicor Kinetic BAQs

Leveraging Union Queries in Epicor Kinetic BAQs

BAQs — Becoming One Data

A fundamental value of your Epicor ERP system is the data that it holds — all that data sits there, nicely organized and begging for consumption. But good data needs to be converted into information to be of value. As such, getting good data out of your ERP system is key. Often, it takes a good query to perform that information transformation. A Union query is one tool in the Epicor BAQ toolbox that can perform this action.

Data Server Epicor BAQs
Within the Epicor Business activity query toolset, Union queries combine multiple data sources into a single results set. Union queries are a great way to combine data from different tables that are, for whatever reason, sufficiently similar as to combine them into a single dataset. Some examples might include:

  • You are using the project module and wish to combine project phases and project tasks into one single set of activities
  • You are tracking the completion of manufactured parts in a mixed mode environment, and need to merge the Job Assembly and Job Material tables
  • You are reviewing sales activity for a customer and wish to combine open orders and open quotes

The UNION command in some ways functions like a JOIN command. It is used to select related information from two related tables. The biggest difference is in how the two tables are related and returned. A JOIN returns multiple table data elements combined into a single row, while with the UNION command, the records from different tables are returned as separate rows. It’s important to note the following: because records from different tables are being combined into a single set of rows, the rows returned need to be of the same data type. We will spell this out further below.

Let’s look at the attached Epicor BAQ example and better understand the UNION command in an Epicor business activity query.

The following query combines three sets of supply-side data into a single dataset:

  • Purchase Orders
  • Jobs
  • Inventory
SubQuery1 is the top-level query. It pulls data from the PartBin and PlantWhse tables:
Epicor SubQuery1
SubQuery2 is a Union query, from the JobPart and JobHead tables. Note: the data types are organized in the same order as the top-level query:
Epicor Kinetic SubQuery2
SubQuery3 is also a Union subquery that returns data from the PODetail and PORel tables:
Epicor Kinetic SubQuery3
Note: UNION command requires all selected columns to be of the same data type. If these returned values are not of the same type, you will receive error messages, per the screenshot below:
Epicor Kinetic Union Command
The value of Union queries is far-reaching. For example, the above query can then be used in a job shortage dashboard, such as the one below. In the following dashboard, the main query returns all past-due job material records where the material’s related operations have been started, but the material has not been issued. The main query published out the material part number, such that the child query can subscribe to this value and present the collected supply for the part in question, whether coming from inventory, from a job, or from a purchase order:
Epicor Kinetic Job

Need help with Epicor Kinetic BAQs?

Epicor Kinetic User Summit Fall 2021

Like BAQs? Looking for more Epicor Kinetic tips and tricks?

Meet us at the EstesGroup Kinetic Summit!