Job Aid: Schedule Reports Glossary

Overview

Users can access Scheduled Reports in My Exchange Invoices. These reports include a specific set of data defined in a custom search. You can run the reports on a daily, weekly, monthly, or quarterly basis for content related to your invoices, trading partners, and the GHX Exception Remove Tools (smoothing).

The tables below explain the content of the various tabs found within the report, which comes packaged as an Excel file. The tabs in the file are labeled as follows: Invoices, PO Smoothing, Smoothing Overview, Vendors, Trx Details.

See My Exchange product help for providers for details about accessing these reports.

Note: The report is a “snapshot in time” for the moment it is run. It contains data available at the time of report generation.

Invoices Tab

Column Header Name	Description
Date	The date when the invoices arrived at GHX.
Exchange	Indicates the total number of documents (paper and electronic) that made it to the Exchange to be processed.
Terminated	Indicates the number of invoices terminated by the GHX Exchange due to invalid process/properties.
Stopped	Indicates the number of invoices stopped by a routing rule or the smoothing process (examples are duplicate or other).
In Progress	Indicates the number of invoices that have been received by the GHX Exchange but have not completed the process to be sent to the customer.
Parked	Indicates the number of invoices parked to be sent to the eInvoicing application.
Received by OnDemand AP	These are invoices that have completed the smoothing process and have been sent into the eInvoicing application.
Pending Delivery	Indicates the number of invoices that are pending delivery to your ERP.
Sent	Indicates the invoice has been sent to your organization.
Reconciliation	The full count of all invoices added together, including the following statuses: Terminated, Stopped, In Progress, Parked, Received by OnDemand AP, Pending Delivery, and Sent.

PO Smoothing Tab

Column Header Name	Description
Date	The date when the invoices arrived at GHX.
Inbound - Exchange - Total	The number of invoices that arrived at GHX for your organization.
Inbound - Exchange - Smoothable	The number of invoices that present to be smoothable and are PO invoices. Does not include non-PO invoices.
Performance - Smoothed - Total	The number of invoices where PO details were available at the time of smoothing. Smoothing was able to enrich at least one portion of the invoice based on active smoothing rules.
Performance - Smoothed - %	The percentage of invoices that were smoothed.
Performance - Smoothed - PO Available	The number of invoices where PO details were available at the time of smoothing.
Performance - Smoothed - CSD PO Source	The number of invoices where the PO history (POH) extract data was available for use in smoothing.
Performance - Smoothed - Exchange PO Source	The number of invoices where the PO data was found in GHX Exchange available for use in smoothing but not found in the POH at the time of processing.
Performance - Touchless - Total	The number of invoices where all invoice lines are exception free.
Performance - Touchless - %	The percentage of smoothed invoices that were touchless.
Performance - Touchless - % Overall	The percentage of all invoices that were touchless when compared with the inbound Exchange smoothable invoices.
Exceptions - Occurrences - Line Number	The number of line numbers that were changed as a result of smoothing.
Exceptions - Occurrences - Quantity	The number of quantity values that were changed as a result of smoothing.
Exceptions - Occurrences - Unit of Measure	The number of UOM values that were changed as a result of smoothing.
Exceptions - Occurrences - Unit Price	The number of unit price values that were changed as a result of smoothing.
Exceptions - Occurrences - Vendor Catalog Number	The number of vendor catalog number values that were changed as a result of smoothing.
Exceptions - Invoices - Line Number	The number of invoices where at least one line number was smoothed.
Exceptions – Invoices – Line Number %	The percentage of smoothing invoices where at least one line number was smoothed.
Exceptions - Invoices - Quantity	The number of invoices where at least one quantity value was smoothed.
Exceptions – Invoices – Quantity %	The percentage of smoothed invoices where at least one quantity value was smoothed.
Exceptions - Invoices - Unit of Measure	The number of invoices where at least one UOM value was smoothed.
Exceptions – Invoices – Unit of Measure %	The percentage of smoothing invoices where at least one UOM value was smoothed.
Exceptions - Invoices - Unit Price	The number of invoices where at least one unit price value was smoothed.
Exceptions – Invoices – Unit Price %	The percentage of smoothed invoices where at least one unit price value was smoothed.
Exceptions - Invoices - Vendor Catalog Number	The number of invoices where at least one vendor catalog number value was smoothed.
Exceptions – Invoices – Vendor Catalog Number %	The percentage of smoothed invoices where at least one vendor catalog number values was smoothed.
Exceptions - Invoices - Vendor Code	The number of invoices where the vendor code was smoothed.
Exceptions – Invoices – Vendor Code %	The percentage of smoothed invoices where the vendor code was smoothed.
Exceptions - Invoices - Remit Code	The number of invoices where the remit code was smoothed. This is the invoice header value count.
Exceptions – Invoices – Remit Code %	The percentage of smoothed invoices where the remit code was smoothed.
Exceptions - Invoices - Buyer	The number of invoices where the buyer (also called the purchaser ID) value was smoothed.
Exceptions – Invoices – Buyer %	The percentage of smoothed invoices where the buyer (also called the purchased ID) value was smoothed.

