Purpose: To build a link to the SQL server(s) where the ERP system(s) are located. Dynamic Budgets (DB) can be installed in a single SQL instance or distributed across multiple linked SQL servers.

This screen is the first step in configuring the system.
The purpose of the screen is to build a link to the SQL server or servers where the ERP system(s) are located.
Dynamic Budgets can be installed in either a single SQL instance or in a distributed fashion across multiple linked SQL servers.
In Single server installs, the Dynamic Budgets database is typically co-located on the same SQL server as the production instance of the ERP.
For Single Server Installs:
Linked Server Alias
| Linked Server Database | System Database
| ERP
|
PRIMR | SQLServerName\Instance | DYNAMICS or the Name of the SystemDatabase | DynamicsGP |
For Multi Server (Linked Server) Installs:
| Linked Server Alias
| Linked Server Database
| System Database
| ERP |
Primary Server (location of budgeting database) | PRIMR
| SQLServerName\Instance | DYNAMICS | DynamicsGP |
Linked Server | 5 character alias as specified in Linked Server definition | SQLServerName\Instance
| DYNAMICS or the Name of the SystemDatabase
| DynamicsGP
|
Related Articles
Manage Servers Tutorial
PDF Tutorials Interactive Tutorial Cropped Screenshots Full Page Screenshots Purpose: To build a link to the SQL server(s) where the ERP system(s) are located. Dynamic Budgets (DB) can be installed in a single SQL instance or distributed ...
What to do after Upgrading GP and/or Migrating to a new SQL Server Article
What to do after Upgrading GP and/or Migrating to a new SQL Server Adjusting Dynamic Budgets after a GP upgrade is typically just a 5 minute task, see the steps below. If you migrated GP to a new SQL server, please send us the name/instance of the ...
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. ...
Manage Objects Article
Tutorial Link Purpose: The client's objects already in GP, are synchronized/added from GP into the Dynamic Budgets manage object screen. Add'l setup procedures are completed including flags, sensitivity levels, object rollups & tag labeling. ...
Manage OrgUnits Article
Tutorial Link Purpose: During Client Configuration, the client's OrgUnits or Depts need to be added to Dynamic Budgets to make them available for budgeting and reporting purposes. They are managed in the Manage OrgUnits tab. Once OrgUnits has ...