Compartir a través de

How to: Export Inventory Analysis Views to Excel

  • Artículo

You can export your inventory analysis views to Microsoft Excel. In Excel, you can analyze and work with data from Microsoft Dynamics NAV using the full range of features in Excel.

To export inventory analysis views to Excel

  1. In the Search box, enter Invt. Analysis by Dimensions, and then choose the related link.

  2. On the Options FastTab, in the Show field, select either Actual Amounts or Budgeted Amounts. If you select Budgeted Amounts, the Show Amount field must contain Amount.

  3. Fill in the rest of the fields on the FastTabs.

  4. When you have finished filling in the fields, on the Navigate tab, in the Actions group, choose Export to Excel.

Warning

The maximum possible number of lines in Excel is approximately 65000. If your analysis view generates too many lines, an error message will appear in Excel.

Note

In Excel, the column headings always display the code. If you select the Inv. Analysis by Dimensions window in the Show Column Name field, the column headings will display both codes and names.

See Also

Reference

Dimension

Concepts

Analysis Reports
Create Analysis Views and Reports

Other Resources

Invt. Analysis View Card