This chapter contains these topics:
Section 87.5, "Budget Change by Account (BA & BU Ledger) (P14101) (Release A9.3 Update),"
Section 87.6, "Detailed Budget by Account - Batch Z File (P14101Z) (Release A9.3 Update),"
Processing Option | Processing Options Requiring Further Description |
---|---|
LEDGER TYPE: | |
1. When entering budgets to the amounts and units ledgers, the ledger type "BA" and "BU" is assumed.
If you wish to enter to a different ledger (such as a temporary budget or a revised budget), you must designate the alternate budget ledger types. Budget Amounts Ledger: Budget Units Ledger: |
|
NOTE: The ledger codes on this screen must be valid in User Defined Codes 09/LT. If not, the program will not function. | |
BUDGET CYCLE: | |
2. Enter a '1' next to each item you wish to update in the Account Balances file (F0902).
If all items are left blank, the default will only update the Final Budget. Requested Budget: Approved Budget: Final Budget: |
|
DISPLAY OPTIONS: | |
3. Enter a '1' to display Balance Sheet accounts, otherwise only Profit and Loss accounts will be displayed. | |
FISCAL YEAR: | |
4. Enter the last two digits of the fiscal year.
Leave blank to use the current fiscal year. |
|
EDIT POSTING EDIT CODE: | |
5. Enter a '1' if you do NOT want the program to edit changes to accounts with a posting edit code of 'L' when a blank subledger has been entered.
Leave blank to edit accounts with a posting edit code of 'L' when a blank subledger has been entered. |
Processing Option | Processing Options Requiring Further Description |
---|---|
LEDGER TYPE: | |
1. When entering budgets to the amounts and units ledgers, the ledger type "BA" and "BU" is assumed.
If you wish to enter to a different ledger (such as a temporary budget or a revised budget), you must designate the alternate budget ledger types. Budget Amounts Ledger: Budget Units Ledger: |
|
NOTE: The ledger codes on this screen must be valid in User Defined Codes 09/LT. If not, the program will not function. | |
BUDGET CYCLE: | |
2. Enter a '1' next to each item you wish to update in the Account Balances file (F0902).
If all items are left blank, the default will only update the Final Budget. Requested Budget: Approved Budget: Final Budget: |
|
DISPLAY OPTIONS: | |
3. Enter a '1' to display Balance Sheet accounts, otherwise only Profit and Loss accounts will be displayed. | |
FISCAL YEAR: | |
4. Enter the last two digits of the fiscal year.
Leave blank to use the current fiscal year. |
|
EDIT POSTING EDIT CODE: | |
5. Enter a '1' if you do NOT want the program to edit changes to accounts with a posting edit code of 'L' when a blank subledger has been entered.
Leave blank to edit accounts with a posting edit code of 'L' when a blank subledger has been entered. |
Processing Option | Processing Options Requiring Further Description |
---|---|
LEVEL OF DETAIL: | |
1. Specify the lowest level account to be printed (e.g., - 7). | |
FISCAL PERIOD: | |
2. Enter fiscal year and period.
Leave blank to use the financial reporting year and period. Year: Period: |
|
LEDGER TYPE: | |
3. Enter ledger type. (Leave blank for General Ledger Type "BA".) | |
FORMAT: | |
4. Enter "1" to print expense and liability accounts as minus amounts. | |
5. Enter "1" to cause page skipping and to print headings with page number and run date on each page.
Enter "2" to cause page skipping and to print headings without page number and run date on each page. If blank, heading will print on first page only. |
|
6. Enter "1" to print the long form on 198 column paper or leave blank to print on 132 column paper. | |
INCOME COMPUTATIONS: | |
7. Select one of the following:
1 - Compute B/S Net Income 2 - Compute P&L Net Income Leave blank for no computation. |
|
INTERIM TOTALS: | |
8. Enter a "1" to print Interim Totals as defined by "FS" Automatic Accounting Instruction. | |
BUDGET CALCULATIONS: | |
9. Select one of the following:
1 - Requested Budget 2 - Approved Budget 3 - Final Budget |
|
10. Select projected budget calculation:
1 - Actual + Remaining Budget 2 - Actual/Percent Complete 3 - Remaining Budget Leave blank for no calculation. |
|
11. Enter "1" to calculate the percent change based on the projected budget or leave blank to use the total annual budget.
NOTE: If option 10 is left blank the percent change calculation will be based on the total annual budget. |
|
SUBLEDGER INFORMATION: | |
12. Enter specific subledger or '*' for all subledgers. (See Proc Opt 13) | |
13. Enter a subledger type if you have selected a specific subledger in processing option 12 above. | |
CURRENCY CODE INFORMATION: | |
14. Enter a specific currency code or '*' for all currency codes. | |
ENHANCED SUBLEDGER INFORMATION: | |
15. Enter the specific Enhanced Subledgers and/or Type in the options below or set the Subledger to '*' for all Subledgers/Types.
Enhanced Subledger 1 . . . . . . . Enhanced Subledger 1 Type. . . . . Enhanced Subledger 2 . . . . . . . Enhanced Subledger 2 Type. . . . . Enhanced Subledger 3 . . . . . . . Enhanced Subledger 3 Type. . . . . Enhanced Subledger 4 . . . . . . . Enhanced Subledger 4 Type. . . . . |
Processing Option | Processing Options Requiring Further Description |
---|---|
ROUNDING CONTROL: | |
1. Enter Rounding Increment for Amounts:
Result of rounding will be exactly divisible by this entry. 10.00 = round to nearest 10.00 00 = round to nearest 1.00 ' ' = round to smallest company currency unit |
|
2. Enter Rounding Increment for Units:
Result of rounding will be exactly divisible by this entry. NOTE: This option only applies if you are spreading a units ledger type 'xU'. |
|
3. Identify Balancing Method:
' ' = Do not force the total of the rounded period amounts to equal the annual budget amount. '1' = Force a balanced spread by rounding the annual budget amount prior to the spread. '2' = Force a balanced spread by NOT rounding the last calculated period amount. NOTE: This option only applies when an annual budget amount is not an even multiple of your specified rounding increment. |
|
4. Identify Rounding Method:
' ' = Round up or down to nearest increment. '1' = Round up to next increment. '2' = Round down to previous increment. |
Processing Option | Processing Options Requiring Further Description |
---|---|
LEDGER TYPE: | |
1. When entering budgets to the amounts and units ledgers, the ledger type "BA" and "BU" is assumed.
If you wish to enter to a different ledger (such as a temporary budget or a revised budget), you must designate the alternate budget ledger types. Budget Amounts Ledger: Budget Units Ledger : |
|
NOTE: The ledger types on this screen must be valid in User Defined Codes 09/LT. If not, the program will not function. | |
FISCAL YEAR: | |
2. Enter the last two digits of the fiscal year.
Leave blank to use the current fiscal year. |
Processing Option | Processing Options Requiring Further Description |
---|---|
DREAM WRITER VERSIONS: | |
1. Enter the version to be used to call Detailed Budget by Account (P14101).
If left blank, ZJDE0001 will be used. |
|
ERROR REPORTING: | |
2. Enter '1' to skip printing the error report. If left blanks, the report will print. | |
3. Enter the version to be used to call the error report program (P00ZERR).
If left blank, ZJDE0001 will be used |
Processing Option | Processing Options Requiring Further Description |
---|---|
LEDGER TYPE: | |
1. Enter the budget or primary ledger to be used for calculations.
Blank will default to budget ledger ('BA'). |
|
2. Enter a second ledger to be used for calculations.
Blank will default to encumbrance ledger or commitment ledger ('PA'). |
|
3. Enter a third ledger to be used for calculations.
Blank will default to actual amount ledger ('AA'). |
|
BUDGET YEAR: | |
4. Enter the budget year.
Default is the current fiscal year. |
|
CALCULATION METHODS: | |
5. Specify the Budget Totaling Method to be used (1-3).
Default of blank will use method '1'. 1) Sum of original budget, additional period amounts for the year, and prior year end posting amount. 2) Sum of period amounts for the year. 3) Sum of original budget, additional amounts through the current period. Use option 1 or 3 only if the original budget is not spread to periods. |
|
LEVEL OF DETAIL: | |
6. Specify lowest level of detail to be used in budgeting (e.g., 7). | |
SUBLEDGER PROCESSING: | |
7. Enter a specific subledger or '*' for all subledgers. | |
8. Enter a subledger type if you have selected a specific subledger above. | |
ENHANCED SUBLEDGER PROCESSING: | |
9. Enter specific Enhanced Subledger and Types or '*' for ALL subledgers in the options below.
Enhanced Subledger 1 . . . . . . . Enhanced Subledger 1 Type. . . . . Enhanced Subledger 2 . . . . . . . Enhanced Subledger 2 Type. . . . . Enhanced Subledger 3 . . . . . . . Enhanced Subledger 3 Type. . . . . Enhanced Subledger 4 . . . . . . . Enhanced Subledger 4 Type. . . . . |
Processing Option | Processing Options Requiring Further Description |
---|---|
UPLOAD FILE NAME: | |
1. Enter the name of the file that contains the spreadsheet data to be converted. | |
UPLOAD MEMBER NAME: | |
2. Enter the name of the file member that contains the spreadsheet data to be converted.
If left blank, the default is *FIRST. |
Processing Option | Processing Options Requiring Further Description |
---|---|
The following processing options allow you to map the starting column and corresponding field length of PC spreadsheet records to be transferred to F0902.
Example: Business Unit MCU X_Y____________ Enter the X value followed by a space and then the Y value. X = The starting column of the field. Y = The length of the field. |
|
ACCOUNT ID INFORMATION: | |
ACCOUNT CRITERIA - TYPE 1: | |
1. Business Unit MCU 12 | |
2. Additional Mapping Area | |
3. Additional Mapping Area | |
4. Account Object OBJ 6 | |
5. Additional Mapping Area | |
6. Additional Mapping Area | |
7. Subsidiary SUB 8 | |
ACCOUNT CRITERIA - TYPE 2: | |
8. Short Account ID AID 8 | |
ACCOUNT CRITERIA - TYPE 3: | |
9. 3rd Account Number ANS 25 | |
ACCOUNT CRITERIA - TYPE 4: | |
10. Single Account Number ANI 29 (Business Unit, Object, Subsidiary are a single field on the PC spreadsheet) or FLEX. | |
OPTIONAL ACCOUNT INFORMATION: | |
11. Subledger SBL 8 | |
12. Subledger Type SBLT 1 | |
13. Enhanced Subledger 1 ABR1 12 | |
14. Enhanced Subl Type 1 ABT1 1 | |
15. Enhanced Subledger 2 ABR2 12 | |
16. Enhanced Subl Type 2 ABT2 1 | |
17. Enhanced Subledger 3 ABR3 34 | |
18. Enhanced Subl Type 3 ABT3 1 | |
19. Enhanced Subledger 4 ABR4 34 | |
20. Enhanced Subl Type 4 ABT4 1 | |
PERIOD/MONTHLY BUDGET INFORMATION: | |
21. Net Posting 01 AN01 15 | |
22. Net Posting 02 AN02 15 | |
23. Net Posting 03 AN03 15 | |
24. Net Posting 04 AN04 15 | |
25. Net Posting 05 AN05 15 | |
26. Net Posting 06 AN06 15 | |
27. Net Posting 07 AN07 15 | |
28. Net Posting 08 AN08 15 | |
29. Net Posting 09 AN09 15 | |
30. Net Posting 10 AN10 15 | |
31. Net Posting 11 AN11 15 | |
32. Net Posting 12 AN12 15 | |
33. Net Posting 13 AN13 15 | |
34. Net Posting 14 AN14 15 | |
ANNUAL BUDGET INFORMATION: | |
35. Requested Budget BREQ 15 | |
36. Approved Budget BAPR 15 | |
37. Original/Final Budget BORG 15 | |
OPEN QUERY SECTION:
You can use IBM based OPNQRYF commands to limit your selection. |
|
38. Command Line 1 | |
39. Command Line 2 | |
40. Command Line 3 | |
41. Command Line 4 |
Processing Option | Processing Options Requiring Further Description |
---|---|
REFERENCE DATA: | |
1. The member name to be uploaded.
If left blank, the default is *FIRST. NOTE: If multiple members exist *ALL is valid. For *ALL, the individual members MUST have identical formats. |
|
2. The (P14110MAP) DREAM Writer version that contains the mapping instruction.
If left blank, the default is ZJDE0001. |
|
BUDGET PERIOD: | |
3. Century number and Fiscal Year.
Century: Year: NOTE: Century is 19 for 1900s or 20 for 2000s. |
|
LEDGER TYPE: | |
4. The Ledger Type to receive the budget records.
If left blank, the default is BA. |
|
ACCOUNT VALIDATION: | |
5. The Account Criteria Type
1 - Business Unit, Object, Subsidiary (3 separate fields) 2 - Short Account ID 3 - 3rd Account Number 4 - Business Unit, Object, Subsidiary (a single field) or FLEX account |
|
PERIOD TO BUDGET: | |
6. Enter 1 for an annual period.
If left blank, the default is monthly. |
|
BUDGET CYCLE: | |
7. Enter a '1' next to each item you wish to update in the Account Balances file (F0902).
If all items are left blank, the default will only update the Final Budget. Requested Budget: Approved Budget: Final Budget: |
|
NUMERIC EDITS: | |
8. Enter 1 to add/subtract the current budget with previous budget entries.
If left blank, the default is to overlay existing budget entries. |
|
9. Enter 1 for no sign reversal on revenue accounts. If left blank, the default is to reverse the sign.
NOTE: If revenue credit entries are positive on the PC Spreadsheet this option should be left blank. |
|
JOB COST: | |
10. Enter 1 for Job Cost Budgeting.
Annual budget amounts will not be updated in F0902. Default of blank will update annual budget amounts. |
|
MODE: | |
11. Enter 1 for final mode.
If left blank, the default is Proof mode. NOTE: Proof mode does not update F0902. It generates a report only. Final mode updates F0902 and also generates a report. |