≡ Menu

Time line

Cool Timeline

Nov 09

Relation between PurchLine and PurchReqline Tables in Dynamics AX 2012 R3.

In one of SSRS Report requirement, client wants to see Purchase order quantity, Invoice Quantity against items purchase requisition Quantity.   Instead of writing a query on ItemId and InventdimId, I found out of the box function In PurchReqLine table. This method return the reference of Purchline. With reference of Purchline, I can get Purchase […]..Read More

Oct 31

Free introductory course on MVA for Dynamics 365 for finance and operations, enterprise edition.

Do you want to introductory session, then this course is for you. Yes it is free any one can watch very basic level course on Microsoft Virtual Academy https://mva.microsoft.com/en-US/training-courses/introduction-to-microsoft-dynamics-365-for-finance-and-operations-enterprise-edition-17908?l=AHneoTOJE_906312570 Course contents are amazing.      Course Introduction Time00:01:3701 | Overview  Cloud-Based Solution Time00:02:02  Workspaces Driving Productivity Time00:02:48  Workflows in Your Business Processes Time00:03:34  Reporting Time00:01:12 […]..Read More

Oct 28

Mass delete records D365 for Finance and Operations.

I was testing one scenario, I have created some main account wrongly. So I want to delete them quickly. Secondly I want to explore the Office integration In D365 for finance and operations. So I did following steps to delete the required records quickly.  Organization administration > Setup > Office integration > Excel workbook designer […]..Read More

Oct 28

Could not upload to the storage location Dynamics 365 for finance and operations.

I was experimenting with Office integration in Dynamics 365 for finance and operations. On Create Excel worksheet. I got following error Could not upload to the storage location: Unable to connect to the remote server. Later I found that on my onbox, Azure Emulator was not running. So I did On OneBox VM, run command […]..Read More

Oct 26

Microsoft Management Report installation, configuration links Dynamics Ax 2012 R3

Couple of days ago, I configure the Management Report on client machine. I found following links helps to install and reconfigure.   You can download Microsoft Management Report integration guide from here. It was last updated Feb 2017 https://www.microsoft.com/en-us/download/details.aspx?id=5916   For me the most important thing I found is user role in white paper.   […]..Read More

Oct 15

Customer in Dynamics 365 for Finance and Operations

Every organization sold product or services to Customer. These Customer are main source of income to these organization. In Dynamics 365 for finance and operations we can create customer in Account receivable and sales and marketing modules.  Customer basic information is saved per legal entity but his Name, address and contact save in global address […]..Read More

Oct 06
Oct 05

Dynamics Ax 2012 Project Types and Time and Material Video

Hi All I found very interesting video about Project Management and accounting module of Dynamics 2012 R3 by Santosh kumar Singh. Video is worth to share.    ..Read More

Sep 29

