You can import and export budgets using the Import Budget from Excel batch job and the Export Budget to Excel batch job.

For example, you can export budget entries and process the data in Microsoft Excel. You can then import the modified data.

To export a budget

  1. In the Search box, enter G/L Budgets, and then choose the related link.

  2. Select a budget. On the Home tab, in the Process group, choose Edit Budget.

  3. On the Filters FastTab, in the G/L Account Filter field, select the general ledger account number.

  4. On the Home tab, in the Excel group, choose Export to Excel.

  5. In the Export Budget to Excel window, on the Options FastTab, fill in the fields as described in the following table.

    Field Description

    Start Date

    The start date to be included in the budget.

    No. of Periods

    The number of accounting periods.

    Period Length

    The length of the accounting periods for the budget.

    Column Dimensions

    Optionally, specify the dimensions that you want to include.

    Note
    If you have set filters for dimensions on the G/L Budget Entry FastTab, you must always specify the same dimensions in the Column Dimensions field on the Options FastTab. Dimension information will be lost when you import from Microsoft Excel if you do not specify the same dimensions.

    Include Totaling Formulas

    Select to include the sum formulas in Microsoft Excel.

  6. On the G/L Budget Entry FastTab, select the appropriate filters.

  7. Choose the OK button.

The data that you specified is exported to Microsoft Excel.

Optionally, you can save the save the workbook as a Microsoft Excel workbook (.xlsx file). You can save the workbook locally, or you can save it to a shared location, such as a SharePoint site.

To import a budget

  1. In the Search box, enter G/L Budgets, and then choose the related link.

  2. Select a budget. On the Home tab, in the Process group, choose Edit Budget.

  3. On the Budget Matrix FastTab, select the matrix.

  4. On the Filters FastTab, in the G/L Account Filter field, select the general ledger account number.

  5. On the Home tab, in the Excel group, choose Import from Excel.

  6. In the Import Budget from Excel window, on the Options FastTab, fill in the fields as described in the following table.

    Field Description

    Budget Name

    The budget to which you want the entries to be imported in the Import to section.

    Option

    Replace entries - To replace entries in Microsoft Dynamics NAV with the budget entries from Microsoft Excel in the Import to section.

    -or-

    Add entries - To add the budget entries from Microsoft Excel to Microsoft Dynamics NAV in the Import to section.

    Description

    The description for the imported budget entries in the Import to section.

  7. Choose the OK button.

  8. In the window that appears, specify the file that you want to import.

    Note
    If you want to import a budget from a workbook that is stored in a shared location, such as on a SharePoint site, you must navigate to the location and then choose the file. If you copy the shortcut to the file into the File name field, Microsoft Dynamics NAV may show an error message. Alternatively, you can save the file locally and then import it.

Tip

See Also