Create Budget from Flat File - GLBUCF
The General Ledger Create Budget from Flat File (GLBUCF) utility uploads budgets from a flat file. The file may hold multiple lines of budgets for various accounts. GLBUCF typically loads one budget per account per file, where all the accounts are either key-object format or FQA. In addition, the file may load an annual, quarterly, or monthly budget that is created in an Excel spreadsheet (space-delimited or comma-separated value file format).
Name of the budget upload file: Features a remote file lookup.
Ledger Side: Defaults to GL (ledger) or update to JL (job ledger).
Year & Version for the New Budget:
'TO' Fiscal Year: Enter the four-digit fiscal year.
'TO' Budget Version: Select a budget version that is not calculated. The content validates to GLUPGN, Budget tab, Code column. The version selected here is where file contents will load. If an administrator set up Budget Version filtered security, it displays only versions that the user has write access to.
Upload Which Type of Budgets?:
AN - Annual Budgets
FA - FTE & Annual Budgets
FT - FTE Budgets Only
MO - Fiscal Period Budgets
QT - Quarterly Budgets
Create budgets at what level?: Drop-down validates to GLUPGN, Object tab offering the object level or object part codes specific for the given ledger. Data displayed will be unique to that ledger makeup. In this example list, BAL, INC, and BCAT are object groups, and OBJ is the object code:
BAL
INC
BCAT
OBJ - Object Code
The ledger selection will be the preferred ledgers of the user, as defined in NU Manage Users, or click Settings on the main menu bar and Settings again to see the active ledgers.
Would you like the Report Only option?: Creates a test or proof before committing to the upload. If you would like to see what GLBUCF will upload without actually uploading the data, select the checkbox (Yes). A report will display the accounts in a GL Account column and the budget amounts under a Budget column. Problems with formatting or other errors will display in both the report and tailsheet.
Do you wish to log budget changes? Y/N: If you select the checkbox (Yes), additional fields display:
Budget change Reason code: Enter a budget reason code. Reason Codes are defined in NU Common Code BURS/xxxx.
Budget change reference number: By default, SYSTEM appears in the Budget change reference number field.
Budget change Reference Date: The system defaults to the current date.
Budget change Set ID: By default, SYSTEM appears in the Budget change Set ID field.
Replace Existing Budget Amounts?: Y/N
Options:
New Budget Flag: Option allows user to put a budget block or warn flag on the budgets being copied to. Select from the following options to set this flag based on the ledger composition. In this example list, BAL, INC, and BCAT are object groups, and OBJ is the object code:
00 - Leave As Is - New Budgets " "
01 - Blank - No Budget Checking
A1 - Authorize at BAL Level
A2 - Authorize at INC Level
A3 - Authorize at BCAT Level
AO - Authorize at OBJ Level
B1 - Block at BAL Level
B2 - Block at INC Level
B3 - Block at BCAT Level
BO - Block at OBJ Level
W1 - Warn at BAL Level
W2 - Warn at INC Level
W3 - Warn at BCAT Level
WO - Warn at OBJ Level
Show exceptions only?: Select the checkbox (Yes) to display only errors within the file.
Would you like to use an Account Conversion Table: Y/N