From the Microsoft Dynamics NAV Blogs: RTC for Excel Import, Managing Network Files, PDF Reports; Partner Assistance

Import Budget into Excel in Dynamics NAV RTC: Alex Chow recently commented on this subject in his blog "Confessions of a Dynamics NAV Consultant."

According to Chow, when you're working in the RTC environment in the G/L Budgets, the standard NAV function lets you export the Budgets into Excel, edit it, then import it back in the same Excel format. This works fine in the classic client, he says. But when you try to import the budget in Excel in the RTC environment, you get this error message: dates have not been recognized in the Excel worksheet.

Chow's local Microsoft rep says that the error is caused by the Dynamics NAV server recognizing the field in "datetime" format instead of just the regular date. The solution to this problem is to modify report 81. The code for the changes is found here, he adds.

Managing Network Files in RTC: The Microsoft Dynamics NAV team offers some info on the subject in this blog post.

According to Arvind Kum, the author of the post, if you're accessing files located on network machines in the RTC client in Dynamics NAV 2009, the files can be accessed when each service is running on a single machine, when SQL and NST are on same machine (two-tier) or when each service is running on a separate machine (three-tier).

But when you try to access the network files in two-tier and three-tier environments there might be some additional delegation requirements, he says. ...