Used to select one or more GL Account Classes. This is a multi-select standard lookup that is not required to return results. It defaults as blank. If blank, this parameter is not used but if filled in then the data is limited based on the selection.

GL Account Classes are used to classify one or more GL Accounts into a group with other similar behaving accounts and for organizing financial reports. For example, you may have several revenue accounts that are all classified as "Sales" Accounts. 

The lookup contains a list of all GL Account Classes.

Used to select the transaction date. All transactions occurring on or before the specified date will be included. This is a text box that is not required to return results. It defaults to the current date and works in conjunction with 'Date Option'. If the 'Date Option' is "GL Date", then a valid date is required. If the 'Date Option' field is "Fiscal Period", then this field must be in a format of "[Fiscal Period]-[Year]".

Used to select one or more GL Account Class Categories. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

The General Ledger Account Category identifies which major section the GL Account belongs to on the Financial Statements. Account Categories can be assigned as follows:

Balance Sheet Accounts: 

• Asset
• Liability
• Equity

Income Statement Accounts:

• Income Statement

This lookup contains the values in the GLAccountClassCategory Enumeration Class.

• Asset
• Liability
• Equity
• Income Statement

Used to select one or more GL Account Control Types. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

A Control Account is a general ledger account containing only summary amounts. The details for control accounts are stored in a separate but related subsidiary ledger. The subsidiary ledger allows for tracking transactions within the control account in more detail. Individual transactions are posted both to the control account and the corresponding subsidiary ledger, and the totals for both are compared when preparing a trial balance to ensure accuracy. Control Accounts keep the general ledger free of details, while still maintaining correct balance for preparing the company's financial statements. The most common examples of Control Accounts include Accounts Receivable and Accounts Payable. The List of Control Account Types include:

• Brokerage: The accrued brokerage payable. The details are stored in Program Balances.  
• Checkbooks: The balance of a bank account. The details are stored in the Checkbook Transactions inquiry.
• Customers: Current Accounts Receivable. The details are stored in the custom aging.
• Fishermen: Current fishermen payable/receivable. The details are stored in the Fisherman Balances inquiry. 
• Fishermen Loans: Current Fishermen Loans Receivable. The details are stored in the Fisherman Balances inquiry.
• Freight: Current Accrued Freight (from Freight POs). The details are stored in the Purchase Order Lines List View.
• Growers: Current Grower Payable. The details are stored in the vendor aging. 
• Inventory: Current inventory valuation. The details are stored in the Inventory valuation.
• Rebates: The accrued rebates payable. The details are stored in Program Balances.
• Retained Earnings: This is posted to during a year-end close.
• Vendors: Current Accounts Payable. The details are stored in the vendor aging.

This lookup contains the values in the GLControlAcctType Enumeration Class.

Used in conjunction with the 'Balances Thru' option to identify the date format. This is a single-select standard lookup that is required to return results. It defaults as "GL Date".

This lookup contains the values:

• Fiscal Period - The date values must be entered as [2-digit GL Period]-[GL Year]. For example if you want period 5 from 2020 you would enter "05-2020".
• GL Date - The dates must be in a valid date format.

Used to select one or more GL Accounts. This is a multi-select standard lookup that is not required to return results. It defaults as blank. If blank, this parameter is not used but if filled in then the data is limited based on the selection. 

A GL Account Description is the name given to a GL Account ID.

The lookup contains a list of all GL Accounts.

A lookup to assign one or more conditions you want included in your search. This lookup contains:

• 0.00 Balance GL Accounts. Defaults as unselected to ensure that only GL Accounts with a non-zero balance are displayed.
• Inactive GL Account. Defaults as unselected to ensure that only 'Active' GL Accounts are displayed.

Used to select one or more Posting Types. This is a multi-select standard lookup that is not required to return results. It defaults as blank. If blank, this parameter is not used but if filled in then the data is limited based on the selection.

This lookup contains the values in the GLAccountPostingType Enumeration Class.

• Balance Sheet
• Income Statement

A non-required text box that defaults to blank and is used to search across multiple fields. When the page is 'Refreshed', the data returned will be limited by what was included in the Search box (in addition to any other Search Options). 

Refer to this FAQ for advanced search options.

The Search field can be used to search across the following fields: 

• Account
  
  • Search a single value "1000"
  • Search a range of values "1000:2000” to return all Accounts between "1000-000-00" and "2000-000-00"
    
• Account Class
• Account Description
  
• Category (Asset, Liability, Equity, or Income Statement)
  
