GL Account Format List View
A GL Account Segment is a specific part of a GL Account. Every GL Account contains at least 1 segment referred to as the "Natural Account" but some companies require additional structure to segment Natural Accounts by things like Companies, Divisions, Departments,, etc. GL Account Segments are typically separated by "-" (e.g. 2000-00).
The purpose of the GL Account Format List View is to set and see the GL Account Segments that make up the structure of your company's GL Accounts. From here, users can drill down to the individual Segment lists for each Segment. Once a GL Account has been added, this structure is no longer editable.
Software Version: 2019.09.03 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Cancel | Cancels the current unsaved changes and returns the view from Edit mode to Read only mode. This toolbar icon is only displayed when the view is in edit mode. |
| Edit | Puts the list view in edit mode allowing all editable fields to be modified at one time. To get out of edit mode you must either Cancel or Save your changes. |
| Excel |  Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, 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.
|
| Grid Layout | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).
|
| Help | Opens the online WIKI help page for the current page.
|
| New | Opens a new blank record for data entry. |
| Save | Saves all changes. |
| Fields | Description |
| Checkbox | Used to select one or more records. |
| Length | A text box to set the number of characters for the Account Segment. This is required and must be >=1 and <= the value in the 'Max Length'. This is not editable after the initial Save. Database Field: ERPx_GLAccountFormat.SegmentLength |
| Max Length | A text box to set the maximum number of characters you would ever envision for each Account Segment. GL Accounts have a max allowable length of 66 so the sum of all the Max Lengths cannot exceed 66 characters. In most companies that values are the same in both the 'Length' and 'Max Length' fields or the values in the 'Max Length' fields exceed the values in the 'Length' by 1 or 2. This is required and must be >=1 and the total of all these values must be <= 66. This is not editable after the initial Save. Database Field: ERPx_GLAccountFormat.SegmentMaxLength |
| Natural Account | A Yes/No lookup to identify whether or not the Account Segment is the Natural Account. The value defaults to "No" but can be changed at anytime. A value of "Yes" means that the Segment is the Natural Account and a value of "No" means that it is not. One of the Segments, and only one, must be assigned as the Natural Account. Database Field: ERPx_GLAccountFormat.IsNaturalAccount |
| Segment | The unique identifier of the Segment. This defaults to blank but is required for all records, must be unique, and must be <= 15 characters. Typical Names would include names like: Account, Company, Department, and Division. A GL Account Segment is a specific part of a GL Account. Every GL Account contains at least 1 segment referred to as the "Natural Account" but some companies require additional structure to segment Natural Accounts by things like Companies, Divisions, Departments,, etc. GL Account Segments are typically separated by "-" (e.g. 2000-00). Database Field: ERPx_GLAccountFormat.SegmentName |
| Seq. | A label to identify the sequence your segments should be in. This is editable by users by using drag+drop. Database Field: ERPx_GLAccountFormat.Sequence |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.