Archive

Monthly Archives: October 2015

Role Centers are cool, but you don’t have to just personalize them with Dynamics AX information – you have a whole slew of standard SharePoint web parts that you can use to spice up the pages.

An example of something that you may want to do is add a banner image to the role center to display corporate banners or branding information. This is easy to do – all you need to do is create the banner image and then add it to your role center through the personalization.

If this sounds interesting to you all then just read on and learn how you.
Read More

I was tinkering with an idea and thought that I would pass this on to you all just in case you could use it.

I create all of my walkthroughs and scripts in PPT (just in case I want to use them in presentations, and also they look tidy).

But if I want to use them as a blog post or create a white paper on them then I have to transfer all of the images and text by hand – the export as handouts does not export out the images and text in a way that they can be reformatted in Word.

So I looked around and found one PPT Macro that would walk through the PPT and convert it into a Word document element by element.  I tinkered with it and created the following Macro:

 

Sub WriteToWord()

Dim aSlide As Slide

Dim aTable As Table

Dim aShape As Shape

Dim TablesCount As Integer

Dim ShapesCount As Integer

Dim MyDoc As New Word.Document

Dim MyRange As Word.Range

Dim i As Word.Paragraph

On Error Resume Next

With MyDoc

.Application.Visible = False

.Application.ScreenUpdating = False

For Each aSlide In ActivePresentation.Slides

For Each aShape In aSlide.Shapes

Set MyRange = .Range(.Content.End – 1, .Content.End – 1)

Select Case aShape.Type

Case msoTextBox

aShape.TextFrame.TextRange.Copy

MyRange.Paste

With MyRange

.ParagraphFormat.Alignment = wdAlignParagraphLeft

.ParagraphStyle = “Normal”

.Font.ColorIndex = wdBlack

End With

Case msoAutoShape

If aShape.TextFrame.HasText Then

aShape.TextFrame.TextRange.Copy

MyRange.Paste

With MyRange

.ParagraphFormat.Alignment = wdAlignParagraphLeft

.ParagraphStyle = “Normal”

.Font.ColorIndex = wdBlack

End With

Else

aShape.Copy

MyRange.PasteSpecial DataType:=wdPasteMetafilePicture

ShapesCount = .Shapes.Count

With .Shapes(ShapesCount)

.LockAspectRatio = msoTrue

.ConvertToInlineShape

End With

End If

Case msoPlaceholder

Select Case aShape.PlaceholderFormat.ContainedType

Case msoAutoShape

If aShape.TextFrame.HasText Then

aShape.TextFrame.TextRange.Copy

MyRange.Paste

With MyRange

.ParagraphFormat.Alignment = wdAlignParagraphLeft

.ParagraphStyle = “Normal”

.Font.ColorIndex = wdBlack

End With

Else

aShape.Copy

MyRange.PasteSpecial DataType:=wdPasteMetafilePicture

ShapesCount = .Shapes.Count

With .Shapes(ShapesCount)

.LockAspectRatio = msoTrue

.ConvertToInlineShape

End With

End If

Case msoPicture

aShape.Copy

MyRange.PasteSpecial DataType:=wdPasteMetafilePicture

ShapesCount = .Shapes.Count

With .Shapes(ShapesCount)

.LockAspectRatio = msoTrue

.ConvertToInlineShape

End With

Case msoTextBox

aShape.TextFrame.TextRange.Copy

MyRange.Paste

With MyRange

.ParagraphFormat.Alignment = wdAlignParagraphLeft

.ParagraphStyle = “Normal”

.Font.ColorIndex = wdBlack

End With

End Select

.Content.InsertAfter Chr(13)

Case msoPicture

aShape.Copy

MyRange.PasteSpecial DataType:=wdPasteMetafilePicture

ShapesCount = .Shapes.Count

With .Shapes(ShapesCount)

.LockAspectRatio = msoFalse

.Width = Word.CentimetersToPoints(14)

.Height = Word.CentimetersToPoints(6)

.Left = wdShapeCenter

.ConvertToInlineShape

End With

.Content.InsertAfter Chr(13)

Case msoEmbeddedOLEObject, msoLinkedOLEObject, msoLinkedPicture, msoOLEControlObject

aShape.Copy

MyRange.PasteSpecial DataType:=wdPasteOLEObject

ShapesCount = .Shapes.Count

With .Shapes(ShapesCount)

.LockAspectRatio = msoFalse

.Width = Word.CentimetersToPoints(14)

.Height = Word.CentimetersToPoints(6)

.Left = wdShapeCenter

.ConvertToInlineShape

End With

.Content.InsertAfter Chr(13)

Case msoTable

aShape.Copy

MyRange.Paste

TablesCount = .Tables.Count

.Content.InsertAfter Chr(13)

End Select

Next

