The AP Cash Requirements screen on the Financial menu uses data from SKYLINE AP Invoice Inquiry . This screen can be used for both commercial and residential properties.
NOTE You must select a Property in the Prompt section to display data in the table.
Cash Balances display in both graphical and tabular formats.
Bar Graph - This graph is produced for one property at a time displaying cash requirements by date range in an aging schedule format. The graph provides a total amount due, for all vendors, in 30 day increments to give you an idea of the overall cash requirements for this property.
Supporting Table - A grid displays below the graph to provide detail for the overall numbers. Each vendor is listed withe the total amount due (Invoices - Payments) in 30 day increments.
The Prompt button is available at the top of the screen to help you group and filter the data presented. Use the multiple selection criteria fields to isolate and customize the information that is most important to you.
In the Prompt section you have the option to show a toolbar of controls for the graph. Select the Show Tool Bars checkbox to change the display to include a toolbar at the bottom of the graph. This allows you to:
Switch the display from a graphical presentation, to a Grid (table) format
Add to the My Portal page
Display the information in Full Page format
NOTE To keep the Prompt section in view, click the push pin icon in the far right section of the screen. When this control is not in place, the prompt section hides from view to give you a larger graphical display area.
Complete any or all of the Prompt fields and click Refresh to filter the displayed results.
Table data is retrieved from the SKYLINE AP Invoice Inquiry screen. The Total Amount Due for each vendor, and for the entire property, is the net value of SKYLINE's Total Invoice Amount and Total Paid Amount. The data is then categorized by date due in an aging schedule.
Each Vendor is listed and all invoices outstanding for that vendor.
Data includes:
Vendor Name
Voucher Number
Invoice Number
Invoice Due Date
Past Due thru 30 Days, 31-60 days, 61-90 days, 91-120 days
Invoice Description
The table includes its own toolbar with multiple options to export and print, plus additional controls to manipulate the table. For instance, you can click the + shortcut to add this view to your My Portal page.
Each table column can be sorted and filtered in a variety of ways. The toolbar includes a control to view or hide the filters. The filters fields display above the top row of data (one for each column) and each includes a drop-down list of filtering options.