Chart of Accounts
Description
Used by DAS for Quick Reports using rows by "Chart of Account" rollup. In the context of creating Quick Reports for Financials, Job Cost, or Fixed Assets, this calculation is created through the wizard. This calculation utilizes the Level of Detail Rollup that can be created inside of the JD Edwards F0901 Account Master table to create grouping levels that roll up in a tree structure based on the designer's settings.
Calculation Editor
Options
| Input Parameter Values |
Input Values |
| Grouping Mode |
Financial: OBJ, SUB or Job Cost: SUB, OBJ |
| Start Level of Detail |
Integer between 3 and 9 |
| End Level of Detail |
Integer between 3 and 9 |
| Consolidate |
Check Box that removes duplication of grouped fields with the same names by consolidating all similar fields under one bucket (ex: one instance of Petty Cash rather than 5 visible) |
| Group by Description |
Check Box that sets up the grouping structure to be alphabetical by level and description name rather than the default structure order |
| Strip Blanks |
Check Box that removes the blank characters in a field description before making the groups visible. |
| Group Outputs |
Check Box ensures all levels of grouping for your Chart of Accounts are displayed in a tree structure |
| Only Rollup If |
Generic Criteria |
| Input |
Input Values |
Required |
| Input 1 |
Column or Literal with Default of the Model Account Column |
✔ |
- Adjust the Start and End Level of Detail inputs to determine which parts of the chart of accounts structure will be displayed and how many grouping levels there are.
- When utilizing the Chart of Accounts calculation and grouping structure, no other column groupings can be added before or after.
- The Chart of Accounts grouping automatically collapses the lowest level of grouping with no method of keeping that expanded due to the nature of the Chart of Accounts logic in JD Edwards.
- This calculation constructs hidden grouping columns to create the visible account hierarchy. Use the "Show System Columns" option from the Hide/Show Columns dialog to view these columns. At that time, the additional Account calculations will appear with the level of grouping number attached at the end of their alias (ex: CALC_3_7 for group level 7 of your chart of accounts).