Microsoft Now Has Quick Start Guides For Office 2016

image

I will be the first to admit that I like having manuals to read for specific information.  Microsoft has now authored documents called Quick Starts for Office 2016.   You can see the documents at https://support.office.com/en-us/article/Office-2016-Quick-Starts-25f909da-3e76-443d-94f4-6cdf7dedc51e.

Here are the different versions available.

Resources Online

Download in PDF

Read in Office Sway

For Mac users, the following Quick Start guides exist.  The Office 2016 guides are available to download in PDF.  They include Word, Excel, Outlook, PowerPoint, and OneNote. 

Skype for Business, Mac, and Mobile

Thinking about whether to upgrade to Office 2016?  Take a look at the resource guides to help you decide. 

Dynamics GP Update on Strategy At November 15, 2016

image

Figure 1 from Pam Misialek’s blog post of November 15 at https://community.dynamics.com/gp/b/gpteamblog/archive/2016/11/15/product-roadmap-and-strategy

If your company is using Dynamics GP, you can now plan your next update or upgrade based on the roadmap that “Inside Microsoft Dynamics GP” has released.  Here are the highlights:

  1. After the December 1 R2 release, Microsoft Dynamics GP will be updated annually in the late fall time frame.
  2. If you have new features that you want to see in a future release, enter them at Connect.Microsoft.com
  3. See the GP 2016 R2 Videos at https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/11/11/microsoft-dynamics-gp-2016-r2-new-feature-blog-series-schedule

 

GP 2016 R2 Release For Dec 1 2016

image

Figure 2 – Slide from the User Group presentation.  Slides are at https://docs.com/pam-misialek/9145/microsoft-dynamics-gp-roadmap-oct-2016?c=GFj46s

Here is the slide that announces the new features available in GP 2016 R2 which is being released on December 1.  You will notice that there are some features that users have been asking for.  This slide illustrates that Microsoft is listening to the requests from users and implementing them as new features.  You can see in the Figure 1 slide that the release in 2018 will be based on user requests.

GP 2016 R2- New Security Roles and Tasks are missing when upgrading to Microsoft Dynamics GP 2016 R2 and Year-End Update

Check out the blog from Derek Albaugh about the issue with missing security roles and tasks after upgrading to GP 2016 R2.  You can find the information at https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/10/14/new-security-roles-and-tasks-are-missing-when-upgrading-to-microsoft-dynamics-gp-2016-r2-and-year-end-update.

Some of the critical information about the scripts required is noted below, from Albaugh’s blog.

These scripts for Microsoft Dynamics GP 2016 / Microsoft Dynamics GP 2016 R2 missing security roles and security tasks records can be found here, and needs to be run against your DYNAMICS/security database:

MICROSOFT-DYNAMICS-GP-2016-R2-SECURITY-INSERT-SCRIPTS.txt

This set of scripts includes the security scripts for Microsoft Dynamics GP 2013 R2, Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2015 R2 from prior blogs, as well as Microsoft Dynamics GP 2016. You’ll need to run this script whether you’re upgrading from Microsoft Dynamics GP 2013 R2 or Microsoft Dynamics GP 2015/R2 to Microsoft Dynamics GP 2016/R2.

**NOTE: Because we’ve combined the INSERT scripts from the other blogs to be included in this one, you may see PRIMARY KEY errors referencing duplicated records trying to be inserted into the security tables. This can be ignored as it means that the record already exists in that table and the script will not overwrite anything that is already present.

Dynamics GP 2016 R2 has Table and Column Changes

image

 

Dynamics GP Support and Services team are spreading the word about changes in Dynamics GP 2016.  Sarah Purdy, Senior Technical Advisor, has written a blog highlighting some of the table changes and column changes in GP 2016 R2.  You can reference her blog at https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/10/21/table-and-column-changes-in-microsoft-dynamics-gp-2016-r2-and-year-end-update.

Here is the information from Sarah’s blog:


