Skip to main content

Posts

Error on running enterprise portal site and sharepoint administration setting in MSD axapta

If you are facing any error during running EP site from ax then you are getting message like troubleshooting with share point  then first you need to check your customization is there error in you page if still problem not resolved then you can compile data dictionary from AOT and if any error coming to table which is related to EP user control or form then you need to resolve that error. If error still exist then you need to compile whole AOT component like classes, forms and reports etc. If still error not resolve then you need to check deployment for you web component like web control , web module etc. I hope after doing that activity you problem will resolve if still problem exists then last option is fresh installation of EP and share point. During installation It can ask to install prerequisite software like .net framework 2.0 which exist in share point setup if its using for ax 2009. Do not forget to take backup of your customization and web project form EP folder and

Why Market of Microsoft Dynamics Axapta ERP is increasing day by day?

Why Market of Microsoft ERP is increasing ? This time microsoft ERP is in high demand. Lot of small , medium and big industries implementing this ERP. Microsoft provide many types of ERP like navision,CRM and axapta . Axapta is one of the best ERP of microsoft. Enterprise portal is web part of axapta and license for EP per user is much more cheap but license value for axapta application user is much high. if you are seeking license for EP then you can get it under Rs 10000 per user but for axapta application it goes around 2 lacs per user. In comparision with SAP this ERP is not costly and easy to implement and not much effort required to learn axapta ERP. Its much user friendly and operating menu is so easy. New company setup is also easy in this ERP whole setup you can do within day. In India many companies are implementing this ERP and some companies like Godrej infotech , DEVITPL, tectura etc are compaines which involes in development. Lot of companies like NDS invol

Enterprise Portal web control programing tips and trick in MSD axapta

Path where all web control stored in EP is as follows C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS\ep if you are doing any change in ax web control then you need to do change in EP folder also to reflect changes easily. If you make changes but you did not done seen changes at the time of run then you need to refresh AOT and data diction at home page. if you want to write some code on change event of any control then you need to set autopostback true property then on form set updatepostback to true than you can write override method modified in AOT and can do any code.

Allow debugging of a Business Connector or Client in MSD Axapta

To Allow debugging of a Business Connector or Client in axapta you can try following way. The following options in the Microsoft Dynamics AX Configuration Utility can used to enable breakpoints for a Business Connector instance or a client: Enable user breakpoints to debug code running in the Business Connector For sessions owned by users for whom debug is enabled within Microsoft Dynamics AX, allow X++ code running in the Business Connector to be interrupted by breakpoints Enable global breakpoints to debug code running in the Business Connector or client For all users, allow X++ code running in the Business Connector or client to be interrupted by global breakpoints

Allow debugging on an Application Object Server instanc in MSD axapta

How to Allow debugging on an Application Object Server instance This option is set in the Microsoft Dynamics AX Server Configuration Utility . 1. Open the Server Configuration utility (Start > Administrative Tools > Microsoft Dynamics AX Server Configuration).  2. Verify that the currently selected AOS instance and configuration are the ones you want to modify.  3. On the Application Object Server tab, click Enable breakpoints to debug X++ code running on this server, and then click OK

Introduction of workflow in Microsoft dynamics axapta ERP MSDAX

Workflow is a system in Microsoft Dynamics® AX 2012 that allows business processes to be automated. For example, a purchase requisition may need to be approved by a number of different employees according to the requisition's total amount. Each employee has to approve it before the next employee in the approval route. A Workflow in Microsoft Dynamics AX uses a combination of Application Object Tree (AOT) elements created by IT and additional set up that a user can control. This course introduces the development side of creating a workflow. To create a workflow you will need to use skills developed from this class and the Morph X development class. To get details of workflow in Microsoft dynamics axapta 2012 you can visit following website in image.

Things which need to learn in Enterprise portal in Microsoft dynamics axapta

