Tuesday, August 23, 2016

Payroll Reconciliation and Tax Flag Comparisons

First things first, it is always easier to reconcile payroll as you go.  Bit by bit goes down easier than looking at large ranges of time. What do I mean by reconciling?  Well, after each payroll do the following...

1. Print the check register that shows up automatically in most cases when you post the payroll (the one that shows what you owe as far as taxes)
2. Then print the payroll summary report (Reports-Payroll-Period End), print this from the start date of the current quarter through the payroll check date.  This report should reconcile (wages, taxes, etc) to the cumulative tracking of your payroll check registers.
3. Then print the 941 report for the current quarter.  This should also reconcile (wages, taxes, etc) to the payroll summary report.  And the Schedule B should reconcile by date to your check registers.

You can also follow this same process for state taxes, using the state tax register that prints when you post payroll and comparing it to the state tax summary printed from reports-payroll-period end.  It is important to do these exercises in a cumulative fashion so you inevitably pick up off-cycle adjustments and voids, as well as enable you to compare to your cumulative 941 as you go which makes quarter end a little less climactic :)

When you find an issue, then you can deal with it and already know what payroll or adjustment time period is the source.  However, we don't all live in perfectville and sometimes time gets away from us.  So if you are needing to back track and reconcile multiple payrolls, specifically after you have gone live, one useful double check can be to make sure that individual employee pay codes, benefits, and deductions are set with the same tax flags as the overall setup (comparing Cards-Payroll to Setup-Payroll).  The script below does that specifically for pay codes, but can be easily adapted for benefits or deductions as well.

--Compares UPR00400 employee pay code master to the overall pay code setup
--Identifies where tax flags don't match, or where SUTA states are missing for SUTA taxable codes
--Provides list of affected codes and employees
select UPR00400.EMPLOYID as EmployeeID, UPR00400.PAYRCORD as PayCode,
UPR00400.SBJTFUTA as SubjectToFUTA, UPR00400.SBJTSUTA as SubjectToSUTA,
UPR00400.SUTASTAT as SUTAState, UPR00400.SBJTFDTX as SubjectToFed, UPR00400.SBJTSSEC as SubjectToSS, UPR00400.SBJTMCAR as SubjectToMed,
UPR00400.SBJTSTTX as SubjectToState from UPR00400 inner join UPR40600 on UPR00400.PAYRCORD=UPR40600.PAYRCORD
or (UPR00400.SUTASTAT='' and UPR40600.SBJTSUTA=1) or (UPR00400.SBJTFDTX<>UPR40600.SBJTFDTX)

Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional. She is a director with BKD Technologies, providing training, support, and project management services to new and existing Microsoft Dynamics customers. This blog represents her views only, not those of her employer.

Monday, August 22, 2016

Dynamics GP message "Do you want to save the unbalanced entry?"

By Steve Endow

This is a trivial issue, but since it took me a few seconds to realize my mistake / accident, I thought I would mention it.

I'm testing a .NET customization to the GL Transaction Entry window that monitors certain GL accounts that are entered in JEs.  While entering a fake JE to test my customization, I chose a random GL account to balance the JE, and then clicked Save.

I received this message:

I was puzzled at first, but then I saw that the second line of the JE did not have a dollar sign in front of the Credit amount, and I had a pretty good guess what I had done.

The account I had randomly chosen, 600-9030-00, just happened to be a Unit account, not a Posting account.

Unit accounts can't be used to balance a GL journal entry, so my test JE was not balanced, as GP indicated.

This is presumably not a common mistake, and is one that is easily diagnosed and resolved, but since I almost never work with unit accounts, I thought I would mention it.

There are quite a few posts on unit accounts, such as these two from Boyer & Associates:



May your journal entries be balanced!

You can also find him on Google+ and Twitter

Friday, August 5, 2016

Using INFORMATION_SCHEMA views to quickly and easily find objects in SQL Server

By Steve Endow

Christina Phillips and I have done a SQL presentation at several Dynamics GP conferences, and one of the items I always like to mention is INFORMATION_SCHEMA.  It seems that many people don't know about this fantastic set of views, and are still suffering by using sysobjects.

I think that it is a very underutilized tool for Dynamics GP users and consultants.

