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