If you want to become master in EP then you need to cover following topics in your learning. 1. Enterprise Portal Components 2. Enterprise Portal Architecture 3. Enterprise Portal Requirements 4. .NET Business Connector 5. Create Business Connector Proxy 6. Add Proxy to IIS 7. Configure IIS Application Pool 8. Install Enterprise Portal Framework and Role Centers 9. Install Enterprise Portal Developer Tools 10. Configure Enterprise Portal 11. Deploy Role Centers 12. The AOT Web Node 13. Creating a User Control in Visual Studio .Net. 14. Creating a Web Form in AOT. 15. Creating a Header Line Form in .NET. 16. Creating a Web Report and displaying the Contents Graphically. 17. How to filter a grid in EP on the click of a button. 18. Customizing and Personalizing Enterprise Portal 19. Creating Proxies in Ax 20. Defining Methods in Data set and calling them in EP 21. Filtering a Web Report through a Dialog Box in EP 22. Linking of 2 Web Parts and transferring data fro

Exception handling in Microsoft dynamics Axapta

Example of Exception handling in microsoft dynamics axapta x++ try { // Do something info("Now I'm here"); // A situation that causes an error occurs and you would // like to stop the execution flow if (true) throw error("Oops! Something happened"); info("Now I'm there"); } catch (Exception::Error) { // Handle the error exception info ("I would like to inform you that an error occurred "); } catch (Exception::Deadlock) { // Handle the deadlock exception // Wait for 10 seconds and try again sleep(10000); retry; } info ("This is the end"); }

Sales Order Creation in Microsoft dynamics Axapta

Steps to create Sales Order in Microsoft dynamics Ax Go to Account Recievable Menu from Main Menu Click on sales order details On Overview Tabl first grid Click on New Button or Press CTRL+N Then Select the customer Account In Ax 2009 Select Delivery Address Select Payment Terms Click on OK Click on Line details Select Item number in Item Number field Enter Quantity in Quantity field Enter Unit Rate in Unit Rate Field Click on Setup Tab Then you can fill other fields like under delivery ,over delivery etc using setup tab. then Click on Setup Button and select Misc. Charges if required Click on Misc. Charges code field and select the charges code from the list. Then you can select or change dimensions using dimension tab as per requirement. Click on save button if you will not click then it will save automatically. After doing all entries you can post for picking,packing then invoicing. Create Sales Order in AX 2012 Create Sales Order by Cod

Accounts payable Invoice Journal Creation and posting in MSD axapta

If you want to create Invoice Journal in axapta then you can follow these procedure step by step 1.Goto -> MainMenu 2. Then click on Account Payable menu item. 3. Click on Journal then go to Invoice Journal form 4.Select Journal Name 5.Click on Lines Button 6.Enter Transaction Date 7.Select Vendor Account 8.Enter Invoice No 9.Enter Invoice Amount in Credit field 10.Select Offset account type Ledger 11.Select offset account for expenses 12.Click on Sales Tax section 13.Select Sales Tax Group 14.Select Item Select Tax Group 15.Click on Post Button 16.Select Post option to post the invoice journal transaction

Autoform for Microsoft Dynamics Axapta is not advisable

Autoform for dynamics axapta is not advisable If you are seeking for auto form functionality in dynamics axapta then its not advisable because axapta is ERP not language kind of like asp.net or java. Dynamic form and report is feasible to make but it will not work properly. If anyway you able to design and develop run time form then to make report run time is not feasible because lot of design work and formatting may required to client which is only possible in static designed report. Taking everything run time and dynamic is time waste work if you are leading technical team then never advice for run time functionality for form and report. If you want to report run time then showing data in Microsoft excel from axapta is advisable. If you are trying to make dynamic entry from dot net platform and making report in axapta then it will not easily feasible. Crosstab query work well in Microsoft access , sql excel etc but in axapta ERP there is no such facility. So take care d

Target date not found in work calendar error in MS Dynamics axapta 2009

If you are facing error like " Target date not found in work calendar error"  during workflow configuration or process then you can do following things This problem occured because calendar not set for workflow you can set it by going following menu Basic->common form ->Go to calendar Enter calendar details if its missing and make control field open if its closed then go to workflow configuration select this calendar. If you done correctly then this error will resolved automatically so do not worry its not technical error its functional issue.

Error executing Code: SysDictMenu object not initialized Workflow MS Dynamics axapta

when I select user group permission setup form, In permission tab ,I can’t select workflow view from viewing drobdown list. It shows Error Message, Error executing Code: SysDictMenu object not initialized. (c) \classes\SysDictMenu\label ... (c)\Classes\SysSecurityViewWor kFlow\initMenuItemType -line 22 (C)\Classes\SysSecurityViewWor kflow\initworkflowTemplateMenu Items - linew 53 (C)\Classes\SysSecurityViewWor kflow\initworkflowview - line 219 (C)\Classes\SysSecurityViewWor kflow\init -line 11 (C)\Classes\SysSecurity\initSe curityTable -line 8. (C)\Form\SysUserGroupSecurity\ Methods\updateprogress - line 59 How to resolve this problems?. Solution : This is not installation problem nor configuration of workflow problem .This problem can come if you are trying to customize workflow for new module if you have done any mistake on properties selection for workflow component then you can face this problem you can resolve this problem by correcting your customizatio

Microsoft Dynamics website for MSD

Microsoft Dynamics works like and with familiar Microsoft software, automating and streamlining inancial, customer relationship and supply chain processes in a way that helps you drive business success. U.S. and Canada Toll Free 1-888-477-7989 Worldwide +1-701-281-6500

Production order for BOM sub items in Microsoft dynamics Axapta MSDAX

If you are creating production order for bom items and items bom level is more than 2 or 3 then it may be possible to system will take more time to create production order or it will hang  . I have face this problem and tried to debug following classes. BOMHierarchyCheckscanupBOM BOMHierarchyCheckserchdownbom Prodtabletype I found there is problem due to inventdimid and number sequence creation problem I tried to reassign number sequence for particular inventory dimension. Finally it got resolved..Thank God.

How to use financial Dimension technically in MSD AX 2012

a. Open AOT>>Data Dictionary>>Extended Data Types type/select Dimension Default and drag it in table which will be used further as a data source in form where you have to show the Dimensions. Do Remember  that you have to drag it in table not at Data Source. b .Open Table in the Data, Dictionary which will be used as a Data source, and create a relation with table DimensionAttributeValueSet . c .Right Click the Relations. Select ‘New Realation’.  Select properties. Set name as DimensionAttributeValueSet, Table as DimensionAttributeValueSet. d. Right Click the this newly created Relation DimensionAttributeValueSet, select New>>Normal. e. Set the properties of Normal Relation as:  Field=TheFieldwhichwillsaveDimensionNumberInYourTable Source EDT= DimensionDefault Related Field=RecId 2.Verify that the table that will hold the foreign key to the DimensionAttributeValueSet table is a data source on the form(the one on which you have to show dimensions

How Group by clause work in MSD Axapta x++

How Group by clause work in Axapta x++ If we use group by clause in ax then we should know how it work . for example select tabletest group by testno,testgroup; it means you will get record by grouping of testno and testgroup but it there is no field selected that means its internally two fields testno,testgroup is in select query means actual query working like this. select testno,testgroup from tabletest group by testno,testgroup; you can also select group by clause with while like this while select tabletest group by testno,testgroup { statements; ----------- ---------- } if we take aggregate funtion with group by clause like this select count(recid) from tabletest group by testno,testgroup; then actual query will work like this select count(recid),testno,testgroup from tabletest group by testno,testgroup;

AOS tasks in Microsoft dynamics Axapta MSDAX

AOS Tasks • X++ run time: It runs the X++ code which provides most of the business logic in Microsoft dynamics AX. • Security: It enforces security to manage access to data and functionality. Record level security • Session management: It manages client sessions. • Web services: It is a web service endpoint.

SQL Error can not select record from table abc in MSD axapta

Some times we face this error which is SQL Error " can not select record from table abc " in axapta application. This error comes due to some index problem or record duplication in table to resolve this problem we can do following. 1. Find index which creating problem you can re index that index. 2. Restore table using right click on table restore option. 3. Synchronize table if problem still not resolved. 4. If problem still not resolved then try to synchronize whole data dictionary in AOT. 5. If you are facing problem due to duplication of records then try to delete duplicate records. By using above steps I hope your problem will resolve.

User name and password screen form for MSD axapta applicaiton

User name and password screen form for axapta applicaiton: If you want to set separate login screen for axapta application then its very difficult to implement but I want to share some hint to help you because this things is in high demand. 1. First you can create table for login details with field user-id and password. extended data type for user id should be userid to select user id for password you can set property password type to yes then you can use different event to maintain password in * character through code. 2. Create login form to enter login details to store it. 3. Create another login form put control for userid and password to check from table you can write validation code on that form. 4. put that form in display menu. 5. call that login form in  application class in start-up post method. this will work if everything done well.

Send report to email using batch process in MSD axapta

Send report to email using batch process in axapta To send any report to particular email of person throgh batch process we need to follow folloing steps and points 1. set email parameter set outgoing email,local host, user name and passwords. 2. set email template there you can give sender name,email, description,language etc. 3. set email in report dialog and select pdf print option, 4 . Make sure server is added to allow send mail etc in different applications which restrict to send email through axapta batch process. 5. set reccurence in batch process of report to set time etc. if you do all those steps completely than you can get success in this task .

Example of validate method in MSD Ax using language x++

Example of validate method in Ax using lanugage x++ void clicked() { super(); if(str2num(rlSrNo_Update.valueStr()) == 0) { Warning("Not Valid Roll No"); } else if(strEmployeeName_Update.valueStr() == "") { Warning("Pleae Enter Employee Name"); } else if(cmbTravellingThrough_Update.selection() == test_Travelling_Through::None) { Warning("Pleae Enter Traveling Through"); } else { element.Update_test_Emp_Travel(); } }

Update records and grid in MSD axapta x++ language

Update records and grid in axapta x++ language public void Update_test_Emp_Travel() { ; ttsbegin; Select forUpdate test_Emp_Travel where test_Emp_Travel.SrNo == str2num(rlSrNo_Update.valueStr()); test_Emp_Travel.Employee_Name = strEmployeeName_Update.valueStr(); test_Emp_Travel.Travelling_Through = str2enum(test_Travelling_Through,cmbTravellingThrough_Update.valueStr()); test_Emp_Travel.update(); ttscommit; test_Emp_Travel_ds.reread(); test_Emp_Travel_ds.refresh(); test_Emp_Travel_ds.research(true); test_Emp_Travel_ds.executeQuery(); element.ClearField_Update(); GridEmpTravel.update(); GridEmpTravelDetails.update(); }

Insert Records and update grid in MSD axapta

 Insert Records and update grid in axapta x++ public void Insert_test_Emp_Travel() { ; test_Emp_Travel.SrNo = str2num(rlSrNo.valueStr()); test_Emp_Travel.Employee_Name = strEmployeeName.valueStr(); test_Emp_Travel.Travelling_Through = str2enum (test_Travelling_Through,cmbTravellingThrough.valueStr()); test_Emp_Travel.insert(); test_Emp_Travel_ds.reread(); test_Emp_Travel_ds.refresh(); test_Emp_Travel_ds.research(true); test_Emp_Travel_ds.executeQuery(); element.ClearField_Insert(); GridEmpTravel.update(); GridEmpTravelDetails.update(); }

The number to convert to a text string using MSD axapta x++

num2Str info("num2Str(real number,int character,int decimals,int separator1,int separator2)"); info("number - The number to convert to a text string."); info("character - The minimum number of characters required in the text."); info("decimals - The required number of decimals."); info("separator1 - The decimal separator. Possible values: 1 – point (.) and 2 – comma (,)"); info("separator2 - The thousands separator. Possible values: 0 – no thousands separator ,1 – point (.) ,2 – comma (,) ,3 – space ( )"); info("num2Str(12345.6,1,2,1,2) " + num2Str(12345.6,1,2,1,2));   

Dialog in Report using MSD axapta x++ language

Dialog in Report //1. Class Declaration public class ReportRun extends ObjectRun { dialogField dftest_Enum_EDT; dialogField dfFromDate,dfToDate; dialogGroup dialogGroup; test_Enum_EDT test_Enum_EDT; Date dtFrom,dtTo; str strtest_Enum_EDT; } //2. Dialog public Object dialog(Object _dialog) { DialogRunbase dialog = _dialog; ; dialogGroup = dialog.addGroup("DialogGroup"); dftest_Enum_EDT = dialog.addField(typeid(test_Enum_EDT)); //dialog.addFieldValue(typeid(test_Enum_EDT)); dfFromDate = dialog.addField(typeId(FromDate));//dialog.addFieldValue(typeId(FromDate),dtFrom); dfToDate = dialog.addField(typeId(ToDate));//dialog.addFieldValue(typeId(ToDate),dtTo); return dialog; } //3. getFromDialog public boolean getFromDialog() { ; strtest_Enum_EDT = dftest_Enum_EDT.value(); test_Enum_EDT = dftest_Enum_EDT.value(); dtFrom = dfFromDate.value(); dtTo = dfToDate.value();

Overwrites part of a text string with another text string in MSD axapta x++

strPoke (Overwrites part of a text string with another text string) info("str strPoke(str _text1,str _text2,int _position)"); info("Overwrites part of a text string with another text string."); info("_text1 - The original string."); info("_text2 - The string to replace part of _text1 with."); info("_position - The position in _text1 at which to begin replacing the characters."); info("strPoke(\"123456\",\"AAA\",3) " + strPoke("123456","AAA",3));

Retrieves part of a string in axapta x++

 subStr (Retrieves part of a string) info("str subStr(str _text, int _position, int _number)"); info("Retrieves part of a string."); info("_text - The original string."); info("_position - The position in _text to begin the new string."); info("_number - The number of characters to select from _position onwards."); info("subStr(\"ABCDEFG\",2,4) " + subStr("ABCDEFG",2,4)); info("subStr(\"ABCDEFG\",5,-3) " + subStr("ABCDEFG",5,-3));

Remove particular chars from a string in MSD axapta x++

 strRem (Removes particular chars from a string) info("str strRem(str text1, str text2)"); info("Removes the characters specified in one text string from another text string."); info("text1 - The original text string."); info("text2 - The text string you want to remove the letters from."); info("strRem(\"ABCDEFGABCDEFG\",\"ACEG\") " + strRem("ABCDEFGABCDEFG","ACEG"));

Delete excluded characters in MSD axapta

 strKeep (Delete excluded chars) info("str strKeep(str _text1, str _text2)"); info("Deletes all of the characters in a text string that are not included in another text string."); info("_text1 - The first text string."); info("_text2 - The characters to keep in the first text string."); info("strKeep(\"ABBCDDEFGHB\",\"BCD\") " + strKeep("ABBCDDEFGHB","BCD"));

Deletes a specified part of a text string in MSD axapta

StrDel (Deletes a specified part of a text string) info("str strDel(str _text,int _position,int _number)"); info("Deletes a specified part of a text string."); info("_text - The text string to delete characters from."); info("_position - The position at which to start deleting characters."); info("_number - The number of characters to delete (including the character at position)."); info("strDel(\"ABCDEFGH\",2,3) " + strDel("ABCDEFGH",2,3)); info("strDel(\"ABCDEFGH\",5,-3) " + strDel("ABCDEFGH",5,-3));

Insert a string into another string using MSD axapta x++

strIns (Insert a string into another) info("str strIns(str _text1, str _text2, int _position)"); info("Inserts a text string into another text string."); info("_text1 - The original text string."); info("_text2 - The text string to insert into _text1."); info("_position - The position in _text1 where _text2 is to be inserted."); info("strIns(\"ABFGH\",\"CDE\",3) " + strIns("ABFGH","CDE",3));

Get number sequence code through code in MSD axapta

To Create a new number sequence Basic>Setup>NumberSequence>NumberSequence e.g. test_NS with format ######_NS Now in any form Where the Table e.g. test_NumberSequence is used, override create method of test_NumberSequence under DataSource Node and do the following //1. in class declaration of form public class FormRun extends ObjectRun { numberSeq numberSeq; } //2. in create method of test_NumberSequence public void create(boolean _append = false) { super(_append); numberSeq = NumberSeq::newGetNumFromCode("test_NS", true,true); if (numberSeq) { test_NumberSequence.NS_id = numberSeq.num(); } }

Parmobject with container in MSDAx

parmObject (Container) //1. Send void clicked() { Args args = new Args(); ContainerClass conClass_Obj; Container conSend; ; conSend = conins(conSend, 1, "Call Of Duty"); conSend = conins(conSend, 2,"BattleField"); conSend = conins(conSend, 3, "Assisins Creed"); conSend = conins(conSend, 4, "retrive hell"); conClass_Obj = new ContainerClass(conSend); Args.parmObject(conClass_Obj); new MenuFunction(menuitemdisplaystr(test_ParamObject_Recieve), MenuItemType::Display).run(args); } //2. Receive public void init() { //super(); str s1,s2,s3,s4; containerClass conClass_Obj; container conRec; Args args; ; super(); args = new args(); conClass_Obj = element.args().parmObject(); conRec = conClass_Obj.value(); s1 = conpeek(conRec,1); s2 = conpeek(conRec,2); s3 = conpeek(conRec,3); s4 = conpeek(c

Find a first occurrence of a character in a string in reverse in MSD axapta x++

strNFind  (Find a first occurrence of a character in a string in reverse) info("int strNFind(str _text,str _characters,int _position,int _number)"); info("Searches a portion of a text string for the first occurrence of a character that is not included in a specified list of characters."); info("_text - The text string to search."); info("_characters - The list of characters to exclude from the search."); info("_position - The position in the string that the search should start at."); info("_number - The number of characters to search."); info("strNFind(\"ABCDE\",\"ABCE\",1,5) " + int2str(strNFind("ABCDE","ABCE",1,strLen("ABCDE"))));

Find a first occurrence of a character in a string in MSD axapta

strFind (Find a first occurrence of a character in a string) info("int strFind(str _text,str _characters,int _position,int _number)"); info("Searches a text string for the first occurrence of one of the specified characters."); info("_text- The text string to search."); info("_characters - The characters to search for."); info("_position - The position in the text string where the search begins."); info("_number - The number of characters to search."); info("strFind(\"ABCDEFGHIJ\",\"C\",1,10) " + int2str(strFind("ABCDEFGHIJ","C",1,strLen("ABCDEFGHIJ")))); info("strFind(\"ABCDEFGHIJ\",\"C\",10,-10) " + int2str(strFind("ABCDEFGHIJ","C",strLen("ABCDEFGHIJ"),(-1) * strLen("ABCDEFGHIJ"))));

Compares two text strings in MSD axapta x++ language

strCmp (Compare Two Strings) info("int strCmp(str text1, str text2)"); info("Compares two text strings. The function is case-sensitive."); info("0 if the two strings are identical, 1 if the first string is longer, or -1 if the second string is longer."); info("e.g."); info("strCmp(\"abc\",\"abc\") = " + int2str(strCmp("abc","abc"))); info("strCmp(\"ABC\",strUpr(\"abc\")) = " + int2str(strCmp("ABC",strUpr("abc")))); info("strCmp(strLwr(\"ABC\"),\"abc\") = " + int2str(strCmp(strLwr("ABC"),"abc")));

Converts string to lowercase in axapta x++ language MSDAX

To Converts all letters in a text string to lowercase in axapta x++ language You can try following code in job. I hope this can be helpful for you for string manipulation programs. strLwr (String Lower) info("str strLwr(str _text)"); info("Converts all letters in a text string to lower case."); info("strLwr(\"ABcd123xYZ\") " + strLwr("ABcd123xYZ"));

Send and recieve parameter string by args in MSD axapta

Send and recieve parameter string through args in axapta 1. Send void clicked() { Args args = new Args(); ; Args.parm("retrive hell"); new MenuFunction(menuitemdisplaystr(abc_Param_String_Recieve), MenuItemType::Display).run(args); } 2. Receive public void init() { // super(); str paramString; Args args; ; super(); args = new args(); paramString = element.args().parm(); info(strfmt("paramString = %1",paramString)); }

Section Group Report using fetch in MSDAX

In Section Group Report not using fetch(Query) only drag and drop the fields you want to get displayed from tables in datasource node In Section Group Report using fetch(Query)  drag and drop the field you want to displayed from tables in datasource node  and do the following public boolean fetch() { test_ItemYN test_ItemYN_Obj; QueryRun qr; QueryBuildDataSource qbds_test_ItemYN, qbds_test_Item_Price; Query q = new Query(); QueryBuildLink QueryBuildLink1; ; q = new query(); qbds_test_ItemYN = q.addDataSource(tableNum(test_ItemYN)); qbds_test_Item_Price = qbds_test_ItemYN.addDataSource(tablenum(test_Item_Price)); // qbds.addLink(fieldnum(pARENTtABLE, FD_Id), fieldnum(cHILDtABLE, Parent_FD_Id)); qbds_test_Item_Price.addLink(fieldnum(test_ItemYN, ItemId), fieldnum(test_Item_Price, ItemId)); qbds_test_Item_Price.relations(true); //qbds_test_Item_Price.joinMode(JoinMode::ExistsJoin);// JoinMode::InnerJoin qbds_t

For Loop Selection from Grid in MSD axapta

For Loop Selection from Grid Syntax of for loop will be like this for ( <your table object>= _formDS.getFirst(true) ? _formDS.getFirst(true) : [_args.record()]/ [TableName]; <your table object>; <your table object> = _formDS.getNext() ) { //you can understand better way by using this example. } for ( Employee1 = Employee_ds.getFirst(true) ? Employee_ds.getFirst(true) : Employee; Employee1; Employee1 = Employee_ds.getNext() ) { args.record(Employee1); new MenuFunction(menuitemoutputstr(EmployeeReport), MenuItemType::Output).run(args); }

Simple runtime lookup code in axapta x++ language of Microsoft MSDAX

Simple runtime lookup code in axapta x++ language of Microsoft public void lookup() { //super(); SysTableLookup tableLookup; QueryBuildDataSource qbds_Test_Item_YN; Query q = new Query(); ; tableLookup = SysTableLookup::newParameters(tableNum(Test_ItemYN),this); tableLookup.parmUseLookupValue(false); qbds_Test_Item_YN = q.addDataSource(tableNum(Test_ItemYN)); tableLookup.parmQuery(q); tableLookup.addLookupfield(fieldNum(Test_ItemYN,ItemId)); tableLookup.addLookupfield(fieldNum(Test_ItemYN,ItemName)); tableLookup.performFormLookup(); }

General Features of the BOM Designer in MSDAX

General Features of the BOM Designer in axapta 2012 Use the BOM designer to perform the following actions: • Create new BOM versions or edit the existing ones. • Edit and delete BOM lines. • Check BOMs for errors, for example, BOM circularity. • Check which BOM versions  are attached to the selected BOM. • Check at which sites the BOM versions are assigned. • Print BOM and BOM lines for the selected BOM. • Verify the site to which the BOM line belongs

The complete syntax for the While select statement in MSD axapta

The complete syntax for the While select statement in axapta [while] select [reverse] [firstfast] [firstonly] [firstOnly10] [firstOnly100] [firstOnly1000] [forupdate] [nofetch] [crosscompany] [forcelitterals | forceplaceholders] [forcenestedloop] [forceselectorder] [repeatableRead] [validTimeState] [ * | <fieldlist> from] <tablebuffer> [ index [hint] <indexname> ] [ group by {<field>} ] [ order by {<field> [asc][desc]} ] [ where <expression> ] [ outer | exists | notexists ] join [reverse] [ * | <fieldlist> from] <tablebuffer> [ index <indexname> ] [sum] [avg] [minof] [maxof] [count] [ group by {<field>} ] [ order by {<field> [asc][desc]} ] [ where <expression> ] ] <fieldlist> ::= <field> | <fieldlist> , <field> <field> ::= fieldname | <function>(<field>)