Vendor History by GL Account Report

Vendor History by GL Account Report

This report allows you to view Vendor activity broken down by G/L Account Number and will also give you additional data for each entry such as Posting Period, G/L Sequence, Invoice number, Check number, Checking Account, Paid Date and the Debit or Credit amount. The Excel export data gives even more data, including the following:

Vendor Tax ID/SS#
Account
Account Name
Posting Period
Date
Reference
AP Item #
AP Item Type
Checking Acct
Check #
Paid Date
Debit/Credit

You are also able to filter by the below criteria when printing/exporting this report:

1. Vendor
2. Vendor Type
3. Date
4. G/L Acct #
5. Paid Items only

When you enter this report module, the system will prompt a Vendor History By G/L Account screen as follows:

 

 

At the Vendor ID -1- field, the default is **All** for all Vendors. Use the Vendor ID button to select a specific Vendor for the report where applicable. At the Vendor Type -2- field, again, the default is **All** for all Vendor Types. This field is only applicable where you have previously set up Vendor Types in the Vendor Maintenance module. Use the drop-down arrow to print for a specific Vendor Type. To learn more about Vendor Types, please see the Vendor Maintenance section of this documentation. At the Beg & End Date -3- fields, click in each box to access the drop-down calendar to set a date range for this report. The Starting and Ending Account -4- fields will default to **All**. To print for only one G/L Account or a range of G/L Accounts, use the Starting and Ending Account buttons to make G/L Account Number selections. The Paid Items Only -5-option will be checked by default. To include unpaid items (items not in the A/P Check Register History file), uncheck this option. Those items will appear on the report with a “000000” Check number. When all selections have been made, click the Excel icon to export the data or click the Print button to print the report.

 


    • Related Articles

    • Vendor Maintenance

      This is a set-up module that must be completed prior to going “live” on the RollMaster System—thereafter, this module will be used to add new vendors and edit the system vendor database. All Vendors with a balance due at the time the RollMaster ...

    • Check History

      This module will allow you to view all checks that have been printed in the system by Vendor, by Invoice number, by Check number, and by PO number. This module is useful for quickly determining whether a specific item has been paid. When you enter ...

    • Print Account History Report

      This report prints the information that you see in the Account Maintenance/Inquiry module. For each account, it will print a period ending balance for 2 Years Ago, Last Year, This Year, and Next Year. This report is helpful if you think someone ...

    • Account Detail Inquiry

      This module is used to view activity detail posted to a G/L Account on screen rather than having to print out a report. Detail from all nine journals can be viewed in this module. The detail in this module can also be printed out through the Print ...

    • Purge Cleared Account Activity

      When an Invoice is paid in full, or a Credit Memo or prior payment is applied to an open item, those items will still show in the Customer Status Inquiry module and print out on the Detail Listing reports even though they have a zero balance. This ...