History Options on Vendors Form

This Help File Page was last Modified on 03/16/2020

<< Click to Display Table of Contents >>

Navigation:  Accounts Payable System > Vendors Form > Navigation section on Vendors Form >

History Options on Vendors Form

This Help File Page was last Modified on 03/16/2020

History Options - The History Options Icon displays the History Options Menus for Filtering the Vendor Form's History Grid and designating the History Period for what is displayed based on that Filter.

 

HelpFilesVendorsFormGridOptions

History Options Icon - History options

 

Anytime a Vendors Form is open, Click the Grid Options Icon on the Navigation section of its Ribbon Menu to display the Grid Options Menu.

An Account History Grid may be displayed at the bottom for the Vendors Form and each User is able to customize the contents of the Account History Grid to include:

A Filter : All - or the option to pick one - of the various Types of Data Entries and Financial Transactions which have been entered for the currently selected Vendor.

A Date Range : Set the Time Frame within which the selected item(s) were posted

This Account History Grid provides a complete and immediate listing of Accounting Transactions (i.e., Bills, Payments, Credits, Purchase Orders and Calls).

 

HelpFiles5DotsBar

The Account History Grid may be displayed "Full-Screen" by Clicking the ..... (5 Dots) option just above the Account History Grid section.

To return the the normal "Split-Screen" view, Click the 5 Dots option again.

 

Understanding the History Options Menu

The three History Options are:

1. Filter - Choose this History Option to display a Drop-Down Selection List of the available Grid Data Filtering options

This will identify the type of transactional and data entry History which is to be included in the Grid.

 

HelpFilesVendorsFormGridOptionsFilters

 

a.By default, All of the available Data (within the Data Types listed) will be included in the Grid.

b.However, the User may Select the specific Type of Data that should be included in the Grid.

 

2. History - Once the Grid Data Filtering option has been chosen, the Time Frame in which the chosen Grid Data was entered may be specified.

 

HelpFilesVendorsFormGridOptions

 

a.The is no default Time Frame.

b.Use the Drop-Down Selection List that displays the available Time Frames from which to Choose.

c.Consider the practical limitations of the number of records which can be effectively viewed and/or analyzed.

 

3. Hide Grid - Turning the History Grid feature On and Off.

Hide Grid - Select the Hide Grid option to remove the History Grid from the Vendors Form.

 

HelpFilesVendorsFormHistoryOptionsHideGrid

 

Display the Grid - Select the Show Grid option to display the History Grid on the Vendors Form.

 

HelpFilesVendorsFormHistoryOptionsShowGrid

 

 

Understanding the Power of the Vendors Form History Grid - This Grid (a sample of which is shown below) offers several ways to manipulate the Grid Data

 

HelpFiles5DotsBar

Note: Remember, the Account History Grid may be displayed "full-screen" by Clicking the ..... (5 Dots) option just above the Account History Grid section.

 

HelpFilesVendorFormHistoryGrid

 

Setting the Order in which the Grid Data is Listed

The sorted order of the Grid is, by default, the Date listed from newest to oldest.

Click the Header Name (i.e., "Date") to change this sorted order to oldest to newest, and Click it again to return it to newest to oldest.

However, the column that determines the sorted order in which the data is listed may be easily changed, as needed.

Click another column's Header Name to change the sorted order to that column, with the sorted order automatically set from lowest to highest (a-z or 1 - 9).  

To change this sorted order from highest to lowest, Click that column's Header Name again.

 

Opening the associated Document - Press the Control (ctrl) key and while doing so, Double-Click on any Detail Line Item to display the Form associated with that History entry.

 

HelpFilesBillsFormGridAssociatedFormOfSelectedDetailLine

 

Grouping the Grid Data - Grid Data may be separated into Groups based on a selected column's Header Name.

Click the Header Name (i.e., "Description" in the illustration below) and Drag that Header Name to the "Drag a column header here to group by that column" message area at the top of the Grid.

The Grid Data will be sorted by that Header Name and each unique example of that Header Name will be listed but the contents of each Group will be concealed.

 

HelpFilesVendorsFormGridOptionsSampleListOfDataByGroup

 

