Training Tidbit: Report Template for Vendor Listing by Last Check Date
Are you looking for a report that lists vendors in Accounts Payable in order by the date they were last paid? With Report Writer, you are able to create a report (or copy and modify a standard report) to obtain this information.
The report example below has been created by copying the Vendor Listing and adding the Last Check Date field, a group (sort) on the Last Check Date field, and a parameter for the Last Check Date field.
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/RWTemplate3.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 in the Look In field; 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 Listing by Last Check Date 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 Vendor Reports. To see a full example of this report, click the link below.
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.