Edit

Vendor payments workspace

  • Article

The Vendor payments workspace shows information that is related to the processing of vendor payments. This workspace includes a My work view and an Analytics page. The My work view shows summary tiles, vendor transaction grids, and related vendor information. The Analytics page uses the capabilities of Microsoft Power BI to show visuals that are related to vendor payments.

Setup needed to view Power BI content

The following setup needs to be completed for data to display in Vendor payments Power BI visuals.

  1. Go to System administration > Setup > System Parameters to set System currency and System Exchange Rate.
  2. Go to General Ledger > Calendars > Fiscal calendars to validate fiscal calendar dates assigned to the active time period.
  3. Go to General Ledger > Setup > Ledger to set Accounting Currency and Exchange Rate Type.
  4. Define exchange rates between transaction currencies and accounting currency, and accounting currency and system currency. To do this, go to General Ledger > Currencies > Currency exchange rates.
  5. Go to System administration > Setup > Entity Store to refresh the latest version of Vendor payment measure aggregate measurement. For example, Vendor payment measure V3 as of August 2023.

My work view

Summary tiles

The tiles in the Summary section give an overview of the state of your payment information. You can see payment journals that aren't yet posted, invoices that are past due, all vendors, and vendors that are on hold. From the Summary section, you can create a new pay run.

The information in the Summary section is for the company that you're signed in to.

Vendor transactions grids

The Vendor transactions section contains grids that show the invoices that are past due and payments that aren't settled. From the Invoices past due grid, you can view the settlement history for a selected invoice. From the Payments not settled grid, you can view the settlement history for a selected invoice and settle an invoice.

Centralized payment clerks can use a filter that appears at the top of each grid to select a company. The grid is then filtered so that it shows only those companies that are defined in the centralized payment organizational hierarchy that the centralized payment clerk has rights to view.

The Find transactions tab in the Vendor transactions section lets you search for a vendor transaction.

You can view the Vendor aging report and the Payment summary by date report by using the links in the Related information section of the workspace.

Analytics page

The Analytics page provides important metrics, such as vendor invoices that are past due and vendor invoices that are due in the future. This page contains nine report pages. One page provides an overview, and the other eight pages provide details about Accounts payable payment metrics.

The following table shows the visualizations that are available on each report page.

Report page Visualization
Vendor payments overview
  • Invoices past due
  • Invoices due today
  • Discounts taken to discounts lost
  • Invoices due in future by cash discount date
  • Invoices due in future by due date
  • Invoices paid late to invoices paid on time
  • Payment workflow assignment
  • Vendor to customer balance
  • Open invoices with payment hold
Invoices past due
  • Invoices past due
  • Invoices past due details
  • Total open invoices
  • Invoices past due per vendor group
  • Invoices past due per company
Invoices due today
  • Invoices due today
  • Invoices due today details
  • Invoices due today per company
  • Invoices due today per vendor group
Discounts taken to discounts lost
  • Discounts taken to discount lost
  • Discounts taken to discount lost details
  • Discounts taken to discount lost per company
  • Discounts taken to discount lost per vendor group
Invoices due in future
  • Invoices due in future
  • Invoices due in future details
  • Invoices due in future per company
  • Invoices due in future per vendor group
  • Invoices due in future by cash discount date
  • Invoices due in future by due date
Invoices paid late
  • Invoices paid after due date
  • Invoices paid after due date details
  • Invoices paid after due date per company
  • Invoices paid after due date per vendor group
  • Invoices paid late versus invoices paid on time
Payment workflow
  • Vendor payment workflow instances
  • Vendor payment workflow instances per approver
  • Vendor payment workflow instances per company
  • Average days in workflow by approver
Vendor to customer balance
  • Vendor to customer balance
  • Vendor to customer balance per company
  • Vendor to customer balance details
Invoices with payment hold
  • Invoices with payment hold
  • Invoices with payment hold details
  • Invoices with payment hold per company
  • Invoices with payment hold per vendor group