Saturday, December 16, 2017

Microsoft Paint 3D - The new Paint?

One of the most valuable tools to me as a consultant is Microsoft Paint. I will use Photoshop or GIMP (open source: for more complex image creation/editing, but Paint is about 75% of my time.

MS added a new paint program called Paint 3D. Its being highlighted in the new 3D Holiday campaign so I thought I would check it out. There was always a rumor that Paint was going away and would be replaced by something new. Paint is not gone (nor heard rumor of it going away) but it is replaced by the equally capable and enhanced Paint 3D. It was released in Windows 10 Creator Addition sometime in Q2'17.

Paint 3D is a windows store app (.appx) so it'll have that look and feel. Its nice to have that native feel especially when using the pens in the Surface family. But it'll take a bit of time to get used to I think. 

I haven't done much playing around with it yet outside of the below picture but it does appear to support transparent backgrounds and a (somewhat inaccurate) magic wand. There are predefined objects you can turn 3D as well as build in a 3 dimensional area. 

There is a 3D model search capability built in which appears like a clip art-like place for 3D models. That'll be handy I think. And textures you can use in images right out of the gate. 

I'll post more about this as I find more applications to use it for my work. This is part of what I want to learn in 2018. That and focus on VR/AR. How can this help with business processes and ERP consulting? Probably not much outside of sales and button images but who knows now with new applications and envisioning stores, displays, etc. 

Here is what I made tinkering around with it. You can export things out in 3D or 2D. 

Stay tuned.

Saturday, November 4, 2017

Dynamics 365 for Finance and Operations Certification Exams

Microsoft finally has new certification exams out. There are new ones that are usually released without any major announcement or fanfare. You basically have to keep your eyes peeled on their official list to see new ones when they come out.

If you are using Dynamics 365 for Finance and Operations Enterprise Edition, you probably noticed there weren't any certifications for that. Microsoft had plenty for the other D365 exams, but nothing for FOEE. 

Here is the official list. Check it often!

currently, these are the exams out there:
  • MB6-894: Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations [GETTING RELEASED 12/5/2017 apparently]
  • MB6-895 - Financial Management in Microsoft Dynamics 365 for Finance and Operations
  • MB6-896 - Distribution and Trade in Microsoft Dynamics 365 for Finance and Operations
  • MB6-897 - Microsoft Dynamics 365 for Retail

Monday, September 11, 2017

Find product attributes and values for an item in AX 2012 via X++

In the event you need to see what the product attributes are while debugging some stuff, run the below script.

This is for AX 2012 but probably works for D365, I'm not sure. Give it a shot.

It literally takes an item id and gives you the attributes and values in those attributes. Pretty straight forward

static void DAXGetProductAttributes(Args _args)
    EcoResProductAttributeValue ecoResProductAttributeValue;
    EcoResAttribute             ecoResAttribute;
    EcoResValue                 ecoResValue;
    ItemId                      itemId      = 'A10021'; // This is a sample Item Id
    InventTable                 inventTable = InventTable::find(itemId);

    while select RecId from ecoResProductAttributeValue
         where ecoResProductAttributeValue.Product   == inventTable.Product
         join Name from ecoResAttribute
             where ecoResAttribute.RecId                 == ecoResProductAttributeValue.Attribute
             join ecoResValue
               where ecoResValue.RecId                     == ecoResProductAttributeValue.Value
        info(strFmt("%1 - %2 - %3", InventTable.ItemId, ecoResAttribute.Name, ecoResValue.value()));

Saturday, June 3, 2017

MPOS Error: Creating device token failed

A little nugget of information:
In  Microsoft Dynamics AX 2012 R3 MPOS, if you receive an 'Creating device token failed' error when attempting to activate the POS or while doing transactions, you'll be halted from proceeding with what you are doing. The error will also say "- The value of Content-Type on server response is not supported."

A common culprit to this is that there is another terminal being used with that exact same Device profile.

The MPOS application can only be installed and activated on a per user basis, not for all users logging into a machine. So Sally can't log into the PC with her credentials and then the MPOS with her information while Tommy doing the same thing only under his PC AD credentials.

As a best practice, the users should all log into a generic account for that store/terminal where the MPOS is activated and then log into the MPOS under their own IDs.

UPDATE: You can have users log into their own respective accounts and have different MPOS Terminal instances. But they are not the same terminal.

Check the different users and see who is logged into what from a PC (Not POS) perspective as well as anyone in the backoffice or other stores.

Here is a scenario in which this could occur:
Someone may have accidently registered terminal 2 at store 52 as Terminal 2 at store 25, which would cause the store25 terminal 2 to get this error. Also, the person activating the device in the self-service model could've installed/activated the device under THEIR AD account, not the proper stores AD account.

Hopefully this helps!

Friday, May 19, 2017

AX POS Permission Groups and Leading Zeros - Solved!

In my previous blog post, AX Modern POS Retail Channel Reports missing and setup, I discussed an issue I hit where I would go into the Retail Channel Report Configuration form and setup permission groups. These groups would immediately not save the values in the form. The form field is a multi-select field so it won't save invalid values.

The values were invalid as the leading zeros in the POS Permission group were being dropped by the code in Figure 2 below. Changing these names to something other than a value with a leading zero fixed the issue (Figure 1).

Figure 1 - Need to start the POS Permission Group name with NOT a zero

Figure 2 - AX will drop leading zeros

Tuesday, May 9, 2017

AX Modern POS Retail Channel Reports missing and setup

When in the Dynamics AX Modern POS, you have the capabilities to do reporting based on the local store DB. There are 13 canned reports that come out of the box, but a user can add additional as needed or modify the base reports.

Some may notice when entering the POS Reports screen that there may not be any reports in this screen out of the box. Its just blank. Or they get a POS Permissions error. This is because the Retail POS reports are driven off of POS Permissions and may not have any assigned. POS Permission groups need to be added and pushed down to the store for them to be visible (via the 1110 job in Figure 2).

I had an issue where the Retail Channel Reports Configuration would never actually populate the ‘Permission Group’ field after setting it (Figure 1). Setting it would only create a record in the table in the backend with a 0 RecID field value in the POSPermissions field I just tried to set. 

Initially there were no records in the ‘RetailReportPermissionGroup’ field. And the data was never in the POS store tables (hence no reports visible). Only by adding a value to that field would it create a record in this table. And the POS Permission group would overwrite to zero. So it didn't actually work.

My fix to this was going into the AOT and manually set the fields to the POS Permission Groups (Figure 3). If you go back in the ‘Retail Channel Reports Configuration’ form after all the values are set, the POS Permission value in the backend would override the RecID to 0 again.

UPDATE: I solved the issue of the POS Permission groups disappearing in my post here:

I would recommend that you copy an existing report and modify it till you are comfortable with how the reports run before creating one from scratch. 

As a recommendation, only make the report reports action button visible to people who can actually access the reports. Otherwise it looks like a system bug. 

Figure 1 - The retail channel reports with the missing Permission Group

Figure 2 - Run the 1110 job to push the POS retail reports to the stores

Figure 3 - The 'RetailReportPermissionGroup' table

Sunday, April 2, 2017

Modern POS Navigation Hierarchy Setup

The Modern POS is great. I really like it. But there are a lot of new setups in relation to the previous 'Enterprise POS'. One of these features is the POS navigation hierarchy.

There is only one 'Retail Product Hierarchy' in AX but there can be multiple 'Supplemental Navigation Hierarchy' records you can configure. These supplemental hierarchies can be attached to your store POS.

If you wish to do this, you can do it through the 'Channel categories and product attributes' form. The user should select their appropriate channel and change the 'Category hierarchy' field to the hierarchy of their choice.

Some times you will make this change and switch over to the POS and not see the hierarchy immediately. You will need to make sure to run the appropriate distribution job to push the data to the store, then make sure the store refreshes this hierarchy. If its not done refreshing, it may show up blank initially. Waiting will usually resolve this issue. I am not aware of a way to speed this process up at the moment.

Figure 1 - The Modern POS navigation setup

Figure 2 - The setup for the POS hierarchy