Using XMLPORT to Export & Import Excel File

sunnyk · 2017-09-21

Hi,
Is it possible to Export the Data from NAV(Say Sales Lines Table) and after updating certain Columns, import the same file to reflect the updates in NAV.
For. e.g. If we want to export Sales Lines(based on user filters- Like location etc.) in Excel and than user updates the Quantity & Prices in Excel and the same Updated Excel we want to import back to NAV to update the sales Lines with these values.

Regards,
Ali

allenyyzhou · 2017-09-22

Hi, Sunnyk

I think what you want is a typical use of OData, you can check belowing post
https://msdn.microsoft.com/en-us/dynamics-nav/configuring-dynamics-nav-excel-addin

sunnyk · 2017-09-25

Thanks. But i need to run some code after importing the data like releasing the SO.

Duikmeester · 2017-10-05

Look at the Budget Export / Import functionality.

Using XMLPORT to Export & Import Excel File

Answers

Categories