This guide will cover:
Navigating to the Payment Report with Invoice Details
Running the Payment Report with Invoice Details
Search Parameters Defined
Interpreting the Report
The Payment Report with Invoice Details gives us a report to analyze both invoices and their payments in one space. This can be run throughout the entire Fiscal Year to include the payment report emphasizing invoice details to show totals and other important invoice information.
The Table of Contents contains many of the most frequently used transactional reports in WyoCloud Financial Management. This guide will walk you through how to navigate to the table of contents.
There is a Reporting Table of Contents shortcut tile accessible under My Profile within WyoCloud.
You still have the ability to navigate to the Reporting Table of Contents through Reports and Analytics
The Payment Report with Invoice Details can be found under Business Optimization Beta Reports header in the Reporting Table of Contents
Under the Business Optimization Beta Reports header on the Table of Contents, click on the Payment Report with Invoice Details
The report page will open
You can use the parameters listed in Step Three to filter your search inside the report.
After you have put in your parameters, when the report finishes loading, the data will display underneath the prompts.
To export the report, click on the export link at the bottom of the page. Click Data and then CSV or similarly select Data followed by Excel.
The file will download, and you can open the file in the necessary means based on the web browser used.
You have the ability to sort and filter for the information you would like to see within the CSV or Excel spreadsheet.
Note: Data saved in csv will not retain data formatting
You may use any of the following prompts on the top of the screen to narrow the report to show data that is relevant to your needs.
Note: in some cases, you can leave a prompt blank. You can search individually, for example by Invoice Number or Party Name
The following criteria can be used to help you filter your search:
Field
Description
Payment Date
This field can be used to narrow down your search by payment date of invoices. Narrow results by selecting a date range for the invoice date. It is important to put in payment dates otherwise it will take longer to load.
Check Number
The number stated on the check.
Invoice Number
The number stated on the invoice.
Party Name
Party Name is the name of the requester or supplier.
Cost Center Code
Cost centers are CO objects and used for internal management reporting.
This report can be used for several reasons. When interpreting the report, you can view the following fields in the Payment Report with Invoice Details. Below is a list of each column and a description of its input:
Column
Concatenated Segments
Concatenated Segments identifies unique account combination.
Distributed Line Amount
The distributions you enter for an invoice allocate the total invoice amount to various expense or asset accounts.
The date of constructive receipt of pay, on which paychecks become negotiable.
Invoice Date
The date the invoice was created.
Invoice Description
Stating what the invoice is about.
Invoice Type Code
The code entered while creating the type of invoice.
Payment History Distribution Amount
Amount of a payment. Payables calculates the Payment Amount for the payment by subtracting the Discount Amount from the Gross Amount.
Validation Status
Displays whether the invoice has been validated or rejected.
Identifying PO
The purchase order number only for purchase orders, not applicable to non-PO invoices
Requisition
The requisition number of the invoice submitted
Cost Center Description
The description of the organization that is paying the invoice, a complete business purpose for the expense
Payment Total
The total payment made for the payment cycle
Payment Posted Status
Whether payment has been initiated for the invoice
Invoice Total
The total stated on the invoice.
Payment Document
The form of payment used for the invoice
Invoice Line Description
Defines information for the invoice lines such as amount, distribution set information, tax determinants, as well as default information to create invoice distributions.
The third-party supplier or distributor of the goods or service that was purchased
Party Site Street Address 1
Street address of supplier or distributor of the goods or service that was purchased
Party Site City
City of supplier or distributor of the goods or service that was purchased
Party Site State
State of supplier or distributor of the goods or services being purchased
Party Site Postal Code
Postal Codes allows you to associate a district with country/state/territory/city/postal code combinations.