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 “000000Check 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 ...
    • Open Item Aging Report

      This report will print a list of all Open Items in the system by age for each Vendor. It will then give a grand total of all Open Items at the end of the report. This report can be printed in either Detail or a Summary format. When you enter this ...
    • 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 ...
    • 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 ...
    • Invoice History Listing

      The Invoice History Listing will print a list of all Invoices for a Vendor within a specific date range, regardless of whether they have been cleared from the Vendor’s open account. When you enter this module, the screen will appear as follows: ...