Pittsburgh’s Power BI Dashboard in a Day

On March 9, 2018, Microsoft in partnership with Orion Systems Integrators will host another Dashboard in a Day event at its Pittsburgh office.  I encourage anyone interested in learning more about Power BI’s business analytics service to monitor your company’s health to attend this event.

This hands-on event is a built around a demo environment, however, attendees are encouraged to bring their own CSV or excel documents to play and explore with a familiarity.

Here is a link to the registration.

If you are not near Pittsburgh, then I would recommend reaching out to your local Power Bi group to see if they host or can create a similar event.


1095C Old Employees are Populating in Microsoft Dynamics GP

Payroll in January is the most havoc time of year.  One common problem I see on the help desk in January is the 1095C printing a form for an employee that has not worked this year or has been inactive since before the current year.

To correct this there are two scripts to run. Both of these scripts are from Terry Heley’s ACA post which can be referenced here. In both scripts, please replace XXX for field YEAR1 with the current year.

This script will remove any employee without coverage for the year:

delete from upr10111
where (MonthofCost_1=’0′ AND MonthofCost_2=’0′ AND MonthofCost_3=’0′ AND MonthofCost_4=’0’and
MonthofCost_5=’0′ AND MonthofCost_6=’0′ AND MonthofCost_7=’0′ AND MonthofCost_8=’0′ AND
MonthofCost_9=’0′ AND MonthofCost_10=’0′ and MonthofCost_11=’0′ AND MonthofCost_12=’0′ AND
MonthofCoverage_1=’0′ and MonthofCoverage_2=’0′ and MonthofCoverage_3=’0′ and MonthofCoverage_4=’0’and
MonthofCoverage_5=’0′ AND MonthofCoverage_6=’0′ AND MonthofCoverage_7=’0′ AND MonthofCoverage_8=’0′ AND
MonthofCoverage_9=’0′ AND MonthofCoverage_10=’0′ AND MonthofCoverage_11=’0′ AND MonthofCoverage_12=’0′)
and YEAR1=’XXX’

This script will need to have the year replaced in two places. This will delete users who are older than the current payroll year. For example , n 2016 you would replace the XX with 2016.

AND DEMPINAC <= ‘XXX-01-01 00:00:00.000′) and YEAR1=’XXX’

What these scripts do is update the UPR10111 table where the wage file creates data for the 1095C and 1094C transmittal form.

This information can be found on Terry Heley’s Blog, the payroll ACA information can be found here. Her blog is an amazing source of information and I highly encourage everyone to check it out.

Disclaimer: Always run a new script in your test environment and run a good backup before you run any scripts that will delete or change data.

Security Mishap Friday: The Fake Wi-Fi Scam

Let’s face it, people like free items.  Free is amazing.  You get something for nothing.  In the case of most businesses, they get more patrons coming into their venue and staying longer when they offer this server.  People stick around longer and potentially spend more money.  Seems like a win, win.

In all reality, free Wi-Fi should be treated as a creepy stranger offering a child a swirly lollypop.  It’s enticing.  Just within your reach.  It also has the unforeseen consequence of stealing your life away.

There are two common ways that hackers accomplish this. The first is that they hack the free Wi-Fi and view all the connections currently connected to the Wi-Fi connection. Why go through all that trouble.  People are trusting.  If they see a free Wi-Fi connection at a business they will assume that it is offered through the business.  In highly congested areas with many cafés or shops, there could be many options that show up on the Wi-Fi connection search.  Because of this aspect of social engineering, many hackers do not bother to hack into a network, they will simply create their own.

Once they create their own free Wi-Fi connection, all they have to do is sit with a cup of coffee until someone connects to it.  Once their victim is connected, they have access to everything they are doing on their device.

What you can do to avoid being a victim

  1. Don’t connect to a public Wi-Fi (not always possible)
  1. If you have Xfinity, then you can connect to the Xfinity anywhere. Xfinity offers secure connections to all their customers to connect through other routers by logging in with their Xfinity accounts. Other companies may offer similar user experiences.
  1. Don’t access banking or financial information while connected to a public Wi-Fi. Even if you turn off your network discovery they can still use packet sniffers to see what you are accessing.  Don’t access anything that you would want someone to see.
  1. Secure Access to your computer. Go to Control Panel >> Network and Sharing Center>>Change Advanced Sharing Settings.  Verify that network discovery is turned off for Guest or Public