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

Export the contents of the list view 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 only the filtered contents 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. 

 This icon is only visible on pages that are documented in the online help.

New

Inserts blank lines that allow adding multiple new records.

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.

Save

Saves all changes.

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.

Fields

Description

Account

The unique identifier of the GL Account record. This defaults to blank but is required for all records, must be unique and must be <= 75 characters. If not assigned, the record is not saved. If assigned, the Account must contain the correct number of segments and each segment must be the correct length as specified in the GL Account Format page. This field is editable if integration is set to None, otherwise it is disabled after the initial Save. 

Linked Database Field: ERPx_GLAccount.AccountNumber

Account Class

A single-select standard lookup to assign the Class the GL Account belongs to. This is only used for reporting and does not control any other behavior in NorthScope. This defaults to blank and is required. If not assigned, the message "Account Class is required." will be displayed on Save. This field is always editable. If either the 'Posting Type' field or the 'Category' field are updated, then the value in this field will be cleared.

Linked Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK 

This lookup contains a list of all 'Active' Account Classes that match the selected 'Category'.

Account Description

The name associated with the GL Account. This is required for all records, does not need to be unique, and must be <= 75 characters. If not assigned, the message "Account Description is required." will be displayed on Save. This field is always editable. 

Linked Database Field: ERPx_GLAccount.Description

Category

Identifies the Category associated with the GL Account. This is a single-select standard lookup that is required. This defaults as blank and is always editable. If the 'Posting Type' field is updated, then the value in this field will be cleared.

Linked Database Field: ERPx_GLAccountClass.GLAccountClassCategoryEN

This lookup contains the values in the GLAccountClassCategory Enumeration Class and is dependent on the 'Posting Type' that is selected.

Control Account Type

A single-select standard lookup to identify GL Accounts that balance to a subsidiary journal. The Control Account Type identifies which subsidiary the account balances to and some GL Account look-ups are limited to only accounts within a specified Control Account Type. This defaults to blank and is not required. This field 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.

Linked Database Field: ERPx_GLAccount.GLControlAccountTypeEN

This lookup contains all the values in the GLControlAcctType Enumeration Class. 

Inactive

A Yes/No field used to identify if the GL Account is Inactive. If set to 'Yes' then the GL Account will not be included in look-ups for transactions or other master files. If set to 'No' then the record can be freely used. This value is always editable but users will not be able to inactivate a GL Account that has a current balance, the message "You cannot inactivate a GL Account with a balance." will be displayed on Save. 

Linked Database Field: ERPx_GLAccount.IsInactive 

Posting Type

A single-select standard lookup to select whether the Account belongs on the Balance Sheet or Income Statement. This defaults to 'Balance Sheet' and is required. This field is always 

• "The Posting Type of account XXXX-XX-XXX-XX cannot be changed because it was used in a previous year end closing entry. Year End entries can be reversed if you need to change the Posting Type."

• "The Posting Type of account XXXX-XX-XXX-XX cannot be changed because it is a balance sheet account and has an ending balance in a closed year. Year End entries can be reversed if you need to change the Posting Type."

Balance Sheet Accounts roll over and Income Statement Accounts are closed to Retained Earnings when a Year-End is run.

Linked Database Field: ERPx_GLAccount.GLAccountPostingTypeEN 

This lookup contains all the values in the GLAccountPostingType Enumeration Class. 

Typical Balance

A single-select standard lookup to select whether the Account typically carries a Debit or Credit balance. This defaults to Debit, is always required, and is always editable.

Linked Database Field: ERPx_GLAccount.GLTypicalBalanceEN

This lookup contains all the values in the GLTypicalBalance Enumeration Class. 

Use In AP

A Yes/No lookup to identify whether or not the 'GL Account' will be included in the Purchase Account lookup for AP Invoices and Credit Memo transactions. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for AP transactions and a value of "No" means that it will not. 

 This is also evaluated for imported records that come through the Inbound Integration tables. 

Linked Database Field: ERPx_GLAccount.UseInAP

Use In GL

A Yes/No lookup to identify whether or not the 'GL Account' will be included in manual journal entry 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for journal entries and a value of "No" means that it will not. 

 This is also evaluated for imported records that come through the Inbound Integration tables. 

Linked Database Field:ERPx_GLAccount.UseInGL 

Use In IM

A Yes/No lookup to identify whether or not the 'GL Account' will be included in Inventory transaction 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for Inventory transaction line items and a value of "No" means that it will not.

Linked Database Field: ERPx_GLAccount.UseInIM 

Use In SO

A Yes/No lookup to identify whether or not the 'GL Account' will be included in Sales Transaction 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for Sales transaction line items and a value of "No" means that it will not.

Linked Database Field: ERPx_GLAccount.UseInSO

Use In SP

A Yes/No lookup to identify whether or not the 'GL Account' will be included in Sales Program 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account" look-ups for Sales Program transactions look-ups and a value of "No" means that it will not.

Linked Database Field: ERPx_GLAccount.UseInSP