View Transaction Inquiry allows you to view and print Accounts Receivable information at any time. You can also unpost invoices.
This Section Includes:
There are different filters available depending on your Type selection. You can choose Invoices or Payments.
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 (1).png){kind=small}
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.
(1).png)
•Due Date
•Setup Date
•Updated Date
Click the Search button to display results or the Clear Filters link to reset all filters.
The grid displays invoices matching the selected filters with the following columns:
•Customer
•Bill To
•Invoice #: Click the Reprint (1).png){kind=small}
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 .png){kind=small}
icon to see any notes on the attachment(s) and the filenames of attached files.
•Note: Hover over the Note (1).png){kind=small}
icon to preview the note.
•Setup: Hover over the Information .png){kind=small}
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® .png){kind=small}
icon.
Click the View Details .png){kind=small}
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.
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.
(1).png)
•Setup Date
•Updated Date
Click the Search button to display results or the Clear Filters link to reset all filters.
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.