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
In the Search box, enter G/L Budgets, and then choose the related link.
Select a budget. On the Home tab, in the Process group, choose Edit Budget.
On the Filters FastTab, in the G/L Account Filter field, select the general ledger account number.
On the Home tab, in the Excel group, choose Export to Excel.
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.
On the G/L Budget Entry FastTab, select the appropriate filters.
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
In the Search box, enter G/L Budgets, and then choose the related link.
Select a budget. On the Home tab, in the Process group, choose Edit Budget.
On the Budget Matrix FastTab, select the matrix.
On the Filters FastTab, in the G/L Account Filter field, select the general ledger account number.
On the Home tab, in the Excel group, choose Import from Excel.
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.
Choose the OK button.
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 |
|---|
For more information about how to work with fields and columns, see Working with Microsoft Dynamics NAV. For more information about how to find specific pages, see Search. |