INFORMATION_SCHEMA is a set of metadata views that allows you to quickly and easily find objects in SQL Server.  The best part about INFORMATION_SCHEMA is that the syntax is very simple and obvious.  It's vastly easier to use than sysobjects.

Here's an MSDN article that covers INFORMATION_SCHEMA views:


Let's jump straight into some examples.

What if you want to find every SOP table in the entire database:


What if you want to find every SOPNUMBE field in the entire database:


What if you wanted to find every SOPNUMBE field in the SOP tables in the entire database:


Inversely, what if you wanted to find every SOPNUMBE field that is NOT in a SOP table in the entire database:


What if you wanted a list of all GP stored procedures related to the SOP1xxxx tables?


What if you wanted to find any stored procedures that had been altered?


One thing that I believe INFORMATION_SCHEMA cannot search for is triggers.  For triggers, you will still need to use sysobjects.  Here is a Stack Overflow post with some options for doing that.

I use INFORMATION_SCHEMA regularly to quickly track down tables and fields and find out which tables contain a given field.  It's a huge time saver and if you work with GP queries regularly, is something you should probably start using.

You can also find him on Google+ and Twitter

Friday, July 22, 2016

Using a VPN service while working in China

By Steve Endow

In my last post, I discussed some of the things I learned about working remotely while travelling in China.  In that post, I mentioned that using VPN services in China to get past The Great Firewall and access resources in the US was frustrating at best.

In this post, I'll share which VPN services I used and discuss my experiences trying to use them in China.

Here are the three VPN services that I purchased and used:

1. VPN Unlimited by KeepSolid
2. VPN Secure
3. ExpressVPN

This is not a recommendation or endorsement of any of these services--they are just the three that I semi-randomly tried, out of the dozens and dozens of offerings.  If you ask 10 people which VPN service they use in China, you are likely to get 10 difference answers or recommendations.

Based on my experience, it doesn't really matter which service you choose.  Just find a few that seem to have a good price, the features you need, and some positive reviews.  I'll explain what I mean shortly.

I used the services on iOS and Windows 10.  I didn't bring my Android device with me, so I don't have any feedback about using them on Android.


I would recommend asking the following simple questions when shopping for a VPN service for use in China.

1. Does the VPN service work from within China?
2. Does the service support the devices you use? (iOS, Android, Windows, etc.)
3. How many devices can you use on your account?
4. If you need to use a corporate VPN (Cisco, SonicWall, etc.) while in China, can you connect to the VPN service first, and then connect to the corporate VPN through the service's tunnel

My impression is that virtually all of the VPN services will claim they work in China, and the ones I looked into all had Windows, iOS, and Android clients.  So the first two questions should be easy.  For the last question, you are on your own to test dual VPNs.

All of the VPN services seem to claim that they are the best, have a bunch of servers worldwide, and that they are fast.  One I used claimed to have "stealth mode" to avoid detection by The Great Firewall.  I can attest that feature didn't seem to make any difference.

If you are working in China, ignore all of the sales and marketing claims and just set your expectations very low.  If you are able to connect to the VPN and get over 1mbps, consider yourself lucky.

I first signed up for VPN Unlimited based on a recommendation by Scott Hanselman.  VPN Unlimited offers a lifetime subscription for a very reasonable price on Stack Social, so I purchased it.


Since I wanted to have a second service as a backup, I signed up for 1 month with VPN Secure, as it was one that received good marks in this rather extensive review of VPN services:


Near the end of my 3 weeks in China, I had a day where I was having a lot of difficulty connecting to either of the two VPN services from two different residential networks.  Frustrated, I signed up for the third service, ExpressVPN.  ExpressVPN didn't work that day either, so I pretty much confirmed the problem was not with the VPN services.  But that's how I ended up testing 3 different services.

Of the three services that I tried, VPN Unlimited was probably the one I preferred the most, but for a pretty trivial reason.  On iOS, all three of the VPN services prompt for a username and password when launched.  VPN Unlimited was the only one of the three that supports Touch ID on the iPhone and iPad.  So when I had to kill the app or reboot my iOS device (which I had to do constantly in China), it was much easier to launch VPN Unlimited and use Touch ID than to have to login by typing my username and password repeatedly.

