NOTE: This option is only available for users with on-premise ERP systems, such as Visma Business, PP7, and Microsoft Dynamics.
To prepare your ERP database for the direct write-back budgeting functionality, you must run through the Budgeting Setup procedure. This procedure will install the OSR Extension tables into your ERP system’s database. These tables are designed to extend the ERP system’s following Dimensions: Account, Employee and Budget version. In addition, a table to enable budgeting Line Item Detail entries will be installed.
Many of the ERP systems lack sufficient properties in the Account and Employee master data (dimensions) to construct a full budgeting model that includes expense and payroll budgeting. The additional tables installed will provide storage capabilities for these situations.
NOTE: The Budgeting Setup will only be available if you have purchased a license for OSR Budgeting.
NOTE: This procedure does not change any of the original ERP systems’ tables or data. It only adds additional tables into the database.
For on-premise installations of OneStop Reporting: You will be asked to log on to the SQL server with a user having administration rights for inserting tables into the ERP database. After clicking OK in the Enter credentials dialog, the tables will be inserted and ready for entering additional properties to some of the master data dimensions.
For on-premise systems running the OneStop reporting Cloud Agent: To be able to set up budgeting, the user who initially installed the Cloud Agent must have administration rights for inserting tables into the ERP database.