float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.

    Today I have to record very small tip. During development of on SSRS report for Dynamics Ax 2012 R3, End user wants a row at the report footer for  analysis. he wants some kind of percentage  calculation with ‘%’.  A For this I have to use CStr ssrs expression function  like   Ctr(((sum(DataSet!field.Value) […]..Read More

Sep 28

Workflow Approve Name  in Grid Dynamics Ax 2012 R3

Small tip, with reference at the end of post. I got small task, User want Last approval Name in grid at the result. I wrote following code snippet as method in a required table and bind it to grid field.   display Name LastApprovalName() { WorkflowTrackingStatusTable workflowTrackingStatus; WorkflowTrackingTable workflowTrackingTable; WorkflowTrackingCommentTable workflowTrackingCommentTable; UserInfo userInfo; RecId _recId; […]..Read More

Sep 22

Customer Credit limit in Dynamics 365 for Finance and Operations

We can set credit limit for customer. Customer can purchase product or services up to certain limit. Even D365 for finance and operations provide us option to generate error message and stop processing of Sale order or just show error message and let the transaction happened.   For this you have to enable customer credit […]..Read More

Sep 16

Dynamics 365 for Finance and Operations Development Cookbook Review.

    Book is excellent. It is handy and cover the almost all technical scenarios with very simple and precise examples. It is scenario based book, Instead a lot of story and unnecessary details, It focus to the point. As compare to previous cook books, which were more abstract, this feel book wrote in mind […]..Read More

Sep 09

D365 For Operation – 15 UI Tips and Tricks – A video from YouTube

    I found very interesting video regarding UI tips for Dynamics 365 for finance and operations. Its worth to share so it is here  ..Read More

Aug 22

Select on InventSum vs InventOnHand Class Dynamics Ax 2012 R3.

Today I face the very strange behavior of X++ code. We develop customization. We generate transfer and issuance through X++. Logic was very simple,If stock is available then transfer  / Issuance or Adjustment journal create otherwise generate error message, We took this decision  based of query on Inventsum. It works fine in most of cases […]..Read More

Aug 19

Custom financial Dimension shows in lookup D365 for Finance and operations

I one of last post, I added the custom financial dimension in D365 for finance and operations. You can find this post here https://www.tech.alirazazaidi.com/custom-financial-dimension-in-dynamics-365-for-finance-and-operations-ax-7/ In next post I load financial dimension in custom lookup. Custom lookup for Financial Dimension D365 for Finance and Operations (Dynamics Ax 7) But above link shows only out of the […]..Read More

Aug 17

Dynamics 365 For Finance And Operations On Perm Demo Video

I just completed first video. 9 minute video just explore the navigation of D365 for finance and operations. Dynamics 365 For Finance And Operations On Perm Demo from alirazazaidi on Vimeo...Read More

Aug 06

Custom lookup for Financial Dimension D365 for Finance and Operations (Dynamics Ax 7)

Suppose we have to display all values in “Cost Center” financial dimension in custom lookup. For this post I used unbound field. So first step is we need we need a text box. So drop a control of type “String” ( “Traditionally it is StringEdit Control”). Right click on “OnLookup” event and click on “copy […]..Read More

Aug 06

Getting All Active financial dimensions in D365 for Finance and operations (AX 7)

Testing the old code in Dynamics 365 for Finance and operations. It works fine. If you try to get all active financial dimension in D365 for Finance and operations following code snippet works perfectly fine. class TestReadFinanicalDimension { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void […]..Read More

Jul 14

Custom Financial Dimension in Dynamics 365 for Finance and Operations (AX 7)

Purpose of this post to share the procedure I learned yesterday for adding custom Financial dimension in Dynamics 365 for Finance and Operations aka (AX 7). So I added a fictional Financial dimension. Suppose we have to create a financial dimension with “Jaggah Tax”. This financial dimension required in Sales order, Sales Line, Purchase Order, […]..Read More

Jul 06

Dynamics 365 for Finance and operations on premise deployment Landing Page link

A month ago, Microsoft publish a link page for  On-premises deployment. They titled it as Landing Page. This page contains On premise infrastructure, hardware requirements, licensing polices,  purchasing license, configuration, deployment and much more. Page is worth reading, you can find its detail from link below.   https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/on-premises-deployment-landing-page..Read More

Jul 03

Skip certain values Report group sum SSRS Dynamics Ax 2012 R3. Dynamics 365 for operations

There is again small tips. Let me share you again scenario. Suppose you have to show customer Sale With customer group level. And group footer want to sum of Sales of that group. Now requirement is that customer with certain sub classification will skip in group sum. For example those customer who are on hold […]..Read More

Jul 03

Serial Number in Report Group SSRS Dynamics Ax 2012 R3.

Today I have small tip. Let me share a scenario. Suppose you have to display Customer group as report level group and customer at detail level who did purchased products from your organization in given period of time. Serial number on detail level can be achieved by RowNumber(“Scope Name”) But serial number shown on Group […]..Read More

Jun 23

Enum value to Table Insertion Dynamics Ax 2012 R3, D365 for operations

Let me share you a small tip, During customization We extend out of box Enum for classification. Later client requirement is extensive usage of new Values for classification. For adding new values in enum results dependency on technical person . So we did customization and provide form and custom table so he can create number […]..Read More

Jun 20

Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) system requirements White-Paper

Microsoft just release the white paper about system requirement of Dynamics 365 for Finance and Operations and Enterprise edition In short Dynamics Ax 7 on premises.   You can download it from here https://www.microsoft.com/en-us/download/confirmation.aspx?id=55496..Read More

Jun 05

Customization in Dynamics 365 for operation (Dynamics AX, AX 7) – Part 8 Tree Control

Recently I complete the custom Inquiry for Dynamics Ax 2012 R3. That customization is extensive and based on Tree control. Now I did experiment with Tree view control  in Dynamics 365 for operation and output will share here.  For this post I used Dynamics 365 for Operation Update 4 Vm with contoso data. Suppose we […]..Read More

Jun 05

Tips and Tricks in Dynamics 365: Export Excel Data to Dynamics 365 for Finance and Operations

Hi All, I just enjoyed the video by Clients First Business Solutions on excel data export. I think its worth to share  ..Read More

May 30

Data Manipulation tip 5. Like operator wild card in Select query Dynamics ax 2012 D365 for Operations.

Currently I am writing an Inquiry for Client. For this inquiry I have to use Like operator functionality. For example end user wants to search Sale Orders. For this he/she enters the partial sale order number and Inquiry provides the result. Microsoft provides “Like operator” functionality , I used it with text box in below […]..Read More

May 29

Relation between VendInvoiceInfoTable and VendInvoiceJour Dynamics Ax 2012 R3

Relationship between VendInvoiceInfoTable and VendInvoiceJour. Is Parm Id. This problem occurs when we need some customization on vendor Invoice form and values of these fields required in reporting. Due to minor nature no impact on calculation. For getting these fields to VendorInoviceJour required complex customization, God knows what will broke or long way of testing […]..Read More

May 05

Good By AX Brand, Microsoft Officially retired the AX as brand

The Dynamics AX brand has been officially retired by Microsoft. As of July 1, 2017, new customers will not be able to buy Dynamics AX 2012 R3.   Existing client still extended and renew their license.  But After 1 July new customer only purchase Dynamics 365 for operations.   There is possible release of on premise […]..Read More

Apr 26

Special character In Query range, Dynamics ax 2012 R3 and DFO 365 for operation.

Yesterday I got very interesting issue. So When put filter on color, config, style and size. A strange error occur. Filter works for 99% of records but on 1 percent time out occurs. When we dig deep into issue, we found that End user, used the special character ‘(‘ in style. And when we execute […]..Read More

Apr 24

Data manipulation tip 4 Dynamics ax 2012 and D365 of Operations Insert_recordset

During report development we populate temp table and bind it to SSRS report. And most of the time we were doing one to one mapping inside while loop or query run loop., Kindly consider following code snippet. While select sum(Qty) from Inventtrans group by ItemId, InventDimId , DatePhysical Where datePahyical > _fromdaet && datePhayical _fromdaet […]..Read More

Apr 12

Data manipulation tip 2 Dynamics ax 2012 and D365 of Operations Table initialization method.

If we consider the following code snippet. CustSalesQty _temp1,_temp2; _temp1.IntQty=100; _temp1.CustAccount ="Cust00001"; _temp1.insert(); _temp1.IntQty=200; _temp1.insert();   _temp1.IntQty=300; _temp1.CustAccount ="Cust00003"; _temp1.insert(); while select * from _temp1 { _temp2.data(_temp1); _temp2.insert();       }   while select * from  _temp2 { info( " _temp2 with " + _temp2.CustAccount + " " + int2Str(_temp2.IntQty));   }     […]..Read More

Apr 09

Data manipulation tip 1 In Dynamics ax 2012 and D365 Of Operations Data copy method.

  Currently I am doing Report development project, I got some tips for Data manipulation , these tips I recently learned.   Copy data from one table buffer to other of same type.     During report development, We usually populate  temp table with result of Query execution. Usually we need copy of same data […]..Read More

Apr 01

Code permission Error, SSRS report missing. Dynamics Ax 2012 R3.

Today after Db resorted form Production / live server, Full CIL failed, And During compilation I found very strange error. Error described that ” Code Permission Error” And It pointed to out of box SSRS report. Interestingly a junior developer added customization on report. And there is no error on report. Finally I found that […]..Read More

Mar 17

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`..Read More

Mar 16
Mar 12

Management Reporter 2012 CU16 is now available

With reference to blog.MSdn.Microsoft, New version for Microsoft Management Report for Dynamics Ax 2012 is now available. You can download it from https://mbs.microsoft.com/customersource/northamerica/MR/downloads/service-packs/MROverview For more information kindly visit following link https://blogs.msdn.microsoft.com/axinthefield/management-reporter-2012-cu16-is-now-available..Read More

Feb 24

Advance SSRS Report Drill Through Action URL Dynamics ax 2012 R3

Let discuss real time scenario. In one of my custom SSRS report, Client wants to open Saleorder form by clicking on Customer Account, By default it leads to customer detail form. I used following link to build this functionality. https://technet.microsoft.com/en-us/library/cc582049.aspx https://dynamicsaxinsight.wordpress.com/2014/12/23/ax-2012-ssrs-report-drill-through-action-url/ to complete the re If you read the Microsoft link on TechNet in one […]..Read More

Feb 12

Voucher not specified as of … Dynamics Ax 2012 R3

A year ago, I did some customization, where ledger entries are done with X++ code. Now client wants Reverse ledger entries. As per logic reverse ledger entries has only difference is debit amount will be credit amount and versa vise. With X++ code  80 percent of these entries are successful, But 20 percent were fail […]..Read More

Feb 12

Microsoft Dynamics 365 vs NetSuite White Paper by Merit solutions

Currently I just complete small not more than 10-pages white paper released by http://www.meritsolutions.com I love is definition of Dynamics 365 in article. For your reference I copied it “Microsoft Dynamics 365 is Microsoft’s next generation of intelligent business applications delivered in a single-tenant cloud environment. Dynamics 365 unifies CRM, ERP, BI, IoT, and mobile […]..Read More

Feb 03

Customization in Dynamics 365 for operation (Dynamics AX, AX 7) – Part 7 Custom SSRS based on Report Data provider.

Time change, Things change but experience always counts. Today I decide to write a post to build very simple custom Report Data provider based report. It is similar report I  developed back in May or April 2012. My current development environment is Dynamics 365 for operations Update 2 vm on my personal Laptop vm. Prerequisite […]..Read More

Jan 31

Stopped (unrecoverable) workflow dynamics ax 2012 R3

Yesterday I face a problem; some Ledger journal records are stuck into Workflow. In Error message, described about issues in  customization. In the after last deployment code full cil was not generated. So first step is full Cil generation. For resubmit these pending records, I used the code snippet delivered on Microsoft Forum by Dick […]..Read More

Jan 06

Various operation During Build process in Dynamics 365 for Operations.

During project build process following operations are performing. All these operations are one by one after each other. Metadata and X++ code validation. Best practice checks. Report RDL Generation Compilation and creating .Net assembly. Label and resource file generation. Database Synchronization.  ..Read More

Jan 05

Naming convention for Customization Dynamics 365 for operations.

Following are some recommendation. Using Camel casing.  Variable name must be in camel Case for example table buffer for CustTable must be similar custTable. Avoid keyword. Avoid system keywords. Company name of  Prefix with company name or project,  For example if my company name with Al then all custom table, Custom form, Extended data Type, […]..Read More

Jan 02

Run time workflow Type Change Customization in Dynamics Ax 2012.

Recently I completed a customization.  Basic requirement is workflow type have to decide on Certain enum based value at run time. For dumpy example, I have two customized type for Sales Order. External Sales and Internal Sales. And Workflow based on same query or table will be different for external sales and internal sales. For […]..Read More

Dec 09

Dynamics Ax 2012 R3 RTM upgrade to Cu12 step by step.

Recently I upgrade the Dynamics Ax 2012 R3 RTM environment to CU12. You can find official Microsoft guide for CU12 form following link. https://mbs.microsoft.com/Files/public/CS/AX2012R3/CumulativeUpdate12InstallationGuideforMicrosoftDynamicsAX2012R3.pdf Following are my notes during upgrade process. First step to download patch KB3199741. https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;3199741 This link requires  login to partner source. You have to add email address and then Microsoft send […]..Read More

Dec 06

The formatter threw an exception while trying to deserialize the message Dynamics Ax 2012 R3 SSRS

On running report, following error message appear in info box. The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was ‘Element ‘http://tempuri.org/:queryBuilderArgs’ contains data from a type that maps to the name ‘http://schemas.datacontract.org/2004/07/XppClasses:SrsReportProviderQueryBuilderArgs’. The deserializer has no knowledge of any […]..Read More

Dec 05

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 […]..Read More

Dec 05

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, […]..Read More

Dec 05

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 […]..Read More

Nov 23

Whats Dynamics 365 offering today and What will it tomorrow, SL,GP,Nav also Part of it

I took picture, not share from where, But certainly from Microsoft Slide. Yaa, SL , GP Nav also part of it...Read More

Nov 23

What’s New In Dynamics Ax 2012 R3 Cu12

Microsoft release update Cu12 for dynamics Ax 2012 R3. Microsoft Also release the what’s new document to describe what in this Update. You can found it in this location   https://mbs.microsoft.com/Files/public/CS/AX2012R3/WhatsNewinAX2012R3CU12.pdf..Read More

Nov 17

Some Videos for Microsoft Flow : Dynamics 365 for Operations

I found some videos for Microsoft Flow on youtube. All these videos are uploaded by Microsoft Team. Microsoft Flow: Getting Started Microsoft Flow Quick Look (0-1) Building Blocks of Microsoft Flow (0-2) Microsoft Flow: Watch your flows in action Microsoft Flow: Create a Flow from Scratch   Microsoft Flow: wait for Approval Introducing Microsoft Flow […]..Read More

Nov 16

MVP Summit 2016 and my experience.

This was my second visit to USA on MVP summit. Every year Microsoft Invite MVP from all over the world. Where Microsoft team provides information about product Insight, get feedback. It helps to create collaborations between MVPs around the globe. MVP are free contributors to Microsoft technologies.  Anyone can contribute by different ways like answers […]..Read More

Nov 14
Nov 13

New Android apps for Microsoft Dynamics 365.

Microsoft release new apps for Dynamics 365   On searching I found two apps on Android store. Dynamics 365 for Operations Extraction form google App store The Microsoft Dynamics 365 for Operations mobile app empowers your organization to mobilize your business processes. Once your IT admin has enabled the mobile workspaces feature for your organization, […]..Read More

Nov 13

Introduction to New Dynamics 365 for operations in 90 seconds.

Microsoft release a 90 seconds video as introduction to new Dynamics 365. More and less a advertisement video.  Video release with title   Increase the Speed of Doing Business with Microsoft Dynamics 365 for Operations  ..Read More

Nov 03

Workflow resubmit code snippet dynamics ax 2012

Recently I wrote the code for Custom workflow for resubmit.  It took me half an hour to explore out of box code for resubmit. While working in ERP, we have to daily learn new things and handle new situation. Most of resubmit functionality is done through a lot of inheritance and much complex way.  Finally […]..Read More

Oct 31

New Dynamics Ax and Power BI Integration interactive Guided tour.

I found very interesting and interactive guided tour provided by Microsoft at Dynamics.com. I feel its worth to share. Enjoy and say welcome to 365 degree change in the world of ERP.  ..Read More

Oct 28

RegisterOverrideMethod was called twice for the same object for method Dynamics Ax 2012

I was developing the report by adding UI Class and building the drop down list to select multiple customer.   When I try to bind, DataSet of SSRS report to data provider class, it shows following error.   RegisterOverrideMethod was called twice for the same object for method ‘textChange’. You can only override a method […]..Read More

Oct 28

Time field on SSRS shows time format Report Dynamics Ax 2012

Today is another small tip, I was developing a custom report. Queried table stored the date and time in separate fields ie. Transdate and transtime. On  mapping the transtime to report, its showed time format. Instead of time value. For it solution, I added the string field on report temp table and then convert the […]..Read More

Oct 19

Customization in New Dynamics Ax (Aka AX 7)- Part 6 Custom Workflow

Customization in New Dynamics Ax (Aka AX 7)- Part 6 Custom Workflow   Hi, every one, Let’s explore the custom workflows in new Dynamics Ax commonly known as AX 7. This blog post is part of series. In this post, I build a custom workflow based on table and form build in pervious posts. Below […]..Read More

Oct 18

Design/Controls/Filtergrp’ is missing child ‘Quick Filter new Dynamics Ax 7

While building Dynamics Ax 7 simple list page, I got following error on compiling.   Severity                Code      Description         Project  File         Line Error                     Path: [AxForm/AXEarningCodeGroup/Design/Controls/Filtergrp]:Control ‘AxForm/AXEarningCodeGroup/Design/Controls/Filtergrp’ is missing child ‘Quick Filter’ required by pattern ‘Custom and Quick Filters’.   CustomPayroll (USR) [CustomPayroll] C:\AOSService\PackagesLocalDirectory\ApplicationSuite\CustomPayroll1\AxForm\AXEarningCodeGroup.xml               0   In short Design/Controls/Filtergrp’ is missing child ‘Quick Filter   Something different then […]..Read More

Oct 13

6 new courses for Dynamics 365 on Dynamics learning Portal

Just open then dynamics learning portal, two new menus or classification found on top menu. Dynamics 365 enterprise and Dynamics 365 Business. I found that Microsoft just upload 6 new courses for Dynamics Enterprise on Dynamics Learning Portal.   If you have time and passion and more importantly Dynamics Learning Portal access credentials, you must […]..Read More

Oct 10

Dynamics Ax 7 Vm configuration on Windows 8.1 and Windows 10 -Urdu -Hindi My video on Channel 9

I created a video and posted on Channel 9 . It is my native language. There is sound quality problem, But I made it. This is my second video on Channel 9.    ..Read More

Oct 10

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 […]..Read More

Sep 27

TSQL Query for tables where each General ledger entry has effect Dynamics Ax 2012

For Future reference, I used following Queries to check the General Ledger Entry in Dynamics ax 2012. Small tip, You can used them to delete posted ledger entry   select * from LEDGERJOURNALTABLE where JOURNALNUM =’XYZ-015528′   select * from LEDGERJOURNALTRANS where JOURNALNUM =’XyZ-015528′   select * from LedgerEntryJournal   where JOURNALNUMBER =’XyZ-015528′ select recid,* from […]..Read More

Sep 13

Customization in New Dynamics Ax (Aka AX 7) Part 5 – Custom forms – Simple List Page.

  This post is series. In Last post we create some custom tables for  in Dynamics Ax. Customization in New Dynamics AX (AK 7) Part 4- Custom Tables In basic level we create two tables EarningCodeGroup and Earning Code. In this post we build simplest and very basic level forms.   Open the project and […]..Read More

Aug 24

Customization in New Dynamics AX (AK 7) Part 4- Custom Tables

Suppose we are writing a custom module for Payroll. According to requirement, we have to create a custom table for Earning code. As well as Earning group.   At minimum we required following fields Earn  Code Group Table Earning Group of length 20. Earning Group description length 60   Earning Code Table Earning Code possible […]..Read More

Aug 15

Financial dimension for work position Dynamics Ax 2012.

  I used following code snippet to get financial dimension attached with hcmposition   static void GetFinancialDimensionValue1(Args _args) { HcmPosition  position; HcmPositionDefaultDimension  positionDefaultDimention; DimensionAttributeValueSetStorage dimStorage; Counter i; select * from position join * from positionDefaultDimention   where position.PositionId=="000001" && position.RecId == positionDefaultDimention.Position;       dimStorage = DimensionAttributeValueSetStorage::find(positionDefaultDimention.DefaultDimension);   for (i=1 ; i<= dimStorage.elements() ; […]..Read More

Aug 11

Cannot edit a record .. An Update Conflict occurred due to … Dynamics Ax 2012 R3.

today I got this error while running a custom report. Cannot edit a record in  Table An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.     I found that this error occurs due to concurrent access to table is allowed. And we […]..Read More

Aug 04

water mark in SSRS report Dynamics Ax 2012.

Hi, all very small tip today, Recently I have to add water mark in one of custom report. In SSRS for Dynamics Ax 2012, we can achieve water mark by adding background image in report body. Water mark image should be small in size and used as background Image. If you use high in size […]..Read More

Jul 30

Customization in New Dynamics AX (AK 7) Part 3- Form and Table Extensions.

    In new Dynamics Ax, the extensions are created for extension. Previously we use overlay or overwrite change in Out of the box Dynamics Ax object. For example, if we have to add some fields or modification we are overlay or adding changes in original Object. Object is overwrite in configured layer. But in […]..Read More

Jul 26

Customization in New Dynamics Ax (Aka 7) Part 2- Create New Module

This post is continuity of Customization In New Dynamics Ax (AX 7) Part 1 – Creating New Model In Dynamics New module is a Menu,   In this post we are Creating A new module In Dynamics where we add complete implementation.   So first step to create a menu Item Double click on menu […]..Read More

Jul 26

Customization In New Dynamics Ax (AX 7) Part 1 – Creating New Model

Currently I am explore my Dynamics Development Skills in new Dynamics AX (Aka AX 7). So I decide to write series of post. So first post is about creating Model and visual studio project. Open Visual studio but did not create project, first step is Create new model. For this click on Dynamics AX menu […]..Read More

Jul 19

How to run RDP based report from X++ and passing parameter using Data contract.

Interesting, I was modifying some RDP based report, I found that parameter was passed to report through custom table, As report will run form button, and based on current selected record. So former developer did that on pressing button, selected value inserted some custom table. When report run, query on table and fetch required value […]..Read More

Jul 16

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 […]..Read More

Jul 14

No such host is known and AOS not reached SSRS Dynamics AX R3.

Yesterday I deployed the new SSRS customization to staging, so QA / Functional guy can test. Client configured the AOS to Database server and Application server was moved for backup services. Due to change in AOS server I have to face two issues. “No Such Host is known.” Whenever we run the report on staging […]..Read More

Jul 04

Dynamics Ax 7 RTW update 1 available for download.

You can download Dynamics AX 7 RTW update 1 from Microsoft connect with following link. https://connect.microsoft.com/site1321/Downloads/DownloadDetails.aspx?DownloadID=61368 More interestingly, now You can download it in browser, I used Internet download manager.   You can find detail about what’s new in update 1 in following links   https://ax.help.dynamics.com/en/wiki/whats-new-or-changed-in-dynamics-ax-7/     https://blogs.msdn.microsoft.com/lcs/2016/05/27/may-2016-release-notes/  ..Read More

Jun 13

Display methods in Report SSRS Dynamics Ax 2012 .

Hi, All, today I have to modify the report. Interestingly this report was built on AOT Query, instead of Data provider class. Current Scenario I was working on Worker Report. The requirement was to show’s primary position and department. HCMWorker table has two display method returns these values. We can add these display methods into […]..Read More

Jun 08

Exploring Currency Exchange Rate in New Dynamics Ax.

Suppose we need exchange rate from In Dynamics AX, For example dollar to Pakistani Rupee exchange rate. We can do this in three steps     Exchange rate Type in Dynamics Ax (Aka AX 7)   Create a new exchange rate in new Dynamics Ax (Aka 7)   Setup Exchange rate in Ledger Dynamics Ax […]..Read More

Jun 08

Currency Exchange rate Type in Dynamics Ax (Aka AX 7)

For creating new exchange rate type click on top menu and click on ledger.   From detail menu click on Exchange Rate Type   Click on new button from exchange rate types list page     Enter PkR and detail about it and click on save...Read More

Jun 08

Create a new Currency exchange rate in new Dynamics Ax (Aka 7)

Click on General ledger from Ax menu. When currency exchange rates page opens, it load default rate change. Select required rate exchange type.   From currency select dollar and to currency Pkr and set conversion factor to 100.   Also save and then add effective dates.      ..Read More

Jun 08
May 23

Basic level sale order processing In New Dynamics AX (Aka AX 7) Step by Step.

In very basic level we can divide the Sale order into following steps   Create New Customer Create a Sale order Pick the Sale Order Pack the Sale order Invoice the Sale Order..Read More

May 23

Create a new customer in New Dynamics Ax (Aka AX 7)

Login in to Ax         On successful login dashboard page is open in web browser.     Change legal entity from top menu to USMF We can create sales order from either Sales and marketing and Account Receivable module   Click on top menu.   Select Account Receivable menu   Or Sales […]..Read More

May 23

Create a new Sales Order in New Dynamics AX (Aka AX 7)

Either you create new customer and then click on Save and open. Otherwise click on new Sales Order and select customer. Select Customer selection for Sale order.     Select customer and save.       As we create very simple sale order so we select only one Item D0001 and set quantity 10 and […]..Read More

May 23

Pick The Sale Order in New Dynamics Ax (Aka AX 7)

When Sale order is confirm. Select pick and Pack => Generate => Generate picking list.     Click on Ok.  ..Read More

May 23

Pack the Sales Order In New Dynamics AX (AX 7).

After pick list Generation, Click on Pick and Pack => Generate => Picking list registration Click on Updates => Update All.           After that click on end of form click x to close.   Then Click on Pick and Pack => Generate => Post Packing Slip. Click ok, You find that […]..Read More

May 23

Invoice the Sales Oder in new Dynamics Ax (AX 7)

After posting slip,  Click on Invoice  => Generate => Invoice     Click on Save. Status is changed again to Invoice.  ..Read More

May 19

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists. Dynamics Ax 2012

Hi, All today I got error while creating Leger entry Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists. I found some issue with free sequence number in NumberSequenceList . I manually delete the free sequence number with following statement. static void Job14(Args _args) { NumberSequenceList list; while select forUpdate * […]..Read More

May 14

‘Invalid enum value ‘GMTPLUS0500ISLAMABAD_KARACHI’ cannot be deserialized into type Dynamics Ax 2012 R3 WorkFlow Error.

Couple of months ago, I have to face a strange error and its very strange solution. So I decide to share it and document so it helps others as well as I remember if I face it again. Error occur when we try to create, edit or delete workflow. This error is certainly because of […]..Read More

May 11

Workflow status and comments Query Dynamics Ax 2012.

  I have to explore Out of the box workflow status and comments.  After dig down, I found following three tables are important to get all information.   WorkflowTrackingCommentTable WorkflowTrackingStatusTable WorkflowTrackingTable     Reference of row on which workflow is applied or run can be found workflowTrackingStatusTable two field ContextRecid and ContextTableId..Read More

Apr 26

Unit Conversion Real world scenario, Dynamics Ax 2012 X++

A few days ago, I got requirement, where I have to sum up the total quantity and amount of all Purchase line. Here we assume that All lines in Purchase order belongs to same set or convertible unit. You can set these unit conversion settings at Organization administration > Setup > Units > Unit conversions.       Public void SumQTYAndAmount(PurchTable […]..Read More

Apr 13

One time Vendor or supplier Functionality in new Dynamics Ax (Aka Dynamics Ax 7)

Dynamic Ax provide the option to create purchase order against one-time vendor or supplier. It means one-time vendors can transact only once. If you create a new purchase order, you find this option at the top of vendor creation form.   There is possibility that we can create multiple one time vendors or supplier against […]..Read More

Apr 07

SSRS for Dynamics Ax 2012, group sum based on condition

Small tip today, In one of my custom SSRS report for Dynamics Ax 2012 on group total, requires conditioning, For example sum did not include the value in the based on certain value of other field. I used following expression to solve this problem. =Sum(iif(Fields!FieldName.Value <> “abcdxyz”, Fields!FieldName.Value, CDbl(0))) I took help from following link: […]..Read More

Apr 05

Git with Dynamics ax 2012

Recently I explored GIT as source control tool. As per work with Microsoft Technologies I worked with TFS and Source save.  In Dynamics Ax 2012 context I found AX2GIT on codeplex and https://github.com/Go-ERP/Ax2Git/wiki https://github.com/Go-ERP/Ax2Git https://ax2git.codeplex.com/   I download ax2git zip. After extraction I found  XPO.   So I decided first to download its perquisites. i.e. […]..Read More

Apr 04

dynamics ax 2012 form datasource sort X++

Today I got requirement to insert record at run time and shows result in sorted order. I used following code code snippets. Suppose we are sorting on Customer in required field CusTable_ds.query().dataSourceNo(1).sortClear(); CusTable_ds.query().dataSourceNo(1).addSortField(fieldNum(CustTable, AccountNum), SortOrder::Ascending); CusTable_ds.executeQuery();..Read More

Mar 26

error : Object ‘FormRun’ could not be created. when submit workflow from EP Dynamics Ax 2012

I got error  “‘FormRun’ could not be created “on EP. When I test the submit for approval in EP. I have to reimplement all methods with respect to following link   https://msdn.microsoft.com/EN-US/library/ee677503.aspx  ..Read More

Mar 21

Page can not be display -The description for Event ID 110 from source Microsoft Dynamics AX cannot be found new Dynamics AX 7

During development suddenly Ax stop working. When I try to connect web url https://usnconeboxax1aos.cloud.onebox.dynamics.com. It shows page can not display. Previously it was working fine. On Event viewer I found following exception.   The description for Event ID 110 from source Microsoft Dynamics AX cannot be found. Either the component that raises this event is […]..Read More

Mar 09

Labels migration from one environment to other Dynamics AX 2012

Usually I forget this step during code migration from environment to other. So I note it down for future reference. The best way to move labels from environment to copy the *.lac file form location C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\Application\Appl\Standard And paste on some common folder in target environment. And then import it by right click […]..Read More

Feb 28

The new Dynamics AX (aka AX 7) RTW vm component now available for download

Hi, All I found new Dynamics AX RTW download link on Microsoft connect.  Microsoft update that link at 24/2/2016. After download you have to follow following two links to configure it on your machine.   Access Microsoft Dynamics AX Instances Running Dynamics Ax 7 CT8 Vm on Windows 8.1..Read More

Feb 19

Excel power query with Dynamics Ax 2012 R3

  End user in Pakistan industry love the Excel. I worked in local Pepsi franchise for two years. Everything they need raw data or reporting data into excel. They called it cycle. Because their office work cycle starts and end on excel. How much complex report you developed for them, if it not converted into […]..Read More

Feb 09

exception has been thrown by the target of an invocation Dynamics Ax 2012 R3

A few days ago I face again the old error “Exception has been thrown by target of an invocation. This time this error did not let us do anything on client.     Finally I found that AOS server Configuration utility, database server is set as Server Name for example as “DB server” instead of […]..Read More

Feb 07

Dynamics Perf 2.0 important links

I found following links for Dynamics Perf 2.0 http://blogs.msdn.com/b/axinthefield/archive/2015/12/18/what-s-new-in-dynamicsperf-2-0.aspx http://blogs.msdn.com/b/axinthefield/archive/2016/01/03/dynamicsperf-2-0-scheduling-engine.aspx http://blogs.msdn.com/b/axinthefield/archive/2016/01/06/dynamicsperf-2-0-is-here.aspx http://blogs.msdn.com/b/axinthefield/archive/2015/12/30/dynamicsperf-2-0-deployment-guide.aspx http://blogs.msdn.com/b/axinthefield/archive/2015/12/30/dynamicsperf-2-0-installation-for-dynamics-ax.aspx..Read More

Feb 05

How to get next recid in TSQL Dynamics Ax 2012

Suppose we have to insert data into VendGroup table through TSQL, this scenario usually appear when integration or data migration team inject data into AX using TSQL without using AIF. There are two tables are important SQLDICTONARY and SYSTEMSEQUENCES.   SQLDictonary table contains the table id for example Vendtable has 490 id. SYSTEMSEQUENCES table contains […]..Read More

Jan 30

Custom lookup in reference group Dynamics Ax 2012

Here is little tip regarding look up. A few days ago, I have to take join with employee with my custom table. if you check that The primary key of HCMWORKER IS RecId. So I have to create worker relation based on primary key i.e recid.\ But when I drop the foreign key on form […]..Read More

Jan 27

Inline variable declaration in New Dynamics Ax (aka ax 7).

Now in Dynamics Ax 7, now developer can declare variable/object where they need it. Instead ax 2012, where variable  declaration is only possible in very beginning of method or function. For ( int counter =0; counter < 10; counter++) {   If ( counter >10) { Int value= counter+10; } Else { Real percentage = […]..Read More

Jan 24

Try catch and finally in new Dynamics Ax (aka AX7)

Finally I found that in new Dynamics Ax finally statement introduce in exception handling statement. try { } catch { } finally { } It means, everything written in finally must be execute. For testing this functionality I just create a runnable class and written following code. class HelloWorld { /// <summary> /// Runs the […]..Read More

Jan 15

Lot ID not specified Error DMF import Dynamics Ax 2012 R2 Cu7

Today I had to troubleshoot the Inventory journal DMF import, which previously working fine. But somehow it start to throw “Lot ID not specified. Import cancel. Hour of hours debugging reveals nothing. Finally I found some warnings in Database synchronize. These warnings described some index errors on DMF entity tables and need to drop and […]..Read More

Jan 02

Runnable classes and table browser in Dynamics Ax (Dynamics AX 7).

Purpose of This post to explore the runnable classes to test the logic, checking the traditional X++ (AX 2012) code and new table explorer in Dynamics Ax 7.  This post is based on Dynamics AX (Dynamics AX 7) CTP 8.   In new Dynamics Ax (Dynamics AX 7) there is no more AX Jobs.  For […]..Read More

Dec 29

Exploring the Dynamic Ax (AX 7) workspace.

New Dynamics AX (AX 7) is web based. Its navigation layout is different than Dynamics Ax 2012. Writing of this blog post, I am using Dynamics Ax 7 CTP8 beta version, so possible later version will have better navigation layout. Lets explore what Current version offers us.   When we login into AX 7 web […]..Read More

Dec 20

How to enable country or regional functionality to every country or region in Dynamics Ax 2012

During customization, the requirement for client is met by feature built for certain region ie. China and Brazil. Instead of develop that functionality we have to enable this functionality to available in other region too. For this we have to clear the  “CountryRegionCodes” property.   If we remove this property from menu, menu item, extended […]..Read More

Dec 17

Running Dynamics Ax 7 CT8 Vm on Windows 8.1

By writing of this post, I just download the AX7 CTP8 Vm and configure on my machine. I successfully configure it on hyper V. Only one tricky point is external network adapter in Hyper V.   First step is download VHD and extract it to some place. If you are registered to AX 7 Feedback […]..Read More

Dec 12

Delete a legal entity in Dynamics Ax 2012

Today I have to delete all legal entities from one of MS Dynamics Ax 2012 environment. During this I got following error while deleting legal entities. “Can not record , The corresponding AOS  validation failed”. This error clearly shows that Transnational data exists in that legal entity. I follow these steps to clear all legal […]..Read More

Dec 08

New video material on Dynamics Ax 7 at Microsoft Dynamics Learning portal

I just login on Microsoft Dynamics Learning Portal and found that Microsoft Uploaded new videos for Dynamics Ax 7 under following heads General Retail Technical Conference Technical Conference –LCS Technical conference courses https://mbspartner.microsoft.com/AX/Topic/21  ..Read More

Dec 06

Unable to preview the report, install the Business Intelligence Dynamics Ax 2012

A few days ago, I had to modify reports in standard Dynamics Ax 2012 R3. Report successfully opened in Visual studio 2010, but when I tried to modify the report design, visual studio throw following error. Unable to preview the report, install the Business Intelligence. Development Studio feature. For this I had to install the […]..Read More

Nov 30

How to handle empty pages in SSRS report dynamics Ax 2012

Today I was facing the report issue that it print three blank pages other than one require page. This issue is due to page body is covering more area then print page size. During development phase we test the print page size by saving the report review as pdf. Followings is the tip which helps […]..Read More

Nov 22

If this is your first time at MVP summit, you must read this.

This year MVP summit 2015 was my first visit to US and as well as to Redmond Campus. I enjoyed the Aidan Finn post http://www.aidanfinn.com/?p=13909 before leaving for Seattle. So please read that article before this especially if you are from MEA MVP region. The life at Bellevue is different from the area we belong. Here […]..Read More

Nov 18

Invent Journal and its relation with Voucher sequence number Dynamics Ax 2012 R3

  X++ code for these Invent transfer and movement journal is available in different blogs and website. The voucher number for these entries is little bit tricky. This Voucher Number is set InventJournalName as fellow screen. By writing this simple tip I used out of demo vm with contoso data. So If expand the InventJounralName […]..Read More

Nov 12

Required date must not be before today’s date Validation Dynamics Ax 2012

Today I got very small task to remove date validation. This validation appear in out of the box and did not let create functionality for previous dates. Surprisingly I did not find any validation code in form. Later I discover that at table level  validation logic was written in function “validateField(FieldId _fieldIdToCheck)”...Read More

Oct 30

Valid Time State Tables and Date Effective Data on custom table dynamics ax 2012.

Hi all, today I have very small tip, I have inject some data on one of custom table written by some different team.  But update throw exception  Update on a valid time state table is not allowed without specifying a ValidTimeStateUpdateMode     Table is custom I update the required filed by following code snippet. […]..Read More

Oct 21

Custom Workflow from scratch, Dynamics Ax 2012

Let start work on fake requirement. Suppose we are working in HR module and client wants that worker will add their expense and send for Approval.   For this requirement, first we create a custom table and create its relation with Worker table. And then develop a custom workflow on it. So this post contains […]..Read More

Oct 19

Current user and its employee Name and department

Today I got small requirement where I have to pick and display current log in user Name, Following code snippet helps me static void curUserInfo(Args _arg) {     str sUserId; Name name; str departmentName ;     ;     sUserId = curUserId();     info( "Current user ID is " + sUserId ); name= HcmWorker::find(DirPersonuser::findUserWorkerReference(sUserId)).name();  departmentName=   […]..Read More

Oct 14

How to enable debugging on Server 2012 R3.

Usually we have to debug on server, while debugging option is not enabled. Right way to enable it from AX server configuration utility, but some Ax server configuration utility needs is on default setting and any setting on Configuration utility is un-Affordable due AOS service going to restart. On other way is to enable debugging […]..Read More

Oct 12

One or more project in the solution were not loaded correctly SSRS Dynamics Ax 2012 R2.

Today I got an error when I try to edit customize SSRS report project on environment which I first time use.   “One or more project in the solution were not loaded correctly. Please see the Output Window for details”   Visual studio project opens but report did not load, Application Explore shows the message […]..Read More

Oct 05

Out of box Workflow tables and relation with Document table Dynamics Ax 2012

A few days ago I got chance to work on list page which contains the lines which are assign to current user or login user for approval. In Dynamics Ax 2012, every workflow is based on some table. Here we create Query and enable workflow on it. When any record is submit for approval. So […]..Read More

Sep 17

Field ‘abcd’ in table ‘CompanyInfo’ has not been explicitly selected Dynamics Ax 2012 R3.

Today we face an error on our client environment that when we run the report Customer Account Statement shows error in info box as. Stack trace: Field ‘abcd’ in table ‘CompanyInfo’ has not been explicitly selected. Stack trace (C)\Classes\CustAccountStatementExtController\setCommonData – line 29 (C)\Classes\CustAccountStatementExtController\runPrintMgmt – line 76 (C)\Classes\SrsPrintMgmtController\run – line 14 (C)\Classes\SysOperationController\startOperation – line 10 (C)\Classes\SrsReportRunController\startOperation […]..Read More

Sep 12

Sale Order processing In Dynamics Ax 2012 R3 part 1

In dynamics Ax 2012, we can sale stock Item and service Item through sales orders. We can create sales order from Sales and Marketing module or Account receivables module. Currently I am creating and exploring Sales order on demo data contoso data and legal entity UsMF. Open Sales and distribution module and from common menu […]..Read More

Sep 12

“Can not create a record in Audit trail (transactionLog). Dynamics Ax 2012 R3

Today I face an error while confirm sales order “Can not create a record in Audit trail (transactionLog). While searching I found solution already posted by “PavanKumar Idupulapati” at http://pavanidupulapati.blogspot.com/ That’s work for me, with link reference I update the transactionlog table’s create method with following statement if (appl.lastTransactionIdCreated() != appl.curTransactionId()) { if (!TransactionLog::find(appl.curTransactionId())) { […]..Read More

Sep 11

Sales Quotations In Dynamics Ax 2012 R3.

Sales process usually starts with Request for Quotation. And result Sales Quotation generates and send to client. These clients were possible two types. Either they were register customer with organization or they were first time come to register. These first time client which possible become customer or reject our quotation handle as Prospect in Dynamics […]..Read More

Sep 07

Exploring data cache in Dynamics Ax 2012

In Dynamics Ax 2012, table level cache has been performance improving feature. In Dynamics Ax 2012 we can set both client and server side (AOS) level caches. When cache at client and server side enabled. Then user query, first search will be done on client side cache, result not found then Ax tries to locate […]..Read More

Aug 30

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...Read More

Aug 23

Exploring the Full text index In Dynamics Ax 2012 R3

Consider following points for Full text index on Dynamics Ax 2012 Full text index used only on text fields on table. They find all records from table which contains the key words Queries can be used to and full text index used in range filters If keywords contains spaces then it will used as “Or” […]..Read More

Aug 21

Dimension did not save as Personalization Dynamics Ax 2012 R2, R3

Today I got strange query from client that we are adding dimensions like Style in “All production Order” list page using Personalization option. Field added into grid but when we close and reopen the form, it disappear from grid. So there is possible issue with dynamics Ax installation. When I started to investigate, it was […]..Read More

Aug 21

Invalid object name “tempd.dbo” Dynamics ax 2012 R2 cu7

Yesterday at one of our company client was facing this issue, on every transaction or even on validating the Journal post error popup as Invalid object name “tempd.dbo.t4887_”. “Sql statement, select t1.recid from tempdb.”DBO”.t4887_”   I feel that this error is due  tempdb space fill in sql server or temp table created in SQL already […]..Read More

Aug 16

MS Dynamics Ax 2012 Infrastructure ppt

Today I was searching information about MS Dynamics Ax 2012 infrastructure, I found old but excellent power point presentation slide for Dynamics Ax 2012 on slide-share by Davy Vliegen..Read More

Aug 11

Microsoft Dynamics ‘AX 7’ and the Cloud: an analyst’s (pre)view

About Ax 7 and Cloud I found very nice paper at Inside Microsoft Dyanmics Ax Blog. They wrote about the paper In the paper, Mr. Greenbaum explains how the next release of Microsoft Dynamics AX, running on the Microsoft Azure, positions cloud computing for a dramatic and meaningful shift. With a starting discussion of the […]..Read More

Aug 05

Field Mismatch in Union Query in Dynamics Ax 2012 R3

Yesterday, after code merger or migrate from Dynamics Ax 2012 R2 to R3, I got very strange errors in AOT Query or static Query. Error was already reported and solved by different MVPs like Martin Darb and Tommy Skaue. “Field Mismatch in Union Query”.   In code migration, they increased the field length of EDT. […]..Read More

Jul 31

Relation between VendPackingSlipTrans and VendInoiceTRans Dynamics Ax 2012

Today I got chance to find a relationship between vendor packing list and vendor Invoice.  I was expecting that it there was direct relationship between VendPackingtrans and VendInvocietrans. If you expand VendInvoceTrans, there will be a relation but that relation will never use in Dynamics ax 2012. After searching I found VendPackingSlipQuantityMatch table which has […]..Read More

Jul 29

Custom AIF Service in Dynamics Ax 2012 R3 from Scratch.

Today I decide to experiment with custom service. So I decided to create custom table with Name MyColorTable.   This table contains only one field Name. and made it unique with no allow duplicate on Index.   If we consider custom service in Dynamics Ax 2012, it contains following objects   X++ Data contract class […]..Read More

Jul 23

Customer account is missing in general ledger entry by Using X++

Today I was facing a strange problem. I use ledger entry for customer code which was freely available on different blog. You can find the same code here, which I used it two years ago. Create and post Vendor Invoice Journals X++ Dynamics Ax 2012 This code will work perfectly fine. We create ledger entry […]..Read More

Jul 12

Dynamics AX 2012 R3 CU9 Update : Step-By-Step

Download from partner source or customer source. AXUpdateInstaller DynamicsAX2012R3-KB3063879-SlipStreamOnly Extract AXUpdateInstaller. Now also extract the silpstream  in same folder where AX 2012 AxUpdateInstaller extracted.   If you did not download slipstream, then during setup it will ask and download it at run time. Now before running setup perform following steps to Environment preparation: Backup business […]..Read More

Jul 08

How to handle long running reports in Dynamics Ax 2012 R3

  Consider a scenario that we are listing  sale line for  customers on RDP based report. Data is huge on server and report time out occur. In Dynamics Ax 2012 R3 provide new class “SrsReportDataProviderPreProcessTempDB”  use this class instead of SRSReportDataProviderBase For base for this report we please follow below link http://tech.alirazazaidi.com/rdp-or-business-logic-based-ssrs-reports-in-dynamics-ax-2012-r3/   If you […]..Read More

Jul 08

RDP or Business logic based SSRS Reports in Dynamics Ax 2012 R3.

RDP or Business logic based SSRS Reports in Dynamics Ax 2012 R3.   Logic based report in MS Dynamics Ax 2012 can be develop in following steps   Create a temporary table Define the report parameters Add business logic for the report Create a reporting project Bind a report to a report data provider class […]..Read More

Jul 04

An item with the same key has already been added. SSRS Dynamics Ax 2012

Today I got this strange error “An item with the same key has already been added “, Very interestingly I got no error during compilation or deployment of report when I run the report I got this error   On investigate I found this error is due to meta data of report. Report is based […]..Read More

Jul 04

Query Based SSRS report from Scratch Dynamics Ax 2012 R3.

In Microsoft Dynamics Ax 2012, we can create less complex reports with AOT Query or Static Query. Simple or model based report is as follow. http://dynamics-ax.blogspot.com/2011/12/ax-2012-ax-ssrs-report-design-concepts.html   The steps are as follow  We can create simple or model based report with following steps Step 1: Create a Microsoft Dynamics AX query Step 2: Create a […]..Read More

Jul 01

Now everybody can deploy MS Dynamics Ax 2012 on Azure.

Here is very interesting development, Now Microsoft offer, Demo Dynamics Ax 2012 on azure can be deployed, test, learn and train. Previously only partner source and customer source can only login at lcs.dynamics.com. Where they can deploy preconfigured Dynamics Ax 2012 on Azure. From 29-Jun 2015, Microsoft allow very one with live / Hotmail / […]..Read More

Jun 01

Form Development from scratch Dynamics Ax 2012 R3 part 2

Now we start development of form. First form we will build for Simple list form for Diagnostic table For this open AOT and right click on Form Node and click on simple list form template   Drag newly created form in Project and rename it “DiagonasisticTable”. Expand DiagonsisticTable form and Right click on data source […]..Read More

Jun 01

Form Development from scratch Dynamics Ax 2012 R3 part 1

Consider a scenario where we are going to build small Hospital Admission System in Dynamics Ax 2012.  This Add-on is based on small database design based on   http://dhdurso.org/articles/ms-access-database-ad.html       We divide this task into two posts For this post, we are cover following points to develop this small add-on Ax Project Patient, […]..Read More

Jun 01

Microsoft.Dynamics.Framework.Metadata.AX, Version= SSRS Report Error

Today I got very this error on deployment of customized SSRS report. The customization code was written in Dynamics AX 2012 R2 and it was successfully migrated to Dynamics Ax 2012 R3   System.Web.Services.Protocols.SoapException: Error while loading code module: ‘Microsoft.Dynamics.Framework.Metadata.AX, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35’. Details: Could not load file or assembly ‘Microsoft.Dynamics.Framework.Metadata.AX, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or […]..Read More

May 26

List of user under certain Role Dynamics Ax 2012

Consider a real time scenario, where we have to send alerts to all user in certain Role In Dynamics. For this purpose we have to loop through all user in certain role. User, roles and role assignment are done three tables, these tables are hidden in AOT.   These table are UserInfo : This table holds […]..Read More

May 20

internal server error 500 in enterprise portal dynamics ax 2012

There are several reasons for internal server Error 500,  But today i was facing this error in local deployment of enterprise portal. Previously enterpise portal works perfectly fine. I solve it in two steps Restart the IIS. Regenerate the WCF configuration By clicking on refresh button  from Dynamics Ax Server configuration. Following screenshot will help […]..Read More

May 14

How to get time difference between two different time values (TimeEdit control) in MS Dynamics Ax 2012

Today I got change to work with timeedit control in Ax where we have to get input of time and then take difference to get number of hours. For this example I used timeEdit control and add two timeEdit control in form.These timeEdit controls are unbound, I set the out of the box FromTime and […]..Read More

May 06

unchecked’ cannot be called on the client Dynamics Ax 2012 R3

Today  I was debugging the logic written for Custom AIF services  using X++ job before deploy it as AIF service, I got strange error   “Stack trace: ‘unchecked’ cannot be called on the client.”.      It was due that Service class was set as run  at “Called from”, Only solution is to change run […]..Read More

May 03

Deploy and configure Dev/ Test Retail essential environment on Azure Dynamics Ax 2012 R3 Part 1

Dev and test Retail essential is single VM based environment, On which everything need for Retail customization is available.  Yesterday I successfully configured for me. following are some step by step notes for its deployment and configuration.   Login in on following link to login in you Lifecycle services for Dynamics. For this you must […]..Read More

May 01

errors in Payroll classes Symmetry dynamics ax 2012 r3

Today I was configuring POS on Azure test/dev environment, I got very strange errors during compilation  of classes node. All these classes were belong to Payroll modules. Error described that Symmetry variable is not declare.   Later I discover that reference of ste-net.dll is missing in AOT. This mysterious dll (mysterious for me) is found […]..Read More

Apr 28

Reading CSV files in Dynamics Ax 2012.

Today I come across a scenario where, I have to read data from csv file.   Reading data from csv file is very easy with IO operation. For example I have csv file with following student first name and last name which I have to migrate into custom ax table.     Custom Ax table. […]..Read More

Apr 26

Dynamics Ax 2012 R3 Architecture:

Dynamics Ax 7 is now at door step. But still there are many things to explore Dynamics AX 2012.   Here I started again from basics from Dynamics Ax 2012 architecture.     Dynamics Ax 2012 is based on  Three tier Architecture consists of   Database tier. Application tier Presentation tier. Database tier: If you saw […]..Read More

Apr 22

Advance filter Dynamics Ax 2012 Similar to Like wildcard functionality

Today during development of inquiry form, I had chance to explore filters in little more depth. For example if you have to add functionality similar to wildcard like operator.   “Select * from customer where Customer.Name is like ‘%Ali%’ You have to use static functions  SysQuery::valueLike and SysQuery::ValueLikeAfter. For example If I had customer table […]..Read More

Apr 11

Fetching data from AX table using Query AIF service Dynamics Ax 2012 R3

We can expose AOT query as service which can consume in any WCF client. We can call and fetch data from any AX table,  without Static AOT query. For this purpose Dynamics Ax provide the methods to create a query at run time and call with Query service.   This Query service is built in […]..Read More

Apr 09

Fiscal year calendar and ledger calendar in Dynamics Ax 2012

In Dynamics Ax 2012, Fiscal year is common all the legal entities. They usually define in initial step of implementation. The length of Fiscal years is up to user how long he defines the length according to requirement. They are essential for financial reporting for particular company. Define the account period or begin and end […]..Read More

Apr 01

How to generate Entity relation diagram for specific tables in Dynamics Ax 2012

Recently I have to generate a ER-diagram for specific list of tables in Dynamics Ax.  Dynamics Ax has built in feature. Prerequisite of this article has Microsoft Visio.   Create a project for all tables which require in ER-diagram. For this article I  created a new project with Name customer Address and drop CustTable and […]..Read More

Mar 18

Step by Step guide to install Reporting extensions (SSRS) for Dynamics Ax 2012 R3

I was configuring Dynamics AX 2012 R3 reporting extension on one of Virtual machine. Here is my notes with step by step screen shot. First step to run step up and then add or modify component option. Click on next button and select reporting extension  form Click on next and from next window click on […]..Read More

Mar 14

Microsoft Dynamics Connector and installation and configuration step by Step

Microsoft Dynamics Connector and installation and configuration step by Step.   I configured the Microsoft Dynamics Connector on my local configured virtual machine where standard Microsoft Dynamics Ax 2012 R3 installed. Here are step by step and my notes   First step to run the setup form and choose add or modify component option   […]..Read More

Mar 14

Overview of Roles and career paths in Microsoft Dynamics Ax 2012 implementation

In ERP implementations different individuals perform different roles and work as team. These roles varies organization to organizations. I observer ERP consultants in following roles.   Functional consultant: These are unique individual, who usually expert in particular module of Dynamics Ax. They have day to day interaction with business user at client side. They responsible […]..Read More

Mar 10
Mar 03

Process Indicator in Dynamics Ax 2012

During one of my customization, I have perform a lengthy operation, during this process there is requirement to show process indicator, Code snippets I have found from https://msdn.microsoft.com/en-us/library/aa841990.aspx   For this method I have to create a process helper class and add following snippet its static method   static void operationProgress_progressBars(Args _args) { #AviFiles SysOperationProgress […]..Read More

Feb 28

split string in dynamics ax 2012

During one of customization scenario, I have come across to field which contains comma separated values. In C# and VB.net string.split method return into array of string. But in X++  split method return list. Following simple tip helps me to check that my required value exists in comma separated value. public boolean getValidateStudentName(String50 _splitString) { […]..Read More

Feb 25

Material from Microsoft Dynamics Ax Technical conference 2015

Material from Microsoft Dynamics Technical Conference 2015 is available for download. This material contains, Training manuals. PDF, Videos Power point presentations Hand on lab material. https://mbs.microsoft.com/customersource/northamerica/AX/learning/presentations/AXTechConf15PresentationVideos   For visiting this linking you must have partner source or customer source credentials.  ..Read More

Feb 23

Customer as offset account Dynamics Ax 2012 R3

During one of my customization, I have to transfer customer balance from one customer to another, for this purpose ledger entry for old customer as debit amount and other customer account set in offset account.   I used following code Snippet to achieve this functionality LedgerJournalCheckPost  jourCheckPost; LedgerJournalTable      jourTable;   AxLedgerJournalTable    header  = new AxLedgerJournalTable(); […]..Read More

Feb 22

Exploring the message box in Dynamics Ax 2012 R3

Message box are common tools that helps us show messages, results and Provide choices to preform actions or not. Here are some messagebox with examples.     Info box : this is simple box used to display any message other than warnings or error messages.   static void JobInfoBox(Args _args) { info (“Hello world”);   […]..Read More

Feb 18

Enable and Disable an Action Pane Button on grid row change Dynamics Ax 2012

This is very simple tip. That usually found that when we move record to record in list page, from top Action pane button enable or disable as result of this movement.  This functionality required one of my customization from. For example, I have to enable and disable button on action pane “BtnGenerateLine”  based on status […]..Read More

Feb 07

Date in Advance filter Dynamics Ax 2012

Consider we are going to build a Inquiry form, where we are applying different filter criteria’s. One of them is date time filter. Consider this post is second part of one of my previous post. Where we created filter on Sales line. http://tech.alirazazaidi.com/how-to-create-a-custom-filter-on-list-or-inquiry-form-in-dynamics-ax-2012/   For this filter add two utcdatetimeEdit control and set auto declaration […]..Read More

Feb 06

Custom lookup field with no exist join records dynamics Ax 2012

During customization I got requirement that in drop down or lookup shows those customer which did not have sales line. I handle this customization with the help of no exist join.  Code snippet is something like.     public void lookup() { Query query = new Query(); QueryBuildDataSource queryBuildDataSource, qbds, dsView; QueryBuildRange queryBuildRange;   SysTableLookup […]..Read More

Feb 04

How to create a custom filter on list or inquiry form in Dynamics AX 2012

During development we have to create custom inquiry forms. Or Form where we can  search and filter records on different criteria. Consider a scenario, where we have to build custom inquiry form for all saleline. In this inquiry or custom list form, we can filter on records on date, customer and amount or discount. Lets […]..Read More

Feb 04

Current language of client Dynamics Ax 2012

static void Job5(Args _args) { info(companyinfo::languageId()); }..Read More

Feb 01

How to get trade agreement price for An Item or for customer Dynamics Ax 2012

When we make trade agreement, there are 3 possibilities On some products we make discounted price for all Customers. On some products we make discounted for selected Customers All products have discounted or fixed prices for some customers. Third case is exceptional, but there is possibility that organization set sales prices on all items for […]..Read More

Jan 28

How to control events or method on the list page Dynamics Ax 2012

In dynamics if form is created by listpage template, it would not let you write any code on form level.   Best practices says that you have to wrote code in extended interaction classes. But what if we have to write simple method at form levels, For such cases  you can write events or method […]..Read More

Jan 25

No cost rollup is found for this item. Activate the item cost price

During posting a receive entry against purchase order I got following error for a product. “No cost rollup is found for this item. Activate the item cost price.” As understand there is no item cost activate in Dynamics Ax 2012 for this. For this purpose you have to go Product inform Management => Common=> Release […]..Read More

Jan 25

Product receipt against purchase order in Dynamics Ax 2012 R3

In this post I am going to create a new Purchase order and receive inventory against Purchase Order. My post against purchase order in Dynamics Ax 2012 are as follow. http://tech.alirazazaidi.com/how-to-create-request-for-quotations-in-dynamics-ax-2012/ http://tech.alirazazaidi.com/how-to-register-request-for-quotation-response-in-dynamics-ax-2012-and-its-convert-purchase-order/     First of all we create a Purchase order with single line. For this we have to go Accounts payable=>Area page=> Common=>Purchase […]..Read More

Jan 25

Dynamics Ax 2012 R3 Cu8 demo data download link

  Demo data file for Dynamics Ax 2012 R3 CU8 is available for download. You can download it from following link https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials To log on here you must have partner source or customer source credentials.  ..Read More

Jan 23

Todo is help us to remember the reason why we commented the code in Dynamics Ax 2012

Very interesting feature for developers in dynamics Ax 2012 comes from its legacy version is //Todo: come back here During development many times, we have to comment some code because it is unfinished or generate errors and we cannot generate CIL.  Later we forget where were we set commented lines of code because AX has […]..Read More

Jan 19

unable to save method … Dynamics Ax 2012 R3

I got error message ” Unable to save method init” during saving the form.   While surprising it gives no error on compiling the code. I also found some errors on classes too, I solved it by following way, possible it helps,    ..Read More

Jan 17

Using AXBuild for fast compilation in Dynamics Ax 2012 R3

We can compile with whole AOT in less time as compared to compilation in Mophix. From Dynamics Ax 2012 R2 cu7 and later a utility provided for this purpose. You can found AXBuild exe from this location. X:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin And compilation command is as follow. axbuild.exe xppcompileall /s=01 /altbin=”C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin” […]..Read More

Jan 16

How to check Dynamics Ax 2012 form is in edit mode

During development, I wrote code in clicked event of Button. But requirement is that code will works only if form is in edit mode. I used following code to check it   boolean _bool; supper(); _bool=   element.inViewMode(); if (_bool==boolean::true) { info (“true”); } else { info (“false”); } This  method element.inViewMode() return true when form […]..Read More

Jan 14

How to create a new module in dynamics Ax 2012

Go to Data Dictionary in AOT. Expand it and under configuration create a new configuration key. Suppose we are going to create Module name with CustomModule, so we create is configuration key with same name. If you have license key then enter it other wise left it blank. This approach with out licence key works […]..Read More

Jan 10

VendBankAccount and BankAccountTable address relation Dynamics Ax 2012

We can get address for VendBankAccount table and BankAccountTable by following way.   VendBankAccount  table has method which returns address VendBankAccount.addressing() ; For BankAccountTable you can use following query to fetch its address, both table has similar releationship with logistic location table BankAccountTable  _BankAccount; LogisticsPostalAddress _postalAddress; LogisticsLocation  _location; while select * from _BankAccount join * from […]..Read More

Jan 10

How to register Request for Quotation response in Dynamics Ax 2012 and its convert Purchase order

  In my previous post, we create and post a request for Quotation for two different vendors, http://tech.alirazazaidi.com/how-to-create-request-for-quotations-in-dynamics-ax-2012/   In this post I am going to register the response sent by vendors against request for Quotation.     By clicking on Request for quotation replies. A list page open, if you saw last two lines […]..Read More

Jan 08

How to create request for quotations in Dynamics AX 2012

  Consider a scenario, where your organization “USMF” (demo data legal entity), what to purchase items from Vendors. They have different vendors who can provide these items / services on different discounted rate. So USMF create a request Items with specific quantity and send these request to different vendors. When vendors receives these request they […]..Read More

Jan 04

File load dialog in Dynamics Ax 2012

Some times we have to load files into dynamics Ax. Following X++ code helps to load files in Dynamics AX. Dialog _dialog; DialogField _file; ; //Prompt to import excel _dialog = new Dialog(“Please select the file to load”); _dialog.addText(“Select file:”); _file = _dialog.addField(ExtendedTypeStr(“FilenameOpen”)); _dialog.run(); if (_dialog.closedOK()) { info(_file.value() ); }..Read More

Dec 31
Dec 28

Free text invoice in Dynamics Ax 2012 R3

A common question arises in my mind that such a detail sales order invoiced exists then why we need free text invoice. I found two detail answers with reference A free text invoice is an invoice that is not attached to a sales order. A free text invoice contains a header and one or more […]..Read More

Dec 23

Session Date and time in Dynamics Ax 2012

In dynamics Ax 2012, session date is appear in status bar. User can change it if required. If you want to change it you can click on it fil=> tools=> session date and time       On click it similar form will appear.   If session Date is not appear in Status bar, then […]..Read More

Dec 23

Dynamics Ax 2012 BACKUP LOG cannot be performed because there is no current database backup

After fresh installation on VM, we usually restored the database back of Production or QA server . And this technique usually applied in multi development environment. But yesterday I got this error when I tried to restore Dynamics AX database on my newly created Dynamics Ax 2012 VM. BACKUP LOG cannot be performed because there […]..Read More

Dec 19

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 […]..Read More

Dec 19

request for the permission of type ‘fileiopermission’ failed. dynamics ax 2012

During one of my development i got following error, which occurs when I try to convert image into bits and stored in tables. I solved this by adding before the code   FileIoPermission _perm; _perm = new FileIoPermission("c:\\File.txt",'r'); _perm.assert(); Reference: http://msdn.microsoft.com/en-us/library/fileiopermission.aspx..Read More

Dec 17

How to setup Government and organization Identification Types in Dynamics Ax 2012

In real world every person has unique identified number provided by Government of country or organization where he is working. For example if we talk about Pakistan every person either Applicant or worker has its unique CNIC (Computerized National Identity Card) or National Passport or NTN (National Tax Number).  And we have to store these […]..Read More

Dec 12

Microsoft Dynamics AX 2012 Demo VM V1 R3 CU8 available for download

Dynamics Ax 2012 R3 CU8 demo virtual machine, is available now.  You can deployed it on Azure services through Life cycle services. Dynamics Ax 2012 R3 CU8 has following new features.     You can download demo vm from following link through partner source or customer source credential   https://mbs.microsoft.com/partnersource/uk/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials#MicrosoftDynamicsAX2012R3CU8SolutionDemoPackageV1.0     Original post: http://www.jaestevan.com/microsoft-dynamics-ax-2012-r3-cu8-demo-vm-v1..Read More

Dec 10

Product Management in Dynamics Ax 2012 R3 Part 2

In previous post I just create an Item product without its variant and released it to required legal entity. http://tech.alirazazaidi.com/product-management-in-dynamics-ax-2012-r3-part-1/ But product required one more step to finalize it before used in sales or purchase.   Item group Item module group. Storage dimension. Tracking dimension.       For this purpose you have to go […]..Read More

Dec 09

Product Management in Dynamics Ax 2012 R3 Part 1

  In Dynamics Ax 2012, there is separate module  made for product management. There are two types of products in Dynamics ax. Product. It is bare bone and independent product no further variation is not possible or required. Product Master. When same product has different variant for example if we consider the hair color product […]..Read More

Dec 02

Fatal exception performing AXRDCE transformation step. Dynamics Ax 2012 R3

During development of SSRS  report I got follow error,   “Fatal exception performing AXRDCE transformation step. The report cannot be rendered. Please contact your system administrator.”   and report stop working, It working perfectly write a few hours ago. The old trick works for me. Comment all the code in processReport method of RDP class, by […]..Read More

Nov 26

How to enable document attachment in Dynamics Ax 2012

  By default document attachment is not enabled on every table. To enable document attachment you have follow following links Organization administration > Setup > Document management > Active document tables.   Search and add required table ie, custTable,VendTable,hrmRecuritmentTable,hcmApplicant, hcmApplicantion in “Table name” drop down and click on check box “always enabled” and Press Ctrl+S for save   Hopes this works..Read More

Nov 25

Import Export data: Excel Add-ins with AIF service Dynamics Ax 2012

  If you set up Aif service data in Dynamics Ax 2012, You can easily import and export data into AX using Excel Add-in.  You can export, import data with all out of the box AIF services.  In the case of table import export in Excel add-ins then under the hood AIF metadata service used. […]..Read More

Nov 23

Dynamics Ax Excel Add-Ins not visible in Excel

Some times after successful  installation of Dynamics Ax office Add ins, Add-in does not appear in Excel. To Enable Dynamics Ax Excel Add-ins. Click on Options in Excel. Open it and select Ad-ins.   Now from down manage and select com Add-ins and click on go     Select check the “Microsoft Dynamics Ax Add-in […]..Read More

Nov 23

Setup data source for excel add ins Dynamics Ax 2012

For accessing AIF service and custom Query, We have to set up the data source in AX, Later these data sources are available in Excel add in.   From Organization Setup Area page. Then setup, Document management and Document Data Sources setup.         Select module for example “Account Payable”, from data source […]..Read More

Nov 23

Dynamics ax 2012: excel add-in publish data button disabled

Currently working with Excel add-in importing data into Dynamics Ax, I found that publish data is disabled,     Latter I found that push, status, add Row, delete row and other button remains disabled until you closed the field selection by re click on field’s button.  ..Read More

Nov 20

How to download Latest Updates from Microsoft Life cycle services for Dynamics Ax 2012

  Login to https://lcs.dynamics.com/ with your CustomerSource or PartnerSource credentials. Open the existing project, if you have no project then created a new project.  For example I have Project. Click on it and open it.   From next screen. At button you find updates. Next window you will find latest updates listed. For Example yesterday […]..Read More

Nov 18

Invalid attempt to call DocuActionArchive.Add running in CIL on the client. Dynamics Ax 2012

  A few day ago I shared a code about to document attachment. http://tech.alirazazaidi.com/document-attachment-through-x-code-dynamics-ax-2012-r3/ This code  works fine at client side, but in runbatchjob (batch process) run at server side It threw following error.   “Invalid attempt to call DocuActionArchive.Add running in CIL on the client.” This is because in Add method winapi is used. […]..Read More

Nov 18

Dynamics Ax 2012 Enterprise portal Architecture

  Following is architecture diagram I  took from white paper.       You can download white paper from following link. http://www.microsoft.com/en-us/download/details.aspx?id=30171     Enterprise portal is based on Standard flexible ASP.net controls used in web parts and Share point portal. Dynamics Ax 2012 serve  as data source. These data sources are written in X++ […]..Read More

Nov 15

Exploring proxy classes in Dynamics Ax 2012 R3

  In C# or vb.net we can connect and perform on Dynamics Ax classes and Tables with business connector. This technique is widely used in Dynamics Ax 2009 and rarely I saw these used in ax 2012. Its depends on Requirement. Consider following scenario where  I have to perform different operations on following custom table. […]..Read More

Nov 13

My Custom Batch class in not appear in task list ?

  If you consider my last post about creating, deploy and debug the custom batch job In Dynamics Ax 2012. http://tech.alirazazaidi.com/exploring-the-batch-job-process-in-dynamics-ax-2012-r3/   I used X++ job to deploy the batch class as batch process.  But if we have to provide functionality that any person can schedule the class as batch from Dynamics Ax front end. […]..Read More

Nov 13

Exploring the Batch Job process in Dynamics Ax 2012 R3

  There are many scenario where we have to schedule the tasks, so they execute in background. Real world scenarios are Sales order with certain criteria will update status to Invoiced. Scheduled job check the file location to find comma delimited files and after finding create sales order or purchased orders in Ax. Schedule job […]..Read More

Nov 07

Document Attachment through X++ code Dynamics Ax 2012 R3.

During development there is requirement to import attached form physical location and shown in attachment to Dynamics AX.   I found X++ snippet from following links http://theaxapta.blogspot.com/2013/04/x-code-for-document-attachment.html http://microsoftdax.blogspot.com/2012/06/x-code-for-document-attachement-in-ax.html     In Dynamics Ax 2012 there is one table and one class which are responsible for holding and load document from file location and copied it […]..Read More

Nov 06

Custom fields shows as un retrievable on Dynamics Ax 2012 Forms.

Today I was facing the same Issued, I added a few custom fields in AX table. After update data source and dropped custom field at required Place on form. When I run the form, I found that field showed as un-editable and unretrievable written there.   I found that it is cache problem. It solved […]..Read More

Oct 29

How to find next value from sequence number when sequence number reference not in parameter table.

Many times we have to generate and assign sequence number in X++. And usually we find attached sequence number form Parameter tables.  We can get customer through following X++ code   NumberSeq     _sequence; ttsBegin;   _sequence = NumberSeq::newGetNum( CustParameters::numRefCustAccount());     info((_sequence.num())); info(_sequence.Num());     info((_sequence.num()));   ttsCommit;   But sometimes these reference methods did not available […]..Read More

Oct 28

system does not support setup ‘continuous’ of number sequence in ax 2012

During creating and assigning Sequence number in X++ code, I found this error continuously. Later i found that getting and assigning next sequence number should be  written inside transaction block. for example ttsbegin; itemId = NumberSeq::newGetNum(InventParameters::numRefItemId()).num(); ttscommit;..Read More

Oct 25

How to get exception detail and log into SysExpectionTable. Dynamics Ax 2012

When we are working with Document Aif services, any exception is logged in SysExceptionTable. You can excess these details from following link. There is client requirement that all exception must be log in SysExceptiontable in custom service. I did this with the help of following code snippets which just log the division by Zero exception […]..Read More

Oct 22

Handling null values in dataset and DataReader in Dynamics ax 2012

  In X++ we can use System.Data.SqlClient.SqlReader or System.Data.DataSet, to Query on external database. But unfortunately there is No isDBNull function available for checking the null and same time system.string().isnullorempty and CLRInterop::Null is not work.   If you are using dataset or datatable then use datarow’s is null method For example   If (!DataRow.isNull(“FirstName”) { […]..Read More

Oct 20

execute stored procedure with parameters dynamics ax 2012

During in one of my assignment, I have to call sql server stored procedure from X++ code. There is little tricky to call stored procedure with parameters. Following code will help me to call stored procedure with Parameters. Consider sp_StudentCreates a stored procedure with three parameters, first two string and last one is date. private […]..Read More

Oct 18

Connect to an external Database from Dynamics Ax 2012

Sometimes we have to communicate with outside of Dynamics Ax with in boundaries of Dynamics ax. Consider following scenario where I have to communicate with StudentDb in Sql server and insert rows in Student Info. We can do this with odbc connection.     Now create New AX job and paste following code there   […]..Read More

Oct 14

Exploring Dynamics Ax function that convert Numeric value into words

During exploring the question posted on Microsoft community AX fourm, I found about a global method, which converters numeric values into words. static void Job_AmountInWords(Args _args) { info(numeralsToTxt(420.420)); }  ..Read More

Oct 13

Repeat the column header row on every page Tablix SSRS dynamics Ax 2012

During SSRS report for Dynamics Ax 2012, I found that when report goes on multiple pages, column header did not appear all page except the first one. I fix this problem by setting some properties to true.   Select the tablix and below right side of columns group header and click there on small arrow […]..Read More

Oct 12

Unable to find appropriate service endpoint information in the configuration object Dynamics Ax 2012.

Recently installed the SSRS report extension on my VM Dynamics Ax 2012 R2 CU7. During installation, I continuously found following error message In log files.   “Unable to find appropriate service endpoint information in the configuration object” Later I understand that SSRS reports communicate with AOS through WCF services and WCF service for Dynamics Ax […]..Read More

Oct 12

Vendor Reasons Lookup

In Dynamics Ax 2012, you can create Vendor Reasons, These reasons helps to describe codes used to against the vendor, vendor transaction and vendor task. A reason code is used to justify the why change or transaction occurs. You can find Vendor reasons in Account Reasonable Area Page.     You can add vendor reason […]..Read More

Oct 10

Exploring The SalesSalesOrderservice AIF Document Service In Dynamics Ax 2012 R3

  For my session for Integration with Dynamics Ax 2012. I have to consume SalesSalesOrderSerivce. In this article I am configure and consume Sales Order service and share c# code for calling a Sales service and consume.   Enable the methods and configure the inbound port. For this you have to go at following link […]..Read More

Oct 10

Integration with dynamics Ax 2012 Session PPt and pictures.

I did a session on Dynamics Ax 2012 at Lahore Microsoft Invocation Center at 30 September 2014. Session was wonderful. Much better the previous one, I am special thankful to Software gurus from various software companies join this and especially for Microsoft Invocation Center Management team that help me to conduct this session.     […]..Read More

Oct 10

List of functions used in Dynamics AX 2012 SSRS Reports Expressions

During working in SSRS reports I have to handle division by Zero error for calculating accumulated cost by dividing Amount by Quantity.   This expression works for me.   IIf(Sum(Fields!xyz.Value) = 0, “N/A”, Sum(Fields!abc.Value) / IIf(Sum(Fields!abc.Value) = 0, 1,Sum(Fields!xvz.Value))) I did little research on Expressions and function used in these SSRS expressions     Expressions: […]..Read More

Oct 08

List as data contract in Custom AIF service Dynamics Ax 2012

During writing one of custom AIF services, I had requirement to get and set List of certain class type. For exampel Contact list if we have to import Customer or vendor, I found following syntax for attribute to make List as data contract. [DataMemberAttribute(“MyContactList”), AifCollectionTypeAttribute(“contactList”,Types::Class, classStr(ContactDC)), AifCollectionTypeAttribute(“return”,Types::Class, classStr(ContactDC))] public List parmMyContactList(List contactList =_contactList) { _contactList […]..Read More

Sep 22

Dynamics AX Client freezes and goes to Non Responding State

On my local R&D environment, Usually Dynamics Ax client goes on freeze state, especially on first run of Ax client after restart of VM. Finally I found there is issue with ax cache file. I delete the all files with extension “.auc” files from C:\users\userName\appdata\local. After I run the Client, it load in much less […]..Read More

Sep 18

Master Data Management Framework for Dynamics Ax 2012 eLearning course link

Recently we used Master Data Management Framework in Dynamics Ax 2012 for Initial load.. I found that Microsoft release the course on its partner resource. This course contains following topics • Module 00: Course Introduction and Expert Introduction • Module 01: Overview of Data Management • Module 02: Introduction to Data Import Export Framework • […]..Read More

Sep 17

“Wrong field ID in the key data container in entity key” Dynamics Ax 2012 AIF

I got following Error when I called the Read method of Dynamics Ax AIF service. “Wrong field ID in the key data container in entity key”     My code snippet is as follow and I did not found anything wrong with it. StudentInfoRef.KeyField keyField = new StudentInfoRef.KeyField() { Field = "FirstName", Value = "Ali2" […]..Read More

Sep 15

Creating and consuming Custom Document Service in Dynamics Ax 2012 R3

For one of Presentation on AIF, I build a custom Document Service based on custom table. To avoid any validation constraints I made a very simple custom table “StudentInfoTable”. FieldName dataType Roll Number string FistName string LastName string Address string DateOfBirth date.   Create a Unique Index on FirstName field, so Read and find method […]..Read More

Sep 12

ENUM values missing in SRSANALYSISENUMS Table

During one of assignment, I have to get some data directly from Dynamics Ax table in SQL Server. All enum based column in table shown their numeric values in Sql Server. For Analysis services Or OLAP services Dynamics Ax holds a table with name “SRSANALYSISENUMS”. This table contains the all enum which are used inside […]..Read More

Sep 09

Dynamics AX2012 R3 – Virtual Machine download links

Hello everybody! Form the following links you can download the Microsoft Dynamics Ax2012 R3 with Demo data.   CostumerSource https://mbs.microsoft.com/customersource/northamerica/AX/downloads/service-packs/AX2012DemoToolsMaterials   PartnerSource https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials   Enjoy to discover numerous new features included in this new version!..Read More

Sep 09

How to get data from those AX tables which are not appear in SQL server

During customization in Dynamics we usually check that what data store in Tables. For this I am more found of using SQL server then using table explore in AOT.  When we upgrade code from Dynamics Ax 2012 to R2, We found that many tables did not appear in SQL Server. Examples are EcoResProduct , BankLCImport […]..Read More

Sep 08

Dynamics Ax View :You are not authorized to access table. Contact your system administrator.

Yesterday, I got error when I run the view which created on “” table  in Dynamics Ax 2012 “You are not authorized to access table ‘VBankLCImport’ (VBankLCImport). Contact your system administrator”. Error was misleading because in development environment User have full access rights. And this error is not appear while running any view. I also […]..Read More

Sep 04

Currency exchange rate setup in Dynamics AX 2012

  We can create transaction entries in different currency. For Example default currency set of Legal entity is “USD” and we have to create Purchase Order in Pak Rupees. For this purpose we have to create exchange in Dynamics Ax. The link of currency exchange is Ledger module, in Setup section and under currency. You […]..Read More

Aug 27

How to Use AX Form As lookup in Dynamics Ax 2012

Consider a scenario where, I required a StringEditControl and Clicking on Control a lookup is open where the list of Customer of selected Legal Entity are available. And After Selecting required Customer, Customer Id Or AccountNum is return form Lookup form.   For This purpose we have to create form, which will used as look […]..Read More

Aug 21

Import Export Model with Dynamics Ax 2012 R3

As per my understanding for commands, Examples are more easily understand and quick solution instead of syntax.   For model store export/import we have to use Dynamics Ax Management Shell. You can find “Dynamics Ax Management Shell” at  All Programs, Administrative Tools and Microsoft Dynamics Ax Management Shell.       Export Command Syntax  (Windows […]..Read More

Aug 19

How to clear inactive sessions from Dynamics Ax 2012

If you check the online user in Administrator Module, You may be found some session with inactive and block status. These inactive and block session are due to crashing of AX clients. These sessions are not create any problem, but possible issues with limited number of active users under Dynamics Ax license. Best approach to […]..Read More

Aug 15

Dynamics Ax 2012 R3 System Requirements

System Requirements for Microsoft Dynamics Ax 2012 R3 Updated by Microsoft. For this purpose Microsoft uploaded a new document , you can download it from this link http://www.microsoft.com/en-pk/download/details.aspx?id=11094..Read More

Aug 15

How to get Standard SQL out from Query Object in AOT?

We can get standard sql from AOT Query object through X++ code. Following X++ Code used to get Standard Sql out of EcoResProductListPage   static void Job2(Args _args) { Query query; query = new Query(queryStr(EcoResProductListPage)); info(query.dataSourceNo(1).toString()); }  ..Read More

Aug 13

Book “Inside Microsoft Dynamics Ax 2012 R3” is now available

Updated version for “Inside Microsoft Dynamics Ax 2012” is now out. It is updated for AX 2012 R3 version. What’s new : It include a new chapter about developing companion apps. It include a new chapter about application life cycle. A new sections about LINQ support and print management.   You can purchase inline from: […]..Read More

Aug 10

Clear the Cache on all clients Dynamics Ax 2012

Last week I post a solution to problem of old code on Dynamics Ax 2012 Client, That work for single client and it is not possible to clear cache on manually on every client. Later I found better solution to reset the client cache at AOS. Reference is http://thwidmer.wordpress.com/2010/05/19/reset-program-cache-file-for-all-clients/ According to that reference we have […]..Read More

Aug 05

Little bit taste of List In Dynamics Ax 2012

In Dynamics Ax List is used as collection, You can add , remove or update elements in it. Type of list is define at the time of its declaration and cannot be change after initialization. We can iterate in List with the help of ListIterator object, which have several methods to process on list. List […]..Read More

Aug 05

Dynamics Ax 2012 Error Code 90, Unable to connect to database

My friend Bashir Ahmad Malik got following error during start up dynamics Ax service.   “The Microsoft Dynamics AX Object Server 6.2$01-MicrosoftDynamicsAX service terminated with service-specific error Code 90. Suspect state of SQL Server database is a state when you are unable to connect to the database. “   During trouble shooting we find following […]..Read More

Aug 03

Dynamics Ax 2012 Client cache problem

A few days ago, I was working on Dynamics Ax 2012 customization. When I shifted code to QA server, Compile, Generate CIL, but no changes display on client. I was shocked, latest code working fine on my machine but why it is not working on QA server. AOT shows the latest code. During troubleshooting I […]..Read More

Jul 27

Getting Count in X++ using Select statement

Hi, You can get Count X++ select statement as   /// <summary> /// Get resource poool count. /// </summary> /// <returns> /// resource pool count. /// </returns> protected int getResourcePoolCount() { select count(Rank) from resourceTable where resourceTable.UserSession == _userSession && resourceTable.ResourceSet == ProjResourceSet::Pool; return resourceTable.Rank; }..Read More

Jul 20

Install and configure Analysis Services for Dynamics AX 2012 R3

If analysis services are not deployed on machine, then deployed it and select analysis services from sql server installation wizard.   After installation, Please verify that sql server analysis services are running in services.       Run the Dynamics Ax 2012 R3 setup to install the Analysis services component.       Validate the […]..Read More

Jul 14

Little helpful X++ editor extensions for Dynamics Ax 2012 R3.

During search I found link codeplex for X++ extension, freely available Extensions at CodePlex by  José Antonio Estevan Estevan. This extension helped me to identify Starting and ending of brackets. – Collapse and un-collapse sections wrapped with {- and }-brackets. Highlight the all occurrence of keyword in method similar to  NotePad++ Installation of this extension […]..Read More

Jul 01

How to integrate Dynamics AX 2012 R3 AIF Document Service with BizTalk server

Purpose: Purpose of this post is help to Consume AIF Document service in BizTalk and call its method. Assumption: that target audience has deep knowledge of BizTalk, mapping, schema and orchestration.   First of all you have to create service group that is gateway to your document service. For this post I have to consume […]..Read More

Jun 23

Exploring Drill-down SSRS Reports in Dynamics Ax 2012 R3.

Drill drown reports in Dynamics Ax 2012 R3 are very Easy. For this purpose I have to create a new AOT/Static Query AOT. This query is join between CustTable and SalesTable. I want to create Inner Join so Only those Customer came who have Sales Orders. Consider following Steps to create A new report Create […]..Read More

Jun 23

Exception has been thrown by the target of invocation in dynamics Ax

Exception has been thrown by the target of invocation in dynamics Ax. I got this error on my VM. On closely examination, I found that In AOT Data dictionary is not synchronize with Sql Server . I perform following steps to resolve this error • Right click on data Dictionary and synchronize the data Dictionary. […]..Read More

Jun 21

Exploring Report Controller class in dynamics AX 2012 R3

In Dynamics AX 2012 Reports can be called from Class, and it is import part of MVC pattern implementation for reports The report created from following link is called from controller class http://tech.alirazazaidi.com/exploring-drill-through-reports-in-dynamics-ax-2012-r3/ Create a new class and extends it with “SRSReportRunController” class. Add New method, and update it with following code public static void […]..Read More

Jun 19

Exploring Drill through Reports in Dynamics Ax 2012 R3.

Creating basic drill through reports in Dynamics Ax 2012 R3 is really simple. Consider following scenario where we have to show the list of customer and their sales Orders in particular legal Entity.  In this report when User click on customer account, a new report open which contains list of all possible sales Order. For […]..Read More

Jun 13

A call to the Microsoft Dynamics AX SRSFramework Service failed.

Today while deploying Dynamics AX 2012 R3 SSRS reports on window 7 I got following when I run Report deployment command on publish-AXReport -ReportName *. “A call to the Microsoft Dynamics AX SRSFramework Service service failed. An existing connection was forcibly closed by the remote host.“. I perform following steps to solve this problem. 1. […]..Read More

May 31

Dynamics Ax 2012 Development Overview session

PowerPoint and pictures taken during Session at Lahore MIC on the topic of MS Dynamics Ax 2012    ..Read More

May 25

SQL Server 2012 Reporting Services UAC (User Access Control)

While configuring Reporting server with Dynamics Ax 2012 R23, I got error that Dynamics Ax 2012 R3 did not validate the Reporting Server. On Opening reporting server in Browser I got following error. “User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have […]..Read More

May 18

List of framework in Dynamics Ax 2012

There are a lot of frameworks in Dynamics Ax 2012 a Few of them listed as follow.                 Address Book                 Application Integration Framework (AIF)                 Budget Control framework           […]..Read More

May 09

Exploring the Navigation layout of Dynamics Ax 2012

Above picture is taken from following link http://blogs.msdn.com/b/microsoft_press/archive/2012/10/25/new-book-inside-microsoft-dynamics-ax-2012.aspx Role center is user page; appear on opening at Dynamics Ax. The role center is depending on rights and role of user. Role center provide dashboards, which helps to user to monitor their roles. This information includes transaction data, alerts, links and common tasks that are associated […]..Read More

May 03

How to import Contoso Demo Data to Dynamics Ax 2012 R3.

The setup contoso demo data for Dynamics Ax 2012 R3 is different from previous version. I remember, I used .dat file to load demo data into Dynamics Ax 2012 R2. Now DynamicsAX2012R3DemoData.exe available partner Resource. DynamicsAX2012R3DemoData.exe extracted files round 15 GB. Extracted folder contains three types of files. According to MSDN Xml (A bcp data […]..Read More

Apr 27

Different Sections of Dynamics Ax 2012 forms

Dynamics Ax forms is divided into different section. Pictures worth thousand words.  ..Read More

Apr 26

AX 2012 – Unable to write the generated WCF configuration to local storage

  I found following log entry in event log, Unable to write the generated WCF configuration to local storage. The generated WCF configuration will be used from memory. The contents of the new configuration are written to the following temp file: C:\Users\i<BC Account> \AppData\Local\Temp\Microsoft.Dynamics.AX.Framework.Services.Client.Configuration.ClientConfigurationInternal.log. Exception details: System.ComponentModel.Win32Exception (0x80004005): Access is denied at Microsoft.Dynamics.AX.Framework.Client.ConfigurationModel.NativeRegistry.OpenNativeRegistryKey(String keyPath, Boolean writable) […]..Read More

Apr 17

Microsoft Dynamics AX 2012 Xpp – Sales Orders Import

I am sharing the excellent article of Alex Anikiev, PhD, MCP  about import Sales order in X++ code with article link Purpose: The purpose of this document is to illustrate how to write a required minimum X++ code in Microsoft Dynamics AX 2012 in order to import Sales orders. Challenge: Data model changes in Microsoft Dynamics AX […]..Read More

Apr 08

Functional side Training of new features of Dynamics Ax 2012 R3

Recently I found the training session for new features of dynamics Ax 2012 R3 on Channel 9 website. The important features of Dynamics Ax 2012 R3 are Warehouse management and Transportation management.  Presenters described these feature in brief and very precisely.  You can explore these features on below link of Channel 9. http://channel9.msdn.com/Series/Microsoft-Dynamics-AX-2012-R3-Training..Read More

Apr 04

What’s New In dynamics Ax 2012 R3.

I just saw the R3 demo VM. There is Lot of new features.  The major feature Include Forecasting. Budgeting Transportation management A wireless client for warehouse. Retail Module has number of changes. Let’s see small detail which I just collected.   Demand Planning – New Sales Forecasting Tool In Dynamics AX 2012 R3 a new […]..Read More

Mar 20

Microsoft Dynamics AX 2012 Xpp – Products Import

Purpose: The purpose of this document is to illustrate how to write X++ code in Microsoft Dynamics AX 2012 in order to import Products and Released products. Challenge: Data model changes in Microsoft Dynamics AX 2012 related to high normalization and introduction of surrogate keys made some imports more complex. In order to create a product in […]..Read More

Mar 18

Some important Order tables in Dynamics Ax 2012

  CustGroup – The CustGroup table contains a list of groups into which customers can be added. Every customer must specify a CustGroup with which it is associated. VendGroup – The VendGroup table contains definitions of vendor groups. CustTable – The CustTable table contains the list of customers for accounts receivable and customer relationship management. VendTable –  The VendTable […]..Read More

Feb 25

Simple Query Based Report in Dynamics Ax 2012

The SSRS reports need a data source from where data can be fetched and displayed on the report. Since we are going to develop query based report therefore we will use an AOT query as a data source. For creating report, First we have to create A AOT Query. For this we have A simple AOT […]..Read More

Feb 22

Customer Form run from Job

Here is the code in X++: public static void CustomerForm(Args _args) { //Initialization DictTable dictTable; DictTable dictTable1; Form form; FormBuildDesign design; FormBuildDataSource formBuildDataSource; FormBuildDataSource formBuildDataSource1; FormBuildActionPaneControl actionPane; FormBuildActionPaneTabControl actionPaneTab; FormBuildButtonGroupControl buttonGroup1; FormBuildButtonGroupControl buttonGroup2; FormBuildCommandButtonControl CommandNew; FormBuildCommandButtonControl CommandDelete; FormBuildMenuButtonControl CustomerButton; FormBuildFunctionButtonControl NewCustomerButton; FormBuildFunctionButtonControl ForecastButton; FormBuildGroupControl Grp; FormBuildGridControl grid; FormBuildGroupControl grpBody; Args args; FormRun formRun; #task //Adding […]..Read More

Feb 16

Create and post Vendor Invoice Journals X++ Dynamics Ax 2012

Create and post Vendor Invoice Journals from code as follow. static void createVendorInvoiceJournal(Args _args) { LedgerJournalCheckPost jourCheckPost; LedgerJournalTable jourTable; AxLedgerJournalTable header = new AxLedgerJournalTable(); AxLedgerJournalTrans trans = new AxLedgerJournalTrans(); container offsetDim; // The AP invoice journal name, could vary. LedgerJournalNameId ledgerJournalNameId = "AP"; // This is the entry against the Vendor account. // It will […]..Read More

Feb 13

How to extract all customer in X++

A year ago, I have to write a custom AIF service, where I have to extract All customer in Particular Legal Entity. For this purpose I have to create data Contract Classes and then these populate them and return from Service. The Customer Extraction on AIF will done on Customer Table level. But Address and […]..Read More

Feb 10

Restart Ax 2012 Services via the command line

AOS services can be start or stop through command line. Similar other services, One way to make .bat files and run them. net stop “” net start ““ So restarting the AOS service named AOS60$01 would be: net stop AOS60$01 net start AOS60$01 You can determine the service name by going to Control Panel -> […]..Read More

Feb 09

Vendors and Vendors look ups list in Dynamics Ax 2012

Creation of Vendor in Dynamics Ax 2012 is very easy. There are too much options available which can be used as per client customization. My background is technical side, so during development and testing links to these looks is too much time consuming. There are two ways to create values for these lookups. One way […]..Read More

Jan 20

Exploring the Functional Side of Dynamics Ax 2012: How to create Legal entity.

Today I decide to start Exploring the functional side of Dynamics AX 2012. The starting point certainly to create legal entity and explore the further options. To Create a legal entity you have to open the legal entity form by the following link Organizational Administrationè ==>Organization==>Legal Entities. To create a new legal entity click on […]..Read More

Jan 13

Power script commands and Dynamics Ax 2012 SSRS reports.

When you install dynamics Ax 2012, default reports automatically deployed. But sometimes we have to deployed the reports manually. Dynamics Ax provides build in PowerShell commands to perform various operations. For testing these commands, you have to run Power shell Management Shell as Administrator.   $reports = Get-AXReport -ReportName * $reports   Above power shell […]..Read More

Jan 09

Organization Model framework overview In Dynamics Ax 2012

Every organization which is small or large, have some sort of organizational structure. For example in a large organization it is possible that company have several sub-companies and then they have departments, then sub departments and they have the people in department. Like other ERPS, Microsoft Dynamics AX provides the Organization Model framework and functionality. […]..Read More

Jan 05

Short introduction to AIF framework

Usually we have to communicate with external systems with Dynamics Ax. In many business Scenario, Data is imported from other application or export form Dynamics Ax to external system. For Data Export or import Microsoft provide AIF or application Integration Framework. Consider the following Business scenarios in which Microsoft Dynamics Ax accesses information that is […]..Read More

Jan 04

Unable to log on to Microsoft Dynamics AX” error message when opening the AX client”

Currently somehow the other I was unable to log on my local vm, and I used another user to log on and try to connect with dynamics Ax. I got the Error “Unable to log on to Microsoft Dynamics AX” error message when opening the AX client” On Searched found that have to made User […]..Read More

Jan 03

Happy New year , Hope this year will bring more success in world of Dynamics Ax

  A little bit late , I was busy house shifting so Internet breakdown. For me, 2013 has been a great year. It has been full of new experiences that lead me to become a better person and also a much sharper professional. I’m grateful about all that I went through, and the people I […]..Read More

Nov 14

Dynamics Ax 2012: How to duplicate the existing report for modification

I got task to extend the existing dynamics ax SSRS report. Client also wants to sustain the existing report. They want a new report that will be replicate the original one with extended features. Data provider classes are easily duplicated by right clicking on it and select duplicate, I renamed the duplicate classes in AOT. […]..Read More

Nov 13

SSIS Vs BizTalk which is best tool for integration/migration with Dynamics Ax

During last couple of years, I have integrate data with Dynamics Ax both with SSIS and BizTalk. I common question is asked to me what is difference when every thing is possible in SSIS why we need BizTalk or what BizTalk provide different from SSIS. So My answer to this question is something like Everything […]..Read More

Nov 10

Dynamics Ax 2012: How to Edit the Existing Report.

In Ax Dynamics usually work is pop out regarding customization of what is existing In Dynamics Ax. Usually is one of them is Report customization. If you are new in Dynamics Ax, Report locate and open mode will create more headache then modifying it. Let’s explore what steps require to open report in Edit Mode. […]..Read More

Nov 04

Entity Relationship diagrams of Dynamics Ax 2012 Tables

Today I found the link on Microsoft website, where they upload the Entity Relationship diagrams for dynamics Ax 2012 table. Module Name       ERD Link       Module-Tables Link       Parent-to-Child Link Accounts payable ERDs Module-Tables Foreign Keys Accounts receivable ERDs Module-Tables Foreign Keys Budgeting ERDs Module-Tables Foreign Keys Cash and bank management ERDs Module-Tables Foreign […]..Read More

Nov 04

Dynamics Ax 2012: Configuration of basic Setup or basic company data in Dynamics Ax 2012

Recently I made a new Virtual machine for dynamics Ax 2012. The issue was the VM was clean, no legal entity and no step up data present in it. Purpose of making this virtual machine is to study functional side of dynamics Ax 2012. On Searching start up data, I found excellent article by MVP […]..Read More

Oct 26

Microsoft dynamics ax 2012 development introduction part 2/3

Microsoft dynamics ax 2012 development introduction part 2/3 from Ali Raza Zaidi..Read More

Oct 20

Microsoft dynamics ax 2012 development introduction part 1/3

My Presentation on Dynamics AX 2012 Development Introduction. Microsoft dynamics ax 2012 development introduction part 1/3 from Ali Raza Zaidi..Read More

Oct 19

Dynamics Ax 2012 : “Only integrated security is supported for AX queries.”

Recently I update my dynamics Ax development Environment by restoring Database from Production Dynamics AX Db. After the restoring the database, when I run any  SSRS report form Dynamics Ax, it  starts to give error  “Only integrated security is supported for AX queries.” The reporting Services are working perfectly other than Dynamics Ax reports. One […]..Read More

Oct 01

What makes a good Dynamics AX Project Manager?

On Google search i found very beautiful png file belongs to cognitive group. It will really help for me and for others. It belongs to other, but i like to share it with reference of owner, http://www.cognitive-group.com/blog/ax/what-makes-a-good-dynamics-ax-project-manager-with-infographic..Read More

Sep 22

Sending Email using X++ code Dynamics Ax 2012

In Dynamics Ax 2012, there is form for configuration parameters. There parameters will further use in sending email. Following is the path of Step. System Administrator è step upè Email parameters   These value stored in Dynamics ax 2012 table SysEmailParameters you can get these values by querying on this table using X++ code.   […]..Read More

Sep 11

Dynamics Ax 2012: Number of tables in Dynamics Ax 2012

While working, the question aries in my mind, how many tables and view exists in default dynamics Ax 2012, with out any customization. I queried on Microsoft Dynamics AX database in Sql server SELECT count(*)NumberOf,table_type FROM information_schema.tables group by table_Type I found 3198 base tables and 477 Views. Happy Dynamics Ax development...Read More

Jul 01

Dynamics Ax 2012 : Exploring Data Base logging for Insert ,Update and Delete

Dynamics Ax 2012 provide the functionality to log insert update and delete functionality on table as well as selected filed of a table. When tracking on any table in dynamics Ax, a new entry will be created in sysDatabaselog table. Inside database logging required table will find with the help of label of function. For […]..Read More

Jun 11

Dynamics Ax 2012 : Number of months between two dates

Recently I got small problem to calculate no of months between two dates. Dynamics Ax 2012 provides a default function which calculates no of intervals between two dates based on enumeration. int intvNo(date input_date, date ref_date, int func)   You can use it as   noOfIntervals = intvNo(refDate, inputDate, intvScale::Month);   intvScale enumation have two […]..Read More

Jun 03

How to upgrade evaluation version of SQL server 2012 with product key?

Two months ago I was install on SQL server 2012 evaluation version on my development machine, Today client provide me the product key to upgrade the SQL server 2012 to enterprise edition.  I perform following step to complete this process.   Launch the SQL Server Installation Center from Configuration Tools.   Click Maintenance, and then […]..Read More

Feb 24

Dynamics Ax 2012 : Exploring the Cross company Queries in dynamics Ax 2012

Recently one of my assignments, I have to explore and use Cross company queries to fetch data. Although cross company queries have performance overhead, for example, if my custom AIF service return result in 4 seconds , Cross company returns in 30 seconds.  I found multiple design pattern,  The fastest  cross company query are by […]..Read More

Feb 10

Dynamics Ax 2012 : Exploring the Containers

In Dynamics Ax there is structure known as containers. Here are some points for Containers They are value based structure. So no class based object stored on it. They are similar to linked list or array like structured. Their size fixed at time of declaration. When you insert update or delete any value from container, […]..Read More

Jan 29

Dynamics Ax 2012: Very simple report in dynamics ax 2012

There two common and mostly used ways to develop reports in dynamics Ax 2012 Query Report data Provider.   Here we have to create a very simple report using AOT query. For this purpose I have create a custom table Student with 4 fields as Rollnumber First Name Last Name Address The sample data in […]..Read More

Jan 28

Dynamic Ax 2012: Complete guide to Dynamics Ax 2012 Reporting

Hi folks, Today i am searching for sample to write a blog entry for Ax deport development, i found very informative link at msdn which covers all portions of report development in Ax 2012.   http://msdn.microsoft.com/en-us/library/cc653472.aspx     Regards Ali Raza Zaidi..Read More

Jan 27

Dynamics Ax 2012 : Exploring the Radio buttons as a report parameter

It is common scenario in report development to use check boxes or radio button as parameter.  Any Boolean variable define at data contract class become check boxes at report dialog. But how we make radio button on report dialog. When we require radio button then it means we have more than two values and one […]..Read More

Jan 25

Dynamics Ax 2012: Exploring the Dynamics Grouping in Dynamics Ax SSRS reports.

Dynamics Ax provide complex and interactive reports because they help gain valuable insights. One common report requirement is dynamic grouping which allows the users to choose which fields to group their data around. In SSRS, dynamic grouping can be set up using the following steps. Define the grouping parameters To enable a dynamic grouping on […]..Read More

Jan 25

Dynamics Ax 2012 : Exploring the SSRS as reporting tool in Dynamics Ax 2012

This latest dynamics Ax version uses SQL Server Reporting Services (SSRS) as the primary platform for reporting. Developing in SSRS is much faster than X++ making custom reports easier to implement. In addition to the use of SQL Server tools, there is an integration of the report development environment with Visual Studio 2010 making report […]..Read More

Jan 16

Dynamics Ax 2012 : Exploring the database logging on custom table

Dynamics Ax 2012 provide the database level logging. You can track every change not only at table level but also at field of any table. Dynamics Ax 2012 provide the functionality to log insert update and delete functionality on table as well as selected filed of a table. When tracking on any table in dynamics […]..Read More

Jan 14

Dynamics Ax 2012: Dynamics Ax reporting Model is MVC (Model View Controller)

I just start writing on Dynamics Ax reporting. To write on Dynamics Ax  starting point is what is Dynamics Ax reporting Model. On Searching I found that Dynamics Ax 2012 reporting Model is based on Model View Controller pattern.  It means reporting services can be replaced by any other report rendering application. Currently Reporting services […]..Read More

Jan 09

Dynamics Ax 2012 : Exploring the Query Service

You can excess AOT query directly in your dot .net code. For this purpose I predefine AIF services comes with dynamics ax 2012. These services return data in dataset and paging mechanism you can handle large sum of data set. I my last example I create a student table with following fields. FieldName dataType Roll […]..Read More

Jan 07

Exploring the little complex custom service in Dynamics Ax 2012

In this example, we explore a complex custom services. Which perform a insert , update, delete and return all the records form table. If you interested in basics of custom services you have to visit my pervious post on this topic http://tech.alirazazaidi.com/explore-the-custom-service-in-dynamics-ax-2012/.   For this example, I create a very simple custom table . This […]..Read More

Jan 04

Exploring the current session user Id in AX 2012

You can get current session log in id in AX 2012 by this method   str curUserId()     Complete example is as follow. static void curUserInfo(Args _arg) {     str sUserId;     ;     sUserId = curUserId();     info "Current user ID is " + sUserId; }  ..Read More

Dec 29

Explore the custom service in Dynamics Ax 2012

In Dynamics Ax 2012 you can expose your custom logic as Custom service. Like wcf service the custom ax services also contains Data contracts and Custom business logic.   Simplest customer services contains three things   X++ Class Service Node Service Group node. Very simple custom service project structure will be look like as follow, […]..Read More

Oct 18

How to get default dimensions for Vendor and Customer in dynamics ax 2012

I used following code for this   CustTable custTable = CustTable::find(“1101”); VendTable _VendTable= VendTable::find(‘54278’); DimensionAttributeValueSetStorage dimStorage; Counter i; dimStorage = DimensionAttributeValueSetStorage::find(_VendTable.DefaultDimension ); for (i=1 ; i<= dimStorage.elements() ; i++) { info(strFmt(“%1 = %2”, DimensionAttribute::find(dimStorage.getAttributeByIndex(i)).Name, dimStorage.getDisplayValueByIndex(i))); }..Read More

Oct 03

Dynamics Ax 2012: Xpp.ErrorException

While positing sales order I got following exception.   Exception of type ‘Microsoft.Dynamics.Ax.Xpp.ErrorException’ was thrown On event log on Server OSA, I found following message. Object Server: RPC error: RPC exception 1702 occurred in session 8 process is Ax32Serv.exe thread is 19640 (User: username, ClientType: Worker)   For Correct the problem, I recompile the CIL […]..Read More

Sep 03

In statement functionality dynamics ax++

Sometimes we have to get rows from one table based on the list of value form other tables. We use in statement queries. For example I have to display only those customers which have at least one sales order in sales table. In this scenario we have to use in statement. But there is no […]..Read More

Sep 03

Date to UTCDateTime Convertion Dynamics Ax 2012

Usually we have to convert date to UTCDateTime. That is usally case when we have to query on createdatetime filed of very table, which filled when new row is created. We for this purpose we have to create use DateTimeUtil::newDateTime function. This function takes two values one for date, and second for time. So time […]..Read More

Sep 03

Some Useful date functions in dynamics ax X++

There are a lot of functions in dynamics Ax for dates. Followings are some date time functions I used extensively. Some times we need to get month, year form date we can get these with the use of following functions in Dynamics ax int _Months; int _Years; //Get day from date _DayOfMonth =dayOfMth(systemdateget());; // Get […]..Read More

Aug 28

How to disable AutoComplete functionality on controls Dynamics Ax

How to disable autocomplete functionality on Form Control in dynamics Ax. Currently I was facing the problem of autocomplete functionality, every time user enter text for search, stringEdit control filled with autocomplete and error message display. I was using TextChange Method of String Edit Control. I add the following line of code in TextChange method […]..Read More

Aug 09

How to execute Sql directly form Dynamics AX X++

Dynamics Ax provide many other ways to communicate with database, but sometimes we have to execute direct query to database. For example I have to delete all items form InventTable of particular company or dataarea. I execute it as follow.       Connection      connection; Statement       statement; str             query; DataAreaId      currentDataArea;     // create […]..Read More

Aug 06

How to search a specific character in string dynamics ax

Last I have to logic that if text contain contains “-“ then validate the length of string 9 other wise at 8. I did it with strscan function of X++ or dynamics ax 2012. Full code as follow.   Int found=0; Str target=”Aliraza-zaidi”; found = strscan(target,”-“,found,strlen(target)); //this function return the position of character if it […]..Read More

Aug 03

Study resource for SQL Server 2008 R2 Integration services (SSIS)

  SQL Server 2008 R2 Integration services (SSIS) Creating a simple ETL Package http://msdn.microsoft.com/en-us/library/ms169917.aspx Typical Uses of SSIS Packages http://msdn.microsoft.com/en-us/library/ms137795.aspx Package Protection Level Setting: http://msdn.microsoft.com/en-us/library/ms141747.aspx Running Packages: http://msdn.microsoft.com/en-us/library/ms141708.aspx Logging Package Execution: http://msdn.microsoft.com/en-us/library/ms139845.aspx Architecture of Integration Services http://msdn.microsoft.com/en-us/library/bb522498.aspx Architecture of an Integration Services Package http://msdn.microsoft.com/en-us/library/cc645924.aspx Package Deployment http://msdn.microsoft.com/en-us/library/ms137592.aspx Package Troubleshooting: http://msdn.microsoft.com/en-us/library/aa337088.aspx Managing Integration Services: http://msdn.microsoft.com/en-us/library/ms137731.aspx   […]..Read More

May 24

Comprehensive guide for Dynamics Ax 2012 Form development

I found Comprehensive guide for Dynamics Ax 2012 Form development on Msdn, The link is worth to share http://msdn.microsoft.com/en-us/library/aa881211..Read More

May 18

Microsoft Dynamics AX 2012 White Papers: Services

i found excellent white paper of web services in Microsoft Dynamics AX 2012. You can download it from here  This white paper gives an overview of different types of services available in Microsoft Dynamics AX 2012 and provides guidance to developers and architects in deciding when to use a specific service type. The white paper […]..Read More

May 16

Dynamics Ax 2012 Study Links

New Stuff for Developers What’s New in Microsoft Dynamics AX 2012 for Developers [AX 2012] http://msdn.microsoft.com/en-us/library/gg845327.aspx Architecture AOS architecture [AX 2012] http://technet.microsoft.com/en-us/library/dd309593.aspx Model store architecture [AX 2012] http://technet.microsoft.com/en-us/library/dd362019.aspx Help server [AX 2012] http://technet.microsoft.com/en-us/library/gg866975.aspx .NET Business Connector architecture [AX 2012] http://technet.microsoft.com/en-us/library/dd309664.aspx Enterprise Portal architecture [AX 2012] http://technet.microsoft.com/en-us/library/dd362005.aspx .NET Business Connector .NET Business Connector Overview [AX 2012] […]..Read More

Apr 20

WFX to XSD schema generation module is not installed

Today I am trying to generate XSD from Well formed XML. Visual studio return this error WFX to XSD schema generation module is not installed. Execute C:Program FilesMicrosoft BizTalk Server 2006SDKUtilitiesSchema GeneratorInstallWFX.vbs to install the WFX to XSD schema generation module. To resolve this issue, simply run the aforementioned VB script; you’ll also need to […]..Read More

Apr 20

BizTalk Orchestrations XPath: Survival Guide

Following are good links Xpath in BizTalk , Original Article is here Common XPATH Examples, Questions, Issues with Biztalk  Using XPath Inside BizTalk Orchestrations  BizTalk Working With XPath – XPath 1.0 Function Library Quick Reference  XPath – the hidden language of BizTalk?  BizTalk 2010 Recipes : Orchestrations – Using XPath Queries on Messages  BizTalk Server: Handling […]..Read More

Apr 18

Esb Itinerary beginner Samples

  Following links are best starting point for ESB Toolkit. http://abhijitmahato.wordpress.com/2010/09/10/biztalk-esb-toolkit-2-0-samples-content-based-routing/ http://blogs.technet.com/b/meamcs/archive/2011/11/17/biztalk-esb-step-by-step-walkthrough-creating-a-custom-orchestration-service.aspx   http://www.codeproject.com/Articles/293385/Dynamic-message-processing-and-routing-in-Itinerar   http://www.codeproject.com/Articles/288285/Hello-World-in-BizTalk-ESB-Itinerary-using-a-Purch  ..Read More

Apr 17

ESB Toolkit 2.1 error: “Could not enlist Send Port ‘ALL.Exceptions’…”

I found this error, when I just complete the installation of ESB toolkit on my machine. I found that I missed the following Filters on “All.Exceptions” send port ErrorReport.FailureCode – Exists Microsoft.Practices.ESB.ExceptionHandling.Schemas.Property.FaultCode – Exists When I set the these filters on send port. All exception port successfully enlisted and start..Read More

Apr 13

BizTalk 2010 Cookbook Released

I am very happy to announce that BizTalk 2010 Cookbook written by a great MVP Steef Jan is released. He has done a marvelous job writing this book, the contents of the book can be viewed at Packt Website. The book is mainly for Developers and Administrators who can gain their knowledge in Development, Maintaining, Monitoring & Deployment of BizTalk […]..Read More

Apr 12

File cannot be loaded because the execution of scripts is disabled on this system error in PowerShell

  While installing ESB portal on 64 bit machine I found following errors   File Management_Install.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details. At line:1 char:2 The reason for this error is the security setting on your pc that does not allow you […]..Read More

Apr 12

set-executionpolicy unrestricted access denied

  open cmd with accessories with run as administer option. When command prompot open. Write powershell. And press enter. Powershell is opened. Now write set-executionpolicy unrestricted. It will run successfully...Read More

Apr 09

ESB Toolkit webcasts

ESB Toolkit How To 4: Dynamic Itinerary Resolution Peter Kelcey In this video, I’ll show you how to create an BRE policy to resolve itineraries and I’ll show you how to setup your BizTalk receive ports to use this policy. I’ll show you how to implement context and content based itinerary resolution. February 17 2010 […]..Read More

Apr 04

Failed to connect to the SQL database SSODB on SQL Server

After hundreds of time failure on BizTalk configuration failed at configuring SSOS with error Failed to connect to the SQL database SSODB on SQL Server The best solution I found was to re-register the ssosql.dll on the following manner: 1. start the visual studio command prompt 2. go to the ssosql.dll C:Program FilesCommon FilesEnterprise Single […]..Read More

Mar 25

Insert with WCF-SQL-Adapter BizTalk 2010

  I decided to write a simple kick start tutorial for WCF-SQL Adapter for beginners. In this tutorial where I just perform single operation insert. A simple BizTalk solution which read a value from file location and insert this value into table. First of all I create a very simple category table. Which hold two […]..Read More

Mar 22

XSLT In BizTalk Maps

XSLT is by default used by BizTalk maps (XSLT engine) to transform source schema to destination schema so there is nothing new (If you just open the .cs file of a map you can see it clearly there) Intention of this post is to highlight different usages of custom XSLT. 1) WHEN to use XSLT […]..Read More

Mar 13

describe table tsql

Currently I was searching describe  like function, which used in Oracle PLSQL to get the detail of table.  I found equvilent function in TSQL “sp_help”. you can used it as sp_help <table_name>   i.e sp_help studentdet..Read More

Mar 12

Xpath vs Distinguished fields.

Xpath consider to be slower, because when we get value using xpath, the whole message will be loaded into memory, so Xpath is memory hungry  solution Distinguished filed return value faster then xpath. Distinguished filed  has limitation. It failed to returning value when message contains multiple node contains the value. In this case Xpath works wonder. Final point is […]..Read More

Mar 01

How to get Current Fiscal year starting and Ending Date

For starting Date int month = DateTime.Now.Month; int year = DateTime.Now.Year; // if month is october or later, the FY started 10-1 of this year // else it started 10-1 of last year return month > 9 ? new DateTime( year, 10, 1 ) : new DateTime( year - 1, 10, 1 ); For Ending […]..Read More

Feb 29

Convert Date into Integer like YYYYMMDD in SSIS package

i used following Expression in  Integer values expression shap   (DT_WSTR, 4) YEAR( @[User::StartDate] ) + Right("0"+ (DT_WSTR, 2) MONTH( @[User::StartDate] ) ,2) + Right("0"+ (DT_WSTR, 2) DAY( @[User::StartDate] ) ,2) It convert the date into integer like 20120229..Read More

Feb 29

BizTalk 2010 Cumulative Update Package 4 available BizTalk 2010 Cumulative Update Package 4 available

Cumulative update package 4 for BizTalk Server 2010 is now available and it is a rollup update that contains the following items: All previously released hotfixes for BizTalk Server 2010 Some hotfixes for Microsoft BizTalk Server 2009 and for Microsoft BizTalk Server 2006 R2 Some other fixes that improve the product This cumulative update package […]..Read More

Feb 28

SSIS – Pass a date variable to a OLE DB Source in a Data Flow

Currently i have to make query dynamic, i have to  pass date variable to query to execute for specific date range, and this date range could be very time by time, Previously I tried for script component or expression of variable to build query but failed, but then I found command option of  oledb command. […]..Read More

Feb 27

Delete with identity reset

I am dropping the rows but insertion start with next to last max identity . Something was missing in my knowledge. To reset Identity i have use one extra statement, other option is use trunc  statement to drop rows.  but if i have too drop rows with delete statement and reset the identity what should […]..Read More

Feb 27

How to extract date and time in Tsql

I extract date and time  from dateTime filed in TSQL as   select CAST(CONVERT(varchar(8),vm_dm_StudentDet.Dep,112) AS int) DepDate, Cast(CONVERT(VARCHAR(8),vm_dm_StudentDet.Dep,108) AS time) DepTime, Cast(CONVERT(VARCHAR(8),vm_dm_StudentDet.Dep,101) as date) dt from vm_dm_StudentDet if you test this on current date you use as follow. select CAST(CONVERT(varchar(8),GETDATE(),112) AS int) DepDate, Cast(CONVERT(VARCHAR(8),GETDATE(),108) AS time) DepTime, Cast(CONVERT(VARCHAR(8),GETDATE(),101) as date) dt..Read More

Feb 27

How to convert date to interger In TSQL

During my assignment I have to generate Integer value from datetime filed for Date Dimension . I found excellent  id this way.     CAST(CONVERT(varchar(8),StartDATE,112) AS int) DateDateKey,   The whole Query is  as follow.   SELECT CAST(CONVERT(varchar(8),BEGDATE,112) AS int) DateDateKey, ,Name ,Address ,Joindate ,EndDate FROM dbo.from Student   🙂 its works for me...Read More

Feb 25

How to get site visitor Api in asp.net

How to get IP Host Address of remote Client // To get IP of the client meachine // There is two methods to obtain IP address // Method 1 //     Gets the IP host address of the remote client. // Returns: //     The IP address of the remote client. string ipMethod1 = Request.UserHostAddress; // HttpContext.Current.Request.UserHostAddress; […]..Read More

Feb 22

How to create dynamic connection string with variables SSIS

Create Parameter on package level with string datatype with following Name, set default value with respect to your machine configuration I set according to mine VServerName =”pc-aliraza” VSQLUserName=”aliraza” VSQLDbName =”Nwind” VSQLPassword =”123” If  integrated securtity with database is false or you connect with windows authentication following is the expression you have to set  expression at […]..Read More

Feb 22

Connect to the console session of a server using Remote Desktop using mstsc /console

The command I forget, so i log it here   Using the command line Open Command Prompt. Type: mstsc /console. Remote Desktop Connection will start. Type the computer name or IP address of the computer you want to connect to in the Computer box. Configure any other desired options, and then click Connect...Read More

Feb 20

how to get lastest inserted identity working with access database

You know the word “@@IDENTITY” it really has magic, It returns me the latest inserted rows identity in my access database using oldebcommand. For this purpose i have to execute command object two times first for insert query and second time by execute secular for getting value back   public void InsertReviews(string _Nick, string _Name, […]..Read More

Feb 19

Simple Data Access Class for Access database

After little time i have to wrote a simple data access layer for MS Access database, For Connection string I wrote a simple Util Class as using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Configuration; /// <summary> /// Summary description for Util /// </summary> public static class Util { public static string GetConnString() { […]..Read More

Feb 14

Using a Common Table Expression (CTE) with an Delete statement

Delete Part of ETL Process If any row is deleted at source table, but destination table rows  exits. So I did to make a inner join with source table with destination table I used right join in this case, so I got all rows from destination which I placed at right side of query. The […]..Read More

Feb 14

Using a Common Table Expression (CTE) with an UPDATE statement

For update part of ETL Process I have to write another Common table expression to get  all records where are changed at source to run update query on destination table   My update part of basic ETL using TSQL as   with ChangedRows as (   SELECT     sourceEmp.empid, sourceEmp.lastname, sourceEmp.firstname, sourceEmp.title, sourceEmp.titleofcourtesy, sourceEmp.birthdate, sourceEmp.hiredate, sourceEmp.address, […]..Read More

Feb 14

Using a Common Table Expression (CTE) with an INSERT INTO statement

My current assignment was to write ETL Process using TSQL.  So I have to get all rows which are newly added to Source Table and are not part of destination table. I wrote simple Common Table Expression to get all rows and insert into destination table. So part of ETL Process using CTE as   […]..Read More

Feb 07

T-SQL: How to do SQL Server paging with ROW_NUMBER()?

DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 2; SET @PageSize = 10; WITH OrdersRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY DimProduct.ProductKey) AS RowNum, DimProduct.ProductKey, DimProduct.EnglishProductName as Product, DimProductSubcategory.ProductSubcategoryKey as SubCategoryKey, DimProductSubcategory.EnglishProductSubcategoryName as SubCategory, DimProductCategory.ProductCategoryKey as CategoryKey, DimProductCategory.EnglishProductCategoryName as Category FROM DimProduct INNER JOIN DimProductSubcategory ON DimProduct.ProductSubcategoryKey = DimProductSubcategory.ProductSubcategoryKey INNER JOIN DimProductCategory […]..Read More

Feb 07

How to get list of tables in Database TSQL

You can use the list down all tables in specific database with this query select TABLE_NAME from information_schema.tables where Table_Type = 'BASE TABLE'  ..Read More

Feb 07


Nolock is T-Sql hint, That used to ignore the locks on table during transactions. It allows retrieving data and did not wait to complete the transaition applied on table. It has some pros can cons Pros: NoLock provides significant improvements on large table, where upserts commands take time. You can retirve data during the same […]..Read More

Feb 07

How to create SSIS Package Configuration in SQL server 2008

There will be change possible of server name at connection strings, file paths when deploying SSIS packages  in production and same issue appears  when ssis package will go from development environment to QA server for testing. So what is workaround.  SSIS configuration wizard allow us to generate configuration settings for  connection string and properties of […]..Read More

Feb 05

BizTalk Interview Advice

  Excellent article from Seroter. http://seroter.wordpress.com/2007/07/27/biztalk-interview-advice/..Read More

Feb 05

Primary SSO Server ” failed. Cannot perform encryption or decryption

I face an error while creation file location at my personal computer for Could not store transport type data for Primary Transport of Send Port ‘SendPort1’ to config store. Primary SSO Server ‘ALIRAZA-PC’ failed. Cannot perform encryption or decryption because the secret is not available from the master secret server. See the event log (on […]..Read More

Feb 05

Distinguished vs. Promoted Properties

There are two ways to get content of message specified filed directly in BizTalk in message. Distinguished fields and Promoted property.   Distinguished fields/properties When you need to access  the content of filed only in orchestration level prefer Distinguished fields. Distinguished fields are xpath equivalent and these xpath stored insisted XSD.  Due these fields are […]..Read More

Feb 05

How to run apache server and ii7 simultaneously same time on window 7

In my personal machine, I installed the ii7, same time I required XAMP for php, Problem is that ii7 and apache server both occupied the same port 80 by default. Apache is stop running on my machine. So I decide to change the default port of XAMP to something else I follow the following steps […]..Read More

Feb 02

how to write a tab delimited text file using C#.net

Use following Code StreamReader sr = new StreamReader(@"d:simpleTabDelimeterFile.txt"); StreamWriter outputFile = new StreamWriter(@"d:out.txt"); string strline = ""; string[] _values = null; while (!sr.EndOfStream) { strline = sr.ReadLine(); _values = strline.Split('t'); if( _values.Length == 3 ) { strline = _values[0] + 't' + _values[1] + 't' + _values[2]; outputFile.WriteLine(strline); } } sr.Close(); outputFile.Close();..Read More

Jan 25

Drill Down Report SSRS with the Visibility Property

Too the point, opens your Reporting Services project in BIDS and add report menu.  The database is used in report can be download from here http://tsql.solidq.com/books/tsqlfund2008/       Select new report like as After creating new report you have to add new dataset form data source panel. In Dataset Properties window you have to […]..Read More

Jan 23

SSIS Community Tasks and Components

There are hundreds of free SSIS tools available, which provide additional functionality. Codeplex listed them as http://ssisctc.codeplex.com/. These divided into following sections Tools Connection Managers Log Providers Task (for Control Flow) Foreach Enumerators Script Task Script Samples Components ( for Data Flow) Script Component Samples Sources Transforms Destinations..Read More

Jan 18

cannot transfer unicode to non-unicode string ssis

Today I face the following Error, when I transfer data from excel file to sql server server through SSIS package. Problem is that in excel data is stored in Unicode. And  transfer data to field of sql server which is define as varchar.   Solution 1. Change the sql data type   to nvarchar instead varchar. […]..Read More

Jan 18

BIDS Helper

http://bidshelper.codeplex.com/ There are many advantages in using this tool… 1. The first thing which I use this is for checking the dimension health, this is very helpful especially when you are dealing with the hierarchies…this helps in checking the data which is violating the hierarchy rule like data with many to many relationship etc… 2. […]..Read More

Jan 17

MSDN Virtual Labs for BI project

MSDN Virtual Lab: Building Your First Cube with SQL Server 2008 R2 Analysis Services MSDN Virtual Lab: Building Your First Data Mining Model with SQL Server 2008 R2 Analysis Services MSDN Virtual Lab: Building Your First Extract-Transform-Load Process with SQL Server 2008 R2 Integration Services..Read More

Jan 17

AdventureWorks2008R2 download link

Are you searching the download location for sample Databases for Microsoft SQL Server 2008R2 RTM (May 2010) ? You can download it from Click here It contains the complete set of databases: – AdventureWorks – AdventureWorks2008R2 – AdventureWorksDW2008R2 – AdventureWorksLT – AdventureWorksLT2008R2  ..Read More

Jan 15

How to get Tables list in database TSQL

  Main object is sys.tables. you can get all information about tables by query on sys.tables.   User databasename Select * from sys.tables;.     SELECT SCHEMA_NAME(schema_id) AS table_schema_name, name AS table_Name FROM  sys.tables;     SCHEMA_NAME convert  schema_id into schema name...Read More

Jan 15

Three TSQL books which every software developer must read

In my seven years of development experience, I read my tutorial and books on programming as well as. But when we talk about sql server from developer ‘s perspective. The following books are best. From novice developer to expert Tsql developer I recommend these books. All these books are from Itzik Ben-gan     From Microsoft […]..Read More

Jan 13

Microsoft SQL Server 2008 Virtual Labs for BI

Want to learn BI with Sql Server 2008, you have to go through virtual labs. I found excellent links on msdn virtual lab page http://msdn.microsoft.com/en-gb/cc138238 SQL Server 2008 R2 Virtual Labs MSDN Virtual Lab: Building and Sharing Your First Report Builder 3.0 Report MSDN Virtual Lab: Building and Sharing Your First SQL Server 2008 R2 PowerPivot for […]..Read More

Jan 13

Data warehouse Concept White Paper

I found very good pdf, It  is wrote by unknown, but  it helps me to clear understanding of basics of data warehouse. You can download it from my dropdown folder   http://dl.dropbox.com/u/22227947/dataWarehouse-concepts.pdf..Read More

Jan 13

Data warehouse Concepts

Data Warehouse is a central managed and integrated database containing data from the operational sources in an organization (such as SAP, CRM, ERP system). It may gather manual inputs from users determining criteria and parameters for grouping or classifying records. A source for the data warehouse is a data extract from operational databases. The data […]..Read More

Jan 10

All you need to know about the WCF-SQL Adapter

Currently I am studying the WCF-SQL Adapter. I found very informative webcast by “Thiago Almeida” about WCF-SQL adapter. This webcast belongs to BizTalk 2009, but for beginners it’s still good starting point. I don’t think things will not much different in BizTalk 2010 at least not at beginner level.   http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521554268962766719  ..Read More

Jan 09

How to fix “HTTP Error 403.14 – Forbidden The Web server is configured to not list the contents of this directory”

Currently working on sftp BizTalk adapter, I have to configure SSL site on my local machine. I got following error when  run the local host. HTTP Error 403.14 – Forbidden The Web server is configured to not list the contents of this directory.   The issue was that .Net framework 4.0 was not installed on […]..Read More

Jan 06

BizTalk Server 2010 Business Rule Engine: Survival Guide

During the studying BRE i found following survival guide for BRE.   http://social.technet.microsoft.com/wiki/contents/articles/6480.aspx Some excerpt form above link ” Out of box the business rules engine (BRE ) is offered as either stand-alone .NET-compliant class library that includes a number of modules, support components, and tools or as component within your BizTalk solution enabling you […]..Read More

Jan 05

Biztalk 2010 and CEP (Complex Event Processing)

 For all those friends who are interested in integrating CEP with BizTalk, check out the white paper by Jesus Rodriguez at : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6c1da607-4785-4668-a274-6898c38ea603StreamInsight is part of SQL 2008R2. You have to read on StreamInsight before checking out this paper. This paper is very conceptual and does not provide any code snippets. If you are looking for […]..Read More

Jan 05

Configuring BAM portal on Biztalk 2010

So, I installed Biztalk 2010 on Winows 7 with SQL server 2008 R2 on a 32 bit machine. Biztalk configuration worked smoothly as one would expect it to until the wizard tried to enable BAM portal. Biztalk configuration wizard threw an error saying “Default Web Site can’t be validated”. I did some research and found […]..Read More

Jan 03

BAM Guide for Biztalk 2010

Another great skill in BizTalk, the BAM. This tool is very powerfull but never really used, and often misunderstood. For helping, Technet did a great job with these series of article about BAM. You can get general informations or very technical ones. For the moment here is the link I talked about http://social.technet.microsoft.com/wiki/contents/articles/5599.aspx..Read More

Jan 02

microsoft.ruleengine.dll location

You can find it at here   <installation drive>:Program FilesCommon FilesMicrosoft BizTalk, double-click Microsoft.RuleEngine.dll..Read More

Jan 01

Business Rules Framework Walkthroughs for bizTalk 2010

Currently studying BRE in BizTalk 2010, i found following link MSDN. The complete walkthroughs for BizTalk 2010 Walkthrough: Creating a Simple Business Policy Walkthrough: Testing the Policy Walkthrough: Invoking the Policy from an Orchestration Walkthrough: Creating and Using a Vocabulary in the Policy Walkthrough: Adding a Rule to the Policy Walkthrough: Modifying the Policy Walkthrough: […]..Read More

Dec 25

How to Send File to MSMQ Using C#

During the testing of BizTalk application, which read data from MSMQ. I have to write small C# routine, this routine send data to MSMQ.  If you have no knowledge about MSMQ, Please read My Post on this here. http://www.biztalkhq.com/what-is-msmq-and-how-to-configure-it-on-windows-7/   To Send File on MSMQ you have to include the dll System.Messaging in your C# […]..Read More

Dec 25

What is MSMQ and How to configure it on windows 7

Microsoft Message Queue (MSMQ): MSMQ is a messaging protocol that allows applications running on separate servers/processes to communicate in a failsafe manner. A queue is a temporary storage location from which messages can be sent and received reliably, as and when conditions permit. Queues are used to receive and send the Messages. To Install MSMQ, […]..Read More

Dec 13

BizTalk Server Pipeline Component Wizard

If you need to design BizTalk Pipeline custom component, Use the BizTalk Pipeline Component Wizard on codeplex (http://btsplcw.codeplex.com), It is my favorite way to create pipeline components. It is an easy-to-use tool that walks you through the pipeline component creation process via a friendly wizard. http://btsplcw.codeplex.com/..Read More

Dec 11

BizTalk Server 2010 R2 Announced

A few days ago , Microsoft announced the forthcoming release of BizTalk Server 2010 R2 on the BizTalk Server blog site.  This is advanced notice, given that this new version will ship six months after the release of Windows 8, expected in the second half of next year.  On this basis, we can expect the […]..Read More

Dec 11

Cannot locate document specification because multiple schemas matched the message type

  Currently working on BizTalk 2006 applications, during testing freshly created and deployed version of one application, I got error at failure executing the receive pipeline:   There was a failure executing the receive pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “XML disassembler” Receive Port: Reason: Cannot locate document specification because multiple schemas matched the […]..Read More

Dec 08

Principles of Success Arces of diamonds summary

How can we learn to discover these acres of diamonds in our own backyards? Maintain a ready mind. Be open to the possibilities around you. Don’t let preconceived notions cloud your judgment. We often overlook the value of something because we believe we already know it. Look at the familiar in new ways. Conwell lists some important […]..Read More

Dec 06

BizTalk Software Factory

  The BizTalk Software Factory supplies guidance for developing BizTalk applications. There are 3 versions: v1.7 is for BizTalk Server 2006 solutions, v2.1 is for BizTalk Server 2009 solutions, v3.0 is for BizTalk Server 2010 solutions.     v3.0 is for BizTalk Server 2010 solutions: This release is updated for Visual Studio 2010 and BizTalk […]..Read More

Nov 24

Microsoft BizTalk Server 2010 Patterns Book Review

For those who’ve read the description of this book, it’s no surprise, this book is broken into two distinct parts. The first part it is a general introduction to the important parts of BizTalk Server 2010: understanding what is BizTalk, when to use it and its capabilities, appropriate topologies for different scenarios (architecture, scalability, availability) […]..Read More

Nov 23

Error: Unable to install the assembly into the Global Assembly Cache – BizTalk Deployment

Today during testing and redeploying the BizTalk 2006 application, I got this error. Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Unable to install the assembly into the Global Assembly Cache. Exception: A file load exception occurred while attempting to install the assembly into the Global Assembly Cache. This […]..Read More

Oct 14

Effort is important, but knowing where to make an effort makes all the difference

Effort is important, but knowing where to make an effort makes all the difference, read story below:   A giant ship engine failed. The ship’s owners tried one expert after another, but none of them could figure but how to fix the engine. Then they brought in an old man who had been fixing ships […]..Read More

Oct 13

Three Schema Design Approaches

Article reference from :   http://technologyandleadership.com/three-schema-design-approaches/   In a project where multiple schemas are created it is critical to decide which namespace design approach is suitable for the project: (1)should we give each schema a different targetNamespace, (2)should we give all the schemas the same targetNamespace or (3)should some of the schemas have no targetNamespace. […]..Read More

Oct 11

Pro BAM in BizTalk Server 2009

Beautiful book from By Jeff Sanders , Geoff Snowman. Currently i am reading it. From the Amzon page.   Business activity monitoring, or BAM, provides real-time business intelligence by capturing data as it flows through a business system. By using BAM, you can monitor a business process in real time and generate alerts when the process needs human intervention. Pro […]..Read More

Oct 06

BizTalk 2010 Web Console

With reference to Abdul Rafay’ he developed excellent web console for BizTalk .  You can find it form here (http://btswebconsole.codeplex.com/)   Project Description BizTalk 2010 Web Console allows administrators/operators to perform operations below from the browser. Stop/Start/Restart Host Instances View Status of Service Instances by applying queries to the group. Stop/Start/Unenlist Orchestrations, Send Ports and […]..Read More

Oct 05

BizTalk 2010 Documenter is available on CodePlex.

Yaa, another existing tool form Nigel Bachmann, a new version of BizTalk Documenter BizTalk Server 2010 documenter.  BizTalk 2006 Documenter is also available and developed by the same Person.  As from  CodePlex page following are extraction.     Overview Having recently become involved in BizTalk I was happy to find the BizTalk Server 2006 Documenter but unfortunately […]..Read More

Sep 20

BAM Data read write from Dot net application

You know that BAM is used to gather statistics from your BizTalk application. What you probably don’t know is that: ·          You can collect BAM data from your non-BizTalk applications such as external .NET components that BizTalk calls into. ·          Tracking profile editor (TPE) is not the only way to collect data you can use a set […]..Read More

Sep 20

Microsoft BizTalk 2010: Line of Business Systems Integration

Authors Kent Weare, Carl Darski, Thiago Almeida, Sergei Moukhnitski and Richard Seroter Book Description Microsoft BizTalk 2010: Line of Business Systems Integration will be a tutorial that focuses on integrating BizTalk with Line of Business systems using practical scenarios. Each chapter will take a Line of Business Adapter, introduce some pre-requisite knowledge and demonstrate how […]..Read More

Sep 19

Generic fault message exception handling

  In my current project, there are 50 operations on each port. It is very difficult and time consuming to create fault on every port operation and then add exception handler for every fault message.  This solution is not so comprehensive that if fault message is of different type what you made on each port […]..Read More

Sep 14

Exploring the BizTalk 2010 schema Editor

Whenever you create new schema in visual studio or open the exiting one in BizTalk application  you find similar window. This screen shot is taken form  http://msdn.microsoft.com/en-us/library/aa559175%28v=bts.70%29.aspx...Read More

Sep 13

How BizTalk Server 2010 Works

I found a very beatiful article on msnd about how Biztalk 2010 works. here some extraction complete artilce you can read from here http://www.microsoft.com/biztalk/en/us/messaging.aspx At the core of BizTalk Server are the Messaging Engine and the Orchestration Engine, which provide the underlying architecture for integrating and exchanging messages between various services, both within and outside […]..Read More

Sep 12

What is BizTalk message Type ?

All messages in BizTalk are represents in XML. One important aspect of all XML documents is its namespace. Briefly, a namespace allows you describe the Student (for example) in one way without affecting anyone else’s description, possible student can mean different things to other applications, Second important aspect of all XML document is the name […]..Read More

Sep 08

White Paper: See how Microsoft BizTalk Server 2010 can address your business needs.

The goal of BizTalk Server 2010 is to help organizations create automated business processes that span diverse applications and platforms. Along with its core messaging and orchestration capabilities, the product includes a BRE for working with complex business rules and BAM to let information workers track running processes. Additional components, such as EDI support, the […]..Read More

Aug 24

How to use Regular Expression(Regex) in BizTalk 2010 Schemas

this is a very usual but quite tricky and simple .. Using Regular Expressions 1) Select the element for which the validation is to be done. 2) Set the ‘Derived By’ property to ‘Restriction’. 3) Type the regular expression(s) in the ‘Pattern’ property. if you want this Pattern in same schema on other elements you should do following […]..Read More

Aug 22

Microsoft BizTalk Server 2010 Unleashed

Microsoft BizTalk Server 2010 Unleashed is the definitive, pragmatic guide to Microsoft’s latest and most powerful version of BizTalk Server. In this book, a team of world-class BizTalk Server 2009 experts bring together the deep practical insights .NET developers need to solve real business problems with BizTalk Server 2009 in any enterprise environment. Drawing on […]..Read More

Aug 15


Just like web.config in asp.net and app.config in .net applicaiton.  BizTalk server stored configuration values in name value pair. The File Name is “BTSNTSvc.Exe.Config”. It is located at biztalk installation directory on you machines like c:program files BizTalk Server 2006BTSNTSvc.exe.config” Sample config file look like this <?xml version=”1.0″ ?> <configuration> <configSections> <section name=”xlangs” type=”Microsoft.XLANGs.BizTalk.CrossProcess.XmlSerializationConfigurationSectionHandler, Microsoft.XLANGs.BizTalk.CrossProcess” […]..Read More