Account Class

Used to select one or more GL Account Classes. This is a multi-select lookup that is not required to return results. It defaults as blank, which implies ALL.

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.

Auto Hide Filters

A non-required text box that defaults as checked and is used to determine if the Search Options should be hidden when the Inquiry runs or is refreshed.

• When checked, each time the 'Refresh' button is clicked, the search options will be hidden, allowing for more rows of data to be visible on the page. This behavior is ideal for users that have entered their search parameters and want to see the results in full-screen. 
• When unchecked, the search options will not be hidden when the 'Refresh' button is clicked. This behavior is ideal for users that need to run several searches with different search parameters.

Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup. If you change the default setting but do not save it in a custom search, it will only remain this way while the page is opened.

Refer to this FAQ for advanced search options.

Auto Refresh on Open

A non-required text box that defaults as checked and is used to determine if the inquiry opens with or without data in the grid.

• When checked, each time the page is opened, the search is run using the default parameters (or a 'Saved Search' if one was set as your default for the page) so the grid will be populated with data .  
• When unchecked, the search is NOT run when the page opens and no data will be present until the 'Refresh' button is clicked. 

Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup.

Refer to this FAQ for advanced search options.

Budget

Used to select one or more Budgets to view details for. This is a multi-select lookup that is not required to return results. It defaults as blank, which implies ALL. This lookup contains the values in the GL Budgets Master File.

Category

Used to select one or more GL Account Class Categories. This is a multi-select lookup that is not required to return results. It defaults as blank, which implies ALL. This lookup contains the values in the GLAccountClassCategory Enumeration Class.

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

Fiscal Year

Used to select one or more Fiscal Years. This is a multi-select lookup that is not required to return results. It defaults as blank, which implies ALL.

A Fiscal Year is a one-year period that companies use for financial reporting and budgeting. A Fiscal Year is most commonly used for accounting purposes to prepare financial statements. Fiscal Years often start on January 1st and end on December 31st. However, not all Fiscal Years correspond with the calendar year. For example, a company may run their Fiscal Year from May 1st - April 30th. Once a Fiscal Year has been determined, it is unlikely to ever change outside of a company sale and/or merger.

The lookup contains a list of all Fiscal Years.

Posting Type

Used to select one or more Posting Types. This is a multi-select lookup that is not required to return results. It defaults as blank, which implies ALL.

This lookup contains the values in the GLAccountPostingType Enumeration Class.

• Balance Sheet

• Income Statement

Saved Searches

Displays the saved searches lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. Saving search options will also save the preferences for 'Auto Refresh on Open' and 'Auto Hide Filters'. The new search option can also be set as the default.  Default searches can be removed by clicking the 'Set as Default' button again when the current default search is selected.  

Refer to this FAQ for advanced search options.

Column Filter Show/Hide

 Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.

Excel

 Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Favorites

 Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. 

 Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

Group By Show/Hide

 Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 

Help

 Opens the online WIKI help page for the current page. 

Quick Column Filter

 Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.

Refresh

 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.

Save

 Saves the changes made to the record. 

Saved Layouts

 Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

Search Options

 Toggles between displaying and hiding the Search Options portion of the page.

Fields

Description

Checkbox

Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.

Account Class

Identifies the Account Class associated with the GL Account. This field is not editable from this page.
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_GLBudgetDetail.GLAccountSk, ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK

Budget

A Budget is a plan for the GL accounts in your general ledger. These are typically used to plan revenue and expense accounts (Income Statement accounts) but can also be used for Balance Sheet accounts. A GL Budget stores all the budget amounts, by fiscal period, for each GL Account. Users can configure multiple GL Budgets for a single Fiscal Year but only one can be assigned as the ‘Report Default’ at any given time. The others are used to store different versions.This field is not editable from this page.

Database Fields: ERPx_GLBudgetDetail.BudgetSK, ERPx_GLBudget.BudgetName

Category

Identifies the Account Category associated with the GL Account.This field is not editable from this page. 

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

Fiscal Year

Identifies the Fiscal Year the Budget applies to. This field is not editable from this page. 

