What is the Relationship between the Master Chart of Accounts and Dynamic Budget's Budget Account Numbers? Article

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.

When Dynamic Budgets synchronizes the ERP GL Chart of Accounts Numbers (Synchronize Chart of Accounts) to Dynamic Budgets it isolates 2 building blocks (OrgUnit and Object) to help you quickly organize your Dynamic Budget Chart of Accounts Numbers (Manage Master Chart of 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  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 ...
    • 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 ...
    • 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 ...