Top 5 Window Changes to Microsoft Dynamics GP 2018 R2

Its that time again where Microsoft releases a new update for our beloved product. Here is the countdown of my favorite top 5.

5. Retain the Ship-To-Address with Customer Modifier. In prior versions of Microsoft Dynamics GP, the Ship-To-Address name field was removed whenever a customer was modified with the modifier utility or the customer combiner.

10042018_1.png
4. A new smartlist that shows “Deposits on Unposted Sales Transactions.” This can be found in the smartlists by going to Sales -> Sales Transactions-> Deposits on Unposted Sales Transactions. This will allow your users to save time by not searching through sales transactions to see if any deposits exist. It is programmed to look at the Sales Order WORK table (SOP10100) with a ‘Deposit Received’ (DEPRECVD) greater than zero.

10042018_2

3. Excluding Inactive checkbooks in your lookup. I had a customer ask for this feature two months ago and Microsoft has delivered. It can make your users spot the correct checkbook even faster!

10042018_3

2. Add Vendor Document Number to Purchasing All-In-One View. When I did not think the All-In-One view could get better. This tool allows users to track related documents through the system. Where I ran into trouble when troubleshooting documents is that the vendor document number is the one known and not the document number. With this update, it has been added to the payments and credit documents columns.

10042018_4
1. The Vendor Hold Status will produce a warning when a user enters a transaction. Many clients complain that after they entered transactions they found that the vendor was on hold. Microsoft added a warning, “Vendor XXXX is currently on hold. Do you want to continue?,” to the Payables Vendor Inquiry, Payables Transaction Inquiry – Vendor, the Purchasing All-In-One View, and Payables Transaction Entry Zoom. These windows show a red stop sign after the vendor ID and show a clear indication that the Vendor has issues.

10042018_510042018_6

These are my Top 5 favorites. Has anyone else had a chance to review the changes?

Advertisements

SSRS Error: “This page might not function correctly because either your browser does not support scripts or active scripting is disabled”

10022018

Recently I have logged into a client’s new server. They recently upgraded and have a new report server. They requested that I edit an SSRS report for them. This was delayed because of the error: “This page might not function correctly because either your browser does not support scripts or active scripting is disabled.”

After some trial and error, looking at permissions and tech guides. I found that this was resolved in an IT 101 troubleshooting task. I added it to the Trusted Sites in Internet Explorer.

SQL Error: “Unclosed quotation mark after the character string”

One of the most frustrating thing that happended to me recently was looking for an unenclosed quotation mark after a character.   The error message “Unclosed quotation mark after the character string” appeared when a client ran a Historical Aged Trial Balance for Payables Management in Microsoft Dynamics GP.  Microsoft offered a solution here.   My initial thought that I would be able to find the problem voucher with little effort.  It should have been a simple select statement filtered to look for a wildcard and single quotation.  I was wrong.

I found that T-SQL likes the single quotes as much as my cat likes water.  I still have scratches from the last bath (not pretty).  Here is a screenshot of my first attempt.

09302018

The syntax wasn’t compatible with my theory.  After about an hour of attempting different solutions, I found that you had to search for wildcards before and after the quotations. Here is the SQL solution.
Select * from PM30200 where Doctype=’6′ and VCHRNMBR like ‘%”%’

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.

DELETE UPR10111 WHERE EMPLOYID IN (SELECT EMPLOYID FROM UPR00100 WHERE INACTIVE = ‘1’
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

post_netword-discovery