If aSlide.SlideIndex < ActivePresentation.Slides.Count Then

.Content.InsertAfter Chr(13)

End If

.UndoClear ‘ Clear used memory

Next

With .Content.Find

.ClearFormatting

.Format = True

.Font.Color = wdColorWhite

.Replacement.Font.Color = wdColorAutomatic

.Execute Replace:=wdReplaceAll

End With

MsgBox “PPT Converted to WORD completed”, vbInformation + vbOKOnly, “ExcelHome/ShouRou”

.Application.Visible = True

.Application.ScreenUpdating = True

End With

End Sub

It’s not perfect, but it does scrape the PPT and create a Word document:

All that is left to do is format it which is the easy part.

If anyone knows how to create Add-Ins for PPT and code this in Visual Studio then I will hand over full rights to this idea as long as I can use it 😉

It’s happened to the best of people – Copernicus, Magellan, Scully & Mulder and now me. “What’s that?” I hear you ask. Well let me tell you the story…

Week before last I was at the AXUG (Dynamics AX User Group) Summit and to earn my keep I had 8 presentations and also a four hour training session that I gave titled “How To Implement Dynamics AX In An Afternoon” (which was actually scheduled for the morning slot but that is not what this story is about) where I planned to show how to start with a blank Dynamics AX partition and then load and configure all of the core financial modules (GL, Cash, Payables & Receivables) and then the operations modules (Products, Inventory, Sales & Purchasing).

This was a pretty ambitious undertaking which I thought that I could do, I didn’t have enough time to do a run test run. I have to admit, I was a little worried that I had bit off more than I could chew to compress a 24 hour training class that I had done in the past into 4 hours.

Let’s face it when you boil down Dynamics AX, all you really need to configure is the Ledger, Products, Customers and Vendors and you should be up and running. Everything else is just windows dressing and polishing up of the processes. I had proven that with the Bare Bones Configuration Guide series that I had spent the last two years compiling.

And I wanted to prove a point that Dynamics AX is not a complicated product to set up and it shouldn’t take you weeks (or even months) to configure a base company within Dynamics AX and also show how the students could do this themselves and also learn a lot more about the inner workings of Dynamics AX through the process.

In addition, I wanted to prove that the people who say that Dynamics AX is a complicated product and that it will take an exorbitant amount of time and money to get even this base system up and running are misguided (this is a polite version of the word) and there needs to be a change in attitude.

So I distilled all of my guides into an expert edition that covered 11 of the core guides and with that in hand I dove in head first into the training session.

Now back to the point of the story – which is the unwarranted persecution of people that were trying to fix the misconceptions of the world and make everyone’s life just a little better…

Later on that week I was coming down in the elevator on the way to the conference and a gentleman got on as well. I thought that I would chat to him for the 30 seconds that we were on the elevator to pass the time.

He asked if I was attending the conference, I said yes.

I asked if he was enjoying the sessions and presentations, he was.

He asked me what I was doing there and I mentioned that I was speaking and also had given a training course.

He then asked what the training course was on and I said that it was “How To Implement Dynamics AX in an Afternoon”.

All he could say to that was – “You are a liar!”

OMG – as he stepped out of the elevator I was shocked at the venomous allegation that one small comment provoked. I’m guessing that he made a living from implementing Dynamics AX and I had rattled the foundation of his belief system.

Because the training that I gave worked and I was able to set up all of AX, load in and configure the ledger, set up cash management, load in customers, vendors and products and then configure the inventory, sales and procurement, all within the 4 hour time slot. And all of the students went home with a door prize of a starter kit to do it themselves and also all of the data that I had used for the training so that they could do the same thing themselves.

On the bright side he did prove a point that my mission to convert all of the misguided heathen out there was not done.

PS. For those of you that have been converted and have completed the entire Bare Bones Configuration Series, then you deserve an award. if you can send me proof that you have set up a blank company then I will send you a care package that includes a Bare Bones Configuration Privateer merit badge and also a couple of other goodies.

The AXUG Summit starts in just a couple of days and here are the sessions that I will either be hosting, or sitting in on as a panelist. If you are attending then make sure you mark them down on your dance card and drop on by so that I’m not lonely.

Creating Your Own Product Information Management Processes With Cases and Project Management

Wednesday, October 14 • 11:00am – 12:00pm

Although Dynamics AX is not a complete New Product Development (NPD) and formulation system, as it does not calculate nutritional details or perform least cost formulation, it does allow you to manage all of your product, costs, formulations, nutritional details, and more. Additionally, it has a lot of capabilities to help you streamline management of the NPD/New Product Introduction (NPI) process. In this presentation, we will show an example of how you can use Cases, Workflow, and Projects within Dynamics AX to manage the entire NPD/NPI process.

Using Cases To Do Almost Anything Your Dynamics AX Doesn’t Do

