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#
AP Item #
AP Item Type
You are also able to filter by the below criteria when printing/exporting this report:
2. Vendor Type
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:
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
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.
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: ...