Uncategorized
Publish-AXReport : The user or group name is not recognized. Dynamics ax 2012
Today I faced this issue, after restoring database of other server, on report deployment on new ssrs I found this error and deployment aborted
Solution is to delete all rows form SysServerSessions.
How to add company legal entity report logo in SSRS Report Dynamics 365 for finance and operations
Old tip, but felt to post for future reference. Follow these steps
-
Add field in Table / table extension with Type Container and update EDIT as Bitmap.
-
In Data provider class, Map following statement FormLetter::CompanyLogo() to table field.
-
Update Report dataset and verify that required added field in table / table extension appeared in dataset.
-
Add image on SSRS designer and from Property window, Update MimeType to image/bitmap, set use this field to Expression to dataset field.from image properties update to Dataset. Select the image source to database.
I am no more MVP, but every ending is a new beginning. Let embrace it.
Common saying that, Maintain anything is more difficult to achieve it. I maintained my MVP status for 5 years. I got my first MVP award back in 2014. I was not awarded this year, thanks God, now life is little more easier for me. I have to spent time to wrote blog post. Most of the time when I had nothing to share, then I have to do R&D. And did not engaged any activity that creates more responsibility, because I need time to wrote blog post.
It’s certainly creates lot of learning opportunity, but consumes lot of time.
Now I feel light weight and able to focus on those things which are more important than MVP.
Anyhow, I habitual to write posts, This blog will continue. But now things are more open like
CRM, SQL Server, C#. And Happy DAXing.
I still have more than 12 years coding experience. Many tough projects delivered. Projects kick off, develop, delivered and closed off. I worked for client side, Partner side and as independent consultant. And more importantly I am self-taught programmer. I learned by self VB 6, VB.net, C#, oracle reporting 6i, oracle reporting 10 G, Biztalk 2008 R2, Biztalk 2010, BizTalk 2013, Ax 2012, AX 2012 R3 and now Dynamics 365 for finance and operations. My experience is customization, integrations, Report development and I have good knowledge of ERP processes. Now I have to play on my experience and deliverable.
The batch task you entered is not valid. Enter a different batch task. Dynamics 365 for finance and operations
During development, I got this error, when try to type newly created class that need to be run in batch processing.
That class I manually type because it was not appear in a list new task form inside batch job.
Later I found that I did not implement the canGoBatchJournal() method of RunBaseBatch
After adding following code snippet in my class, it will start to show in batch job task list.
Set collections in X++ Dynamics 365 for finance and operations
How to add custom privileges to out the box Role in dynamics 365 for finance and operations.
While adding Privileges to certain role, I made this walk through.
After compiling code and no error in privilege in model. Copied the Label. From GUI, We can search privileges with labels text.
Go systems Administration
Security form, For current example I add my custom privilege into “Employee” Role That is out of the box.
Now click on Privilege. And all privileges will start showing.
Now form top menu, you found another link or menu item, Add reference
Form next window, filter with privilege label name.
When select the required privilege, check mark on grid. And then click
After adding selected privilege, you find underline unpublished objects 1. Now click on “Publish all”.
Now your role is active with new changes.
View Details User Tip MSDyn365FO Dynamics 365 for finance and operations
Hi everyone this is user level tip for Dynamics 365 for finance and operations. We can add and remove Values in any drop down or lookup field by right click and from view details on menu. It is very beginner level tip.
MCT (Certified Trainer) Dynamics 365 for Finance and operations Update
Hi all, from Last 4 years I am maintaining Microsoft Certified trainer status. I got renewal couple of days ago. Today I got mail from MCT Certified Program that requirements are updated and I have to new certification if I need to renew In next Period.
Updated certification list is available here for Dynamics certification.
Its little tougher for Maintain MCT now. For technical track, we need three certifications, but for Functional side needs 6 certification including functional area from CRM.
As per my experience, MVP is not in our hand but MCT still in our hand.
Technical side
| MCT Eligibility – MCSA: Microsoft Dynamics 365 for Operations | 70-764 | Administering a Microsoft SQL Database Infrastructure | |||
| 70-765 | Provisioning SQL Databases | ||||
| MB6-894 | Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations |
And Functional Side it requires 6 Certification
| MCT Eligibility – MCSE: Business Applications | MB2-717 | Microsoft Dynamics 365 for Sales | |||
| MB2-718 | Microsoft Dynamics 365 for Customer Service | ||||
| 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 | ||||
| MB2-877 | Microsoft Dynamics 365 for Field Service |
Microsoft Connect portal retired, you have to follow other link
Hi all, I was trying to download latest Dynamics 365 for finance Dev box vm, but found that Microsoft Connect portal is retired. you can found all information here.
https://docs.microsoft.com/en-us/collaborate/connect-redirect
I expect that lastest VM link will available here, As I found latest 7.3 update 12 link here
https://aka.ms/finandops73pu12
And it leads us to some share point link, Download is good as compare to old connect link.
Procurement and sourcing
81128AE: Procure to Pay with Inbound Transportation in Microsoft Dynamics 365 for Operations
Microsoft release a new course for Dynamics 365 for operations.
This course contains the procurement process from start to finish with the transportation Management.
You can find this course at following link
For https://mbspartner.microsoft.com/D365E/CourseOverview/1565`
Entity Store and error Microsoft.Dynamics.AX.Framework.Tools.DMF.DriverHelper.DMFOdbcDriver Dynamics Ax 2012 R3
After Installation and configuration, When I connect the Entity store and establish DNS error, I got following error.
I found that Data Import and export framework did not installed on machine.
I log this error for my future reference I got its solution from Deepak Agrwal Sahib, He blog this issue on following link
Entity store for Dynamics Ax 2012 R3 step by Step installation and configuration.
I observed that Many developers are using Power BI with Dynamics Ax 2012 R3 by using Direct SQL server connection on Dynamics Ax database. Which is not good approach? This will expose Dynamics Ax 2012 database outside Dynamics Ax 2012 security. Especially when you expose or deploy Power BI on public URL.
With entity Store, Microsoft provide near to real time database access to Power BI.
In this approach, you can extract data to external database by Designing entities and data extraction from Dynamics ax tables and populate that staging entities and then to database. And this process can schedule into Dynamics Ax.
This approach is faster and more secure in the sense
- Only required data available for Query, Unnecessary fields and table already removed.
- No extra overhead on OLTP Dynamics Ax 2012 Database.
- You can create more indexes on target database to faster fetch. As compare to indexes on Ax tables which creates performance overhead on Dynamics Ax.
- Instead of Creating complex data mart, cubes and complex queries. We can create simple table structure and build dashboard on them.
- Certainly external database can share and access on Internet or reporting is much more secure instead expose Dynamics Ax 2012 database for reporting.
For reference you can explore following links.
https://blogs.msdn.microsoft.com/intel/archives/185
Microsoft release the Entity Store for Dynamics Ax 2012 R3 back in May 2016.
But somehow I decide to explore it. So today I decide to Install Entity store on my local VM. And My local vm had Dynamics Ax 2012 R3 RTM. No other Dynamics Ax 2012 Update Installed on machine. Entity stored is already part of Cu 11 for Dynamics Ax 2012 R3.
So First step is download and install KB. You can find It from following link
https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;3147499
I have to enter my email address and Microsoft send download link for patch.
I recommend to explore the following link for Installation of any update for Dynamics.
https://technet.microsoft.com/en-us/library/hh335183.aspx
For this article I just extract the self-extract file.
Extraction result in folder something like
This file is again extracted exe. On its extraction it creates two folders
And again these two folder contains two self-extracted exe files..
On extracting these exes, one update for Model store and second for Kernel update.
Model Store Update:
So First I decide to install update for Model store.
Before that I stopped the AOS service. Otherwise update process takes unnecessary time.
So I Click on update Ax exe in Application folder.
Click on Next
Accept and Continue
Select you model store and Click on next.
On this steps you find conflict then first resolve them. In my clean installation there will be no conflict. Press next.
Next
Click on Install.
And finally Update is successful.
Kernel Update.
Now I decide to install what ever exe at Kernel folder.
So I go the extracted folder and run the update ax exe there
Next
Accept and Continue
Next
Click on Install
Finally it also installed successfully.
Post Installation update challenges:
After installation when I start AOS service and open Ax Client. I found check list, with different options for example database synchronization, compilation and full cil Generation.
In my case, this check list did not perform anything.
So closed the Ax client and in Windows command prompt, I run following command. Remember, run Windows command prompt as run as administrator.
AXUTIL set /noinstallmode
Now open Dynamics Ax client and perform following steps.
- Synchronize the database.
- Full compile and resolve any error.
- Generate Full CIL.
Interestingly I got errors. And errors are related to Payroll some symmentic dll. Each line shows error 99999.
I used very strange trick. Just add new empty line and add empty comment //. Save it and compile and as result error resolved. I resolved all these error 99999 by same way.
More details I follow my own link.
http://tech.alirazazaidi.com/errors-in-payroll-classes-symmetry-dynamics-ax-2012-r3/
After that, I found Entity store menus in Import export framework.
DNS and Entity store connection.
Now open Windows control panel, Administrator tools.
Select ODBC Driver 11 or it depends on installation.
Enter Name of User dsn.
Set default database.
Now test the connection.
Now go back to Dynamics Ax client and click on entity store. Select on User DNS. And set User DSN in last step. And click on test.
.
Dynamics Ax 2012 R3 Check list dialog did not Post Installation or Upgrade
After upgrade process, Dynamics Ax checklist dialog did not let me do anything. 
So closed the Ax client and in Windows command prompt, I run following command. Remember, run Windows command prompt as run as administrator.
AXUTIL set /noinstallmode
Now open Dynamics Ax client and perform following steps.
- Synchronize the database.
- Full compile and resolve any error.
- Generate Full CIL.
Dynamics ax a Walk through – Pakistani MVP meetup.
We conduct an information sharing session on New Dynamics Ax 7 at Microsoft Innovation Center Lahore on 7 October 2016.
In this session, two speakers invited by Meetup group. Hasan Bukhari from Maison Consultancy (It is leading Microsoft Dynamics AX Implementer in Pakistan and Middle east). Second speaker was Me.
As professionally I am technical consultant (Currently working as freelancer). I cover the technical side of Dynamics Ax. While Mr. Hasan Bukhari covered the Functional expects of The Product. Usman Ur Rehman Ahmed helped us to organize this meetup. Here are some picture taken during the session.
Employee hiring process (recruitment process) in new Dynamics Ax (Aka AX 7).
Suppose we have to hire a Ax Dynamics Ax Technical consultant in new Dynamics AX (AKA).
There are multiple ways to do that, but we follow these steps.
For this we have follow following steps. We explore, Job creations, we create skills, education and certification required for this job, later we create position and attach it to job. Than create a recruitment project where we mentioned who is HR Manager, who is recruiter and create a new application and hire the required person.
We can divide the whole process into following parts
- Create a new job
- Create a position and associate with job
- Create a new recruitment project for job.
- Hire a new worker against Recruitment Project.
Create a new Job.
After successful login
and from menu open the HR module
and expand it and click on Jobs.
On click a new web page opens, that shows the list of jobs present in Dynamics Ax. Now Click on new button.
In a new Job detail page, enter, Dynamics Ax consultant in job , In description, mentioned “Dynamics AX techno Functional Consultant” And Title select Consultant. You can also set
You can also Expand Skills fast tab and add new skill, If skill is not available for example in my current scenario, X++ and supply chain is not preset so on skill text box right click and click on view details.
You have to add rating also the same way.
When skills are added, I select them in skill section.
Next step is to add certification, Here requirement is that Person must have certification.
So right click on certification and create new certification and then select it.
Add new Education, suppose we require to person at least Graduate. So select graduation.
Now we have to add three task, that belongs Customization, integration and code.
Save the job from top menu and close the job
If we see on list page, we find our new job is listed there
.
Create the new position
Now second step is Position creation and attach job with it.
From menu, select position.
On list page, from top menu, Click on new
Select Job we created in last step.
You find the now position associated with job in position
New position is listed on list page
Create a Recruitment Project.
Now go back to Main menu and create a new Recruitment Project
Form list page create new recruitment Project by clicking on new at top menu.
Select Previously Created Job and save the Recruitment project.
From top menu click on and start the Recruitment Project
Hire new employee against recruitment project
New recruitment project is started, we can receive application against this
From top menu click on applications.
Select the applicant name, In my current scenario, required Applicant name was not exists in ERP. So I right click on Name field and click on View Details.
From New party page enter the Required name and create a new party.
After that save and select newly created party as new applicant. Right click on top menu. And hire new worker.
If select employee from menu.
Click on Hire button to create new worker, the applicant successfully Hired against job.
Dynamics Ax 2012 R3 Customization Overview Session Pictures
My session on Lahore Microsoft Invocation Center was at 24-8-2015. Purpose of this session was give introduction about Dynamics Ax to young graduates. Target Audience was of 0-1 year working experience.
Happy New year, best wishes for 2015
Image stored in Dynamics Ax 2012 tables
In dynamics Ax 2012, You can read image from physical path and stored in database as follow
BinData binData = new BinData();
str extention, path, nameOfFile;
container imageContainer;
str imageFilePathName;
imageFilePathName=”C:\\abc\\ali.jpg”;
// if ( WinAPI::fileExists(imageFilePathName))
{
binData.loadFile(imageFilePathName);
imageContainer = binData.getData();
table.Person = _Party.RecId;
table.Image = imageContainer;
table.insert();
}
This code runs both for server side and client side. At server side execution table use winserverapi::FileExists