GENERAL LEDGER - Accounts List Functionality

GL Accounts List functionality overview

 

• view Account Details as well as current month activity (Debit / Credit) and current Debit Balance / Credit Balance (as of the logon date)
• Refresh to load any General Ledger Accounts that may have been created since the last refresh and that may not be displaying on this list
• General Ledger Accounts List Functionality

 

• • Filters - create a filter for this list
    • click on Filters
    • choose Any or All selector
    • select from the list of fields to set the criteria
    • select from the operators ie: ‘is one of’, ‘is not one of’, ‘does not contain’, etc - this operator list changes based on the field selected in the previous step
    • enter or select the criteria information
    • if desired click to add a line of criteria
    • to remove the line, click
    • select Filters for save options

                         

• • • • Save as default - this filter will be active whenever viewing GL Accounts
      • Remove default to remove the previously set default Filter
      • Save filter if you are making changes to a previously saved Filter
      • Save filter as… will allow you to name the Filter with the following settings:
        • give this filter a name

                                     

• • • • • select User if this filter will be used by you only
        • select  Company to save for all users
        • Show in module list to display beneath the module name
        • Save column state if you have removed or added columns and to save your column sort
        • click OK
        • the new Filter is also accessible in the Filter menu:

                                           

• • • click on the Filters button to release the current filter to see entire list or start a new filter

• • Icon Menu Customization
    • hover over the Icon Group handle until you see
    • drag the Icon Group to where you want it

• • Column Customization
    • drag and drop columns for preferred positioning
    • right-click on any column heading to list to identify which columns you wish to see in the grid

                         

• •   Column Sort - click on any column heading to sort the list by that column

          

• • • further narrow your search by just typing (you will see the typed letters turn green) and the list will highlight the closest match, in currently sorted column 

• • - type any character(s) into this field and the list will narrow to only records containing the character(s) typed, somewhere in the details
  • Open a GL Account record and use the Navigate buttons to page through GL Accounts in the list, filtered or not filtered in order of the current column sort (see next section)

• • right-click on any line(s) in the list to display the Context Menu

•   Export General Ledger Accounts in your filtered or un-filtered list in Excel (.xlsx only) or CSV type
  • will export all GL Accounts visible, with the current column layout and sort order
  • click   Export
  • choose the location File Name then Save as type (.xlsx only)
  • Save
  • option to Open File right away
    
  • from excel, make any changes or build any desired formulas