IsBudgeted Article

IsBudgeted Article

The below chart shows the relationship between Great Plains Accounting "ERP" software General Ledger Chart of Accounts and Dynamic Budget's Budget Account Numbers.  To enlarge the chart, "double-click" on it and it will open in a new window.

Dynamic Budgets synchronizes the ERP General Ledger Chart of Accounts (Synchronize Chart of Accounts) and isolates 2 building blocks (OrgUnit and Object) to help you quickly organize your Dynamic Budget Chart of Accounts (Manage ERP Accounts). This allows you to mark the building blocks to be available for Budgeting (IsBudgeted) and/or Reporting (InReports).

In our example, legacy OrgUnits were made available for reporting but not for budgeting by Add OrgUnits  and unselecting them for IsBudgeted.  Legacy OrgUnits that were neither needed for Budgeting or Reporting were not added.  Also, we ignored the balance sheet and legacy Objects by unselecting them for IsBudgeted.

Dynamic Budgets relies upon the IsBudgeted flag of these building blocks to minimize unwanted and maximize required Accounts been listed in the Create Budget Accounts window so you don't accidentally create unwanted Budget Accounts. The objective is to only offer your users valid Budget Account Numbers and thereby prevent inadvertent use of discarded Accounts for budgeting. Finally we only created those Account Numbers that are budgeted to in the Create Budget Account process.


"IsBudgeted" is a check box setting on Manage Company Databases, Manage OrgUnits, Manage Objects and Manage Budgets.

For a CompanyDB, BudgetID, OrgUnit and Object to be available to be budgeted to its related checkbox needs to be checked. 

Please note that budgeting is a hierarchical structure and for a lower level to be available for budgeting, the level above needs to have its' "IsBudgeted" checkbox checked. The order of the hierarchy is CompanyDB, BudgetID, OrgUnit, Object and finally Account Number (Budget Account Number).

In our below example, in order for AccountNumber 000-4100-00 to be created as it sits at the bottom of the hierarchy, Company DB "DB3147_TWO15", BudgetID "2017 Test1", OrgUnit "000" and Object "4100-00" respective IsBudgeted checkboxes need to be checked.

Please note checking the IsBudgeted box does not create budget account numbers.  To budget to an Account Number (Budget Account Number)  it needs to be created in Create Budget Accounts.

Also by checking the checkbox the CompanyDB, BudgetID, OrgUnit/OrgUnit Rollup, Object/Object Rollups will be available to be Searched on in the Budgets dropdown menu.

Please note it can be a useful tool to limit the number of available CompanyDBs, BudgetIDs, OrgUnits, Objects in their respective Search dropdown menus to only those that are necessary by unchecking the IsBudgeted box as this can result in a "decluttered" search dropdown menu.

Below OrgUnit150  was deselected:

And you can see that it does not appear in the Search dropdown menu:

    • Related Articles

    • Create Budget Accounts Article

          Tutorial Link Video Link Prerequisite: Synchronize Chart of Accounts, Manage Objects, Manage OrgUnits Purpose: This procedure is creating budgeting accounts to store budget values. A number of steps need to completed before a Budget Account can ...
    • Basic Budget Entry Article

          Tutorial Link   Basic Budget Entry  is used for entering and viewing budgets within two tabs:  Dashboard  Account Details  Other entry and viewing screen options are the  Budgeting Dashboard , and the Custom Budget Entry .  The Dashboard tab ...
    • Custom Budget Entry Article

      Tutorial Link Custom Budget Entry is used for entering and viewing budgets. As discussed in the Define Custom Budgets Entry Forms, all of the columns can be user defined. Custom Budget Entry has two tabs: Dashboard and Account Details. Other Budget ...
    • Column Formats Article

      Column formats can be defined in the following Setup screens: Define Custom Reports; Define Basic Budgets Entry Forms; and Define Custom Budgets Entry Forms. There are two options to setup Column formats: a) Grid Layout Tab This format supports Copy ...
    • Manage Budgets Article

          Tutorial Link Purpose: To provide tools to manage budgets such as budget list, budget creation, delete/purge budget, lock budgets/acct #s, link actual GP data & display setup, display budgetids, forecast setup, create historical avg for spreads. ...