What is the Relationship between the Master Chart of Accounts and Dynamic Budget's Budget Account Numbers? Article
The below chart shows the relationship between Great Plains Accounting ("ERP") software General Ledger ("GL") Chart of Accounts Numbers and Dynamic Budget's Budget Account Numbers. To enlarge the chart, "double-click" on it and it will open in a new window.
Account Numbers cannot be created in Dynamic Budgets. This is by design and acts as a control such that you will only budget to valid Account Numbers which were originally created in the ERP.
It is important that Dynamic Budgets ERP Account Number list is current and is therefore a mirror image of the GL Account Numbers in the ERP. Maintaining a mirror image of ERP Account Numbers in Dynamic Budgets is a manual process and is managed through the Synchronize Chart of Account screen and its associated "Yellow Brick Road" wizard.
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 but unselecting them for IsBudgeted. Legacy OrgUnits that were neither needed for budgeting nor reporting were not added. Then we ignored balance sheet and legacy Objects by unselecting them for IsBudgeted.
Dynamic Budgets relies upon the IsBudgeted flag of these building blocks to both minimize unwanted and maximize required Accounts Numbers been listed in the Create Budget Accounts window so unwanted Budget Accounts are not accidentally created. The objective is to only offer your users valid Budget Account Numbers and thereby prevent inadvertent use of discarded Accounts Numbers for budgeting. Finally we only created those Account Numbers that are budgeted to in the Create Budget Accounts process.
Related Articles:
Report Level -GL Code, Object or Object Rollup
How Do I report on Account Segments?
Related Articles
Manage Master Chart of Accounts Article
Standard functionality is Print, Export to Excel, Print to PDF, Auto-fit Columns, Expand/Reduce Column Width, Filter, Column Data Sort-Ascending/Descending, and Copy and Paste. The Right-Click and Short-Cut Keys are: When a new General Ledger ("GL") ...
Synchronize Chart of Accounts Article
Standard functionality includes Print, Export to Excel, Print to PDF, and Auto-size Columns. When the system is first setup Great Plains Accounting ("ERP") software General Ledger ("GL") Account Numbers are imported into Dynamic Budgets using the ...
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 ...
Manage Budget Accounts Article
Standard functionality is Print, Export to Excel, Print to PDF, Auto-fit Columns, Expand/Reduce Column Width, Filter, Column Data Sort - Ascending/Descending, and Copy and Paste. The Right-Click Menu and Short-Cut Keys are: In order to free-up ...
Account Number (Budget Account Number) Article
An Account Number refers to the full General Ledger Account Number ("GL Accounts") which originates from Great Plains Accounting Software ("ERP"). Account Numbers cannot be created in Dynamic Budgets. This is by design and acts as a control such ...