View a Vendor's Payable Activity

Access

Tabs:  Summary, Open Bills, Closed Bills

This routine is a STORIS standard DTS (Dynamic Tab Select) A custom, user-defined inquiry routine comprised of one or more STORIS inquiry routines. Each inquiry routine in a DTS appears as a tab, allowing you to move between inquiries. inquiry. You can modify its contents via the Dynamic Tab Settings (DTS Setup) routine, but you cannot delete it. Since DTSs are user-defined and changeable, the descriptions in this topic may not match the DTS inquiry you see on your screen. This topic describes the DTS as it appears when you first install STORIS.

Use this inquiry to view open and closed payable activity for a selected vendor.  After you specify a vendor to view, information on the vendor appears on the screen. Click on the other tabs to view additional information.  This routine includes separate tabs for various document types. Each tab includes a grid whose columns are specific to the type of document.

If you select the special RFND vendor, some fields are inactive and some columns in the grid function differently.  See the field and grid documentation below.

VendorEnter the code of the vendor whose payable activity you want to view. If you click on the Search button, the Vendor Name Search appears.

Summary

This tab displays a summary of payable information related to the selected vendor.

Aging Method

AgeThis field displays six aging periods, each of whose duration is determined by the Bill Aging Days field in the Payables Control Settings.  

AmountThese 6 fields display amounts based on their corresponding Age field labels.  Each displays the total open amount for their aging period.

Total on HoldThe total open amount of all AP bills with a Hold status displays.

Total PendingThe total amount of all AP bills with a Pending status displays.

Calendar YTD DollarsThe year-to-date total dollars paid to this Vendor displays.  The system uses the calendar total as opposed to fiscal year total because 1099 amounts are calendar-based.

Previous Year DollarsThe total dollars paid to the Vendor in the prior calendar year displays.

Exchange RateThe domestic exchange rate appears.  To display the exchange rate for non-U.S. vendors, click on the Currency Toggle option on the Actions button.

Open Bills

This tab displays detailed information on open AP bills.  The grid display is listed in (AP) Bill number order. Use the entry fields to filter A pattern through which data is passed. Only data that matches the pattern is allowed to pass through the filter. your output.  Click on the Filter button to search for AP bills based on your selected search criteria. Note that the Filter button is not active until you specify a filter value.

Status to Include

Hold CodeEnter the hold code to which you want to restrict this inquiry. If you click on the Arrow, a list of Hold codes appears from which you can choose. If you click on the Action button, the Multiple Hold Code Selection Window appears from which you can choose one or more Hold codes. If you leave the field blank, you select all codes.  

This field is active only if you select Hold at the Status to Include field.  

CompanyEnter the company to which you want to restrict this inquiry. This field is active only if multi-company possessing is active.  If multi-company possessing is active, you can click on the Arrow to display a list of companies from which you can choose. If you click on the Action button, the Multiple Company Selection Window appears from which you can choose one or more companies. If multi-company possessing is not active, the default company appears and the field inactivates.  If you leave the field blank, you select all companies.  

Bill TypeEnter the bill type to which you want to restrict this inquiry. If you click on the Arrow, a list of bill types appears from which you can choose. If you click on the Action button, the Multiple Bill Type Selection Window appears from which you can choose one or more bill types. If you leave the field blank, you select all bill types.  

If you select the special RFND vendor at the Vendor field, this field is not available.

Remit ToEnter the code of the vendor remit-to to which you want to restrict this inquiry. If you click on the Arrow, a list of vendor remit-to's appears from which you can choose. If you click on the Action button, the Multiple Remit-To Selection Window appears from which you can choose one or more vendor remit-to's. If you leave the field blank, you select all vendor remit-to's.  

If you select the special RFND vendor at the Vendor field, this field is not available.

Purchase OrderUse this field to restrict this inquiry to one or more purchase orders for the selected vendor. If you click on the Action button, the View Billed Purchase Orders By Vendor routine appears from which you can choose one or more purchase orders.  If you leave the field blank, you select all purchase orders.  

If you select the special RFND vendor at the Vendor field, this field is not available.

Invoice/Customer

Closed Bills

This tab displays summary payable information related to the selected vendor.  The grid display is listed in (AP) Bill number order.  Use the entry fields to filter your output.  Click on the Filter button to search for AP bills based on your selected search criteria. Note that the Filter button is not active until you specify a filter value.

CompanyEnter the company whose you want to restrict this inquiry to. This field is active only if multi-company possessing is active.  If multi-company possessing is active, you can click on the Arrow to display a list of companies from which you can choose. If you click on the Action button, the Multiple Company Selection Window appears from which you can choose one or more companies. If multi-company possessing is not active, the default company appears and the field inactivates.  If you leave the field blank, you select all companies.  

Bill TypeEnter the bill type to which you want to restrict this inquiry. If you click on the Arrow, a list of bill types appears from which you can choose. If you click on the Action button, the Multiple Bill Type Selection Window appears from which you can choose one or more bill types. If you leave the field blank, you select all bill types.  

If you select the special RFND vendor at the Vendor field, this field is not available.

Remit ToEnter the code of the vendor remit-to to which you want to restrict this inquiry. If you click on the Arrow, a list of vendor remit-to's appears from which you can choose. If you click on the Action button, the Multiple Remit-To Selection Window appears from which you can choose one or more vendor remit-to's. If you leave the field blank, you select all vendor remit-to's.  

If you select the special RFND vendor at the Vendor field, this field is not available.

Invoice/CustomerUse this field to restrict this inquiry to one or more invoices. Or, if you selected the RFND vendor, you can restrict the inquiry to a specific customer. If you leave the field blank, you select all invoices/customers. If you click on the Action button and select Enter Multiple Invoices, you access the Multiple Invoice Entry screen, which you can use to select more than one invoice. When inquiring on the RFND vendor, the Action button offers the Customer Lookup option, which provides access to the Search for a Customer screen.

Purchase OrderUse this field to restrict this inquiry to one or more purchase orders for the selected vendor. If you click on the Action button, the View Billed Purchase Orders By Vendor routine appears from which you can choose one or more purchase orders.  If you leave the field blank, you do not restrict your inquiry to selected purchase orders.  

If you select the special RFND vendor at the Vendor field, this field is not available.

Starting DateEnter the starting date in the range of dates for which you want to view vendor bills. A date of 30 days previous defaults, but you can override this date.  Note that entering a large a time frame in this routine may increase the grid-load time.

Ending DateEnter the ending date in the range of dates for which you want to view vendor bills.