DAX Blogger | Santosh Ramamurthy

DAX Blogger | Santosh Ramamurthy
  • Address/Contact Information: Export data using View in AX 2012

    Hello Everyone, It’s been a while since I have blogged and this time I will start on newer version named Dynamics AX2012. Before get into the act, I would like to take this opportunity to wish all a “Very Happy and Prosperous New Year 2014″...
  • Tip: Suppress “Save Changes” prompt when you close a Excel workbook using X++ in Dynamics AX

    In Microsoft Dynamics AX, to read data from excel worksheets the focus needs to shift on the active workbook. So when application is closed you’ll still find the process thread being shown up in Task manager and when trying to view the excel file...
  • Tip: COMVariantType for Real values in Dynamics AX

    Case Study: Reading cell content from excel template for COM variant type VT_R4 or VT_R8 is always little tricky. Observation: Reading real value can be done in following ways 1) num2Str0(_variant.double(), 0); 2) num2str(_variant.double(), 0, numOfDec...
  • Tip: QueryValue function in Dynamics AX

    Case Study: Below a sample example is illustrated on how queryValue usage impacts the data retreival in reports based on different customer data. Note : Enlarge the screen to view the actual content of the blog Global function queryValue Please...
  • Reading Selected Node in XML – Dynamics AX2012

    Case Study: Below a sample job is illustrated to read selected (multiple) nodes from a given XML. private static void SR_ReadSelectedNode_XML(Filename fileName) { #define.node('INFORMATION//ROWS/ROW') XmlDocument xmlDocument; XmlNode...
  • Generating Lookups using SysAttributes Class – Dynamics AX2012

    Case Study: In earlier or current release we have different ways of displaying lookups using table lookup, field group lookups, building reference lookup from custom form using FormAutoLookupFactory. Building custom lookups for displaying AOT elements...
  • Display Web Image Content in Forms using Dynamics AX2012

    Case Study: In this demo scenario, we are going to display Web Image Content on forms using Dynamics AX2012. For this demo, I have taken a clue from my exisiting colleague Sreenath Reddy (Thanks Sreenath) to build a web image content. Image:AX2012 ...
  • Generation of CodePage using X++

    Case Study: In this demo scenario, we are going to build Windows Code page using X++ class. For this project, I have build a generation class which basically returns the list of available codePage. private void buildCodePage() { System.Text...
  • Dynamics AX2012: Create Custom Service using X++

    Case Study: In this demo scenario, we create a custom service to find the inventory onhand physical item quantity from AX2012. To expose any Custom Service, method should be ‘public’ Access Specifiers & should be defined by an attribute...
  • My Blog Review in 2011

    The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog. Here’s an excerpt: The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 14,000 times in 2011. If it were a concert at...
  • Dynamics AX2012: Table Full Text Indexes

    Microsoft Dynamics AX 2012 provides full-text functionality that enables Microsoft Dynamics AX to search business data over a large volume of text data or documents. Please refer the following link which explains on the same. http://dynamicsaxgyan...
  • How to write UtcDateTime value along with Timezone in AX2012

    In AX2O12, we can manage record relationship that are valid for a specific date range, by setting the ValidTimeStateFieldType property to UtcdateTime . Let’s draw a scenario where you need to parse an XML which was built on lower version (S.O...
  • Multiple XPO Import Version – 3

    Hey Guys, I have added a small Add-in feature to the existing tool which will create a Project for all the imported elements. Each import will have a following namespace (ImportProject) followed by underscore and a random number appended to the namespace...
  • We are AX Bloggers :)

    Nice video Thanks Mahesh for sharing this AX search for users who can refer our blogs
  • AX2012 Hands on Labs

    Friends, There are hands on lab session on AX2012 available on Partner Source. For more information please refer the following link here Topics covered in the hands-on lab are as follows: 1 . Workflow Implementation 2 . Accounts Payable 3 . Accounts...
  • X++ Script to renamePrimaryKey across companies

    Hey Guys During data upgrade to AX2012 we had issue in ‘Product Upgrade’ preprocessing checklist. Validation errors were observed due to presence of same item in different companies with different ‘DimGroupId’ or ‘ItemType’ values . ...
  • Multiple XPO Import Version – 2

    Hi folks , There was a major issue in the version 1 of the Multiple XPO Import tool. Each time when a multiple XPO’s are imported, a confirmation dialog keeps popping up for all the existing elements. This behavior seems to be very annoying to the...
  • Form Size Exceeds the Maximum Pixel in Dynamics AX

    One of my colleague had a strange warning as stated below in the screenshot. In order to find the root cause of the issue I designed a form named FormPixelExceeds with Datasource as “Invent Table”. In the Design – Grid property instead of...
  • Happy New Year – 2011

    New Year Greetings I wish all my blog readers a happy and properous new year 2011 Hope to continue blogging on new stuffs and latest upcoming in AX (Dynamics AX WILL rock with AX6 release in 2011……
  • Check out Save Our Tigers | Join the Roar

    Check out Save Our Tigers | Join the Roar
  • TreeNode AOT Save – Did you know?

    Today I had a small requirement from one of my colleague stating he would like to update a particular table field property using X++ code for upgrade purpose. So I wrote a sample job when I actually found that, if treeNode is traversed all the way...
  • Development Tips on Application Integration Framework

    Is there any way to turn off the mandatory fields when working on AIF? All the table fields for which the mandatory field is said to “Yes” are by default enabled in AIF data-policies form. To make this field as not mandatory on Ax Table classes. ...
  • Publish Selected Fields using AIF without Send Framework

    Sample example is written for publishing selected field based on AIF setup made in Data-policies form without using AxdSend framework class. /// <summary> /// The <c>LedgerTableRead</c> job will published the xML to the folder ...
  • Multiple XPO Import Tool for Dynamics AX

    I have developed a tool for importing multiple XPO’s using single instance as there is a limitation for now in AX since it allows only single object importing.The sneak peak of the tool which I have developed: I have attached documentation, on how...
  • Welcome to Dynamics AX @ WordPress :)

    Dear Readers, My blog will be redirected to Word press site. I have upgraded my blog to the following address.AX