This may seem trivial, but when in China, I had to shut down the apps and relaunch them a dozen times a day, at least, to try and get them to work.  Logging in every single time gets really old.  So for that reason alone, I used VPN Unlimited the most.

I just tested VPN Unlimited and ExpressVPN on Android, and neither app prompts me for a password every time the app is launched or after the phone is restarted.  So that's a bonus for Android users.

Signing Up

I recommend signing up for at least two services prior to going to China.  They aren't expensive, so having two or three handy is worth it.  You will want to have your account setup and paid for, the client software installed and configured on all of your devices, and you will want to test the VPN on all of your devices.

I would recommend using the same simple password for all of the services.  Since I had to constantly re-enter my login on iOS, it was annoying having to type long passwords every time I launched the apps.

Using the VPN

The vast majority of the time, I used the VPN services on my iPhone and iPad.  It is easy to launch the apps and they are relatively quick to connect on iOS.

Using the VPN services on Windows 10 was a different story.  For some reason, they were horribly slow to connect on Windows, and the Windows apps were very bad at refreshing or updating their status.  So I couldn't tell if the app had hung, was stuck, was connecting, or was connected.  Sometimes they worked okay, but most of the time it was a hassle to use them.

And for some reason I had a much harder time successfully connecting on Windows.  One day I used over 50% of my Surface Pro 4's meager battery just trying to connect to the VPN, and I eventually gave up.  I dreaded having to use my Surface Pro to connect to the internet, since it wasted so much time, and I had such little success with any of the VPN services on Windows 10 while in China.

So if you use iOS and Windows, I would recommend trying to get everything you need setup on your iPhone and iPad, as I found the VPNs to work much better on iOS.  I'm guessing Android is better than Windows as well.

Using Multiple VPN Services on iOS

If you install multiple VPN services on iOS, there is one thing you'll want to be aware of.  In the iOS VPN configuration settings for each VPN service, there is a setting called Connect On Demand.  The idea is that whenever you connect to a WiFi network, the VPN service will detect it and automatically connect for you.  This is fine when you only have one VPN service installed.  But if you have multiple services installed on an iPhone, they will fight with each other.  If you turn on your phone and try and connect with one service, the second service may be trying to connect behind the scenes, preventing either connection from working.  So you have to make sure to turn off Connect On Demand.

Unfortunately, it seems that every time the VPN apps refresh and download their configurations and server lists, they re-enable the Connect On Demand setting.  So you have to constantly turn it off again.  Normally, you'd only need one VPN service, and Connect On Demand would be a good feature, but when in China and using multiple VPN services, it isn't.

The reality of using a VPN in China

The VPN services do work.  You can test them while in the US and easily connect to different cities and different countries just fine.  When you test from the US, you'll likely see decent speeds without too much latency.

And technically, the services do work in China.  But for me, they didn't always work, and some days they didn't work at all.

All of the 3 services I tried had issues, so one wasn't better than another or less prone than another to have problems.

I'll let these screen shots speak for themselves.






While all of the VPN services claim to work from China, clearly they don't always work from China. Between The Great Firewall, local network firewalls, flaky WiFi, and questionable internet connectivity, it was a constant battle to get and maintain a decent connection with any of the 3 services I used.

And even when one of the VPNs did appear to connect, sometimes the connection just didn't work, or the speed was so slow, or so high latency, that it was unusable.  Many times my phone would appear to be connected to the VPN service, but I couldn't connect to any web sites or retrieve my email.

I would disconnect, turn WiFi off, turn WiFi back on, then try and reconnect to the VPN.  I would also regularly reboot my iPhone in the hopes that would work.  I don't know if any of those things actually made a difference.  It was a constant battle.

Based on my experience, it seems that China has become fairly good at blocking VPN traffic.  As I mentioned in my last post, it seemed as if it became harder for me to connect over the course of my three weeks in China, and I speculate that there are MAC address filters that start to completely block all traffic that is associated with VPN usage.

Given how frustrating it was for me to get a decent connection and get any work done remotely while in China, I don't know how business travelers can work in China.  Either everyone is suffering and coping like me, or there is some secret that I'm missing.

If you have to travel to China, just be prepared to potentially have limited or intermittent connectivity to web sites or internet services outside of China, and for your productivity to be severely limited.