Smoothing Overview Tab

Automated Exception Removal	Description
eInvoicing Net-to-Net Smoothing	eInvoicing verifies whether the difference between the invoice and additional data source header amounts are within tolerance. If the difference is within tolerance, eInvoicing updates the invoice, removing all exceptions and creating a touchless invoice.
eInvoicing Net-to-Line Smoothing	eInvoicing attempts to match the invoice header amount with line amounts. If there is a match, eInvoicing updates the invoice, removing all exceptions and creating a touchless invoice.
eInvoicing Line-to-Line Smoothing: Complete Match with Full Confidence	eInvoicing attempts to match invoice line data with additional data sources. If there is a match, eInvoicing updates a sub-set of the invoice.
eInvoicing Line-to-Line Smoothing: Partial Match with Full Confidence	Same as above, but with varying match criteria and confidence.
eInvoicing Line-to-Line Smoothing: Part Number Match with Full Confidence	Same as above, but with varying match criteria and confidence.
eInvoicing Line-to-Line Smoothing: Complete Match with High Confidence	Same as above, but with varying match criteria and confidence.
eInvoicing Remove Zero Amount Lines Smoothing	When this rule is applied, it removes zero-dollar lines.
eInvoicing Duplicate Check Smoothing	This rule compares incoming invoices to additional data sources to identify if the document has already been received. If a duplicate is identified, the duplicate is stopped.
Add Remit To	This rule uses additional data sources to identify if a remit to exists. If a remit to does exist, it is added to the invoice.
Add Purchaser ID	This rule uses additional data sources to identify if a buyer exists. If a buyer does exist, the buyer information is captured and added to the invoice.
eInvoicing PO Number Truncate Smoothing	When this rule is applied to an invoice, a new output PO number is generated and replaces the input PO number in the invoice.
eInvoicing Tax Exempt Smoothing	This rule modifies invoices and ensures the document is balanced. Through identifiers in the additional data sources, the rule can be applied to a subset of a customer’s overall invoice volume.

Vendor Tab

Column Header Name	Description
Vendor Name	This is the vendor name taken from the PO details.
Invoices	The number of invoices that arrived at GHX for this vendor.
Paper	The number of invoices from the vendor that were sent via email or to a PO box (Data Capture).
Electronic	The number of invoices from the vendor that were transmitted electronically via EDI.
% Electronic	The percentage of invoices from this vendor that were electronic.
% of Total	The percentage of invoices from this vendor out of all invoices received.
Smoothable	The number of invoices that present to be smoothable and are PO invoices. Does not include non-PO invoices.
Smoothed	The number of invoices where PO details were available at the time of smoothing. Smoothing was able to enrich at least one portion of the invoice based on active smoothing rules.
Smoothing – Smoothed %	The percentage of invoices that were smoothed.
Touchless	The number of invoices where the PO history (POH) extract data was available for use in smoothing.
Smoothing – Touchless %	The number of invoices where the PO data was found in the GHX Exchange available for use in smoothing, but not found in the POH at the time of processing.
PO Available	The number of invoices where all invoice lines were replaced by PO lines.
CSD PO Source	The percentage of smoothed invoices that were touchless.
Exchange PO Source	The percentage of all invoices that were touchless when compared with inbound Exchange smoothable invoices.
Exceptions – Occurrences – Line Number	The number of line numbers that were changed because of smoothing.
Exceptions – Occurrences – Quantity	The number of quantity values that were changed because of smoothing.
Exceptions – Occurrences – Unit of Measure	The number of UOM values that were changed because of smoothing.
Exceptions – Occurrences – Unit Price	The number of unit prices values that were changed because of smoothing.
Exceptions – Occurrences – Vendor Catalog Number	The number of vendor catalog number values that were changed because of smoothing.
Exceptions – Invoices – Line Number	The number of invoices where at least one line number was smoothed.
Exception – Invoices – Line Number %	The percentage of smoothed invoices where at least one line number was smoothed.
Exceptions – Invoices – Quantity	The number of invoices where at least one quantity value was smoothed.
Exceptions – Invoices – Quantity %	The percentage of smoothed invoices where at least one quantity value was smoothed.
Exceptions – Invoices – Unit of Measure	The number of invoices where at least one UOM value was smoothed.
Exceptions – Invoices – Unit of Measure %	The percentage of smoothed invoices where at least one UOM value was smoothed.
Exceptions – Invoice – Unit Price	The number of invoices where at least one unit price value was smoothed.
Exceptions – Invoices – Unit Price %	The percentage of smoothed invoices where at least one unit price value was smoothed.
Exceptions – Invoices – Vendor Catalog Number	The number of invoices where at least one vendor catalog number value was smoothed.
Exceptions – Invoices – Vendor Catalog Number %	The percentage of smoothed invoices where at least one vendor catalog number value was smoothed.
Sent Count	The number of invoices sent to the customer.
Sent Rate	The percentage of invoices sent to the customer.

