Meta tags:
description=Technical contents related to Microsoft ERP Product (Dynamics AX);

Headings (most frequently used words):

share, this, dynamics, in, using, ax, ax2012, blog, tip, view, dax, santosh, ramamurthy, address, contact, information, export, data, 2012, suppress, save, changes, prompt, when, you, close, excel, workbook, comvarianttype, for, real, values, queryvalue, function, reading, selected, node, xml, generating, lookups, sysattributes, class, display, web, image, content, forms, generation, of, codepage, create, custom, service, my, review, 2011, community, profile, blogroll, aquarium,

Text of the page (most frequently used words):
the (79), this (30), share (30), new (28), blog (24), print (21), for (21), facebook (20), opens (20), window (20), and (19), dynamics (17), ax2012 (17), which (17), using (16), #santosh (15), ramamurthy (15), like (14), case (14), data (14), service (13), excel (13), you (11), loading (11), content (11), 2012 (11), customer (11), _variant (11), categories (10), class (10), code (10), image (10), view (9), have (9), stuffs (9), happy (9), from (9), are (9), attribute (9), null (9), double (8), true (8), codepage (8), following (8), rows (8), com (7), group (7), function (7), item (7), custom (7), system (7), study (7), listenumerator (7), sysexcelapplication (7), comment (6), comments (6), report (6), dax (6), would (6), value (6), please (6), salesline (6), try (6), attributes (6), dictclass (6), way (6), sysexcelworkbook (6), sysexcelworkbooks (6), comvarianttype (6), workbook (6), address (6), get (5), wordpress (5), microsoft (5), click (5), when (5), will (5), prompt (5), can (5), find (5), inventonhand (5), returns (5), recordinsertlist (5), build (5), list (5), read (5), filename (5), xmldocument (5), information (5), real (5), columns (5), variant (5), sysexcelcells (5), sysexcelworksheet (5), valuestr (5), export (5), with (4), create (4), that (4), leave (4), visual (4), studio (4), return (4), all (4), public (4), node (4), auto (4), movement (4), qty (4), demo (4), required (4), shown (4), below (4), encodinginfoarray (4), encodingobject (4), error (4), always (4), web (4), note (4), sysclassenabledattributes (4), sysattribute (4), lookups (4), lookup (4), values (4), xmlinformationnode (4), xmlinformationsnodelist (4), xmlchildnodelist (4), break (4), int (4), reading (4), sysexcelworksheets (4), close (4), since (4), changes (4), saved (4), contact (4), similar (4), design (3), here (3), about (3), 2011 (3), out (3), january (3), tools (3), inbound (3), port (3), tags (3), link (3), method (3), under (3), _itemid (3), available (3), created (3), could (3), current (3), add (3), deploy (3), property (3), order (3), application (3), start (3), where (3), scenario (3), should (3), sample (3), output (3), text (3), exception (3), clrinterop (3), tostring (3), void (3), external (3), source (3), into (3), form (3), display (3), forms (3), field (3), sysattributetmp (3), currentclass (3), flag (3), name (3), static (3), table (3), displaying (3), building (3), has (3), approach (3), xml (3), queryvalue (3), september (3), tip (3), strfmt (3), site (2), post (2), log (2), sign (2), account (2), now (2), website (2), file (2), scale (2), community (2), aif (2), enterprise (2), see (2), concert (2), opera (2), house (2), people (2), was (2), take (2), download (2), test (2), your (2), itemonhandphysical (2), specify (2), physical (2), quantity (2), reference (2), command (2), through (2), sysentrypointattribute (2), inventqty (2), itemid (2), inventmovement (2), construct (2), any (2), named (2), project (2), basically (2), given (2), runtime (2), dlink (2), sharedproject_codepage (2), encodinginfo (2), interoppermission (2), permission (2), convert (2), catch (2), private (2), going (2), generation (2), set (2), above (2), there (2), needs (2), sreenath (2), check (2), shared (2), location (2), sysdictclass (2), while (2), boolean (2), define (2), summary (2), classes (2), different (2), ways (2), aot (2), same (2), type (2), functionality (2), implemented (2), usage (2), xmlnodelist (2), length (2), projects (2), row (2), illustrated (2), selected (2), based (2), cell (2), comvariant (2), variant2str (2), varianttype (2), vt_r4 (2), vt_r8 (2), num2str0 (2), num2str (2), numofdec (2), worksheets (2), first (2), only (2), throw (2), str (2), template (2), exact (2), task (2), suppress (2), via (2), been (2), save (2), know (2), 2014 (2), vendor (2), exporting (2), party (2), dirpartypostaladdressview (2), technical (2), contents (2), related (2), erp (2), product (2), started, must, logged, collapse, bar, manage, subscriptions, reader, privacy, join, other, subscribers, subscribed, subscribe, free, top, jan, october, 2026, gigya, width, 300, height, 200, quality, high, src, http, hosting, gmodules, gadgets, 112581010116074801021, fish, swf, noscale, salign, aquarium, bojensen, dilip, saelen, kenny, zubair, sysdictcoder, training, kamalkannan, maheshtej, mfp, arijit, basu, thomas, bonde, ejby, portal, perf, blogroll, profile, inezha, bloglines, newsgator, yahoo, zhua, xia, xian, guo, youdao, google, feed, rss, older, entries, uncategorized, complete, hall, syndey, holds, 700, viewed, times, were, sydney, sold, performances, many, 000, excerpt, stats, helper, monkeys, prepared, annual, review, servicing, inventoryonhandservice, wcf, client, starts, request, passing, 1290, invoke, appropriate, response, next, step, map, newly, exposed, methods, scope, proceed, further, creating, mark, yes, properties, right, relavent, artifacts, administration, module, simply, traverse, allprograms, 2010, enter, wcftestclient, space, then, paste, wsdl, uri, deployed, select, firstonly, newphysicalupdate, inventdim, availphysical, inventonhandservice, inventory, onhand, expose, access, specifiers, defined, inventoryonhand, number, once, executed, formrun, displays, ax20009, ax2009, buildcodepage, tablenum, codepagetable, interopkind, delete_from, assert, encoding, getencodings, getanytypeforobject, get_length, getvalue, get_codepage, displayname, get_displayname, insertdatabase, ttscommit, codeaccesspermission, revertassert, clrerror, getlastexception, get_innerexception, ttsbegin, deviation, documented, clear, windows, page, april, technology, software, development, sharedproject_ax_webimagecontent, streamreader, snippet, populate, not, actually, requiring, store, local, drives, url, html, textbuffer, according, fill, give, wonderful, built, streaming, taken, clue, exisiting, colleague, reddy, thanks, may, implementation, attributing, sharedproject_lookup_attributes, getallattributes, classnum, abstractattributesclass, extendedby, getenumerator, movenext, getattribute, parmflag, description, parmname, insert, buffer, sysenabledattributes, queue, enabled, finds, extend, earlier, release, formautolookupfactory, elements, sysmodelelements, utilelementsid, usually, performed, query, querybuilddatasource, instead, generate, similiar, across, one, such, instance, workflow, queues, checking, whose, adding, temporary, syntax, base, extends, helps, pattern, classstr, sysenableddocument, june, generating, sysattributes, ing, sr_readselectednode_xml, xmlnode, newfile, documentelement, selectnodes, setprefix, childnodes, basename, info, innerxml, details, sys98689, readnode, job, multiple, nodes, august, example, how, impacts, retreival, reports, enlarge, screen, actual, xpo, qurering, sharedproject_tip_queryvalue, global, whenever, specified, celing, sr_varianttype, vt_empty, vt_bstr, bstr, workbooks, open, itemfromnum, cells, pause, quit, names, considering, sheet, sys76826, update, links, false, sys26908, default, sys311964, switch, xlsx, path, column, integer, 123, 9756097560976, 234, 69105691056911, little, tricky, done, generated, round, off, compared, second, correct, precision, functions, observation, focus, shift, active, closed, still, process, thread, being, manager, trying, dialog, appears, forcing, without, saving, best, implementing, responds, though, already, occurred, last, more, its, handled, refer, reason, hello, everyone, blogged, time, newer, version, before, act, opportunity, wish, very, prosperous, year, lot, gab, they, ideally, mean, relation, between, tables, relevant, validate, addresses, huge, question, remains, what, simplest, although, dixf, master, got, followed, views, postal, browse, shall, corresponding, fields, section, except, belong, visible, purpose, locationroles, primary, drag, synchronize, viewing, result, finding, custtable, might, accounts, blank, others, well, vendors, warehouse, need, handle, easily, needed, follow, dirpartycontactinfoview, asap, hope, useful, happing, addressing, home,