Good luck.

You can also find him on Google+ and Twitter

Tuesday, July 19, 2016

The Challenges of Working Remotely While Traveling in China and Singapore

By Steve Endow

I just returned from a one month vacation (June / July 2016), spending 3 weeks in China and one week in Singapore.

While in China, I traveled over 2,000 km to four different cities and lived in apartments, houses, and several hotels.  During my trip, I attempted to monitor my email (hosted in Canada), access all of my usual US web sites, make phone calls to the US and Australia, and connect to my office network in Los Angeles.

I was familiar with The Great Firewall of China that is known to block internet traffic to the rest of the world, so I anticipated that I would have difficulties working remotely.  To prepare for this, I signed up for three VPN services that claimed to work in China.  I tested the VPN services in the US, but there was no way for me to know how well they would work in China.

There was not a whole lot I could do to anticipate what it would be like to work remotely from China, so I just warned my customers and colleagues that I would have limited internet access and may not be able to respond to emails for several days.  I would recommend that you set your own, and your customers' expectations, very low, and assume you will have limited connectivity.

I learned quite a bit about trying to work remotely in China and experienced several challenges and frustrations, so I thought I would share my experiences in case some other poor soul has to work from China.

Here's what I'll cover:

1. Before you go
2. While traveling
3. Using VPNs
4. What worked and what didn't
5. Workarounds
6. After you return

Before You Go

VPN Service

I'll do a separate post about the VPN services that I used and how well they worked, but here's the short version.

You will want to sign up for at least 2 VPN services before you leave for China.  And you will want to have them installed and configured and fully tested on every single device before you leave.  Fortunately they are fairly cheap and there are tons of options, and based on my experience, it isn't critical which ones you choose.  Technically they do appear to work, but set your expectations very, very low.

If you're old enough to have used a 56k (or 28.8k) modem, you might remember the days when it sometimes took 20 minutes of redialing to connect to an ISP (Compuserve, AOL, Prodigy, WorldNet, etc.), and after you were connected for 5 minutes at those blazing fast speeds, the modem would disconnect randomly, and you would start the process all over again.  That's exactly what it's like to use a VPN service in China.  It is a frustrating, time wasting, and very unproductive process.

In short, do not plan on being productive with any online or internet-dependent resource.  Do not plan on having quick access to any foreign internet service.  Do not assume that you can connect to foreign internet services daily--it may be 1 or 2 days before you can get connected to even retrieve your email.

And if you anticipate needing to connect to a corporate, work, or customer VPN, then you'll also need to test dual VPN connections.  First your need to connect to the VPN service to tunnel out of China, and you'll then attempt to connect to the corporate/client VPN.  In some cases, this dual tunnel setup will simply not work.  In other cases, the dual tunnel setup may work fine outside of China, but will not work from within China.  Be prepared for this.

I had some success in using OpenVPN over a VPN service on my iPhone and iPad to connect to my office network.  But while in China, I was unable to use OpenVPN on my Windows laptop to connect over the VPN service.  It just wouldn't work from China.  This may vary based on the corporate VPN client, but I would recommend assuming that you may be unable to connect to a private / corporate VPN from China using a Windows laptop.

Once I got to Singapore, the VPN services started working again.  They were slow and flaky, but they worked much better than in China.

Mobile Number and Two Factor Authentication

This is one that I did not prepare for.  It applies to any international travel, and being in China just makes it a little more complex.

The third day I was in China, I had to send a wire transfer.  I was able to connect to a VPN service, and then connect to the BofA web site.  I setup my wire transfer, but when I went to submit it, I realized that I needed to receive a one-time passcode--something I forgot about.  The Bank of America web site requires a one-time text message passcode for all wire transfers, and this feature cannot be disabled.  But guess what?  My account is setup to send the passcodes to my US mobile number, and I did not setup international roaming on my mobile phone, nor did I want to.

I checked to see if I could add a new mobile number to my BofA account, but of course, that also requires me to receive a passcode on my main mobile number to authorize the request.  And even if I could add a number, it would have to be a US mobile number, and I didn't have direct access to a US mobile number that could receive text messages in China.

