Note: For recovery purposes, Dynamic Budgets maintains an audit trail of all export sessions.  A snapshot of the before state of the records in Great Plains is captured as well as the batch of account records transmitted during the export sessions.  This feature provides visibility and assurance to the export function.  Please see Restore Budget Snapshort to ERP.

Creating the Destination Budget in Great Plains

First the destination budget must already exist in GP.  Dynamic Budgets populates existing budgets and it will not create new budgets on the fly in GP. 

(Open Financial \ Cards \ Budgets)

Enter a BudgetID, Budget Description, choose Fiscal Year, and enter a Budget Year.

(Note if your Budget Year is not present go to Company Fiscal Period Setup, type in the latest year, and hit calculate

A. Exporting Budget Data from Dynamic Budgets to Great Plains for a single company

The process to export data is per the below screen. 

Please note that Print, Export to Excel, Print to PDF, Auto-fit Columns, Reduce/Expand Column Width, Copy, Drill and Select/Deselect All functionalities are available.

1) Fill your data shopping cart with what you want to Export by using the standard Search or Advanced Search functionality. 

Please note that the Exclude Zero Values Accounts functionality is available. 

Please use this feature with circumspect.  For example, if a prior exported account had a value in it, say $20, and then the value was changed to zero, by excluding accounts with zero value, the account in Great Plains will not be updated and will remain at $20.

1) convert budgeted amounts to a value of a currency other than the currency of the budget; and

2) provide a convenient method to manage the implementation date of a budget when this date is unknown during the budget process.

2) Where are you sending it?

3)  Tell yourself why

4) Choose an export style

a) Leave existing records and only update with the selected records

Only the records that are in the shopping cart will be updated in Great Plains and all other records in Great Plains will remain with prior exported data.

Please use this feature with circumspect. For example, if a prior exported account had a value in it, say $20, and then the value was changed to zero in Dynamics Budget and this report is not part of the shopping cart data, the account in Great Plains will not be updated and will remain at $20.

b) Delete all existing records import selected records

5) Start Export

Click the "Export" button to process the export.

The following Validation Checks performed during the Export process:

1.Source Company = Destination Company

2.Source Year = Destination Year

3.Is the budget Password protected in GP, if so prompt for password to unlock and enable the export

4.Validate that all selected accounts exist in GP (ACTINDX and ACTNUM), if not show pop-up with error accounts and drill down options to review the proposed budgets for each account.

A successful export is indicated by 2 green arrows.

A failed export will result in a error message. Please use the send error function to email the error log to Dynamic Budgets support staff for interpretation. Verify the year is accurate in the Manage Budgets screen for the Budget ID. 

Please see related article: What To Do When Exporting a Budget With Account Numbers That No Longer Exist in GP?

The system is delivered with standard Application Configuration settings for the Export Budget to GP process.  These settings and alternative settings are set in App Config/Menu Editor.  Please see A. Application Configuration Tab item number 11.

Complete the steps as above but instead of clicking the "Export" button", click the "Export for ALL companies" button.  In the below example "Budget 2017" will be exported for all CompanyIDs for which that budget was set up.