A Fiscal Year is a one-year period that companies use for financial reporting and budgeting. A Fiscal Year is most commonly used for accounting purposes to prepare financial statements. Fiscal Years often start on January 1st and end on December 31st. However, not all Fiscal Years correspond with the calendar year. For example, a company may run their Fiscal Year from May 1st - April 30th. Once a Fiscal Year has been determined, it is unlikely to ever change outside of a company sale and/or merger.

Database Fields: ERPx_GLBudgetDetail.BudgetSK, ERPx_GLBudget.FiscalYearSK, ERPx_MFFiscalYear.FiscalYear

GL Account

Identifies the GL Account ID of the GL Account assigned to a transaction line, journal entry line, or master file record. This field is not editable from this page. 
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 Fields: ERPx_GLBudgetDetail.GLAccountSK, ERPx_GLAccount.AccountNumber

GL Account Description

Identifies the Description associated with the GL Account assigned to a transaction line, journal entry line, or master file record. This field is not editable from this page. 

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

Database Fields: ERPx_GLBudgetDetail.GLAccountSK, ERPx_GLAccount.Description

GL Account: Description

Identifies the GL Account and GL Account Description in one field as [GL Account]: [GL Account Description]. This field is not editable from this page.

Posting Type

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. This field is not editable from this page. 

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 Fields: ERPx_GLBudgetDetail.GLAccountSK, ERPx_GLAccount.PostingTypeEN

Period 01

Identifies the Budget Amount for 'Period 1' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 02

Identifies the Budget Amount for 'Period 2' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 03

Identifies the Budget Amount for 'Period 3' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 04

Identifies the Budget Amount for 'Period 4' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 05

Identifies the Budget Amount for 'Period 5' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 06

Identifies the Budget Amount for 'Period 6' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 07

Identifies the Budget Amount for 'Period 7' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 08

Identifies the Budget Amount for 'Period 8' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 09

Identifies the Budget Amount for 'Period 9' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 10

Identifies the Budget Amount for 'Period 10' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 11

Identifies the Budget Amount for 'Period 11' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 12

Identifies the Budget Amount for 'Period 12' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

Period 13

Identifies the Budget Amount for 'Period 13' for each GL Account.

This is only editable for a Budget when the Budget's 'Allow Edit' property is set to "Yes" on the GL Budget page. 

This is only applicable in Companies with a 13-period fiscal year.

Segment 1

Identifies the first part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.
A GL Account Segment refers to the individual components that make up a General Ledger Account. Every GL Account contains at least on segment called the "Natural Account". Companies often add additional "Segments" to further organize and structure their chart of accounts. GL Account Segments are typically separated by a "-" within the GL Account Number (e.g. 5003-05-4). For example, a company that runs multiple Plants and produces multiple lines of product may use three GL Account Segments: [Natural Account] - [Plant ID] - [Product Line].

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 2

Identifies the second part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.

A GL Account Segment refers to the individual components that make up a General Ledger Account. Every GL Account contains at least on segment called the "Natural Account". Companies often add additional "Segments" to further organize and structure their chart of accounts. GL Account Segments are typically separated by a "-" within the GL Account Number (e.g. 5003-05-4). For example, a company that runs multiple Plants and produces multiple lines of product may use three GL Account Segments: [Natural Account] - [Plant ID] - [Product Line].

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Segment 3

Identifies the third part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.

A GL Account Segment refers to the individual components that make up a General Ledger Account. Every GL Account contains at least on segment called the "Natural Account". Companies often add additional "Segments" to further organize and structure their chart of accounts. GL Account Segments are typically separated by a "-" within the GL Account Number (e.g. 5003-05-4). For example, a company that runs multiple Plants and produces multiple lines of product may use three GL Account Segments: [Natural Account] - [Plant ID] - [Product Line].

Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK

Total

Identifies the total budget amount for all Periods (whether the Periods are displayed or not). This is a calculated field that is not editable and calculates totals differently for each GL Account Posting Type:

• Balance Sheet Accounts: displays the budget amount from the last GL Period.

• Income Statement Accounts: displays the summary of all the Period Budget amounts.