Trx Details Tab

Column Header Name	Description
Customer EID	The GHX Exchange ID of the receiver organization for the invoice.
DC Received	The date/time when the invoice was received at Data Capture.
DC Scanned	The date/time when the invoice was scanned at Data Capture.
Exch Received	The date/time when the invoice was received by GHX.
App Received	The date/time when the invoice was received within the eInvoicing Advanced application.
App Released	The date/time when the invoice was released from the eInvoicing Advanced application.
Exch Sent	The date/time when the invoice was picked up at ConnectPlus for on premises ERP integrations or ingested via API for Cloud ERP integrations.
Transaction ID	A GHX internal, unique transaction identifier.
Doc ID	A GHX internal, unique document identifier.
GSL ID	A Data Capture unique document identifier.
Exch Invoice #	The invoice number as identified from the supplier.
Exch PO #	The purchase order number identified on the invoice.
Exch Control Num	The control number on the invoice
Invoice Amount	The monetary amount payable on the invoice.
State Tax	The amount of state tax on the invoice.
Local Tax	The amount of local tax on the invoice.
Other Tax	The amount of other tax on the invoice.
Freight	The amount of freight and special charges on the invoice.
Receipt Format	Indicates the method of delivery Data Capture. Options are PO Box and email.
Source Type	Indicates the invoice source type, which is how it was delivered to GHX. Options are electronic and paper.
App Latest Comment	eInvoicing application last comment.
App Assigned To	eInvoicing application invoice flow data showing assigned to user.
App Buyer	eInvoicing application indicating flow identification of the buyer.
Facility	The GHX Exchange organization name of the invoice recipient.
Vendor ID	The vendor ID on the invoice.
Vendor Name	The vendor name on the invoice.
DC Status	The status of the processed invoice within Data Capture.
Sender Org	Indicates the GHX supplier organization name or will indicate the GHX eInvoicing vendor when processed by Data Capture.
Status	Indicates the status of the invoice at the time the report was generated. Options are: Processed – Indicates the invoice completed processing and has been sent to your ERP Received by OnDemand AP – Indicates the invoice was transmitted to the eInvoicing application for processing Stopped – Indicates the invoice was stopped; possible stop reasons include duplicate checking and zero amount invoices In Process – Indicates the invoice is currently in process at GHX Terminated – Indicates the invoice was terminated by the Exchange due to invalid processes or properties at the time when the report was generated Sent – Indicates the invoice has been sent to your ERP
App Status	The status of the invoice within the eInvoicing application.
Smoothed	If this cell contains a "Y," this indicates that the invoice was smoothed.
Touchless	If this cell contains a "Y," this indicates that all invoice lines were smoothed and replaced by the smoothing process.
DC Cycle Time (Hours)	Indicates the number of hours from the time the invoice was received at Data Capture (DC Scanned) until it was sent to GHX (Exch Received).
App Cycle Time (Days)	Indicates the number of days from the time the eInvoicing Advanced application received the invoice (App Received) until it was released (App Released).
Exception Removal Counts	These rows indicate the exception removal process counts on the invoice.

General Terms

Column Header Name	Description
EID	GHX Exchange ID. This is an internal GHX unique identifier assigned to each organization that can send or receive transactions through the Exchange.
Smoothed	The smoothing engine was able to enrich at least one portion of the invoice based on your active smoothing rules.
Touchless	When the entire invoice is smoothed, removing any invoice and purchase order exceptions.
Net to Net Smoothing	When the net-to-net matches, removing any invoice and purchase order exceptions.
Line to Line Smoothing	When the net-to-net data does not match, line-to-line data is used to attempt to smooth the invoice data.
Out of Tolerance	When the price cannot match due to tolerance levels. Some smoothing can occur if there is an item match.