{"id":465,"date":"2014-04-11T20:32:31","date_gmt":"2014-04-11T18:32:31","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=465"},"modified":"2016-07-13T22:31:04","modified_gmt":"2016-07-13T20:31:04","slug":"dynamics-c5-2014-are-you-nuts","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=465","title":{"rendered":"Dynamics C5 2014\/2015. Are you nuts?!!?"},"content":{"rendered":"<p>Sikkert ikke &#8211; men det har v\u00e6ret en sv\u00e6r n\u00f8d at kn\u00e6kke at f\u00e5 NAVs &#8220;CRONUS Danmark A\/S&#8221; demonstrationsdatabase til at k\u00f8re p\u00e5 den &#8211; i hvert fald hvis man \u00f8nsker at k\u00f8re den med en rigtig C5 2014\/2015 Subscription licens.<\/p>\n<p>&nbsp;<\/p>\n<p>Tilsyneladende har Microsoft i skrivende stund (C5 2015 Rollup 4) ikke n\u00e5et at f\u00e5 demodata klar der kan k\u00f8re med en C5 2014\/2015 Subscription licens, s\u00e5 man f\u00e5r masser af rettighedsfejl mv.\u00a0hvis man fors\u00f8ger at genudskrive bogf\u00f8rte\u00a0fakturaer og kreditnotaer, oprette salgsfakturaer eller bogf\u00f8re dem. Ganske simpelt fordi licensen ikke giver adgang til de n\u00f8dvendige tabeller mv.<\/p>\n<p>Det skal siges at Microsoft arbejder p\u00e5 sagen &#8211; s\u00e5 det kommer jo nok :-).<\/p>\n<p>&nbsp;<\/p>\n<p>Men hvad g\u00f8r man egentligt LIGE NU\u00a0hvis man gerne vil demonstrere en Dynamics C5 2014 eller 2015 med demonstrationsdata?<\/p>\n<ul>\n<li>Ja, enten laver man sine egne med basis i opstartsregnskabet &#8220;CRONUS Danmark&#8221; (bem\u00e6rk ikke noget A\/S efter &#8211; det er demodataene hvor alle transaktioner blot ikke er lavet).<br \/>\nHer skal man blot &#8211;\u00a0direkte i SQL databasen\u00a0&#8211; lige manipulere Salgsops\u00e6tningen og K\u00f8bsops\u00e6tningen\u00a0til at Dynamics C5 2014\/2015 ikke automatisk laver f\u00f8lgesedler ifm. faktureringen (for man kan nemlig ikke lave f\u00f8lgesedler i Dynamics C5 2014\/2015).<br \/>\nEr du i tvivl om hvordan &#8211; s\u00e5 kig i den f\u00f8lgende komplette l\u00f8sning. De to rettelser er nemlig ogs\u00e5 en del af den \ud83d\ude42<br \/>\nBem\u00e6rk: \u00c6ndringen kan ikke laves i Dynamics C5 2014\/2015s ops\u00e6tningsbilleder &#8211; for den\u00a0indstilling er jo netop ikke supporteret med en\u00a0 C5 2014\/2015 licens (man kan naturligvis lave \u00e6ndringen med NAVs ops\u00e6tningsbilleder hvis man lige h\u00e6lder s\u00e5dan en licens p\u00e5 midlertidigt \ud83d\ude42 ).<\/li>\n<li>Eller ogs\u00e5 skal man smide en NAV licens p\u00e5, skifte rollecenteret til &#8220;Lille virksomhed&#8221; (som Dynamics C5 2014\/2015 jo bruger) og s\u00e5 bilde folk ind at det rent faktisk ikke er en NAV 2013 R2\/2015, men en Dynamics C5 2014\/2015&#8230;<br \/>\nMen det er lidt snyd &#8211; ikke? Og jo da et problem hvis man har Dynamics C5 2014\/2015 subscription kunder som faktisk gerne vil lege med demodata&#8230;<\/li>\n<li>Eller ogs\u00e5 kan man&#8230;.<\/li>\n<\/ul>\n<p>&#8230;starte Microsoft SQL Server Management Studio (MS SSMS som den s\u00e5 smukt ogs\u00e5 hedder) og fyre\u00a0nedenst\u00e5ende SQL-kommandoer af p\u00e5 en NAV 2013 R2\/2015 demodatabase. Herefter er den opsat s\u00e5 i hvert fald genudskrift af bogf\u00f8rte salgs- og k\u00f8bsfakturaer, oprettelse og bogf\u00f8ring\u00a0af salgs- og k\u00f8bsfakturaer, samt bogf\u00f8ring af indbetalinger virker med en C5 2014\/2015 subscription licens.<\/p>\n<p>&nbsp;<\/p>\n<p>PS: Finder du andet der ikke virker, s\u00e5 skriv til os s\u00e5 vi kan finde l\u00f8sninger og opdatere dette blogindl\u00e6g \ud83d\ude42<\/p>\n<p>&nbsp;<\/p>\n<p>PPS: Gider du ikke alt det b\u00f8vl og skal du blot lege med en Dynamics C5 2014\/2015?<br \/>\nS\u00e5 pr\u00f8v vores\u00a0demosystem (naturligvis med virkende CRONUS Danmark A\/S demodata \ud83d\ude42 ) ved at klikke p\u00e5 demo-knapperne p\u00e5 denne blogs forside&#8230; Det er HELT gratis og uforpligtende, kr\u00e6ver ikke at du registrerer dig &#8211; og vi tilbyder b\u00e5de test med webklienten og den Windowsklienten v.hj.a. en ClickOnce installation&#8230; God forn\u00f8jelse&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>SQL-kommandoerne der skal fyres af i MS SSMS er:<\/p>\n<hr \/>\n<pre>USE [&lt;databasenavn&gt;]\r\nGO\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Sales &amp; Receivables Setup]\r\n SET [Shipment on Invoice] = 0\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Purchases &amp; Payables Setup]\r\n SET [Receipt on Invoice] = 0\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Customer]\r\n SET [Responsibility Center] = '',\r\n     [Shipping Agent Code] = '',\r\n     [Shipping Agent Service Code] = '',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0[Location Code] = ''\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Vendor] \r\n SET [Responsibility Center] = '',\r\n     [Shipping Agent Code] = '',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0[Location Code] = ''\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Sales Invoice Header]\r\n SET [Responsibility Center] = '',\r\n     [Shipping Agent Code] = '',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0[Location Code] = ''\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Sales Cr_Memo Header]\r\n SET [Responsibility Center] = '',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0[Location Code] = ''\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Purch_ Inv_ Header]\r\n SET [Responsibility Center] = '',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0[Location Code] = ''\r\n\r\nUPDATE [dbo].[CRONUS Danmark A_S$Purch_ Cr_ Memo Hdr_]\r\n SET [Responsibility Center] = '',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0[Location Code] = ''\r\n\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Responsibility Center]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Contact Business Relation]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Base Calendar Change]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Item Substitution]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Dimension Combination]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Stockkeeping Unit]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Cost Accounting Setup]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Warehouse Shipment Line]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Interaction Template Setup]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Sales Shipment Header]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Sales Shipment Line]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Return Receipt Header]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Return Receipt Line]\r\nDELETE FROM [dbo].[CRONUS Danmark A_S$Location]\r\n\r\n<\/pre>\n<hr \/>\n<p>\u00c6ndringer:<br \/>\n06.05.2014: Sales Shipment Header\/Line og Return Receipt Header\/Line tilf\u00f8jet<br \/>\n07.01.2015: Fixet virker ogs\u00e5 p\u00e5 C5 2015, men her advares dog om at der er mere end 2.500 transaktioner pr. regnskab pr. \u00e5r hvis man ikke har k\u00f8bt den udvidelse.<br \/>\n13.07.2016: Location Code feltet og Location tabellen tilf\u00f8jet<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sikkert ikke &#8211; men det har v\u00e6ret en sv\u00e6r n\u00f8d at kn\u00e6kke at f\u00e5 NAVs &#8220;CRONUS Danmark A\/S&#8221; demonstrationsdatabase til at k\u00f8re p\u00e5 den &#8211; i hvert fald hvis man \u00f8nsker at k\u00f8re den med en rigtig C5 2014\/2015 Subscription &hellip; <a href=\"https:\/\/scblog.lynge.org\/?p=465\">L\u00e6s resten <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,41,38],"tags":[30,15,43,22,11,54,29,23,14,28,20],"class_list":["post-465","post","type-post","status-publish","format-standard","hentry","category-c5-support","category-c5-teknik","category-dynamics-c5","tag-bug","tag-business-solutions","tag-c5","tag-database","tag-dynamics","tag-dynamics-c5","tag-fejl","tag-hint","tag-microsoft","tag-sql","tag-udokumenteret"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=465"}],"version-history":[{"count":14,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/465\/revisions"}],"predecessor-version":[{"id":993,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/465\/revisions\/993"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}