So I had to call BofA customer support, authenticate myself and then have them remove my mobile number completely from my account.  I then had to contact my sister in the US and add her cell number to my BofA account.  I then had to coordinate with her so that when I submitted my wire transfer request, she could quickly send me the confirmation code that I would then enter in the BofA web site.  It was comical.

So before leaving, try and think about any web site or service or login that uses mobile text messages for two-factor authentication.  If you need to use any of them, you'll need to either have international roaming on your cell and be sure that roaming will work in China and that you can receive text messages while in China (good luck verifying that before you leave), or you'll need to have a virtual phone number that can receive text messages (preferred).  Even if you have roaming, I would strongly recommend also setting up a virtual phone number as a backup and setup that additional virtual number on all of your accounts.

Virtual Phone Numbers and Text Messages

I clearly did not anticipate the need to receive text messages while in China, and that was a gaping hole in my preparation.

After realizing this, I checked to see if my Google Voice number would receive texts.  Based on my testing and forum posts on the topic, it will not.  Google Voice is unable to receive text messages sent by web sites.  Apparently Skype cannot either.

There are virtual phone services, similar to Google Voice, that provide you with a virtual phone number and let you make calls with an app on your mobile device.  Some also claim to allow you to receive text messages.  I only had time to test one, KeepSolid Phones, and in my limited testing with a trial phone number, the KeepSolid Phones app on my iPhone was unable to receive a text message from a web site.  I didn't have time to do more testing, so I gave up on it and didn't try any other such services.

To my surprise, I stumbled across a solution that did work for me.  In my office, I use Vonage Business for my VoIP phone service.  I realized that as part of my Vonage Business service, I have an iPhone app called Vonage Business Essentials.  Through the iPhone mobile app, I found that I was able to send and receive standard SMS text messages using my office phone number.

I also made a few calls using the Vonage Business Essentials iPhone app and was typically able to make and receive calls without having to use a VPN.  If I used the VPN, the calls were very choppy and unreliable due to the slow VPN speeds.

However, I was unable to make an international call from the Vonage Business Essentials app, so I was unable to call Chinese phone numbers.  I  don't know if that is a restriction in the application, or if that option was just disabled or blocked on my account.  I instead used Skype to call Chinese phone numbers, and that generally worked fine.

SIM Cards

You can get prepaid SIM cards in China, but because I did not get one, I can't provide any details.

In the Shanghai airport, there were vending machines that dispensed the prepaid SIM cards, but there were many different types, apparently by region and plan type, and I don't know what they required in terms of setup or activation.

If you try and get a prepaid SIM card from a retail store, you'll want to bring a local with you who can translate and potentially provide their contact info and ID on your behalf--I don't know what the current requirements are for foreigners who wish to purchase a SIM card.

If you do plan on using a China SIM card with your mobile phone, try and verify that your phone will work in China.  China apparently uses its own unique mobile frequencies, and apparently different carriers use different frequencies, like in the US, so not all phones will work on all Chinese mobile networks.

And you will need to unlock your phone before you go to China.  In the case of AT&T, that requires that you own your phone outright with no outstanding contracts or payments, and that you unlock it via the AT&T web site.

I have relatives in China who provided my wife with an extra SIM card from their mobile account, so I can report that an unlocked US AT&T iPhone 5S worked just fine with that particular Chinese carrier--I believe it was China Telecom.  While in China, I was able to access the AT&T consumer unlock web site over VPN and unlock my wife's phone successfully.  So that step can be done while in China, but I recommend doing it before you leave.

In Singapore, SingTel offered a prepaid SIM card for $30.  It is good for 10 days and includes 14gb data.  I didn't note how many voice minutes were included.

While Travelling

Public WiFi

If you have layovers at Chinese airports and will be spending a few hours waiting around, I would recommend signing up for a Boingo Wireless hotspot account.  I believe that Boingo is available in most Chinese airports.  I signed up while waiting in the Shanghai airport and found the Boingo service to work fairly well in the main terminal areas.  I did occasionally have issues connecting, and the signal strength was weak in some of the odd gate boarding areas in the Shanghai airport, but overall it was well worth the nominal $9.95 monthly fee, and you can cancel once you return if you no longer need it.

When setting up the Boingo account, choose a simple username and a relatively simple password, as you will need to re-enter it nearly every time you connect using a mobile device, and on my iPhone I was unable to copy and paste the password from my password manager into the Boingo authentication page.

