IdealWare Online Users ManualGL4-09-07 G/L MAINTENANCE |
|
┌────────────────────────────────────────────────────────────────────────────────â”
│05/14/07 D E M O C O M P A N Y │ │ G/L REPORT DETAILS MAINTENANCE │ │ │ │ REPORT CODE __________ │ │ REPORT HEADING │ │ │ │ SECTION# │ │ LINE# │ │ COLUMN# │ │1. RANGE OR CALCULATION │ │2. TOTAL TYPE │ │ DEFAULT FOR ABOVE │ │ │ │ RANGE# │ │1. STARTING ACCOUNT │ │2. ENDING ACCOUNT │ │3. ADD OR SUBTRACT (A/S) │ │4. PERIOD# │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter the report code you wish to access.
You can not add a new code from this program.
Displays the selected report code heading.
Enter the desired section number.
The sections must already be defined using the Section Titles Maintenance program, you can not define new sections with this program.
Enter the desired line number.
The lines must already be defined using the Line Titles Maintenance program, you can not define new lines with this program.
COLUMN#
Enter the desired column number.
The column headings must already be defined using the Column Headings Maintenance program, you can not define new columns with this program.
ADD A NEW DETAIL
If you enter a combination of section/column/line numbers which have not yet been defined as a detail the following prompt is displayed.
[Enter] to add a new detail.
The program will step you through each field. Once all fields have been entered, the following prompt is displayed.
[Enter] to accept and update.
[F2] to modify.
See MODIFY AN EXISTING DETAIL below.
[F4] to not add and return to SECTION NUMBER field.
[F2] to not add a new detail.
You are returned to the SECTION NUMBER field where may enter a different NEW detail, an existing detail or press [F4] to exit.
MODIFY AN EXISTING DETAIL
If you enter an existing combination of section/column/line detail the following prompt will display.
[F1] to display the next detail defined for this report.
[Enter] to not modify and return to the SECTION NUMBER field.
"R" to modify the detail ranges.
See ADD/MODIFY DETAIL RANGES below.
"M" to modify.
Enter the number of the field you wish to modify.
Once you have modified the field data (see FIELDS below) press [Enter] to return to this prompt where you may enter the number of additional fields to modify or press [Enter] again to end modifications.
[Enter] when modifications complete.
[Enter] to Accept and update.
The file is updated and you are returned to the SECTION NUMBER field.
[F2] to make additional modifications.
You are returned to the FIELD NUMBER prompt above.
[F4] to cancel and return to SECTION NUMBER field
"D" to delete the detail.
"Y" to delete the detail.
Note: if there are ranges defined for the detail, you will be prompted to delete the ranges before you can delete the detail.
"N" to not delete the detail.
Example Report Details Maintenance display:
|
┌────────────────────────────────────────────────────────────────────────────────â”
│05/14/07 D E M O C O M P A N Y │ │ G/L REPORT DETAILS MAINTENANCE │ │ │ │ REPORT CODE NEWREPORT │ │ REPORT HEADING New Report │ │ │ │ SECTION# 01 SECTION 1 │ │ LINE# 01 LINE 1 │ │ COLUMN# 1 COL1 │ │1. RANGE OR CALCULATION R TOTALS BY ACCOUNT RANGE │ │2. TOTAL TYPE VAC VARIABLE, ACTUAL, FOR THE CURRENT YEAR │ │ DEFAULT FOR ABOVE │ │ │ │ RANGE# │ │1. STARTING ACCOUNT │ │2. ENDING ACCOUNT │ │3. ADD OR SUBTRACT (A/S) │ │4. PERIOD# │ │ │ │ │ │ │ │ │ │** 'M' TO MODIFY; 'R' FOR RANGES; 'D' TO DELETE; CR TO CONTINUE: │ │PRESS F1 FOR NExT LINE. │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
ADD/MODIFY DETAIL RANGES
If you enter a range that is not yet defined the following prompt is displayed.
[Enter] to add a new range.
The program will step you through each field (see FIELDS below). Once all fields have been entered, the following prompt is displayed.
[Enter] to accept and update.
[F2] to modify.
[F4] to not add the range and return to RANGE NUMBER field.
[F2] to not add a new range.
If you enter an existing range the following prompt is displayed.
[Enter] to not modify and return to the RANGE NUMBER field.
"M" to modify.
Enter the number of the field you wish to modify.
Once you have modified the field data (see FIELDS below) press [Enter] to return to this prompt where you may enter the number of additional fields to modify or press [Enter] again to end modifications.
[Enter] when modifications complete.
[Enter] to accept and update.
The file is updated and you are returned to the RANGE NUMBER field.
[F2] to make additional modifications.
You are returned to the FIELD NUMBER prompt above.
[F4] to cancel and return to RANGE NUMBER field.
"D" to delete the range.
"Y" to delete the range.
"N" to not delete the range.
Example Report Details Range Maintenance display:
|
┌────────────────────────────────────────────────────────────────────────────────â”
│05/14/07 D E M O C O M P A N Y │ │ G/L REPORT DETAILS MAINTENANCE │ │ │ │ REPORT CODE NEWREPORT │ │ REPORT HEADING New Report │ │ │ │ SECTION# 01 SECTION 1 │ │ LINE# 01 LINE 1 │ │ COLUMN# 1 COL1 │ │1. RANGE OR CALCULATION R TOTALS BY ACCOUNT RANGE │ │2. TOTAL TYPE VAC VARIABLE, ACTUAL, FOR THE CURRENT YEAR │ │ DEFAULT FOR ABOVE │ │ │ │ RANGE# 01 │ │1. STARTING ACCOUNT 011000 BANK ACCOUNT │ │2. ENDING ACCOUNT 011000 BANK ACCOUNT │ │3. ADD OR SUBTRACT (A/S) A ADD │ │4. PERIOD# C │ │ │ │ │ │ │ │ │ │** 'M' TO MODIFY; 'D' TO DELETE; CR TO CONTINUE: │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
FIELDS
Enter the report code you wish to access.
You can not add a new code from this program.
Displays the selected report code heading.
Enter the desired section number.
The sections must already be defined using the Section Titles Maintenance program, you can not define new sections with this program.
Enter the desired line number.
The lines must already be defined using the Line Titles Maintenance program, you can not define new lines with this program.
Enter the desired column number.
The column headings must already be defined using the Column Headings Maintenance program, you can not define new columns with this program.
"R" to total the detail by account range.
"C" to calculate detail total based on other totals.
Enter a formula using totals and numbers as defined here.
A formula performs a computation between the totals calculated by sections, lines, rows and columns, or a combination based on the following references.
Totals are derived by tyyyx where:
t = Total TYPE; yyyy = ROW NUMBER; and x = COLUMN NUMBER
Total TYPES:
L = Lines
S = Sections
M = Major sections
ROW NUMBER:
TYPE L = Section Number + Line Number
TYPE S = Section Number + 00
TYPE M = Section Number + Section Number
Totals can be calculated by combining with the following operands:
+ = ADD
- = SUBTRACT
* = MULTIPLY
/ = DIVIDE
('; ') = COMBINE
For example, the following formula would calculate the difference between a budgeted total and an actual total for a range of expense accounts within one section with the budgeted amounts in column 1 and the actual amounts in column 2: S01001-S01002.
The formula breaks out as follows: S0100 = Section 01+00, the 1 and 2 final digits represent columns 1 and 2 respectively, the operand is the connecting minus sign.
If you select "R" for a range you will be prompted to enter a total type and then specify a range of accounts.
Enter the 3 character total type using the following information:
1ST letter:
Period (M=Monthly, Q=Quarterly, Y=Yearly, V=Variable)
2ND letter:
Source (A=Actual, B=Budgeted)
3RD letter:
Year# (C=Current, N=Next Budget, 1=One Back, 2=Two Back, etc)
Example: MAC = Month to date, Actual, for the Current Year
Enter a desired range number.
Enter the starting division and account number for the range.
Use division XX if the report is to consolidate balances for a number of divisions.
Enter the ending division and account number for the range.
Use division XX if the report is to consolidate balances for a number of divisions.
"A" to add to the line/column total.
"S" to subtract from the line/column total.
"C" to use the specified period's balances.
"C""-""??" to use ?? prior month's balances.
For example, C-02 for two month prior to specified period.
"O" to use the specified period's opening balances.
"1"..."1""2" to Use the indicated period of the specified period's year.
The current or specified period is entered when printing the report.
If you select "C" for a calculation you will be prompted to enter a formula.