Open Items Adjustment Register

Open Items Adjustment Register

This report module prints an audit of all activity in the Open Item Maintenance module, as well as any Recurring Items posted since the last time the report was cleared. It is considered a daily report, only on days where activity has been performed, because it must be run and cleared in preparation for the next day’s activity. The end of the report will give you the net effect on the Accounts Payable G/L Account for the day. 

When you enter this report module, the system will prompt an A/P Open Item Adjustment Register box as follows:

The Print G/L Distributions -1- box defaults to checked. If you leave it checked, for every Item on the report, the system will display each G/L Journal Distribution. This is a good way to double-check that all the entries for the day are correct. The Beginning & Ending Vendor -2- fields will default to **All**, however, if you would prefer to print and clear for a specific Vendor, or range of Vendors, you can use these fields to narrow the selection. The Vendor Type -3- field will allow you to print for a specific Vendor Type. This field is only applicable where you have previously set up Vendor Types in the Vendor Maintenance module. To learn more about Vendor Types, please see the Vendor Maintenance section of this documentation. To export the data to Excel, click the icon at the top left of the screen. Otherwise, click the Print button to continue. Whether printing or exporting, the system will prompt the following:

The data will not clear out of the module until you click the Yes button in the Confirm box. 

If you click No because you need to regenerate the data, the system will place you back at the first screen to reprint the report. When you click Yes from the Confirm box, the system will prompt an additional: Are You Sure? Click Yes again to clear the report. Please Note: Items that have been deleted will display the Deleted Date on the report, not the original Open Item Date.

    • Related Articles

    • Open Item Audit Report for A/R

      The Open Item Audit Report details the total cost changes that were made to material and freight in the Review P.O. History feature of the Open Item Maintenance module. It includes the Journal Entry that will be sent to your financials along with the ...
    • Open Items Adjustment Register

      This report module prints an audit of all activity that took place in the Customer Account Maintenance module. It is considered a daily report [this report does not need to be run on days when no activity has been performed in the Customer Account ...
    • A/P Recurring Items

      This module will allow you to set up recurring payables and quickly process those items every month. Only set up items in this module that are due on a recurring basis for the same amount. When you enter this module, the system will prompt an A/P ...
    • 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 ...
    • 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 ...