<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0"
    xmlns:dc="http://purl.org/dc/elements/1.1/"
    xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
    xmlns:admin="http://webns.net/mvcb/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:content="http://purl.org/rss/1.0/modules/content/">

    <channel>
    
    <title><![CDATA[Kuntz Consulting Blog]]></title>
    <link>http://www.kuntzconsulting.ca/index.php/blog/</link>
    <description></description>
    <dc:language>en</dc:language>
    <dc:creator>jen@kuntzconsulting.ca</dc:creator>
    <dc:rights>Copyright 2013</dc:rights>
    <dc:date>2013-05-16T14:18:31+00:00</dc:date>
    <admin:generatorAgent rdf:resource="http://expressionengine.com/" />
    

    <item>
      <title><![CDATA[eConnect error &#8220;configured identity is incorrect&#8221;]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/econnect_error_configured_identity_is_incorrect</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/econnect_error_configured_identity_is_incorrect#When:14:18:31Z</guid>
      <description><![CDATA[<p>
	A client recently had an issue with their nightly eConnect integrations, getting an error about the username and password.</p>
<p>
	This integration had been live for nearly 2 years, running every night, and running without issue - or at least without this kind of issue. In other words, fairly stable.&nbsp; They also never touch the service accounts, so the thought that the password might have been changed was nearly impossible.</p>
<h3>
	The Error</h3>
<p>
	The text of the error was:</p>
<p>
	Error type: Unknown<br />
	Code: 1000<br />
	Location: e-Connect<br />
	User Message: The server process could not be started because the configured identity is incorrect.&nbsp; Check the username and password. (Exception from HRESULT: 0x8000401A)<br />
	Description: System.Runtime.InteropServices.COMException (0x8000401A): The server process could not be started because the configured identity is incorrect.&nbsp; Check the username and password. (Exception from HRESULT: 0x8000401A)</p>
<p>
	The client is using Dynamics GP2010 and the accompanying eConnect version for their integrations.</p>
<h3>
	Troubleshooting</h3>
<p>
	I researched the error the normal way, using "Dr Google" as one of my clients calls it. &nbsp;(My bad, I guess I should say "using Bing!", but alas, old habits die hard). &nbsp;We got many hits on this error but everyone&#39;s experience was one of two things:</p>
<ul>
	<li>
		You need to use a domain account for the identity (this client already was using a domain account)</li>
	<li>
		The password must have been changed by someone (this was verified as not the case)</li>
</ul>
<p>
	So, we were a little stumped until someone thought to check the Event Viewer on the server. In my role at this client I don&#39;t have access to the server on which this integration runs (it doesn&#39;t run on the actual GP sql server), so thankfully, one of the clients thought to look there to see if by chance there was more information. Sure enough, the event viewer log was much more specific!</p>
<p>
	<img alt="" src="http://kuntzconsulting.ca/images/uploads/docs/eConnect_Event_Viewer.png" style="width: 325px; height: 358px; border-width: 1px; border-style: solid;" /></p>
<p>
	The description in the error was "Logon failure: the user has not been granted the requested logon type at this computer". &nbsp;In short, the Active Directory account didn&#39;t have permission to log onto that server any more - nothing to do with the username or password configuration being incorrect.</p>
<p>
	At that point we went back to the IT team, and sure enough, they were doing some network and permission clean up in the recent days and inadvertantly removed some groups&#39; "log on as a service" permissions.</p>
<p>
	The moral of this story? &nbsp;If you get an error, check the event viewer too, to see if there is more specific information there about the error. In this case, it was obvious what the issue was but since no one checked there initially, we wasted a couple of days trying different things first.</p>
<p>
	&nbsp;</p>
]]></description>
      <dc:subject><![CDATA[Integrations, Troubleshooting,]]></dc:subject>
      <dc:date>2013-05-16T14:18:31+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[Full vs Light User licenses]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/full_vs_light_user_licenses</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/full_vs_light_user_licenses#When:12:00:54Z</guid>
      <description><![CDATA[<p>
	This is short and sweet - as I don&#39;t usually post "sales" types of things and don&#39;t intend to start now!</p>
<p>
	It&#39;s somewhat of a tale of two client scenarios, and advice to those who hear certain things from their clients, and are in a position to recommend license options.</p>
<p>
	I&#39;ve got two clients right now both of whom have expressed a need for additional user licenses in the near future. &nbsp;Both of them have decent user bases right now (12 and 16 user licenses respectively). Both of them are running into issues with the maximum number of concurrent users being logged in, at various times of the day or week or month.</p>
<h3>
	Client #1</h3>
<p>
	Client number 1 has been a Dynamics GP client for 10 years, and their accounting department has grown probably double in size since they first implemented GP. &nbsp;They keep hiring and have more and more users using GP every year. &nbsp;Right now they have approximately 25-30 actual GP users set up in the system, and at least half of them are daily, transactional users which need GP open all day long to do their jobs. &nbsp;The other half range from people that do a lot of analysis and reporting, to people who perform tasks more at certain times of the month - monthly expense report entry, for instance. &nbsp;So far a 16 user base has been ok, but over the last few months, as they&#39;ve hired one or two or three more bodies, they are using all 16 licenses nearly every hour of every day.</p>
<p>
	With this client, there is very little that can entirely offset the use of Dynamics GP outside of the application via reporting tools, as most of the users in the "non-day-to-day" camp still need in GP to do lots of inquiries, not all of which are easily replaced outside of GP. &nbsp;This client is a perfect example of when they simply need to consider purchasing additional full user licenses to relieve some of the pressure - as well as the inevitable "Can someone log out of GP for a minute please?" cries around the office!</p>
<h3>
	Client #2</h3>
<p>
	Client number 2 has also been a GP client for a number of years. Their 12 user license has served them well for many years but over the years, they added more and more users to GP to allow more non-accounting staff to run their own reports and do their own inquiries. &nbsp;This seemed innocent enough at the time, but now as their overall staff level has grown, they too are running into issues where there aren&#39;t enough licenses for the users to log in when needed. &nbsp;In this case, they often also have a couple of users who do tons of reporting and analysis opening both of their primary entities (companies) at the same time so they can easily flip back and forth at will, without stopping something they are doing in one company. That right there is 4 licenses taken up by 2 users most days of the week.</p>
<p>
	In contrast to the first client, they have a small accounting department and only about 30-35% of the user activity in GP is from users who I would define as "needing to be in GP". &nbsp;The vast majority of their user base do things that can easily be transitioned to other external methods - excel reports, sharepoint, SSRS reports etc. Some need in only to look up the next PO number to use; some only need to check inventory quantities on hand; some only run project accounting reports to check the status of their projects.</p>
<p>
	With this client, when they first asked me about an estimate to add new users, I immediately thought that in this case, it&#39;s a complete waste of money for them. They originally purchased users for something they never ended up implementing, leaving them also with 50+ light user licenses, which to me means they shouldn&#39;t spend a dime on licenses right now. &nbsp;I&#39;ll be working with them over the coming weeks to make a plan to transition as many of these users out of GP as possible, to external reporting and inquiry options.</p>
<h3>
	The difference between Full &amp; Light</h3>
<p>
	Before I get into details, both of these clients are GP2010 users, not GP2013. Both of them are also on Business Ready Licensing so that is what I am really talking about in this post. &nbsp;This information is also intentionally generic and general - specific questions on all the purposes and usages of each license should be a question for your partner if you are unsure.</p>
<p>
	In these examples, a full user is a license to log into GP itself; a light user is a license that allows you to access GP data externally to GP - Excel Reports, SSRS, Sharepoint etc. all come to mind as ways to access data and use its information.</p>
<p>
	Pricing varies depending on market and other factors, plus there are price breaks once you buy 11 or more users etc. &nbsp;For simplicity, let&#39;s just say the cost of a full user is $5,350 + enhancement. The cost of a light user is around $175 + enhancement. That&#39;s a huge difference!</p>
<p>
	In my examples, client #2 was considering purchasing at least a couple more licenses which means an expenditure of over $10,000. &nbsp;What I explained to them was for the same money, and likely for a lot less than that, it would be better for them in the long term to spend that money on the services to identify the reporting needs, utilize the out of the box report options already there in Excel Reports and SSRS, and if needed write a handful of specific reports to cover gaps that aren&#39;t addressed. They have more than enough Light User licenses to cover their needs, and if they need more in the future, a couple hundred bucks is a no brainer.</p>
<p>
	If you are a consultant, and you notice your clients often at or near their maximum user capacity, look around at what users are keeping GP "full" and whether there are external solutions for them that have the option to provide more service to them and more inexpensively purchase licenses.</p>
<p>
	If you are a client and you&#39;re in a situation like I have described above, take a look at what the users in GP are doing and identify any that don&#39;t &#39;really&#39; need GP to do what they are doing. Talk to your partner about options, and extend the reach of the information in GP to other users in your organization!</p>
]]></description>
      <dc:subject><![CDATA[Off Topic Articles,]]></dc:subject>
      <dc:date>2013-04-05T12:00:54+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[Update on Account Number error in Canadian Payroll]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/update_on_account_number_error_in_canadian_payroll</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/update_on_account_number_error_in_canadian_payroll#When:19:35:06Z</guid>
      <description><![CDATA[<p>
	A couple of years ago around this time of year, I got a call from a client of mine with a strange error in Canadian Payroll.&nbsp; At the time, I ran into other significant issues in trying to help with said error, and at the time, I blogged/ranted about it <a href="http://www.kuntzconsulting.ca/index.php/blog/article/disenchanted_with_support_i_understand_your_pain" target="_blank">here</a>.</p>
<p>
	Fast forward to last month, when I received an email from another customer who was asking me "did you ever find out what the issue was with that error? We are having the same problem now!".&nbsp; We exchanged emails and I researched what notes I had taken at the time, and in the end, she confirmed for me that what worked for my client also worked for her.</p>
<p>
	So, this post is just an update on the issue and at least one resolution, in case it helps someone else out there. Some of this is a repeat of the rant blog, without the rant!</p>
<h3>
	The Issue</h3>
<p>
	<span style="font-size: 12px;">The client&#39;s error message was "Account Number does not exist". &nbsp;This occurred when they were creating the poster file in Canadian Payroll, after running their payroll successfully that week. &nbsp;They&#39;d been live for several years so the fact that now of all times a new random error came up was a little odd.</span></p>
<h3>
	The Resolution</h3>
<p>
	The accounting in Canadian Payroll is fairly straight forward: each paycode has an account number and in the main Setup window, you can identify if you want to "mask" the account number, say, to go to an employee&#39;s department segment in the GL. The biggest complication is usually forgetting to set the masked value in the department setup or the combination of the paycode&#39;s account and the masked value doesn&#39;t exist. Those are pretty easy to spot.</p>
<p>
	The other most common source of Account Missing types of errors usually you figure out immediately upon running your first payroll tests after configuration: some default account in a setup window wasn&#39;t populated with the default GL account.</p>
<p>
	This error was strange and random. &nbsp;The good news: both my client and the person who contacted me through the blog comments found the same common issue, and it resolved this error:</p>
<ul>
	<li>
		The company setup (Canadian Payroll Control window) had "Allow Banked Leave GL Accrual" set to No while the employee in question had their field set to Yes.</li>
	<li>
		In both cases, this only popped up when the employee was taking vacation, and it was looking at the account setting to identify where to reduce the accrued vacation.</li>
</ul>
<p>
	So, sounds simple but annoyingly random! Hopefully if anyone else finds the same error, this may help them resolve it too.</p>
]]></description>
      <dc:subject><![CDATA[Canadian Payroll, Troubleshooting,]]></dc:subject>
      <dc:date>2013-03-29T19:35:06+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[Canadian Payroll 2012 T4 issue (updated)]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/canadian_payroll_2012_t4_issue</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/canadian_payroll_2012_t4_issue#When:03:21:27Z</guid>
      <description><![CDATA[<p>
	(Updated Feb 2013)</p>
<p>
	There was an issue identified last week with the 2012 year end tax update that affects T4s.&nbsp; This issue is being worked on and a hotfix should be available soon.</p>
<p>
	The specific issue is this:</p>
<ul>
	<li>
		Box 24 (EI Insurable Earnings) will show the 2011 rate $44,200 instead of the 2012 rate $45,900</li>
	<li>
		Box 26 (CPP Pensionable Earnings) will show the 2011 rate $48,300 instead of the 2012 rate $50,100</li>
	<li>
		Also, RL-1 Box G (QPP Pensionable Earnings) will show the 2011 rate $48,300 instead of the 2012 rate $50,100</li>
</ul>
<p>
	These amounts will appear in the T4 edit (or RL-1 Edit) windows after running the Create T4 (RL-1) process.&nbsp; There are scripts you can download to fix this issue, or you can wait until the hotfix is released.</p>
<p>
	Here are the Customersource links: <a href="https://mbs.microsoft.com/customersource/downloads/taxupdates/cagptuye2010.htm?printpage=false" target="_blank">GP2010</a> and <a href="https://mbs.microsoft.com/customersource/downloads/taxupdates/cagpye10.htm?printpage-false" target="_blank">GP10</a>.</p>
<p>
	NOTE: if you create your T4s or RL-1s and then run the scripts - and THEN run Recreate T4s (or RL-1s) it wipes out the script update.&nbsp; Keep this in mind and keep the scripts handy if you are creating and recreating the forms, until the hotfix is ready.</p>
<p>
	UPDATE:</p>
<p>
	The hotfixes were released in the end of January, and for the record, here they are:</p>
<p>
	<a href="https://mbs.microsoft.com/customersource/downloads/taxupdates/cagptuye2010.htm?printpage=false" target="_blank">GP2010 link</a> (version after update: 11.0.2164)</p>
<p>
	<a href="https://mbs.microsoft.com/customersource/support/selfsupport/hottopics/HOT_TOPIC_MDGP2013Upgrade" target="_blank">GP2013 link</a> (version after update: 12.0.1343)</p>
<p>
	This is a regular hotfix, so you will notice in the details on the downloads page or documentation, there are other bug fixes included with this.&nbsp;The hotfix includes the following (for Cdn Payroll):</p>
<ul>
	<li>
		2013 Quebec new health contribution formulas</li>
	<li>
		The form corrections related to the issues noted above (T4, RL-1)</li>
	<li>
		Any year end tax changes for GP2013</li>
</ul>
<p>
	&nbsp;</p>
]]></description>
      <dc:subject><![CDATA[Canadian Payroll, News,]]></dc:subject>
      <dc:date>2013-01-14T03:21:27+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[New Year&#8217;s Resolutions 2013]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/new_years_resolutions_2013</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/new_years_resolutions_2013#When:15:17:59Z</guid>
      <description><![CDATA[<p>
	It&#39;s that time of year again - time for a review of 2012 and noting what to resolve to do in 2013.</p>
<p>
	I say this every year - time flew by!&nbsp; As my dad just told me, it seems to fly by faster the older you get.&nbsp; It certainly does! &nbsp;Today is December 31st and my sister &amp; I are visiting my dad and his wife, and loving the few relaxing days away from home.&nbsp; Along with relaxing with family, this is my favourite, if not humbling, part of the new year process: reviewing what I said I would do this year!</p>
<h3>
	What happened in 2012?</h3>
<p>
	Well, I started the year <a href="http://www.kuntzconsulting.ca/index.php/blog/article/new_years_resolutions_2012" target="_blank">resolving to make more reasonable goals</a>... what a cop out eh?&nbsp; I also thought I&#39;d do monthly resolutions, in an effort to keep them&nbsp;manageable.&nbsp; I&#39;m embarrassed to admit that I forgot about that by mid-February!</p>
<p>
	Here&#39;s the quick tally of what I wanted to accomplish and how I fared (hint: not very well!):</p>
<ul>
	<li>
		Blog 3 times a month - I finished the year with 26 articles, after writing 28 in 2011.&nbsp; I&#39;m surprised that I got that many written actually, it felt like I only&nbsp;wrote a dozen or so.</li>
	<li>
		Read more - the good news is I plowed through a huge pile of magazines so I no longer have a backlog of mags to read;&nbsp;but I didn&#39;t read as many books as I wanted to. &nbsp;I&#39;ll call this a slight success!</li>
	<li>
		Re-immerse myself in development - this never got off the ground!</li>
	<li>
		SQL Reporting Services - I started by installing the Report Builder 3.0 application but other than playing with that a little bit, I really didn&#39;t make much headway&nbsp;on this.</li>
</ul>
<h3>
	So, what did I accomplish this year?&nbsp;</h3>
<p>
	Under the category of "the 99% complete project": Hey!&nbsp; I actually <a href="http://www.kuntzconsulting.ca/index.php/blog/article/report_writer_series_the_end" target="_blank">finished my Report Writer series</a>!&nbsp; Now THAT&#39;s an accomplishment... I&#39;d left it dormant for a few months and was happy to finally dust it off and finish it.</p>
<p>
	In the "is it me or is the rest of the herd insane?" category: I found a few interesting bugs, <a href="http://www.kuntzconsulting.ca/index.php/blog/article/project_accounting_update_budget_lines_the_good_and_the_ugly" target="_blank">here</a>, <a href="http://www.kuntzconsulting.ca/index.php/blog/article/project_accounting_misc_log_econnect_import_issue" target="_blank">here</a> and <a href="http://www.kuntzconsulting.ca/index.php/blog/article/bizarro_world_integration_mgr_use_input_doesnt_work" target="_blank">here</a>. &nbsp;It sounds crazy but part of the fun of being a consultant is troubleshooting issues, and with that, there is just something about the moment when you find you&#39;ve actually discovered a bug and aren&#39;t going crazy! &nbsp;(Not that bugs are a good thing, but when you don&#39;t get the expected results and are trying to prove that you&#39;re not causing the problem, the validation that it is a bug is kind of nice!)</p>
<p>
	On the social and learning side of things, I returned to Fargo for my second time, to the Technical Airlift.&nbsp; I met a bunch more of our fantastic GP community members and had a great time learning about GP2013. &nbsp;I love putting names to faces, that&#39;s always the best part to me.</p>
<p>
	Saving the best for last: The best part of 2012 for us in the GP world arguably was the release of GP2013 in December 2012... this was a highly anticipated release with the first web client&nbsp;being introduced.&nbsp; I&#39;m looking forward to upgrading my environments to play with the new features.</p>
<h3>
	What&#39;s in store for 2013?</h3>
<p>
	As I sit here, I&#39;m not entirely sure what 2013 will look like for me.&nbsp; The last half of 2012 included some "life changes" and the early part of 2013 will most definitely include continued personal distractions.&nbsp; One thing is for sure, in 2013 I&#39;ll be moving somewhere, to a location yet to be determined!&nbsp; I&#39;ve got a house to sell first, which is on the market but not moving as quickly as I would like.</p>
<p>
	Other than that, this year&#39;s resolutions will be more along the lines of things I&#39;d like to keep doing!</p>
<ul>
	<li>
		Upgrade at least one of my environments to Dynamics GP 2013. &nbsp;This is an easy one, there is no way to learn better than to get your hands on a new product or version.</li>
</ul>
<ul>
	<li>
		Migrate to and learn Management Reporter 2012. &nbsp;This is also an easy one.&nbsp; I&#39;ve used MR already, I just haven&#39;t gotten around to playing with the newest version.&nbsp; Two of my clients use FRx Webport so we&#39;ve been waiting until this MR release with a web client replacement to consider migrating.</li>
</ul>
<ul>
	<li>
		Blog more! &nbsp;LOL... it wouldn&#39;t be a proper new year&#39;s resolution list without my annual "I&#39;d like to blog more often" entry!&nbsp; I predict sporadic blogging until I am sorted in a new house/condo/apartment/hole-in-the-wall, at which time one of two things will happen: I&#39;ll be renovating a new place &amp; still randomly blogging or I&#39;ll have more time to blog more often!</li>
</ul>
<ul>
	<li>
		Reading. &nbsp;I&#39;ll keep this on my list, as there are tons of things I&#39;d like to read both personally and professionally.&nbsp; I picked up a few GP books from our fine community of authors over at a Packt Publishing sale and look forward to reading them all for the first time.</li>
</ul>
<ul>
	<li>
		Take a Dexterity course. &nbsp;The good news is this year there are several classes scheduled with either <a href="http://dynamicsgpblogster.blogspot.ca/2012/10/microsoft-dexterity-training-roadshow.html" target="_blank">Mariano Gomez</a> and <a href="http://dynamicsconfessions.blogspot.ca/2012/11/dexterity-basics-training-february-1115.html" target="_blank">Leslie Vail</a>&nbsp;in early to mid 2013. &nbsp;I&#39;m not sure yet which one I&#39;d be able to attend but I&#39;d love to get to one of their offerings while the choice of dates and locations is vast. &nbsp;Personally I&#39;d love to take on the London UK offering from Mariano, which happens to fall the week of my birthday. &nbsp;How cool would that be? &nbsp;A good excuse to travel somewhere and celebrate a birthday in style! &nbsp;I&#39;m not sure the timing works as that coincides with a go-live of a project I&#39;m on, so we&#39;ll have to see about that...</li>
</ul>
<p>
	That&#39;s it... kind of a "low-hanging fruit" list of resolutions but hey, at least they are achievable!</p>
<p>
	Here&#39;s hoping everyone has a happy new year and a fantastic 2013!</p>
<p>
	&nbsp;</p>
]]></description>
      <dc:subject><![CDATA[Off Topic Articles,]]></dc:subject>
      <dc:date>2012-12-31T15:17:59+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[Bizarro world: Integration Mgr &#8220;use input&#8221; doesn&#8217;t work]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/bizarro_world_integration_mgr_use_input_doesnt_work</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/bizarro_world_integration_mgr_use_input_doesnt_work#When:15:47:46Z</guid>
      <description><![CDATA[<p>
	This is a short post... a bizarre issue that I can&#39;t find an answer to.</p>
<p>
	A client has a bunch of inactive GL accounts and for a project, wants to re-active them to do some re-allocations and then inactive them again.&nbsp; Simple right?</p>
<p>
	I set up a simple Integration Manager integration for them, and set the "Inactive" field to "Use Input".&nbsp; In other words, let the user decide if they are inactivating or re-activating the accounts.&nbsp; Better than changing the integration, right?</p>
<p>
	Seemed like a good idea at the time.&nbsp; So we set the field to Use Input and then they ran it, it gives them a drop down list, and they chose False, as in "re-activate".&nbsp; They run the integration and start getting a bunch of errors "This account has a current balance".&nbsp; Hmmm.&nbsp; That should not matter if you are "activating" so I didn&#39;t understand the message.</p>
<p>
	They spot checked the GL accounts on the error log + the accounts not on the error log.&nbsp; Everything is still inactive, except the ones on the error log, because they were never inactive as they had a current balance.</p>
<p>
	OK.&nbsp; Well, against all logic, I suggested running it again but choosing TRUE instead of FALSE.&nbsp; The field is Inactive so TRUE should &#39;inactivate&#39; it, but stranger things have happened, and it&#39;s worth trying.&nbsp; I thought there is a chance that it is working backwards for some reason.</p>
<p>
	Same issue.&nbsp; Huh.</p>
<p>
	Well... let&#39;s get rid of the Use Input and put it back to Use Constant and set it to False.&nbsp; Run the integration, it works like a charm.</p>
<p>
	So, in this bizarro world, Use Input apparently ignores whatever the user selects in the drop down list and runs the integration as "Inactive = True".&nbsp; Using a constant works.</p>
<p>
	Go figure!&nbsp; Just when you think you&#39;ve seen everything, something new and strange pops up!</p>
<p>
	(for reference, the client is using GP2010, and Integration Manager 11).</p>
]]></description>
      <dc:subject><![CDATA[Integrations, Troubleshooting,]]></dc:subject>
      <dc:date>2012-12-27T15:47:46+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[Fun with Windows 8]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/fun_with_windows_8</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/fun_with_windows_8#When:16:38:03Z</guid>
      <description><![CDATA[<p>
	I&#39;ve been using Windows 8 now on my new laptop for about a couple of weeks.&nbsp; I *love* it!&nbsp; What baffles me is the sheer volume of blogs and articles I run into that are crapping all over this new operating system... it&#39;s hilarious really.&nbsp; "How to make windows 8 look like windows 7"??&nbsp; Are you serious?&nbsp; Why bother upgrading if you&#39;re going to do that?</p>
<p>
	Enough of that. &nbsp;Part of the learning curve has fortunately been handled by reading other users&#39; experiences and searching out tips and tricks to understand how to get things to work for you. &nbsp;None of what I&#39;m putting in here is new or revolutionary, but hopefully it helps someone out!</p>
<p>
	Key note for all of these tips: I am not using a touch device so these tips are 100% for keyboard and mouse users... some might work for touch too, I have no idea!</p>
<h3>
	What I love about Windows 8</h3>
<p>
	I really love the overall look and feel, the UI itself. &nbsp;Others hate the metro tile home screen but that is the single biggest thing I love. &nbsp;My home page has been turned into my start menu. &nbsp;Remove some app tiles, add some new app tiles, move the things I use most frequently to the far left side, and voil&agrave;!</p>
<h3>
	Playing with Tiles</h3>
<p>
	The first thing I did, after doing a clean install of Windows 8 (to remove the typical new computer bloatware), was to customize the tiles &amp; my home page.</p>
<p>
	Windows 8 puts a lot of default apps on there that I have no interest in. &nbsp;I tried some of the default apps like Windows Mail, found them too limiting, so I uninstalled them. &nbsp;Others I simply removed from "Start" (unpin them).</p>
<ul>
	<li>
		Right click on most app tiles on the home page and you see options like "Uninstall", "Unpin from Start" and with some apps (seems to be limited to Microsoft apps) options to make the tile smaller (one square) or larger (two squares).</li>
	<li>
		Not all apps have an uninstall link - like the App "Store" for instance, but most do.</li>
	<li>
		If you right click on several apps, you are actually selecting multiple app tiles - and your selections will differ. &nbsp;Look for the checkmark in the right hand corner of the app tile to identify what is selected. &nbsp;This is how you select multiple items, but it&#39;s not quite as obvious as holding down a CTRL key which is what most users are used to. &nbsp;I use this to unpin a bunch of apps I don&#39;t want, all at once.</li>
	<li>
		Moving tiles is as simple as click and drag to a new spot.</li>
</ul>
<h3>
	Adding new tiles</h3>
<p>
	To see the list of all of the apps installed on your computer, you can right click on an empty portion of the home page and select All Apps. &nbsp;This shows tiny tiles of all of your apps. &nbsp;Then right click on what you want, and select Pin To Start to create a tile/shortcut for it. &nbsp;This is the equivalent of modifying or editing your old start menu.</p>
<p>
	Things like the specific items in your control panel are also right clickable - there is a shortcut on the context menu to Pin To Start. &nbsp;Personally I like to have a shortcut on my desktop for Windows Update so in this case, I put a shortcut on my home page for it. &nbsp;I also put a shortcut to the Control Panel since I tend to use that a lot.</p>
<p>
	I have not yet figured out if you can put a tile shortcut to a specific document on the start menu; I&#39;m sure there is a way but I haven&#39;t looked into that yet.</p>
<h3>
	Handy Shortcuts</h3>
<p>
	There are tons of articles on shortcuts for Windows 8... simply google (or bing!) Windows 8 shortcuts and you&#39;ll get tons of hits. &nbsp;Here are the things I use a lot, and a few new ones I just started to use.</p>
<ul>
	<li>
		Windows Key = toggle between start page and your last app. &nbsp;This is awesomely simple - I used to use the Windows key once in a while on Windows 7 to hit the start menu, but this is even better. &nbsp;I use this constantly to see my "home page start menu".</li>
	<li>
		Multiple Monitors? Move the home page to the right monitor using Windows key + Page Up or Page Down. &nbsp;I only (only! ha!) have two monitors so I haven&#39;t tied this with 3 ... apparently you just keep hitting Win + PgUp (or PgDown) and it cycles through your monitors.</li>
	<li>
		Want to add multiple monitors or are hooking up to a projector? &nbsp;Windows + P opens the project charm. &nbsp;</li>
	<li>
		Tired of mousing over to the corner to open the Charms sidebar? &nbsp;Windows + C opens the charms and even better, Windows + I opens the Settings if all you want is to quickly shutdown your computer or do other things in the Settings section of the Charms bar.</li>
	<li>
		Did you know there&#39;s a poweruser / Administrator menu? &nbsp;I knew about Administrative Tools but this was completely new to me: Windows + X opens a special poweruser menu with all sorts of toys for managing your computer. (Not new apps, but shortcuts to the most commonly used admin apps). &nbsp;Way cool.</li>
	<li>
		Looking to lock your screen when you go to a meeting? &nbsp;Windows + L is quicker than CTRL-ALT-DEL + enter.</li>
	<li>
		The new "open apps" bar on the left side you can scroll through with Windows + Tab. &nbsp;Kind of like ALT-TAB to scroll through open items, this scrolls through open apps on the Windows 8 bar.</li>
</ul>
<h3>
	Some Search tips</h3>
<ul>
	<li>
		Want to search quickly? &nbsp;One quick way to search is simply press Windows to get to your home screen and just start typing. &nbsp;Seriously, this is cool. &nbsp;Doesn&#39;t matter where you are searching, just get to the home menu and start typing. &nbsp;No mousing to the Charms or shortcuts. &nbsp;</li>
	<li>
		You can also edit the search apps to either hide an area you don&#39;t want to search results in, or pin it to move it to the top. &nbsp;It does appear that only the first three "apps" show instant results but the other apps are there if you want to search there. &nbsp;For instance, I use Evernote, so if I am searching for something that is in Evernote, I click Evernote in my search bar and it then passes your search phrase to that application.</li>
	<li>
		A second way to search quickly&nbsp;for when you really want to search specific areas: WIndows + Q is to search Apps; Windows + F is to search Files; Windows + W is to search Settings.</li>
</ul>
<p>
	I&#39;m quite sure there are tons more handy tips and tricks... my favourites? &nbsp;X for the admin menu &amp; Windows key simply to get back to the home page and facilitate easy search.</p>
<p>
	I think this is a fantastic step forward in Windows operating systems and I encourage new users to try the play with the new tools instead of instantly looking to make it look like Windows 7 or earlier! &nbsp;Have fun with it...&nbsp;</p>
]]></description>
      <dc:subject><![CDATA[How To & Tips, Off Topic Articles,]]></dc:subject>
      <dc:date>2012-12-24T16:38:03+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[Canadian Payroll Year End 2012 Tax Update]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/canadian_payroll_year_end_2012_tax_update</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/canadian_payroll_year_end_2012_tax_update#When:03:44:56Z</guid>
      <description><![CDATA[<p>
	Welcome to my annual "hey the tax tables are out" blog post!&nbsp; Like clockwork - or like death and taxes - yet another certainty is each year end there are tax table updates to apply! &nbsp;Here are the details for those Canadian Payroll users of Microsoft Dynamics GP!&nbsp; Special note to you GP2013 users as well...</p>
<p>
	First - an important note although I doubt this will affect anyone already: Dynamics GP 2013 RTM&nbsp;<u>did not</u>&nbsp;release with the 2013 tax rates! &nbsp;So in the unlikely event that you are considering upgrading to GP2013 immediately (since it&#39;s launch yesterday!), I would recommend holding off until the first hot fix is released. &nbsp;The hotfix is expected the week of January 21, 2013. &nbsp;New clients - same goes for you... the RTM build has the 2012 tax rates and thus any payrolls run in it, will not reflect the new tax rates yet.</p>
<p>
	Now on to the details of the tax update: (<a href="http://kuntzconsulting.ca/images/uploads/docs/CAN12YETax.pdf" target="_blank">PDF file with the year end update details</a>)</p>
<p>
	These links will be live on Friday December 21st, 2012 (just in time for the end of the world! &nbsp;(couldn&#39;t resist a little Mayan calendar joke...))</p>
<p>
	<a href="https://mbs.microsoft.com/customersource/downloads/taxupdates/cagpye10.htm?printpage=false" target="_blank">GP10</a>&nbsp;(build number expected to be&nbsp;10.0.1868 &amp; Canadian Payroll version 10.0.1880)</p>
<p>
	<a href="https://mbs.microsoft.com/customersource/downloads/taxupdates/cagptuye2010.htm?printpage=false" target="_blank">GP2010</a>&nbsp;(build number expected to be&nbsp;11.0.2121 &amp; Canadian Payroll version 11.0.2128)</p>
<p>
	GP2013 (will update this when the hotfix is out...)</p>
<p>
	I&#39;ll be doing my first update for a client this weekend... if any issues arise or anything interesting comes up, I will post an update or new article!</p>
<p>
	&nbsp;</p>
<p>
	&nbsp;</p>
]]></description>
      <dc:subject><![CDATA[Canadian Payroll, Installation, News,]]></dc:subject>
      <dc:date>2012-12-21T03:44:56+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[It&#8217;s a big day!]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/its_a_big_day</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/its_a_big_day#When:03:27:54Z</guid>
      <description><![CDATA[<p>
	It&#39;s a big day ... and I&#39;m a day late!</p>
<p>
	Microsoft Dynamics GP2013 has launched!&nbsp; Yay!</p>
<p>
	<img alt="" src="http://kuntzconsulting.ca/images/uploads/docs/GP2013_banner.png" style="width: 480px; height: 121px; border-width: 1px; border-style: solid;" /></p>
<p>
	Here is a link to the launch portal on Customersource: <a href="http://mbs.microsoft.com/customersource/downloads/servicepacks/MSDGP2013CSLaunchPortal.htm" target="_blank">click here</a></p>
<p>
	There is a ton of information out there already on the Microsoft sites and in the Microsoft Dynamics community so I won&#39;t get into repeating a lot of what&#39;s already been blogged about. &nbsp;Suffice to say: it&#39;s a big day with the introduction of the first web client, some very cool new features and tons of excitement in the community about this release. &nbsp;Check it out!</p>
]]></description>
      <dc:subject><![CDATA[General Stuff, News,]]></dc:subject>
      <dc:date>2012-12-21T03:27:54+00:00</dc:date>
    </item>

    <item>
      <title><![CDATA[Windows 8 install tips and tricks]]></title>
      <link>http://www.kuntzconsulting.ca/index.php/blog/article/windows_8_install_tips_and_tricks</link>
      <guid>http://www.kuntzconsulting.ca/index.php/blog/article/windows_8_install_tips_and_tricks#When:02:09:51Z</guid>
      <description><![CDATA[<p>
	Time has flown by, as it does tend to do when you are not paying attention!&nbsp; One minute I&#39;m in Fargo at the Technical Airlift, dropping a perfectly functioning laptop on a hard tile floor (yes, boy, that was fun!), and the next, it&#39;s nearly Christmas and I&#39;m loading Windows 8 on a even more perfectly functioning new laptop. It&#39;s wrapped in bubble wrap to protect it from myself, just so ya know... ; )</p>
<p>
	When the Windows 8 previews and betas came out, I fully intended to install them on a virtual image or something, and get to know the new features.&nbsp; So much for that!&nbsp; The, ahem, fortunate timing of dropping a laptop and having my other functional Dell brick fail to boot led me to a just-in-time-for-Christmas new shiny laptop.&nbsp; While my American friends were eating Thanksgiving turkey, I was doing some timely Black Friday shopping.&nbsp; It seems Canadian retailers have adopted the sale weekend much to our price advantage!</p>
<p>
	I ordered another trusty Lenovo, my third one. Even though my first one died, I got a ton out of it and took it everywhere.&nbsp; My last one - which I dropped - actually still kind of worked even after dropping it on a tile floor. Dented, yes, but busted, no!&nbsp; I think I dented some internal things though as there were several issues with all the ports on one side not working all the time etc., and Black Friday came calling to rescue me from frustration.</p>
<p>
	This is an off-topic post - nothing to do with Dynamics GP this time around.&nbsp; I&#39;m behind in my blogging (again) and will get back to that shortly.&nbsp; For now, I wanted to document some Windows 8 installation related things that may help someone.&nbsp; I needed to search long and hard for some things and I&#39;d like to save someone the trouble when they go to do what I&#39;ve done.</p>
<h3>
	The background</h3>
<p>
	As I mention above, I bought a Lenovo, an X230 model specifically.&nbsp; I bought it with a mid-range configuration but didn&#39;t order it with a Solid State drive (SSD), as I planned on getting one far cheaper after the fact.&nbsp; Every time I buy a new computer, the first thing I do is wipe it clean and do a clean O/S install.&nbsp; This time, I was doing a clean install as well as swapping out the hard drive for an SSD.</p>
<p>
	I also bought it pre-loaded with Windows 8 Professional.&nbsp; Everything here is related to the Pro version, so YMMV if you are not on Pro (although I think the steps below are generic enough to work for any edition).</p>
<p>
	These notes are not in any particular order, it&#39;s not meant as&nbsp;a "how to" but rather a compilation of things that helped me.</p>
<p>
	My end goal was the following:</p>
<ul>
	<li>
		Install an SSD instead of the hard drive it came with</li>
	<li>
		Keep the UEFI boot to take advantage of the secure boot functionality</li>
	<li>
		Do a clean install, not a clone of the factory install</li>
</ul>
<p>
	Lastly, I&#39;m not a hardware person, so I may use the most technologically correct terminology in places... apologies for that!</p>
<h3>
	Windows 8 product key</h3>
<p>
	If Windows 8 is installed already by the OEM vendor, the product key&nbsp;should be&nbsp;embedded in the BIOS.&nbsp; I didn&#39;t need to worry about finding my key, getting the key, hacking a registry to get the key etc.&nbsp; In previous iterations of Windows, there are usually some steps that require finding out the key for what is installed so you can use it again.&nbsp; No need this time.&nbsp; In fact, I still&nbsp;have no idea what my product key is, and the O/S is so new, Lenovo hasn&#39;t gotten around to putting the stickers on the bottom of the laptops yet to show you the key.&nbsp; I&#39;ve installed Windows 8 twice now (I&#39;ll explain why!), and it recognized that I had an OEM key in the BIOS and installed without any issue whatsoever.</p>
<h3>
	Windows 8 drivers</h3>
<p>
	This was the biggest and most pleasant surprise for me.&nbsp; The first time I did a clean install was with my old Lenovo x61s and Windows XP.&nbsp; Wow, the clean install instructions were convoluted.&nbsp; There were at least 17 steps to install, 99% of it was the exact order and method to install the drivers you need. Pain in the ___.&nbsp; I don&#39;t remember how it worked with Windows 7, it certainly was simpler, but with Windows 8, nearly everything worked right off the bat.&nbsp; I haven&#39;t installed a single Lenovo driver, and have 3 devices that are "unknown" - but using my laptop I haven&#39;t yet found what isn&#39;t working and I&#39;ve used everything I would use on a regular basis.&nbsp; It might be a while before I find what those 3 devices are!&nbsp;</p>
<p>
	Now, this being said, not all of the Microsoft drivers are the best ones out there for your devices and hardware. I found one instance where I will have to find the Lenovo driver and it isn&#39;t even for my laptop but for the docking station.&nbsp; Audio doesn&#39;t play when my X230 is docked, but it is a simple fix, according to many sources online.</p>
<h3>
	Swapping hard drive for an SSD</h3>
<p>
	There are several blogs and several forum posts about doing Windows 8 clean installs, and several about swapping an SSD for a regular hard drive.&nbsp; I didn&#39;t seem to find many articles or blogs that did both, they all seemed to do one thing or another or didn&#39;t addres the difficulties I had run into.&nbsp; Also,&nbsp;many of them were using a clone approach which doesn&#39;t seem to be recommended from what I have read, because of differences in the hardware types.&nbsp; It sounds like you don&#39;t want to clone a regular hard drive to copy that to an SSD as it won&#39;t be installed optimized for an SSD.</p>
<p>
	Fortunately I didn&#39;t find any issue or difficulty in doing this.&nbsp; I did a full recovery backup of the factory install in case I needed to revert back to Win8 "original" - that&#39;s always a safe recommendation.&nbsp; After that, I literally took out the old hard drive *, installed the SSD, and with the next steps on the specifics to boot into Windows 8, that was it.&nbsp; Not a single issue was SSD/hard drive change related.</p>
<p>
	* To be clear, there is a proper way to remove the hard drive which is basically:</p>
<ul>
	<li>
		Turn off the computer</li>
	<li>
		Unplug the power supply</li>
	<li>
		Take out the battery</li>
	<li>
		Press the power key to drain any remaining power</li>
	<li>
		Remove the hard drive (in my case, remove a couple of screws to access it).</li>
	<li>
		Install the new hard drive/SSD</li>
	<li>
		Put the battery back in and continue</li>
</ul>
<h3>
	Windows 8 media</h3>
<p>
	This was the part that I found a challenge, specifically getting the media in the right format for UEFI.&nbsp; First things first: apparently you can use any media including Windows 8 Upgrade media to do a clean install.&nbsp; From everything I&#39;ve read, you do not need a "full" copy for a clean install.&nbsp; (Assuming you are eligible for the upgrade version).&nbsp; If you have MSDN or TechNet subscriptions, you should be able to find what you need.&nbsp; Since I wanted to upgrade my home computer too and I don&#39;t currently have an MSDN subscription, so I took advantage of the upgrade offer for Windows 8 - $40.</p>
<p>
	Using the ugprade media method, here is the rough steps (because initially I was expecting that it was as simple as buy it and download it)..&nbsp; It seems at first like you can&#39;t just download the media but rest assured, you do in the end.&nbsp; The website for the upgrade offer starts with having an upgrade advisor download.&nbsp;</p>
<ul>
	<li>
		It checks your hardware for issues with requirements, if any, so you know in advance.&nbsp;</li>
	<li>
		Next, it asks you what you want to keep off of your computer.&nbsp; I selected None since I didn&#39;t intend to install immediately on this machine, I just needed the media.&nbsp;</li>
	<li>
		Next is the ordering part and you get your product key (if you are actually upgrading... that key is what I&#39;ll use for my home computer).&nbsp;&nbsp;</li>
	<li>
		Finally&nbsp;it gets to the download part and the options are basically Install Now or Install by Creating Media.&nbsp; I chose the latter.</li>
	<li>
		The last step gives you an option of downloading an ISO or using a Flash Drive.</li>
</ul>
<h3>
	UEFI &amp; BIOS settings</h3>
<p>
	This specifically was the part where I got a little messed up and ended up installing twice, because I didn&#39;t understand the whole UEFI thing initially. (Not that I&#39;m an expert now...).&nbsp; Initially I created a DVD ISO image using the download and then attempted to just hook up my DVD to my laptop and reboot.&nbsp; WIth legacy boot, depending on your BIOS settings, this usually would recognize the DVD and prompt you to "press any key to boot from CD/DVD" or something like that.&nbsp; This didn&#39;t, it just kept stopped at a boot menu.&nbsp; It recognized a DVD was attached with an ISO image, but the BIOS was set to UEFI secure boot and it&#39;s incompatible with the DVD ISO method.&nbsp; I changed my BIOS to "both" (Legacy/UEFI) and then it recognized the DVD and booted into Windows 8 setup and I was set.</p>
<p>
	However, when it was done, and I went into my BIOS to set it back to UEFI only, it would no&nbsp;longer boot because it was installed in Legacy mode.&nbsp; So back to the drawing board.&nbsp; To make a long story a little shorter, here is what worked and what didn&#39;t for me:</p>
<ul>
	<li>
		DVDs are formatted in NTFS which isn&#39;t compatible with UEFI (for booting at least...).&nbsp; If you don&#39;t care about UEFI and are happy with Legacy boot mode, you should be able to change your bios setting to Both or Legacy and allow it to act as normal like any older O/S ran.&nbsp; The boot times for UEFI only vs Legacy seemed similar to me so I don&#39;t think there is a big difference.</li>
	<li>
		I would like to use UEFI secure boot, so I opted to re-install WIndows 8 again.&nbsp; It requires boot media to be formatted Fat32.&nbsp; I didn&#39;t have a big enough USB flash drive so I ended up buying one, because I wasn&#39;t able to format an external USB hard drive as Fat32.</li>
	<li>
		Next, to make the flash drive bootable, basically you need to extract the ISO contents.&nbsp; There are several tools out there, MagicISO lets you mount an ISO image like a hard drive, from which you could copy the contents to the Flash drive.&nbsp; One common search result for this issue was to download the "Windows 7 USB Download Tool".&nbsp; I did that at first, but it formats the USB Flash drive as NTFS first and then extracts the ISO contents!&nbsp; So, you can do that but then copy the contents off the flash drive, reformat as Fat32, then copy back.</li>
	<li>
		Lastly, I still couldn&#39;t boot from this Flash drive and the final thing missing was I cannot boot to this device with Secure Boot enabled in the BIOS.&nbsp; Once I disabled Secure Boot, but still was in UEFI mode, once again I was successful getting to the Windows 8 install screens.</li>
</ul>
<p>
	After installing, I re-enabled the Secure Boot option and I&#39;m back in business.</p>
<p>
	I may have missed some small nuances here and there, but hopefully this covers the majority of it... going in circles around the UEFI thing took the most time. For a day or so it felt like all I kept doing was burning DVDS (thinking they didn&#39;t burn properly), or copying files to/from Flash Drives to get this to work.&nbsp; That was annoying so hopefully this helps someone just cut to the chase and quickly do a clean install.</p>
<p>
	The best part about going through all of this is you learn a little more and that&#39;s never a bad thing.</p>
<p>
	Going the route of using an SSD is amazing.. it boots in 5 seconds or so, it&#39;s unreal.&nbsp; The "windows experience" disk data transfer rate went from a score of 5.9 to 8.1 or something like that... just no comparison to how fast an SSD runs vs. a regular hard drive.</p>
<p>
	I&#39;ve had fun playing with windows 8 so far and hope to post again about a few tips and tricks I found as I&#39;ve been working through things.</p>
]]></description>
      <dc:subject><![CDATA[How To & Tips, Installation, Off Topic Articles,]]></dc:subject>
      <dc:date>2012-12-12T02:09:51+00:00</dc:date>
    </item>

    
    </channel>
</rss>