Import Budget from Excel Batch Job

Imports a budget from Excel to Microsoft Dynamics NAV. This allows you to import budgets originally exported from Microsoft Dynamics NAV and import budgets that have been created in Excel.

Important

Before you import the budget, you must close Excel.

You can import a budget into Microsoft Dynamics NAV from Excel in one of the following ways:

• You can create a new budget.

• You can add the budget entries in Excel to the budget entries with the same name already present in Microsoft Dynamics NAV. You can do this can if you want to create a single consolidated budget in Microsoft Dynamics NAV that is made up of a number of individual budgets that are imported from Excel.

Options

Field	Description
Workbook File Name	Enter the name of the Excel workbook file that the budget data will be imported from.
Worksheet Name	Enter the name or number of a worksheet from the workbook that is selected in the Workbook File Name field.
Budget Name	Select the budget to which entries are imported.
Option	Select whether the budget entries are added from Excel to budget entries that are currently in the system, or whether the entries are replaced in Microsoft Dynamics NAV with the budget entries from Excel.
Description	Enter a description of the imported budget entries, so that the entries can be easily identified among other budget entries.

Tip

For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.