New tables that were added to Microsoft Dynamics GP 2016 R2

Table Physical Name Table Technical Name
System Tables

ADH00106                                                       ADH_Favorite_LookupAssignment
ASIEXP101                                                       ASI_FavoritePassword_SETP

Company Tables

APR_DIA_Mandatory_HIST                          
CM30200                                                        CM_Transaction_History
CM30300                                                        CM_Receipt_History
UPR30700                                                       uprEmployeeHistory

Data Type Change on an Existing Column:

The data type changed from ‘STR17_LBAU’ to ‘STR30_LBAU’ for the PAerdocnumber column in the following tables:
PA10502
PA30504
PA10504
PA30500
PA30501
PA30503
PA10500
PA10501
PDK10500
PTE10500
PTE30500

New columns added to existing tables (SYSTEM DB):

ASIEXP101 —   CMPANYID, SmartListPassword
SY40800 —       PowerBIWebClientID, PowerBIAppKey

New columns added to existing tables (COMPANY DB):

CM20200 –     VNDCHKNM
FA49900 —      IncludeTaxInAcqustCost
FA01300 —      IncludeTaxInAcqustCost, ORTAXAMT
IVC10500 —     TXDTLPCTAMT
SOP10105 —    TXDTLPCTAMT
RM30601 —     TXDTLPCTAMT
RM10601 —     TXDTLPCTAMT
FA01400 —      IncludeTaxInAcqustCost
FA01401 —      IncludeTaxInAcqustCost
FA01100 —      IncludeTaxInAcqustCost
FA00100 —      IncludeTaxInAcqustCost
POP10310 —    OriginatingPPTaxAmount
POP30310 —    OriginatingPPTaxAmount
APR_PIP40100 —         ACTINDX, ADRSCODE
PTO00101 —    USERID
Check back to the  Microsoft Dynamics GP 2016 R2 and Year-End Update Upgrade Blog Series Schedule page to review our blog posts related to Upgrading Microsoft Dynamics GP and other helpful resource links.

Thank you, Sarah, for letting us know about the table and column changes.

Dynamics GP–Notes on Fixed Asset Year End For Versions 2013, 2015, 2016

image

 

Andrea Melroe has posted a great blog about the Fixed Assets Year End Close for 2016. 

Here is the link to her article.  https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/10/27/mdgp-ye-update-2016-fixed-assets,

Andrea posted some valuable information so I have posted part of her blog, below.  You will need to go to the link to finish the article.

Please utilize the information below to ensure a smooth and seamless year-end in Fixed Assets. Enjoy!

Does the Year-End Update include any changes for the Fixed Assets module?

Yes, as usual there are changes to the Luxury Auto Maximum Depreciation Deduction amounts.  Maximum depreciation deduction amounts  for luxury vehicles have been updated for assets placed in service in calendar year 2015 (PATH Act) and 2016 to comply with IRS Guidelines. Click HERE to see the 2016 changes.

Is there any new functionality in Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2015, or Microsoft Dynamics GP 2016 for the  Fixed Assets Year-End Closing (YEC) process?

There is no new functionality this year that will affect Fixed Assets year-end closing processes. However, as a reminder, in Microsoft Dynamics GP 2015, a Fixed Asset Year-End Closing report was added to the year-end close process!! This optional report will print per Book, and show the Asset ID, Description, Cost Basis, YTD depreciation, Accumulated Depreciation, NBV, Placed in Service Date, Depreciated to Date, Quantity, YTD Maintenance, and Status for all assets impacted by the year-end close process.  In a single step, you can close the year and print a status report of all the assets that were affected by the close!! YEAH!!

To view FA fixes included in the 2016 Year-End Update click the appropriate link below:

Click HERE to get the fix list for the Year End Update for Microsoft Dynamics GP 2016 (Includes GP 2016 R2!! – available when released)
Click HERE to get the fix list for the Year End Update for Microsoft Dynamics GP 2015 (available when released)
Click HERE to get the fix list for the Year End Update for for Microsoft Dynamics GP 2013 (available when released)

