Using XMLPORT to Export & Import Excel File

sunnyk

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

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

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

Duikmeester

Look at the Budget Export / Import functionality.