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.
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.
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: