Figure 1 & 2 from the site https://logs.msdn.microsoft.com
Check it out! Tons of Free Microsoft eBooks. The list of all books and the download selection is located at the link below.
Note from Eric:
It’s that time of year again, and today I am kicking off my annual FREE MICROSOFT EBOOK GIVEAWAY extravaganza! And this time, I’m posting MORE FREE EBOOKS in this post than I ever have in any of my previous giveaways! Based on this, you will notice something different about this year’s post… In previous years, I included images of the eBook covers next to each item; however, I would also get feedback from people on the amount of time to load all of the images. So, this year I decided to streamline the list to make it easier to get to the eBooks you want. You will now find a simple list, organized by category, with the download links in the Format column so you can choose which format you want to download.
- How many can you download?
- ANSWER: As many as you want! This is a FREE eBook giveaway, so please download as many as interest you.
- Wow, there are a LOT listed here. Is there a way to download all of them at once?
- ANSWER: Yes, please see the note below on how to do this.
- Can I share a link to your post to let others know about this giveaway?
- ANSWER: Yes, please do share the good news with anyone you feel could benefit from this.
- I know you said they are “Free,” but what’s the catch?
- ANSWER: There is no catch. They really are FREE. This consider it a, “Thank you,” for being a reader of my blog and a customer or partner of Microsoft.
- Ok, so if they are free and you’re encouraging us to share this with others, can I post a link to your post here on sites like Reddit, FatWallet, and other deal share sites to let them know, or is that asking too much?
- ANSWER: Please do. In fact, I would encourage you to share a link to this post on any deal site you feel their users could benefit from the FREE eBooks and resources included below. Again, I WANT to give away MILLIONS of FREE eBooks!
- Are these “time-bombed” versions of the eBooks that stop working after a certain amount of time or reads?
- ANSWER: No, these are the full resources for you to use.
Posted in Azure, BI, Dynamics 365, DYNAMICS CRM, Dynamics GP, Excel, Microsoft, Office 365, OneNote, Outlook, Power BI, Reporting, SQL 2014, SQL 2016, SQL Server, Warehouse, Windows
- Tagged Free Books
Microsoft has announced the system requirements for Microsoft Dynamics GP 2018 which is to be released on December 1 2017.
The details are here: https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/system-requirements/MDGP2018_System_Requirements.
The requirements listing is very thorough, and, needs to be read carefully.
Figure 1 – Explanation of Power BI from https://powerbi.microsoft.com
On June 12, Amanda Cofsky, Program Manager for Power BI, provided an overview of the new reporting features available as of June. The link to download Power BI is…. http://powerbi.microsoft.com/desktop?WT.mc_id=Blog_Desktop_Update.
Here’s the complete list of June updates from Cofsky’s blog posting.
- Data bars for new table & matrix (preview)
- Markers on line, area, & combo charts
- Accessible reports
- Consume Power BI reports with keyboard navigation and screen reader support
- Create accessible reports
- Visuals font family setting
- Horizontal Image Slicer
- Combo chart formatting updates
- Force zeros to align between the two axes
- Shade area of the line
- Bing maps improvements
- Map themes
- Improved geo hierarchy experience
- High density line sampling
- Custom Data Connectors support
- Power BI service Live Connect to On Premises and Push streaming datasets
- Impala connector is now generally available
- Amazon Redshift connector is now generally available
- SAP BW connector – DirectQuery support (beta)
- IBM Netezza connector (beta)
- “Add Column from Examples” enhancements
You can watch a video of the new features by clicking on https://youtu.be/YlNVE5dgcSI (Power BI Desktop Update – June 2017). Remember that YouTube links can change from time to time so this link may change over time.
Posted in Cloud, Dynamics 365, Dynamics AX, Dynamics GP, Dynamics NAV, Microsoft, Power BI, Reporting, What's New, Working
- Tagged Features, Power BI, Reporting, What's New
Jet Reports Canada sent out a notice this morning announcing that Jet Reports has released a new build. All the details are below.
Recently, I have had to import lots of different data for clients. They give me Excel worksheets that are full of names, numbers and telephone numbers. If you are working with Dynamics NAV or GP, you know that some of the fields can be very fussy in the import. Dynamics AX is more forgiving. I clean up the data, and get it ready.
Most clients ask me how I clean up columns, especially phone numbers. If you use Excel a lot, you will know these formulas or tricks. This post is for those who do not have to do this very often, and need some help.
1. Using Excel to change Words from All CAP to All lowercase, or to PROPER
- you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case.
- First, insert a temporary column next to the column that contains the text you want to convert
- In the temporary column, for example, cell B2, type =PROPER(A2)
- The other choices are =UPPER(A2) or =LOWER(A2)
Now, all of the names, countries, states, provinces, etc. can have standardized type.
2. Removing spaces and symbols in a phone number
- Often we get a list of telephone numbers that look like this
- To get rid of the (, ), –, Ext. 0000, use the find and replace function
- To get rid of the space, use the find and replace, using the space bar
- Press Ctrl + Space to select all cells in a column.
- Press Ctrl + H to open the “Find & Replace” dialog box.
- Press Space bar in the Find What field and make sure the “Replace with” field is empty.
3. Filling in the extension on a phone number
- Now you want to add trailing zeroes to make all the numbers with a fixed length, such as 14 digits for a telephone number in Canada and the US
- Create a blank column right of the existing phone number
- Use the EXCEL function =A2&REPT(“0”,14-LEN(A2)) where “A” represents the column with the telephone number in it
- The results are
Posted in Dynamics AX, Dynamics GP, Dynamics NAV, Excel, How To, Microsoft, Working
- Tagged Dynamics AX, Dynamics GP, Dynamics NAV, Excel, How To, Tips and Tricks
Tampa Summit 2016 was held from October 11 to 14. And, the organization allowed free access to many of the sessions via the Dynamics Community USTREAM channel. The sessions are here:
There are some wonderful presentations included in the eighty some presentations. Note that access to videos changes from time to time so I do not know how long this link will be valid.
I loved this session by Mark Polino and I thought that he did a fantastic presentation on the tools and add-ons available for Dynamics GP users. Since there is 50 of them, I thought I would list out some of the tools that I think will benefit users and partners. You can check out the rest of the tools on his session’s video.
I have put in some of the references for downloading or for contacting. Some you will need to look up.
- Spell Check for GP – from Willoware, a Microsoft ISV
- Color Settings for Different Companies – from Willoware
- Consulting Toolkit Free Tools – from Willoware
- Smart Sort – filtering – from Ethotech
- Macro Command Reference – Kevin Gross (download)
- Ole Note Migration Utility – from Microsoft (for Dynamics 2013 and 2015 for moving notes to Doc Attach in 2016
- GP Build Numbers and Versions – from Victoria Yudin (download from her website)
- SQL Server Performance Dashboard – from Microsoft
- Dynamics Performance Analyzer – from Microsoft (https://dynamicsperf.codeplex.com)
- Password Expiration Notification – from Michael Johnson (see his blog MBSGURU on BlogSpot)
- GP Security Matrix – from FastPath – an Excel form for redoing security
- Super User- to replace Power User – from Mark Polino (mpolino.com)
- Default GP Roles –what permissions are in each role – Jivtesh Singh (https://app.box.com/v/Gproles)
- Paste from EXCEL with Intercompany – from James Lyn (https://jamesdlyn.wordpress.com)
- Multicurrency Setup – from Leslie Vale (http://dynamicsconfessions.blogspot.com)
- Exchange Rate Feed – from Dynamics Innovations (http://di.jo)
- RM Auto Apply – from Microsoft – need to get via your Microsoft Partner
- Average Days to Pay (Customers) – – from Microsoft – need to get via your Microsoft Partner
- SOP Sort Line Items (for moving SOP to POP) – from Microsoft – need to get via your Microsoft Partner
- Copy to New SOP Batch – from Mariano Gomez (http://dynamicsblogster.blogspot.com)
- Vendor/Customer Portal – cloud based – from Viewpost (http://www.viewpost.com/IBG)
- Auto number Customer/Vendor/Items – from Dynamics Innovations (http://mohdaoud.blogspot.com)
- Changer Scripts for Project Accounting – – from Microsoft – need to get via your Microsoft Partner
- Jet Express for Excel – from Jet Express (http://jetreports.com)
- Power BI – from Microsoft (https://powerbi.microsoft.com)
- Excel Based Table Reference – from Mark Polino – (http://mpolino.com)
- SmartList Quick Reference Guide – from Mark Polino – (http://mpolino.com)
Thanks Mark, for creating some cool tools and for putting together the listing of tools and add-ons.
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:
- After the December 1 R2 release, Microsoft Dynamics GP will be updated annually in the late fall time frame.
- If you have new features that you want to see in a future release, enter them at Connect.Microsoft.com
- 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
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.
If you are a customer or partner of Microsoft, you may be finding it difficult to download files for Dynamics GP 2016 and GP 2015 because the File Transfer Manger WILL NOT OPEN.
I tried to download some files today, and was getting nowhere when I suddenly remembered that WALDO’s BLOG http://www.waldo.be/2016/10/27/microsoft-dynamics-nav-2017-ready-for-download-and-how-to-do-it/ had instructions for downloading the Dynamics NAV 2017 files.
I went back to his instructions, followed the steps, and, after closing and reopening Internet Explorer 3 times, and putting the Microsoft sites into compatibility mode, the File Transfer Manager worked.
Thank you, Waldo, and keep writing those great blogs!
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:
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 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
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:
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.