Import Budget into Excel in Dynamics NAV RTC

When you’re working in the RTC environment in the G/L Budgets, the standard NAV function is that you can export the Budgets into Excel, edit it, then import it back in in the same Excel format. This works fine in the classic client, however, when you try to import the budget in Excel in the RTC environment, you get the error message:

Dates have not been recognised in the Excel worksheet

The problem, as explained by my local Microsoft rep, is caused by the Dynamics NAV server recognizing the field in Datetime instead of just regular date. The solution to this problem is to modify report 81 with the following object.

Report81RTC

The code for the changes is found here:

http://www.mibuso.com/forum/viewtopic.php?f=23&t=46932&p=247791#p247791

  1. Alex – Can you also simply change the format in Excel to match the datetime format NAV is requiring? Does this refer to the months that serve as the budget column headers?

  2. I don’t know. I haven’t tried it yet. Even if it does work, I wouldn’t ask the end users to do this. For the end users, I’d rather not have them mess with the format of the file. It should be Export Out in Excel, then Import it back in without any additional edits.

  3. I get this error merely re-importing an excel sheet that was exported from NAV. It won’t eat it’s own dogfood.

  4. This is why there are hotfixes.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.