Wednesday, October 14 • 1:00pm – 2:00pm

Step right up and dare to experience for yourself the one, the only, the world’s largest, strongest tool ever! It walks, it talks, it crawls on its belly!!! — We’re talking about Cases within Dynamics AX, of course. They are the ‘Swiss Army knife’ of Dynamics AX functionality, and if there is something you want to track that isn’t tracked already, you can probably do it through Cases. With Cases you can track incidents, record quality results, track projects, and even create custom workflows to track whether Cases are followed up upon in a timely manner. Cases are accessible virtually everywhere within Dynamics AX; you practically can’t open up a screen without seeing them. In this presentation, we will show you how to configure Cases and will walk through a few examples of how you can use them right now within your implementation of Dynamics AX.

Getting The Most Out Of Dynamics AX Data With PowerBI

Thursday, October 15 • 8:00am – 9:00am

Do you think the only thing better than PowerBI within Excel is PowerBI running within Office 365? Come to this session and we’ll show you why everyone needs to use the much simpler PowerBI Designer available within the Office 365-hosted PowerBI portal! PowerBI is a standalone dashboard designing tool that takes all of the great features within Excel like Power Query, Power View, and Power Pivot and puts them in one single place to make all of your reporting a synch. After you have finished building your dashboards, you can publish them to the new hosted Power BI portal, create your own custom dashboards, and even perform Q&A on the data just by typing in the questions you want answered. In this overview, we will look at this new tool and how you can use it to quickly analyze all your Dynamics AX data and blend multiple data feeds into one dashboard to view all the data you need in one place!

Challenge the AX Experts

Thursday, October 15 • 3:15pm – 4:15pm & Friday, October 16 • 1:00pm – 2:00pm

This is the session to get your answers! Join in on the fun in this fast-moving roundtable where the Microsoft Dynamics AX Experts will field all questions from the audience. There has to be at least one question you wanted answered while at Summit – and this the session to do it. No question is out of bounds, regardless of version, function, or technology!

Self Service Reporting Within Dynamics AX

Thursday, October 15 • 4:45pm – 6:00pm

Having Users perform their own reporting has been a dream on both sides of the organization. IT staff do not particularly like creating reports for Users when they could be spending time on cooler projects, and Users don’t particularly like waiting for IT to create reports because it’s not timely or exactly what they wanted.  The solution is found in the many tools built into Dynamics AX and productivity tools such as Excel and Word. In this session, learn how Users can easily create their own reports without having to get the IT group involved; it’s so easy they may not realize they are creating reports. Join this session and learn how everybody can win!

WOW – The 50 Best Tips and Tricks for Dynamics AX 2012

Friday, October 16 • 2:15pm – 3:15pm

Dynamics AX is full of features you can implement at the module level, but the true power of the product comes from the plethora of smaller features built into the User interface.  You can make Dynamics AX even more powerful by taking advantage of the other foundation products such as SharePoint and Office.  The real trick is to know what the capabilities are. Join us for this session. Even the most seasoned Dynamics AX User or Administrator should find a new tip or trick to make them look like a rock star!

Getting Things Done with Office 365

Friday, October 16 • 3:30pm – 4:30pm

In this session we will show you how you can use Microsoft Office tools like Outlook, OneDrive and OneNote to get organized, get things done, and even get your life back. We will show you how to free yourself from your desk because everything you need is also available on your tablet and phone!

Also, I am still on a one-man mission to help all of you learn Dynamics AX by doing. For those of you that don’t think that you can configure Dynamics AX yourself, here is a starter kit for you to get your feet wet, and realize that you can. It will step you through the first 2.25 guides in the Bare Bones Configuration Guides and you will learn how to create your own Dynamics AX learning environment, configure a new organization, and then set up the General Ledger controls. If you like what you see, then you may want to keep on going.

As an extra incentive, anyone who does complete the entire Bare Bones Configuration Series, then you will become a Bare Bones Configuration Privateer, and I am having merit badges created for you all. If that doesn’t make you just rush out and configure Dynamics AX for yourself then I don’t know what will – everyone wants merit badges 😉

If any of you catch me at the AXUG and promise to take up the challenge, then I will have some USB Wafer drives with the guide and also all of the resources that you need to start.

For those of you that are not able to make it to the Summit, for this week only, use this discount code – AXUGSUMMIT15 – and download the digital version for free.

I’m looking forward the Summit, and seeing some of you this week in Reno, NV.

Having users perform their own reporting has been a dream on both sides of the organization. The IT group don’t particularly like creating reports for the users when they could be spending their time on cooler projects, and users don’t particularly like waiting for IT to create the reports that they need to track the data because it’s never quite what they wanted, and also takes so long to get (because of the first reason) that it’s usually out-of-date. If only there was a solution…