While traveling in China, many businesses and malls claimed to have free WiFi, but most required a Chinese mobile number that could receive a passcode via text message.  They then required that you enter the passcode to login to the WiFi service.  So I was unable to use most of the free WiFi services.

Singapore was similar, with a fair number of locations offering WiFi, but some requiring registration of some form.  Starbucks stores in Singapore offered WiFi, but required you to setup an account with a social media company.  I was able to sign up from my phone to get access.


I was concerned about connecting to public WiFi while travelling.  I assumed that I would be at risk, but I didn't have much choice.

Other than the standard advice of making sure to have anti-malware type software running on your laptop and being careful about what you access, I did the following:

1. Occasionally cleared all web browser cache, cookies, history, etc. on my laptop and mobile devices
2. Reset (wiped out) the network settings on my iPhone and iPad
3. Regularly shut down and restarted my iPhone and iPad

Here is a good article on securing an iPhone for travel:


You don't necessarily have to do all of the steps, but try and do as many as you can.

Using VPNs

I'll cover VPNs in more detail in a separate post, but as I mentioned earlier, VPNs in China are very unreliable.  As in roll-the-dice and pray unreliable.

Over the course of three weeks, I regularly attempted to use three different VPN services and connected to several dozen residential / private and public WiFi networks in four different cities.

In summary:  Sometimes they work.  Sometimes they don't.  Assume a 50% success rate at best and you might not be disappointed.

They worked fairly well on my iPhone and iPad.  They barely worked at all on Windows 10 on my Surface Pro 4, and were painfully slow to connect on Windows.

Trying to use the VPN services and access foreign sites while in China was extremely frustrating, and I would say that I spent more time trying to get the VPNs to connect and get them to work than I did actually using the VPN connection.  And that is not an exaggeration.

One day in China I repeatedly attempted to connect to a VPN over the course of 12 hours and was unable to get any of the 3 services to work on two different WiFi networks.  I had used the same two residential private WiFi networks a week earlier and the VPN services worked fine.  But that day, despite wasting several hours trying on multiple devices, absolutely nothing worked, and I was unable to retrieve a single email or connect to any web sites.

My overall impression was that over the course of my 3 weeks in China, my ability to connect to the VPNs decreased.  When I first arrived, the VPNs connected relatively quickly and easily.  But the last few days I was there, it seemed like I couldn't connect at all.

Based on this, I speculate that the Chinese firewall may have tracked the MAC addresses of my devices and flagged them as being associated with VPN usage.  After 3 weeks in China, it felt like my MAC addresses ended up on a blacklist and the devices would no longer connect most of the time.  The issues were inconsistent, so it could be that the blocking occurred at the ISP level, and not centrally at a national level.  But it was definitely much harder to connect at the end of 3 weeks.

If this is indeed what occurred, there may be some software that allows you to spoof your MAC address on Windows and Android.  I'm assuming that MAC spoofing is not possible on iOS without jail breaking.  The alternative might be to have multiple devices and only use them one at a time.  When one device stops working, try using the next device.  Not very practical, but a potential workaround if you are concerned about the issue and will be in China for several weeks.

What Worked and What Didn't

This is a quick list of things that I tested or used while in China.  In Singapore, I don't think I had any significant issues accessing anything.

Worked Without VPN

Skype iPhone app messaging and phone calls
Vonage Business Essentials iPhone app

Did Not Work Without VPN

Just about every major US site or online service
Hosted Exchange
Yahoo Mail
OpenVPN to my office network

Sometimes Worked Without VPN

iPhone Telegram notifications only (I had to use a VPN to retrieve messages, which was odd)
iPhone WeChat notifications only (I had to use a VPN to retrieve messages, which was very odd, since most people in China use WeChat)
Kindle book downloads


When I needed to access a web site that was blocked, or needed to search for something without using Google, I used Baidu.com.

If you perform a search on Baidu, you can sometimes get access to an equivalent site that will have what you need.  So for instance, I needed to lookup exchange rates, and was able to find an exchange rate web site via Baidu when I was unable to access Google or use a VPN.

Sadly, despite hours of trying, I was unable to find any workarounds, hacks, or tricks that would allow me to reliably connect to a VPN service or access US sites without a VPN.  Zero workarounds in that category.