When should the Year-End close for Fixed Assets be done?

It is recommended to close all books in Fixed Assets after you close Payables Management, but before you close the General Ledger year. 

Below are other key points to remember:

•All assets must be ‘depreciated through’ the last day of the current Fixed Assets year. **This is VERY important** See NOTE below.

•When you close the year in Fixed Assets, you must do it for each ‘Book’ you have set up.

•All ‘Books’ should be closed before you run depreciation for the new year!!

NOTE: The last day of the Fixed Assets year can be confirmed by navigating to the Fixed Assets Calendar Setup window:

Microsoft Dynamics GP 2013 and up: Microsoft Dynamics GP >> Tools >> Setup >> Fixed Assets >> Calendar

Microsoft Dynamics GP 2010 and below: Microsoft Dynamics GP >> Tools >> Utilities >> Fixed Assets >> Calendar

What does the Year End Close Process do and /or affect?

In the Asset General Window:
•The YTD Maintenance amount is cleared from the Expand last Maintenance Date Window.
•The Quantity is copied to the Begin Quantity field in the Expand Quantity Window.

In the Asset Book Window:
•The YTD Depreciation Amount is cleared.
•Cost Basis is copied to Begin Year Cost field.
•Life to Date Depreciation is copied to Begin Reserve field.
•Salvage Value is copied to Begin Salvage field.

In the Book Setup Window:
•The Current Fiscal Year is incremented to the next year.

As I said earlier, you can read the rest of the blog  at this link.  https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/10/27/mdgp-ye-update-2016-fixed-assets

Thanks, Andrea, for the update.

New Features In Outlook 2016

image

Figure 1 – Add-in features for Outlook.com and Outlook 2016, and 2013

Microsoft has been adding new features to Outlook throughout 2016.  In early October, the newest feature was added – Create Events From Email.

Here is what it does:

Outlook can now automatically create events from email messages you receive with flight, hotel, car, or dinner reservations or package delivery and tracking information. No more booking a flight and then adding the flight details to your calendar manually. All events created are marked private, so only you can see them. For more information, see Automatically add travel, restaurant, and package delivery events to your calendar.

In an earlier release, Microsoft added a feature that I really like called, “Use @ to get someone’s attention”.  You can see how to use it in the information below.

If you’d like to get someone’s attention in an email message or a meeting invite, you can type the @ symbol followed by their name in the body of the email message or a meeting invite. If you do, not only will their name be highlighted in the message body or invite details, but Outlook will automatically add them to the To line of the email or meeting invite. For more information, see Use @ to get someone’s attention.

And the best feature is the “Tell Me what you want to do box”.  With the changes, some tasks may now require a bit more explanation or help. 

To use this box,  enter a search for a certain task, function or question you’ll see a wide variety of options. If it’s a quick task Outlook will try to let you take care of it right from the Tell Me pane. If it’s a more complex question, we’ll show you help that we think best matches your needs. Try it out to see how fast you can find what you’re looking for and get things done.

Some of these features will work in Outlook.com as well as in Outlook 2016. 

Don’t forget to check out all of the Outlook Add-Ins that are now available.

Learn About Microsoft Dynamics NAV 2017

imageimage

Figure 1 – images from various sources

Microsoft has been on a role with releasing new software.  And, Dynamics NAV 2017 is looking very exciting for end users as well as developers. 

Lots of people have lots to say about it.  So, I put together a list of different blogs and articles that you might find as interesting as I did.  It can be a little light reading for the weekend.

1.  Waldo’s blog has some great details and some comments on the new opportunities.  See his information at http://www.waldo.be/2016/09/13/microsoft-dynamics-nav-2017-whats-new/

2. On the Community NAV blog, Tharanga Chandrasekara focuses on Microsoft’s release document on What’s New in NAV 2017.  It is a good read.  https://community.dynamics.com/nav/b/tharangacnavblog/archive/2016/09/17/what-is-new-in-microsoft-dynamics-nav-2017

