Non-supported ReleaseNon-supported Release
ECI no longer supports this version of e-automate, and this version of the online help is no longer being updated. ECI recommends upgrading to the current release. Contact your account manager for more information.

Understanding the Accounts Payable Dashboard

You use the ECI Cognytics Accounts Payable Dashboard to view a snapshot of the following important accounts payable information:

High-level Total Sets:

Total Open Invoices Amount and Number of Open Invoices

Past Due PO Invoices Amount and Number of Past Due PO Invoices

Past Due Vendor Invoices Amount and Number of Past Due Vendor Invoices

Open PO Invoices (by Amount)
View Type: Pie Chart with List View Option

Pie Chart Slice Information:

Color-coded Open PO Invoices Category (Purchase Order Credit Memos, Due This Week, Due Next Week, Due After Next Week, Past Due)

Amount within the Category (on mouseover)

List View Table Columns:

Open PO Invoices Category (Purchase Order Credit Memos, Due This Week, Due Next Week, Due After Next Week, Past Due)

Amount within the Category

Open Aged Payables - By Amount
View Type: Bar Graph with List View Option

Bar Graph Bar Information:

Color-coded Type of Open Aged Payables (Open PO Invoices, Open Vendor Invoices)

Graphed Amount within the Type of Open Aged Payables

Amount within the Type of Open Aged Payables (on mouseover)

List View Table Columns:

Time Period (Credit Memos, Due This Week, Due Next Week, Due after Next Week, Past Due)

Amount of Open Vendor Invoices

Amount of Open PO Invoices

Pending PO Invoices (by Amount)
View Type: Pie Chart with List View Option

Pie Chart Slice Information:

Color-coded Type of Pending Invoice (Received This Month, Received Last Month, Received Prior to Last Month)

Amount within the Type of Pending Invoice (on mouseover)

List View Table Columns:

Type of Pending PO Invoice (Received This Month, Received Last Month, Received Prior to Last Month)

Amount within the Type of Pending Invoice

Open POs (Amount)
View Type: Pie Chart with List View Option

Pie Chart Slice Information:

Color-coded Type of Open PO (Open This Month, Open Last Month, Open Prior to Last Month)

Amount within the Type of Open PO (on mouseover)

List View Table Columns:

Type of Open PO (Open This Month, Open Last Month, Open Prior to Last Month)

Amount within the Type of Open PO

Accounts Payable Invoice Due Month-to-Date List: For each invoice, the system lists:

Number

Type

Vendor Number

Vendor Name

Vendor Invoice

Date

Description

Batch

Total

Due

Due Date

For information on dashboard features and functionality, see the ECI Cognytics Features and Functionality topic.

Getting to the Accounts Payable DashboardGetting to the Accounts Payable Dashboard

Click [Dashboards] on the e-automate toolbar to open the Dashboards window.

Note: The system will only display the [Dashboards] button if your company has installed and enabled ECI Cognytics and you have rights to view this dashboard. If you see a [Metrics] button on the e-automate toolbar, your company has not installed and enabled ECI Cognytics.

To open the Accounts Payable Dashboard, use the drop-down menu to select Accounts Payable Metrics.

High-level TotalsHigh-level Totals

See below for query information.

High-level Total	List Window	QuickSearch Query
Total Open Invoices	Accounts Payable Invoices Console	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND On Hold equals No
Past Due PO Invoices	Accounts Payable Invoices Console	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND On Hold equals No AND Due date is less than [First Day of Current Week]
Past Due Vendor Invoices	Accounts Payable Invoices Console	Type Equals Vendor Invoice AND Due is NOT equal to $0.00 AND On Hold equals No AND Due date is less than [First Day of Current Week]
Unapplied Vendor Payments	Payments	Unapplied payment is NOT equal to $0.00

Open PO InvoicesOpen PO Invoices

See below for description and query information.

Chart/List Category	Description	List Window	QuickSearch Query
Due after next week	Any open purchase order invoice that will be due past the end of the current week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is greater than [Last Day of Next Week] AND On Hold equals No
Due next week	Any open purchase order invoice that will be due between the start of the next week and the end of the next week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is in the range [First Day of Next Week] to [Last Day of Next Week] AND On Hold equals No
Due this week	Any open purchase order invoice that will be due between the start of the current week and the end of the current week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is in the range [First Day of Current Week] to [Last Data Update Date] AND On Hold equals No
Past Due	Any open purchase order invoice that was due prior to the start of the current week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is less than [First Day of Current Week] AND On Hold equals No
Purchase Order credit memos	Quantity and amount of purchase order credit memos.	Accounts Payable Invoices	Type Purchase Order Credit Memo AND Due is NOT equal to $0.00 AND On Hold equals No

Open Aged PayablesOpen Aged Payables

See below for description and query information.