After You Return

As a result of using my iPhone, iPad, and Surface Pro in China and Singapore on numerous WiFi networks, I'm assuming that all of my devices have been compromised in some manner.  I'm also assuming that any logins that I used while travelling are also compromised.

Now that I'm back, I'm planning on resetting the password for every web site, service, or account that I may have accessed.  Not my idea of a fun time, but not particularly difficult.

I will also be completely resetting and wiping the iPhones and iPads and setting them up from scratch, not from a backup.  I use both iCloud and the Eye-Fi app on my iOS devices to automatically backup my photos and videos, so once I confirm those are backed up, I'll wipe the devices and reinstall the apps.  Again, I'm not looking forward to doing it, but it's not rocket science, and I've done it many times before.

My Surface Pro 4 is a little trickier, as Windows is a pain to wipe and reconfigure.  I didn't use it much, and it was nearly impossible to get a VPN service to connect on Windows, but in the little time that I used it, my Chrome web browser was somehow hijacked to redirect traffic.  Any time I tried to access nytimes.com, Chrome would redirect me to facebook.com.  No matter what I tried, I was unable to access nytimes.com from Chrome.  The Windows Edge browser did not have the same issue, and using ping on the command line, I confirmed that DNS lookup was not affected.

After poking around, I finally cleared the cache, history, etc. in Chrome, and that resolved the issue.  But it was evidence that something had messed with my Surface Pro, so I'm assuming it could be compromised in other ways as well.  Definitely not looking forward to wiping it and reinstalling everything.

So that was my experience of trying to stay connected while in China for 3 weeks.  I chatted with a friend who happened to be in China at the same time I was there, and he had similar issues and challenges with his VPN service, so it was somewhat reassuring to know that it wasn't just me.

I cannot imagine how people get any significant work done remotely while travelling to China.  I know there are thousands and thousands of people who travel to China for business, so I'm wondering if there is some magic secret for staying connected, or if they are as frustrated as I was.

If you have traveled to China recently (2016 or later), I'm interested in hearing if you had similar experiences and if you have any tricks that allowed you to be productive and actually get work done remotely.

You can also find him on Google+ and Twitter

Friday, June 10, 2016

What do you use to integrate Dynamics GP and Dynamics CRM?

By Steve Endow

Today I was asked what tool I recommended to integrate Dynamics GP and Dynamics CRM.

Unfortunately, I've never done a GP to CRM integration, so I didn't have a recommendation.

I've never searched extensively for GP to CRM integration solutions, so I've only heard of 3 options.

1. Microsoft's Connector for Microsoft Dynamics
2. Scribe and Scribe Online
3. SmartConnect

I'm vaguely familiar with the Microsoft connector, as I recall a version was created many years ago and then discontinued.  And I see that the current version is also apparently being discontinued, and will only work with CRM up to version 2016.


The appeal of the Microsoft Connector is that it is free.  Naturally that would be great for customers, if it works well and does what they need.  But if it won't support CRM releases after version 2016, that is probably not a good option going forward.

So that leaves Scribe / Scribe Online and SmartConnect that I've heard of for GP to CRM integrations.

I just saw one post about Jitterbit being an option, but I don't think I've personally come across a Dynamics GP customer that has used Jitterbit.

Are there other tools are out there for integrating Dynamics GP and Dynamics CRM that you would recommend?

Steve Endow is a Microsoft MVP for Dynamics GP and a Dynamics GP Certified IT Professional in Los Angeles.  He is the owner of Precipio Services, which provides Dynamics GP integrations, customizations, and automation solutions.

You can also find him on Google+ and Twitter

Yup, Dynamics GP user names are case sensitive

By Steve Endow

I occasionally get a call from a customer who is having trouble logging in to Dynamics GP.  They created a new user, they know they have the password correct, but GP keeps saying the login failed.

If you encounter this issue, one of the things to check is the capitalization of the GP user ID.

My login failed when I used "testuser".  Notice that the User ID is actually "TestUser".

Unlike the rest of the software world, Dynamics GP user IDs are case sensitive.  So whenever you have a puzzling login failure, try checking the capitalization of the user ID.

You can also find him on Google+ and Twitter