3. If you are a developer, you may want to check out the info on the NAV TECH DAYS site at https://www.navtechdays.com/2016/sessions.  This covers things like “Building Extensions for NAV”, and Design Patterns in NAV 2017.

4.  To learn more about NAV 2017 Notifications, check out Roberto Stefanetti NAV Blog – https://robertostefanettinavblog.wordpress.com/category/nav-2017/

5.  If you are into Dynamics NAV technology and programming, you may want to check out the DIRECTIONS EMEA conference. It is being held Oct 12 to 14.  They are talking about the next best practices and the new features.  See the website. http://www.directionsemea.com/. “Join 1600 attendees who have already registered for THE BIGGEST NAV EVENT!”

Dynamics NAV 2017 is off to a rocking start!

Save up to 55% on exam prep books & eBooks Up To July 31/16

If you are doing any prepping for Microsoft exams, check out the blog that Kim Spilker wrote yesterday https://blogs.msdn.microsoft.com/microsoft_press/2016/06/15/save-up-to-55-on-exam-prep-books-ebooks/.

It is so full of information such as the excerpt that I have listed below.  Thanks, Kim, for all of the suggestions.  Well done!

Whether you’re studying for your first or your next Microsoft certification, save up to 55% on exam prep books and eBooks now through July 31, 2016.

Use code CERTGOALS during checkout to save 35% on any certification book or eBook. Use code BUY3CERT to save 55% when you purchase 3 featured titles from our suggested reading list.

Shop by series: Exam Ref | MOS Study Guide | Training Guide | Training Kit
Suggested Reading: Buy 3, Save 55%
MCSA

Details on Learning Tools for OneNote

image

Figure 1 – Picture from http://blogs.office.com

The Microsoft Office blogs has more information on OneNote Learning Tools.  You can read more at https://blogs.office.com/2016/01/19/learning-tools-for-onenote-improves-learning-for-all/.

Here is what I consider relevant:

Download the Learning Tools for OneNote public preview version today at onenote.com/learningtools.

We designed reading and writing solutions that leverage what works for people with learning differences and for other users based upon research. We are delivering a mainstream tool that benefits all students; it is a great example of inclusive design because it builds on solutions for people with learning differences but it works for everyone and is non-stigmatizing. This matters for students and educators for a few key reasons:

  1. Our ability to read impacts our ability to learn and our lifelong earning potential.
  2. OneNote is growing, and educators are advocating for OneNote because it helps students get organized and gain their independence.
  3. Most importantly, Microsoft can improve learning outcomes through enhanced reading and writing tools.

How To Get The Best Book Deals And Free Books

 

image

Figure 1 is an example of the book deals available.  This figure does not include the free books.

It is the end of the week, and as I look back on it, I realize what an amazing week it has been for me with technology, web information, and software.   I read books, a lot of books.  I love different genres including steampunk, science fiction, business, software, and mysteries.  And, I should not forget, action and adventure.  I was delighted this week when one of my friends sent me a link to BOOKBUB.  What is it?  Here is the information on the BOOKBUB site (www.bookbub.com).

BookBub is a free daily email that notifies you about deep discounts on acclaimed ebooks. You choose the types you’d like to get notified about — with categories ranging from mysteries to cookbooks — and we send great deals in those genres to your inbox.

BookBub doesn’t actually sell books. We simply alert you by email to fantastic limited-time offers that become available on retailers like Amazon’s Kindle store, Barnes & Noble’s Nook store, Apple’s iBooks, and others. Book publishers offer deals at these sites for promotional purposes, and our staff works with them to determine the best ones to feature to our members.

BookBub features ebooks ranging from top-tier publishers to critically acclaimed independent authors. Our team of experts makes sure that we’re only featuring great deals on quality books that you’ll love.

This week, I was able to download twenty books that I want to read.  How cool is that?

Have a great week!