Viewing each Group's Grid Data - Once a Grid has been sorted into Groups, each Group's Data may be displayed by Clicking the special Arrow to the left of a specific Group Name.  

Sorting each Group's Grid Data Detail

Once a Group's Grid Data Detail has been displayed, the sorted order of the Grid Data Detail may be reset by the User by Clicking the Header Name representing the desired sort order.

The sorted order of the Invoice Numbers may be reversed by Clicking the Document column (see the mouse pointer above).

To change this sorted order of the Grid Data Detail from highest to lowest, back to lowest to highest, Click that column's Header Name again.

Limiting the specific Group(s) to be displayed, and/or the specific Grid Data Detail Items that are displayed, using the Special Selection Icon - HelpFilesSubscribersFormGridOptionsHeaderFilterIcon

 

HelpFilesVendorsFormGridOptionsSampleListOfDataByGroupFilterOption

 

Click the Special Selection Icon associated with that column's Header Name  (or Group's Name) to display its Drop-Down Selection List

The List will contain the available options for that specific column's Header Name  (or Group's Name)

In the example above, the Document column contains the available items and a Check Box is positioned next to each item

Check each item that is to be included.

The un-checked items will disappear.

 

Creating a Custom Filter for the Vendor History Grid, a Group, and/or Grid Data Detail

Sometimes the User may need a more refined method to Chose which Data Entries and/or Financial Transactions will be included in the Vendors Form's History Grid.

To accommodate this need, the Special Selection Icon's Drop-Down Selection List - described above - also has a "(Custom...)" option.

This Custom Filter option is available whenever the Special Selection Icon is displayed - which is anytime the mouse pointer is positioned over a Header Name in the Grid - by Clicking that Icon and then Choosing the (Custom...) option.

When the Custom Filter option is selected, the Custom Filter dialog is displayed.

 

HelpFilesSubscribersFormGridCustomFilterDialog

The first filtering choice is "Show rows where" with the selected Header Name shown.

To define this initial filtering criteria, the User is requested to quantify how the selected column's data should compare to a value (or a different field) in one or two situations (e.g., one comparison or an and/or comparison).

Using the illustration below as a training example, let's assume the User needs to see Documents dated from 01/01/2014 through 06/30/2014 (the first half of that year)

 

HelpFilesSubscribersFormGridCustomFilterDialogExample1

Using the first Drop-Down Selection List the User would choose the first "comparative" phrase from the list provided.

 

HelpFilesSubscribersFormGridCustomFilterDialogComparisonOptions

Then, the User would enter the value to be compared, and because the system knows it will be a Document's Date, it offers a Drop-Down Calendar/Date Entry field from which a Date may be chosen.

Next, the AND button is selected (by default) - but this may be changed, if appropriate; or ignored if no additional comparison is needed (e.g., any Document Dated after 01/01/2014 would be acceptable)

Assuming a comparison is needed (it wold be in this case), use the second Drop-Down Selection List to choose the other "comparative" phrase from the list provided.

Finally,  the User would enter the other value to be compared, and because the system knows it too will be a Document's Date, it offers a Drop-Down Calendar/Date Entry field from which a Date may be chosen.

 

HelpFilesSubscribersFormGridCustomFilterDialogExample2

Click OK and the Custom Filter is implemented.

 

When a Custom Filter is active, that Filter Criteria is displayed at the bottom of the Grid.

 

HelpFilesVendorsFormGridOptionsSampleFilterCriteria

 

The User may Check and un-check the Filter Criteria to quickly see the data differences when the filter is active, or inactive

 

HelpFilesVendorFormGridFilterCloseButton

 

To Cancel the Custom Filter, Click the Close box on the left side of the Filter Criteria line.

 

Enhancing the Custom Filter:

Once defined, a Custom Filter may be further refined by Clicking the "Customize..." button at the bottom right of the Grid (which only appears if a Custom Filter is active - see arrow in the illustration below).

The Filter Builder dialog will be displayed with the original Custom Filter information already inserted.

 

HelpFilesVendorsFormGridOptionsCustomFilterWithFilterBuilder

 

Using the available Filter Builder tools, create the additional filtering needed to list the required data.