• Posting Type (Balance Sheet or Income Statement)

  Please note the use of keywords for searching has not been implemented on this page. For example, to search by a specific Account Description, users may not prepend the search value with the text "Account Description: ". If you have an Account Description containing "Checking", simply enter "Checking" into the Search text box. Clicking Refresh will return all results where the value "Checking" is stored in any of the searchable fields.

 Displays a drop down menu of related actions. The list of options includes:

• IQ: Account Balance by Period: Opens the Account Balance by Period Inquiry for the selected GL Account(s) in a new tab
• IQ: Journal Line History: Opens the Journal Line History Inquiry for the selected GL Account(s) in a new tab

 Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options. 

 This ONLY re-queries the contents of columns that are currently visible, if you add a new column the contents will be empty until you click 'Refresh' again.

Identifies the GL Account ID of the GL Account assigned to a transaction line, journal entry line, or master file record. This field comes from the 'Account' field on the GL Accounts List View. Once saved, this field is not editable.

A GL Account ID is the unique identifier for each record used to summarize transactions for each type of asset, liability, equity, revenue and expense.

Database Field: ERPx_GLAccount.AccountNumber

Identifies the Account Class associated with the GL Account. Account Classes are dependent on the 'Posting Type' and 'Category' that are selected. This field comes from the 'Account Class' field on the GL Accounts List View. It is always editable.

GL Account Classes are used to classify one or more GL Accounts into a group with other similar behaving accounts and for organizing financial reports. For example, you may have several revenue accounts that are all classified as "Sales" Accounts. 

Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK

Identifies the Description associated with the GL Account assigned to a transaction line, journal entry line, or master file record. This field comes from the 'Account Description' field on the GL Accounts List View. It is always editable.

A GL Account Description is the name given to a GL Account ID.

Database Field: ERPx_GLAccount.Description

Identifies the Account Category associated with the GL Account. Categories are dependent on the 'Posting Type' that is selected. This field comes from the 'Category' field on the GL Accounts List View. It is always editable. If edited on an existing GL Account, then the 'Account Class' field will be cleared.

The General Ledger Account Category identifies which major section the GL Account belongs to on the Financial Statements. Account Categories can be assigned as follows:

Balance Sheet Accounts: 

• Asset
• Liability
• Equity

Income Statement Accounts:

• Income Statement

Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK

Identifies the Control Account Type associated with the GL Account. This field comes from the 'Control Account Type' field on the GL Accounts List View. It is always editable.

A Control Account is a general ledger account containing only summary amounts. The details for control accounts are stored in a separate but related subsidiary ledger. The subsidiary ledger allows for tracking transactions within the control account in more detail. Individual transactions are posted both to the control account and the corresponding subsidiary ledger, and the totals for both are compared when preparing a trial balance to ensure accuracy. Control Accounts keep the general ledger free of details, while still maintaining correct balance for preparing the company's financial statements. The most common examples of Control Accounts include Accounts Receivable and Accounts Payable. The List of Control Account Types include:

• Brokerage: The accrued brokerage payable. The details are stored in Program Balances.  
• Checkbooks: The balance of a bank account. The details are stored in the Checkbook Transactions inquiry.
• Customers: Current Accounts Receivable. The details are stored in the custom aging.
• Fishermen: Current fishermen payable/receivable. The details are stored in the Fisherman Balances inquiry. 
• Fishermen Loans: Current Fishermen Loans Receivable. The details are stored in the Fisherman Balances inquiry.
• Freight: Current Accrued Freight (from Freight POs). The details are stored in the Purchase Order Lines List View.
• Growers: Current Grower Payable. The details are stored in the vendor aging. 
• Inventory: Current inventory valuation. The details are stored in the Inventory valuation.
• Rebates: The accrued rebates payable. The details are stored in Program Balances.
• Retained Earnings: This is posted to during a year-end close.
• Vendors: Current Accounts Payable. The details are stored in the vendor aging.

Database Field: ERPx_GLAccount.GLControlAccountTypeEN

Identifies whether the GL Account is an Income Statement Account or a Balance Sheet Account. This field comes from the 'Posting Type' field on the GL Accounts List View. It is always editable. If edited on an existing GL Account, then the 'Category' and 'Account Class' fields will be cleared.

Balance Sheet Accounts live on the Balance Sheet. Year-end balances for Balance Sheet accounts rollover during the year-end close process to become Beginning Balances for the next year. Balance Sheet Accounts are classified as either Asset, Liability, or Equity Accounts.

Income Statement Accounts live on the Income Statement (Profit & Loss Statement, P&L). Year-end balances for Income Statement accounts are automatically closed to the 'Retained Earnings Account' during the year-end close process, ensuring they start the new year with a 0.00 balance. Income Statement Accounts are classified as either Revenue or Expense Accounts.

Database Field: ERPx_GLAccount.GLAccountPostingTypeEN