Chart/List Category	Description	List Window	QuickSearch Query
Open Vendor Invoices
Due after next week	Any open vendor invoice that will be due past the end of the current week.	Accounts Payable Invoices	Type Equals Vendor Invoice AND Due is NOT equal to $0.00 AND Due date is greater than [Last Day of Next Week] AND On Hold equals No
Due next week	Any open vendor invoice that will be due between the start of the next week and the end of the next week.	Accounts Payable Invoices	Type Equals Vendor Invoice AND Due is NOT equal to $0.00 AND Due date is in the range [First Day of Next Week] to [Last Day of Next Week] AND On Hold equals No
Due this week	Any open vendor invoice that will be due between the start of the current week and the end of the current week.	Accounts Payable Invoices	Type Equals Vendor Invoice AND Due is NOT equal to $0.00 AND Due date is in the range [First Day of Current Week] to [Last Data Update Date] AND On Hold equals No
Past Due	Any open vendor invoice that was due prior to the start of the current week.	Accounts Payable Invoices	Type Equals Vendor Invoice AND Due is NOT equal to $0.00 AND Due date is less than [First Day of Current Week] AND On Hold equals No
Purchase Order credit memos	Quantity and amount of vendor credit memos.	Accounts Payable Invoices	Type Equals Vendor Credit Memo AND Due is NOT equal to $0.00 AND On Hold equals No
Open PO Invoices
Due after next week	Any open purchase order invoice that will be due past the end of the current week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is greater than [Last Day of Next Week] AND On Hold equals No
Due next week	Any open purchase order invoice that will be due between the start of the next week and the end of the next week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is in the range [First Day of Next Week] to [Last Day of Next Week] AND On Hold equals No
Due this week	Any open purchase order invoice that will be due between the start of the current week and the end of the current week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is in the range [First Day of Current Week] to [Last Data Update Date] AND On Hold equals No
Past Due	Any open purchase order invoice that was due prior to the start of the current week.	Accounts Payable Invoices	Type Equals Purchase Order Invoice AND Due is NOT equal to $0.00 AND Due date is less than [First Day of Current Week] AND On Hold equals No
Purchase Order credit memos	Quantity and amount of purchase order credit memos.	Accounts Payable Invoices	Type Equals Purchase Order Credit Memo AND Due is NOT equal to $0.00 AND On Hold equals No

Pending PO InvoicesPending PO Invoices

See below for description and query information.

Chart/List Category	Description	List Window	QuickSearch Query
Received this month	Quantity and balance of uninvoiced PO invoices that were received in the current month.	Purchase Receipts and Returns	Uninvoiced is greater than $0.00 AND Date is in the range [First Day of This Month] to [Last Data Update Date]
Received last month	Quantity and balance of uninvoiced PO invoices that were received in the last month.	Purchase Receipts and Returns	Uninvoiced is greater than $0.00 AND Date is in the range [First Day of Last Month] to [First Day of Last Month]
Received prior to last month	Quantity and balance of uninvoiced PO invoices that were received before the first of the last month.	Purchase Receipts and Returns	Uninvoiced is greater than $0.00 AND Date is less than [First Day of Last Month]

Open POsOpen POs

See below for description and query information.

Chart/List Category	Description	List Window	QuickSearch Query
Open this month	Quantity and balance of open purchase orders that were created within the current month.	Purchase Orders	Open equals Yes AND Date is in the range [First Day of This Month] to [Last Data Update Date]
Open last month	Quantity and balance of open purchase orders that were created in the last month.	Purchase Orders	Open equals Yes AND Date is in the range [First Day of Last Month] to [First Day of Last Month]
Open prior to last month	Quantity and balance of open purchase orders that were created before the first of last month.	Purchase Orders	Open equals Yes AND Date is less than [First Day of Last Month]

Accounts Payable Invoices Due Month-to-DateAccounts Payable Invoices Due Month-to-Date

For each invoice included in the Accounts Payable Invoice Due Month-to-Date List, the system lists:

Number

Type

Vendor Number

Vendor Name

Vendor Invoice

Date

Description

Batch

Total

Due

Due Date

To export this table's data to Microsoft Excel, do the following:

Click anywhere on the table to select the table view.

In the top left corner of the view, click the Menu Open icon. The system displays the view's menu options.

From the list of menu options, click the Export icon. The system displays an [Export to Excel] button.

Click the [Export to Excel] button. The system opens a Save File window.

On the Save File window, do the following:

In the File name field, enter a name for this file or make no change to use the default name displayed (i.e., Accounts Payable - Accounts Payable Invoices Due Month-to-Date).

Use the window's navigation controls to indicate where you want the system to save the file, or make no change to have the system save the file in the default location (i.e., the Downloads folder).

Click the [Save] button to save the file and close the Save File window.

Closing the DashboardClosing the Dashboard

Click the Close icon on the title bar of the Dashboards window.