Creating an Unpaid Invoice Report by Fund

Creating an Unpaid Invoice Report by Fund

The Unpaid Invoice Report is a a report we can use to review unpaid invoices in the system.  This report is also handy at the end of our fiscal year to help us balance our accounts payable accounts.  For it be useful, we need to setup this report to print by account number and provide us totals by fund.  To do this, follow these steps:
  1. In Accounts Payable, go to Reports | Unpaid Invoice Report.
  2. If it isn't already, select the Unpaid Invoice Report [Caselle Master] from the Title drop-down at the top.
  3. Under the Report order: section, double-click on Column to bring up the Report Order Fields screen.
  4. On the left, double-click on "[Report].GL Account Number" to move it under the Selected Report Order Fields section.
  5. Click on "[Report].GL Account Number".
  6. Click the Move Up button three (3) times to move it to the top of the list.
  7. Click OK.
  8. Check the Title and Total checkboxes on the "[Report].GL Account Number" row.
  9. Double-click on Entire field under the Test column on the "[Report].GL Account Number" row.
  10. Change the Test to Characters.
  11.  Change the Characters to the number of characters in your fund number.  Usually your fund number consistents of two (2) or three (3) numbers.  For example, if my General Fund is fund 10, I would change the Characters to "2".
  12. Click OK.  
  13. Change the Report dates to 13/YY (e.g. 13/21).
  14. Click the Save button on the toolbar.
  15. Select Save as new report and give it a name (e.g. "by Fund").
  16. Click OK.
  17. Click the Print or Print Preview button on the toolbar to generate the report.
This report will now give you a total by fund of your accounts payable.  

Tip!: If you want to shorten the report, uncheck the Title and Total checkboxes on the "Vendor.Vendor number" and "[Report].Invoice Number" rows under the Report order section.

    • Related Articles

    • Usefulness of the Aging Report - Utility Billing

      The Aging Report in Utility Management displays all unpaid balances and puts them into different aging "buckets" depending on how long the balances have been unpaid.  There are several options you can change so that the report provides the ...

    • miViewPoint Invoice Queues Errors

      The query specified in the URL is not valid. The node count limit of 100 has been exceeded. To increase the limit set the 'MaxNodeCount' property on EnableQueryAttribute or 0DataValidationSettings. This article also applies if you see you have ...

    • Illinois Annual Treasurer's Report

      What is it? ·         The Illinois Annual Treasurer’s Report is a report that each treasurer needs to file with the clerk.  ·         The clerk then publishes the report in a newspaper that is published within the municipality. ·         This needs ...

    • Report Setup

           Date and custom options – This area of the Report Options tab will allow you to select the date or date range that you wish to run the report for.  Some reports will give you additional options here, like the ability to include all accounts or ...

    • Change format (allow for two decimal places) on the invoice quantity field

      Note: This same process can be followed to modify any field on the A/R invoice form. To change the invoice quantity format, you will need to go into the forms editor for the accounts receivable invoice.  You can either get to that from Organization | ...