Text of the page (random words):
contents related to microsoft erp product dynamics ax dax blog santosh ramamurthy technical contents related to microsoft erp product dynamics ax home about address contact information export data using view in ax 2012 january 29 2014 santosh ramamurthy 2 comments 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 ax2012 has implemented lot of changes in gab and the way they function this would ideally mean we should know the exact relation between tables to export relevant data in order to validate the customer addresses contact information it would be a huge task so the question remains what is the simplest way to export customer vendor address contact information the same way as in dynamics ax forms note although we have tools like dixf aif for exporting data exporting customer address the form data which is shown in customer master is got from a view similar approach could be followed to export the data under aot views and find party postal address view dirpartypostaladdressview if you try to browse through the data you shall find data corresponding to following fields which is similar to customer address section except to which customer it belong to in dirpartypostaladdressview click on auto report the following will be visible in order to get the customer id customer name purpose method locationroles and primary add the following code in the view and drag into auto report and synchronize it as shown in the image on viewing the auto report in the view the following result will be as below note since we are finding customer id based on it party from custtable we might have accounts which are blank so it could be others account as well like vendors or warehouse address for which you need to handle via code you can now export to excel easily in case similar functionality is needed to get contact information for customer vendor please follow the similar approach on dirpartycontactinfoview and get the required data asap hope this blog post is useful happing addressing in ax 2012 share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs tip suppress save changes prompt when you close a excel workbook using x in dynamics ax september 7 2012 santosh ramamurthy leave a comment 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 a dialog prompt appears prompt when you close workbook in excel to suppress the following try forcing a workbook to close without saving changes the best way of implementing this via x code sysexcelworkbook saved true reason if saved property is set to true excel responds as though the workbook has already been saved and no changes have occurred since that last save to know more on the way its handled in c refer ms link workbook saved property share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs tip comvarianttype for real values in dynamics ax september 6 2012 santosh ramamurthy 1 comment 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 _variant double 1 0 here is the output which is generated where the first function value is always a round off value compared with the second function which returns the exact content with correct scale and precision comvarianttype functions output for real values build excel template as following and specify the path excel column integer real rows 1 123 60 9756097560976 rows 2 234 5 69105691056911 static void sr_varianttype filename excel c projects data xlsx int rows int columns comvariant variant sysexcelcells sysexcelcells sysexcelworkbook sysexcelworkbook sysexcelworkbooks sysexcelworkbooks sysexcelworksheet sysexcelworksheet sysexcelworksheets sysexcelworksheets sysexcelapplication sysexcelapplication str variant2str comvariant _variant str valuestr switch _variant varianttype case comvarianttype vt_empty valuestr break case comvarianttype vt_bstr valuestr _variant bstr break case comvarianttype vt_r4 case comvarianttype vt_r8 if _variant double valuestr strfmt sys311964 num2str0 _variant double 0 num2str _variant double 0 numofdec _variant double 1 0 break default throw error strfmt sys26908 _variant varianttype return valuestr sysexcelapplication sysexcelapplication construct sysexcelworkbooks sysexcelapplication workbooks try sysexcelworkbooks open excel false update links true read only catch exception error throw error strfmt sys76826 excel sysexcelworkbook sysexcelworkbooks item 1 sysexcelworksheets sysexcelworkbook worksheets only considering sheet 1 sysexcelworksheet sysexcelworksheets itemfromnum 1 sysexcelcells sysexcelworksheet cells since in first row there will be field names for rows 2 rows 3 rows for columns 1 columns 2 columns variant sysexcelcells item rows columns value print variant2str variant pause close excel sysexcelapplication quit variant null sysexcelworkbooks null sysexcelworkbook null sysexcelworksheet null sysexcelcells null sysexcelapplication null whenever reading cell content w r t real values always try using the function 2 specified above happy a x celing share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs tip queryvalue function in dynamics ax september 6 2012 santosh ramamurthy leave a comment 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 check out for the xpo in the shared location sharedproject_tip_queryvalue happy qurering value in ax share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs reading selected node in xml dynamics ax2012 august 21 2012 santosh ramamurthy 3 comments 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 xmlinformationnode xmlnodelist xmlinformationsnodelist xmlnodelist xmlchildnodelist int i int j filename c projects readnode xml xmldocument xmldocument newfile filename xmlinformationsnodelist xmldocument documentelement selectnodes node setprefix sys98689 for i 0 i xmlinformationsnodelist length i xmlchildnodelist xmlinformationsnodelist item i childnodes for j 0 j xmlchildnodelist length j xmlinformationnode xmlchildnodelist item j if xmlinformationnode basename details info xmlinformationnode innerxml break happy dax ml ing share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs generating lookups using sysattributes class dynamics ax2012 june 19 2012 santosh ramamurthy 6 comments 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 using sysmodelelements utilelementsid was usually performed by query querybuilddatasource instead we can generate same using sysattribute similiar type of functionality is implemented across ax2012 and one such instance is usage of attribute for displaying workflow queues design approach we are building runtime lookup by checking attributes whose values are true and adding to the temporary table this way we would display all the classes which has the following attribute syntax sysclassenabledattributes boolean true classstr sysenableddocument where sysclassenabledattributes is a attribute base class which extends sysattribute which helps us to build the required lookup code pattern summary finds the classes that extend the c sysenabledattributes c class that are queue enabled summary returns a c sysattributetmp c table buffer returns public static sysattributetmp getallattributes define sysattribute sysclassenabledattributes sysattributetmp attributes list list sysdictclass dictclass dictclass currentclass listenumerator listenumerator boolean flag true sysclassenabledattributes attribute dictclass new sysdictclass classnum abstractattributesclass listenumerator new listenumerator list dictclass extendedby listenumerator list getenumerator while listenumerator movenext currentclass new dictclass listenumerator current attribute currentclass getattribute sysattribute if attribute null flag attribute parmflag if flag attributes name dictclass name attributes description attribute parmname attributes insert return attributes please check out for the design implementation in the shared location happy attributing ax2012 sharedproject_lookup_attributes share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs tags field group display web image content in forms using dynamics ax2012 may 28 2012 santosh ramamurthy 4 comments 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 source code the web image content are read using streamreader class and set into the x form using the above code snippet you can populate the external image which is required there by not actually requiring to store in local drives note any external url html source code needs to be read by textbuffer class and according fill the image content please give a try to this wonderful application which is built on ax2012 happy streaming data using ax2012 download source code link sharedproject_ax_webimagecontent share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs tags enterprise it external image image content software development technology generation of codepage using x april 25 2012 santosh ramamurthy leave a comment 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 encodinginfo encodinginfoarray system text encodinginfo encodingobject recordinsertlist recordinsertlist new recordinsertlist tablenum codepagetable system exception ex interoppermission permission new interoppermission interopkind clrinterop clear always the codepage data is available delete_from codepage try permission assert encodinginfoarray system text encoding getencodings bp deviation documented for i 0 i clrinterop getanytypeforobject encodinginfoarray get_length 1 i encodingobject encodinginfoarray getvalue i codepage codepage system convert tostring encodingobject get_codepage codepage displayname system convert tostring encodingobject get_displayname recordinsertlist add codepage ttsbegin recordinsertlist insertdatabase ttscommit codeaccesspermission revertassert catch exception clrerror ex clrinterop getlastexception if ex null ex ex get_innerexception if ex null error ex tostring once this code is executed the runtime formrun displays the required output as shown below ax2012 dlink sharedproject_codepage happy ax2012 ax20009 dlink sharedproject_codepage happy ax2009 share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs dynamics ax2012 create custom service using x january 24 2012 santosh ramamurthy 6 comments 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 named sysentrypointattribute true for this project i have a created a sample inventoryonhand service which basically returns the number of qty for a given item class inventonhandservice sysentrypointattribute true public inventqty itemonhandphysical itemid _itemid salesline salesline inventonhand inventonhand inventmovement movement inventqty qty 0 select firstonly salesline where salesline itemid _itemid if salesline movement inventmovement construct salesline inventonhand inventonhand newphysicalupdate movement movement inventdim qty inventonhand availphysical return qty next step is to create a service map the custom class with newly created service by which you could exposed all public methods which are in the scope of current class please proceed further by creating a new service group add it to service node reference please mark the auto deploy property to yes on the service group properties right click on the created service group and click deploy service group this would deploy all the relavent artifacts to the inbound port under system administration module in order to test your custom service application simply start vs command prompt or traverse through start allprograms microsoft visual studio 2010 visual studio tools visual studio command prompt enter wcftestclient space and then paste the wsdl uri which you can find on the deployed inbound port when the wcf test client starts double click on your method itemonhandphysical in my case and specify the value under request by passing the _itemid i e 1290 in my case the invoke function will return the appropriate response of the available physical quantity of an item from the ax2012 download link inventoryonhandservice happy servicing ax2012 share this share print opens in new window print share on facebook opens in new window facebook like loading categories x stuffs tags inbound port new service group visual studio tools my blog review in 2011 january 1 2012 santosh ramamurthy leave a comment 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 sydney opera house it would take about 5 sold out performances for that many people to see it click here to see the complete report share this share print opens in new window print share on facebook opens in new window facebook like loading categories uncategorized older entries rss feed google youdao xian guo zhua xia my yahoo newsgator bloglines inezha dynamics ax ...