Well there is, because there are so many tools built into Dynamics AX and also the productivity tools like Excel and Word that the users can easily create their own reports themselves without having to get the IT group involved. Everybody wins!

In this presentation we will show you how the users can do just that, it’s so easy that they may not even realize that they are creating reports.

Adding Additional Fields to List Page Views

One of the benefits of the list pages within Dynamics AX is that you can add additional fields to the views, so if there is something that you need for reporting and analysis that isn’t currently on the form then all you need to do is add it.

How To Do It…

To do this, just right-mouse-click on the data within the list page, or the heading in the list page and then click on the Personalize option.

This will open up the Personalization form and you will be able to see all of the fields that are currently displayed within the list page. To add a new field all you need to do is click on the Add Fields button.

This will open up the Field Explorer and you will be able to see all of the fields that are associated with the form and also any related tables as well.

If you expand out the Addresses field group then you will see all of the address fields that are related to the Sales Orders.

If you want to report off geographic information then you can click City, State, ZIP/Postal Code and Country/Region fields and then click on the Add button to add them to the form. When you have done selecting your additional fields then just close down the Field Explorer.

When you return to the Personalization form you see that the fields have been added with little green + signs beside them which mean that these are custom fields that have been added to the view. When you are done here you can close down the form by clicking on the Close icon in the top right hand corner of the window.

When you return back to the form you will notice that some of the fields have not been populated yet. Don’t worry. All you need to do here is press F5 to refresh the view.

Now all of the new data will be displayed on the form for you and all of the new fields are displayed on the list page as columns that you can use for your own reporting.

Summary

Not everyone wants the same fields to show up on their forms, and no-one wants the fields that everyone else wants cluttering up their list pages that they use every dat. This is a great way to get information that you need onto your forms without having to do any development and also a very fast way to add additional information that you may only need for a little while and then remove them later on.

Original

To view the original article, click here: http://bit.ly/1hqEFfE

About The Author

Murray Fife is a Technical Solution Professional at Microsoft and Author of over 25 books on Microsoft Dynamics AX including the Bare Bones Configuration Guide Series which contains over 15 books that show novice users host to set up Dynamics AX using visual walkthroughs.  These guides start off with the Financial modules of Dynamics AX and then progress through the Operational, Distribution, and then the more specialized modules like production, service management, and project accounting.  You can find all of his books on Amazon (www.amazon.com/author/murrayfife) and also even more on the independent BSP (www.blindsquirrelpublishing.com) site.

Murray is also the curator of the Dynamics AX Companions (www.dynamicsaxcompanions.com) site which he built from the ground up as a resource for all of the Dynamics AX community where you can find walkthroughs and blueprints that he created since first being introduced to the Dynamics AX product.

Throughout his 25+ years of experience in the software industry he has worked in many different roles during his career, including as a developer, an implementation consultant, a trainer and a demo guy within the partner channel which gives him a great understanding of the requirements for both customers and partners perspective.

He is also a great supporter of the Dynamics AX community and has hosted scores webinars for the AX User Group (www.axug.com) and MS Dynamics World (www.msdynamicsworld.com), and has speaks at Microsoft Convergence and AXUG Summit conferences regularly.

Having users perform their own reporting has been a dream on both sides of the organization. The IT group don’t particularly like creating reports for the users when they could be spending their time on cooler projects, and users don’t particularly like waiting for IT to create the reports that they need to track the data because it’s never quite what they wanted, and also takes so long to get (because of the first reason) that it’s usually out-of-date. If only there was a solution…

Well there is, because there are so many tools built into Dynamics AX and also the productivity tools like Excel and Word that the users can easily create their own reports themselves without having to get the IT group involved. Everybody wins!

In this series we will show you how the users can do just that, it’s so easy that they may not even realize that they are creating reports.

Use Edit in Grid as your Reporting Worksheet

Most of the list pages within Dynamics AX have a second version which is called the Edit in Grid view. This is a great way to have a master reporting form for the users and not clutter up the main list page with the extra fields that they may need to report off.
Read More

Having users perform their own reporting has been a dream on both sides of the organization. The IT group don’t particularly like creating reports for the users when they could be spending their time on cooler projects, and users don’t particularly like waiting for IT to create the reports that they need to track the data because it’s never quite what they wanted, and also takes so long to get (because of the first reason) that it’s usually out-of-date. If only there was a solution…

Well there is, because there are so many tools built into Dynamics AX and also the productivity tools like Excel and Word that the users can easily create their own reports themselves without having to get the IT group involved. Everybody wins!

In this series we will show you how the users can do just that, it’s so easy that they may not even realize that they are creating reports.

Using List Pages as User Reports

The first thing that we will highlight is that the Dynamics AX list pages are the best reporting options that is there for the user. The list pages can be rearranged, filtered, have fields added to them, sorted and a whole slew of other personalization options making it the perfect way to review data.
Read More