Accounts Receivable > View >

Transaction Inquiry

 

         

 

 

Overview

View Transaction Inquiry allows you to view and print Accounts Receivable information at any time. You can also unpost invoices.

 

This Help page contains the following sections:

Filters

Invoice Inquiry

Invoice Inquiry Result

Payments Inquiry

Payments Inquiry Results

 

 

Filters

There are different filters available depending on your Type selection. You can choose Invoices or Payments.

 

 

Invoice Inquiry

Select what type of invoices on which to inquire:

 

Open and Closed

Open

Closed

Unposted

 

If you select Open you can also select to Show Removable Invoices Only.

 

The Unposted filter selection allows you to view invoices that have been unposted through the 'Unpost Invoice' option in Transaction Inquiry.

 

For Invoice # select the range of invoices from which to inquire or Show All. Select the # of Days Past Due range if desired or Show All.

 

Select the Customer or Bill To by clicking the (not set) link or the Search  icon. This displays the Person Search window. By default the search text for the Name field searches for last names and organizations. To search for first and last names enter your search in the "lastname, firstname" format. You can also search by City and State. Select the name you wish to inquire on and click the Select button. Alternately, click the Close link to return to the previous page without selecting a name.

 

Note: Search for just a first name by starting your search with a comma (e.g., ", James"). Display a complete list of names by searching for just a comma.

 

You also have access to the following filters:

 

Revenue Centers

Sources

Divisions: There is a filter for each division you have set up in Preferences.

Items

Invoice Posting Periods

Invoice Date: Select the date range within which to inquire.  Additional date filters may appear depending on what option you choose.

Due Date

Setup Date

Updated Date

 

Click the Search button to display results or the Clear Filters link to reset all filters.

 

 

Invoice Inquiry Results

The grid displays invoices matching the selected filters with the following columns:

 

Customer

Bill To

Invoice #: Click the Reprint  icon to reprint an invoice.

Invoice Date

Due Date

Days Past Due

Total Amount

Outstanding

Payments

Discounts

Write Offs

Revenue Center

Source

Divisions: There is a column in the grid for each division you have set up in Preferences.

ACH

Attach: Hover over the Attach  icon to see any notes on the attachment(s) and the filenames of attached files.

Note: Hover over the Note  icon to preview the note.

Setup: Hover over the Information  icon to display user and time information for when the invoice was set up and last updated.

 

Below the grid display Totals for the Total Amount, Outstanding, Payments, Discounts, and Write Offs columns in addition to Unapplied (Unapplied Cash) and Net totals. 

 

You can export your results to a Microsoft® Excel .xlsx file by clicking the Export to Excel®  icon.

 

Click the View Details  icon to view the details of an invoice (More Information).

 

Click the Print Transaction Inquiry Report button to display a preview of your report. Click Report Preferences to customize what displays on this report. You have the following options:

 

Include Invoice Distributions: Select this option to include items, item descriptions, and item amounts from the invoice detail.

Print Notes

Print Setup Information

Print Bill To Address and Phone

Print Divisions

 

All detail for the displayed transactions is displayed including item information if the option to Include Invoice Distributions is selected. There are totals for each bill to and Final Totals at the bottom of the report. A recap also displays with Totals by Revenue Centers, Totals by Sources, and an Item Recap.

 

If you have changed the selected options click the Run Report button to display an updated report preview. You may also click the Clear Preferences link to reset all of your report preferences to their initial values. Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click Report Preferences on the blue bar above the report preview to return to Report Preferences. Click the Close Report button when finished to return to the Transaction Inquiry page.

 

 

Payments Inquiry

Select what type of payments on which to inquire:

 

Posted

Voided

 

Use the Check # field if you want to inquire on a specific check number. The # of Days Past Due field is not used for payments inquiry.

 

Select the Customer or Bill To by clicking the (not set) link or the Search  icon. This displays the Person Search window. By default the search text for the Name field searches for last names and organizations. To search for first and last names enter your search in the "lastname, firstname" format. You can also search by City and State. Select the name you wish to inquire on and click the Select button. Alternately, click the Close link to return to the previous page without selecting a name.

 

Note: Search for just a first name by starting your search with a comma (e.g., ", James"). Display a complete list of names by searching for just a comma.

 

You also have access to the following filters:

 

Revenue Centers

Sources

Divisions: There is a filter for each division you have set up in Preferences.

Items

Payment Posting Periods

Payment Date: Select the date range within which to inquire.  Additional date filters may appear depending on what option you choose.

Setup Date

Updated Date

 

Click the Search button to display results or the Clear Filters link to reset all filters.

 

 

Payments Inquiry Results

The grid displays payments matching the selected filters with the following columns:

 

Bill To

Check #

Payment Date

Check Amount

Unapplied Cash

Payment Posting Period

ACH

Attach: Hover over the Attach  icon to see any notes on the attachment(s) and the filenames of attached files.

Note: Hover over the Note  icon to preview the note.

Setup: Hover over the Information  icon to display user and time information for when the payment was set up and last updated.

 

You can export your results to a Microsoft® Excel .xlsx file by clicking the Export to Excel®  icon.

 

Click the View Details  icon to view the details of a payment (More Information).

 

Click the Print Transaction Inquiry Report button to display a preview of your report. Click Report Preferences to customize what displays on this report. Select the Report Type:

 

Detail: The complete details of each payment (broken down by bill to) are displayed, along with the invoices against which they were applied. There are totals for each bill to and Final Totals at the bottom of the report.

Summary: For each payment the following columns are displayed: Customer, Check #, Payment Date, Check Amount, and Unapplied.

Images: The Bill To, Check #, Date, Amount, and the check image are displayed.

 

If Detail is selected you can also choose to Print Notes and Print Setup Information.

 

If you have changed the selected options click the Run Report button to display an updated report preview. You may also click the Clear Preferences link to reset all of your report preferences to their initial values. Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click Report Preferences on the blue bar above the report preview to return to Report Preferences. Click the Close Report button when finished to return to the Transaction Inquiry page.

 

Compiled on 1/24/2018 8:42:27 AM