Worksheet Lines
Each account on a worksheet: history beside it, the request by level, quantity x unit cost, a trend method, a link to another line, one-time or annual, a strategic goal, justification and a 500-character memo.
Where to find it
- Module: Accounting
- Group: Planning & Control
- Section: Budgeting
- Screen: Worksheet Lines
Address in the console: /accounting/budget-worksheet-lines
List · 12 columns · 18 fields on its form · 2 of them required · 2 actions
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Worksheet | Code | worksheet_no |
| Account | Code | account_no |
| Name | Text | account_name |
| Fund | Code | fund_code |
| Level | Status | request_level |
| Prior actual | Amount | prior_actual |
| Current budget | Amount | current_budget |
| Requested | Amount | amount_requested |
| Recommended | Amount | amount_recommended |
| One-time | Yes or no | is_one_time |
| Approved | Yes or no | one_time_approved |
| Goal | Code | goal_code |
The form
What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.
| Field | Type | Choices | Notes |
|---|---|---|---|
| Worksheet required | Choice | Looked up from existing records | |
| Account required | Choice | Looked up from existing records | |
| Department | Choice | Looked up from existing records | |
| Fund | Choice | Looked up from existing records | |
| Level | Choice | Reduced, Current, Expanded | |
| How the request is computed | Choice | Entered, % of last year's actual, % of last budget, Straight line (as last year), Quantity x unit cost, % of another line (e.g. benefits of salary) | |
| Percentage | Number | ||
| Quantity | Number | ||
| Unit cost table | Choice | Looked up from existing records | |
| Unit cost | Number | ||
| Follows line | Choice | Looked up from existing records | |
| % of that line | Number | ||
| Requested | Number | ||
| Recommended | Number | ||
| One-time expenditure | Yes or no | ||
| Strategic goal | Choice | Looked up from existing records | |
| Justification | Long text | ||
| Memo (500 characters) | Long text |
What you can do here
Approve one-time
Asks for: Approved
Move to another worksheet or level
Asks for: Worksheet Level
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.
- Creating a record — required fields, where choices come from, and how the number is allocated.
- Importing a spreadsheet — this screen accepts one, and it runs through the same rules as typing.