{"id":200,"date":"2011-12-20T15:35:04","date_gmt":"2011-12-20T20:35:04","guid":{"rendered":"https:\/\/www.apcdynamics.com\/articles\/?p=200"},"modified":"2011-12-20T15:35:04","modified_gmt":"2011-12-20T20:35:04","slug":"import-budget-into-excel-in-dynamics-nav-rtc","status":"publish","type":"post","link":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/","title":{"rendered":"Import Budget into Excel in Dynamics NAV RTC"},"content":{"rendered":"<p>When you&#8217;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:<\/p>\n<p><strong>Dates have not been recognised in the Excel worksheet<\/strong><\/p>\n<p>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.<\/p>\n<p><a href=\"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2011\/12\/Report81RTC.rar\">Report81RTC<\/a><\/p>\n<p>The code for the changes is found here:<\/p>\n<p><a href=\"http:\/\/www.mibuso.com\/forum\/viewtopic.php?f=23&amp;t=46932&amp;p=247791#p247791\">http:\/\/www.mibuso.com\/forum\/viewtopic.php?f=23&amp;t=46932&amp;p=247791#p247791<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you&#8217;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 theRead more<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-200","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Import Budget into Excel in Dynamics NAV RTC | Confessions of a Dynamics 365 Business Central Consultant<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alex Chow\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/\"},\"author\":{\"name\":\"Alex Chow\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/aef29f75349626d15235713ce1db83f0\"},\"headline\":\"Import Budget into Excel in Dynamics NAV RTC\",\"datePublished\":\"2011-12-20T20:35:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/\"},\"wordCount\":143,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/\",\"name\":\"Import Budget into Excel in Dynamics NAV RTC | Confessions of a Dynamics 365 Business Central Consultant\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\"},\"datePublished\":\"2011-12-20T20:35:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/import-budget-into-excel-in-dynamics-nav-rtc\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uncategorized\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/category\\\/uncategorized\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Import Budget into Excel in Dynamics NAV RTC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"name\":\"APC Dynamics | Dynamics 365 Business Central Consultant\",\"description\":\"Dynamics 365 Business Central experts. Less Talk. More Results.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\",\"name\":\"APC Dynamics\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"contentUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"width\":216,\"height\":216,\"caption\":\"APC Dynamics\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/APCommerceInc\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ap-commerce-inc-\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCkM_LLmB4333D4Arjk0knyw\\\/about\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/aef29f75349626d15235713ce1db83f0\",\"name\":\"Alex Chow\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"caption\":\"Alex Chow\"},\"sameAs\":[\"https:\\\/\\\/www.apcommerce.com\\\/\"],\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import Budget into Excel in Dynamics NAV RTC | Confessions of a Dynamics 365 Business Central Consultant","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/","twitter_misc":{"Written by":"Alex Chow","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/#article","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/"},"author":{"name":"Alex Chow","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/aef29f75349626d15235713ce1db83f0"},"headline":"Import Budget into Excel in Dynamics NAV RTC","datePublished":"2011-12-20T20:35:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/"},"wordCount":143,"commentCount":4,"publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/","url":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/","name":"Import Budget into Excel in Dynamics NAV RTC | Confessions of a Dynamics 365 Business Central Consultant","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#website"},"datePublished":"2011-12-20T20:35:04+00:00","breadcrumb":{"@id":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.apcdynamics.com\/articles\/import-budget-into-excel-in-dynamics-nav-rtc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.apcdynamics.com\/articles\/"},{"@type":"ListItem","position":2,"name":"Uncategorized","item":"https:\/\/www.apcdynamics.com\/articles\/category\/uncategorized\/"},{"@type":"ListItem","position":3,"name":"Import Budget into Excel in Dynamics NAV RTC"}]},{"@type":"WebSite","@id":"https:\/\/www.apcdynamics.com\/articles\/#website","url":"https:\/\/www.apcdynamics.com\/articles\/","name":"APC Dynamics | Dynamics 365 Business Central Consultant","description":"Dynamics 365 Business Central experts. Less Talk. More Results.","publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apcdynamics.com\/articles\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.apcdynamics.com\/articles\/#organization","name":"APC Dynamics","url":"https:\/\/www.apcdynamics.com\/articles\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/","url":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","contentUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","width":216,"height":216,"caption":"APC Dynamics"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/APCommerceInc\/","https:\/\/www.linkedin.com\/company\/ap-commerce-inc-\/","https:\/\/www.youtube.com\/channel\/UCkM_LLmB4333D4Arjk0knyw\/about"]},{"@type":"Person","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/aef29f75349626d15235713ce1db83f0","name":"Alex Chow","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","caption":"Alex Chow"},"sameAs":["https:\/\/www.apcommerce.com\/"],"url":"https:\/\/www.apcdynamics.com\/articles\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/comments?post=200"}],"version-history":[{"count":2,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/200\/revisions"}],"predecessor-version":[{"id":203,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/200\/revisions\/203"}],"wp:attachment":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/media?parent=200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/categories?post=200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/tags?post=200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}