Skip to content

Knowledge Base

← Back to Knowledge Base Home

Training Tidbit: Report Template for Vendor Chart of Account Totals

Are you looking for a report in the School Accounting System that shows certain information, but cannot find a standard report matching your exact specifications? If so, did you know that you are able to build an unlimited number of custom reports in the Report Writer module to meet your specific reporting needs?

For example, you can create a custom report to show the vendor totals by account number for a specific time frame. The report can be generated for a particular vendor and/or account number, and printed in a detail or summary format. Below are samples of the Vendor Chart of Account Totals Report built in Report Writer, showing the totals for a vendor from invoices paid in the period of July 1, 2012, to December 31, 2012.

Sample 1 – Vendor Chart of Account Totals Report in Summary

RWTemplate9Sample1

Sample 2 – Vendor Chart of Account Totals Report in Detail

RWTemplate9Sample2

For those customers who have the full version of the Report Writer module licensed, we have provided a complimentary template of this report for you to download from our website. You can then import the report template into the Report Writer module using the Import option. Refer to the steps below for detailed instructions.

Downloading the Report Template:

  • Click this link to access the report template file:
      https://docs.su-inc.com/training/rw/RWTemplate9.exe
    • A message will appear prompting to run or save the file; click the Run button (the Open button if using Windows 2000).
      Note: Depending on the security settings of your Internet browser, an additional prompt may appear after clicking the Run button stating the publisher could not be verified; if the additional message appears, click Run to continue.
    • When prompted for the location in which to save the unzipped file, specify a location and then click the Unzip button. The system will default to save the file on your C: drive, but that can be changed if desired. Please note the location you select for where to save the unzipped file.
    • Once the file has been unzipped, a message will appear stating the process was successful; click OK.
    • Then click the Close button to close the screen.
    • There will now be a file called Transfer.mdb containing the report template in the location you specified above.

    Importing the Report Template into Report Writer:

    • From the Report Writer screen, select the File menu and then Import.
    • The Select Report Writer Database File screen will display prompting for the location of the Transfer.mdb file. Specify the correct location (as noted above) by keying the complete path and file name in the File Name field, or selecting the correct path from the list that appears; then click Open.
    • At the Import screen, select the report to import by clicking once on the box under the Selected column to the left of the report name. A checkmark will appear in the box if the report is selected.
    • Then click the Execute button.
      Note: If a report with the same name already exists, the system will prompt asking whether you want to replace the existing file; click Yes to replace the existing file, or click No to import the file under another report name.
    • When the import is complete, a message will appear; click OK.
    • Click the X in the upper right-hand corner of the Import screen to display the Report Writer screen.

    The Vendor Chart of Account Totals Report will now be available in Report Writer, and can also be printed by selecting the Reports menu on the main Accounts Payable screen, and then Report Writer – Custom.

    For more information on the Report Writer module, visit the Report Writer product page of our website. Also, to register for a Report Writer or Advanced Report Writer Workshop where you will learn how to create similar reports and those using additional report features, visit our training calendar.