Skip to main content

Posts

Showing posts from 2011

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>)

How can you compare layers of MSD Axapta

How can you compare layers of Axapta i) Microsoft Dynamics AX menu >Tools >  Development tools > Code Upgrade > Compare layers ii) Enter the name of Project iii) Select the Surce Layer used as the base layer for the comparison. iv) Select Reference Layer that you want to compare to the Source Layer. v) A new private project will be created in the Project node.

create a new language in MSDAX 2009

create a new language in AX 2009 For creating new language follow the steps. i) Go to AX Menu > Tools > Development Tools > Label > Label File Wizard. ii) Check on Create new label Language then click on Next button. iii) Select language. iv) You can also create new language id by click on Create new language button.

AX among other Dynamics MSDAX

Microsoft bought four independent ERP packages for small to medium business over the years. Microsoft now markets all four + CRM under the Dynamics branding. The ERP packages are AX (Axapta), Great Plains, Navision and Soloman. These four ERP's fit into various customer requirements better or worse depending on what your business requirements are. AX is the choice if a very high degree of customization is required by the customer. The others, not so much.  AX is for EnterpriseMicrosoft Great Plains is TIER 2 application whereas Microsoft AX is TIER 1. TIER 2 means for Small and Medium Size Enterprises  and TIER 1 means Enterprise. Enterprise means where employee count is more than 20,000 and more than 200 concurrent users.

Code For sending data from form to Class using container in MSDAX

Code For sending data from form to Class using container //Write this code on form Container returnAbc() { Container Abc; int conPos = 0; ; conPos ++; Abc= conins(Abc,conPos,test.valueStr()); return Abc; } //Write this Code on class main() { callerForm = _args.caller(); Abc= callerForm.returnFilter(); } void initFilters(Container _Abc) { aAbc = conpeek(_filtAbc,1); }

Code to save previous selected value in form in MSD Axapta

Declare variable in class declaration #define.CurrentVersion(1) #localmacro.CurrentList _itmeid, _description, _classtype #endmacr define pack method public container pack() { return [#CurrentVersion,#CurrentList]; } Then define unpack method public boolean unpack(container _packedClass) { Version version = conpeek(_packedClass,1); ; switch (version) { case #CurrentVersion : [version, #CurrentList] = _packedClass; break; default : return false; } return true; }

Code to generate number sequence in class using MSD axapta

Code to generate number sequence in class using axapta x++ Assign number sequence from parameter table numberSeq = NumberSeq::newGetNumFromCode(LedgerParameters::numRefJournalNum().NumberSequence, true, true); //put value of number sequence to variable this way. voucher = NumberSeq::newGetNumFromCode(ledgerJournalName.VoucherSeries, true, true).num();

Code for uploading image file in table using MSD axapta

Code for uploading image file in table using x++ code FilenameFilter filter = ['Image Files', '*.bmp;*.jpg;*.gif;*.jpeg']; BinData binData = new BinData(); str extest, filepath, nameofFile; ; super(); imageFilePathName = WinAPI::getOpenFileName(element.hWnd(),filter,'',"abc"); if(imageFilePathName && WinAPI::fileExists(imageFilePathName)) { [filepath, nameOfFile,extest] = fileNameSplit(imageFilePathName); if(extest== '.bmp' || extest== '.jpg' || extest== '.gif' || extest== '.jpeg') { bindata.loadFile(imageFilePathName); imageContainer = bindata.getData(); TestTable.Image =imageContainer; TestTable.write(); } else { throw error("Error in uploading"); } }

Difference Between modifiedfield and validatefield method in MSD Axapta

Difference Between modifiedfield and validatefield method modifiedfield and validatefield both method recieve the active field number as parameter.modifiedfield() is used to initialize the value of other fields and does not return an value. while validatefield method  is used for validation only and will return true or false.

Menu path to export table data in Excel Templates in MSD axapta

 This is  a menu path to export table data in Excel Templates. You can keep that data as table backup for security purpose. Administration -> Periodic -> Data Export/Import -> Excel SpreadSheets -> Template Wizard If you want to import that data  again in axapta then you can import same temple using following menu path. Administration -> Periodic -> Data Export/Import ->Import Excel Template.

Deploy reports right from the MSD Axapta

Deploy reports right from the AX 1. First install Reporting Extensions, Configure reporting Servers  then Go to  > AOT. 2) You can check your AX folder if you actually have Report Deployment installed. For example; C:\Program Files\Microsoft Dynamics AX\50\Reporting Services\AxReports.exe 3) You can also try to run it from the AX installation CD itself, For example; D:\Msi\Components64\Progra​m Files\Microsoft Dynamics AX\50\Reporting Services

Code to create csv file from table data in MSDAX

If you want  Code to create csv file from table data using x++ code in Axapta application Try this code in job //Declaration of variables #File CommaTextIo commaTextIo; FileIOPermission permission; CustTable custTable; //assign file path and file name str fileName = strFmt('%1\\ax_%2.csv', WinAPI::getTempPath(), "Name"); // @"C:\My Documents\abc.csv"; ; permission = new FileIOPermission(fileName,#io_write); permission.assert(); commaTextIo = new CommaTextIo(fileName,#io_write); //select data in query to write in csv file while select custTable { commaTextIo.write(custTable.AccountNum,custTable.Name); } CodeAccessPermission::revertAssert(); //After execution of job you can see .csv file in temp folder

Fundamental of Class Declaration in MSD axapta

Class Declaration The classDeclaration consists of three types of definitions: Variables used to create fields in the dialog Variables used within the data manipulation Local macro to define which variables to pack (in other words,remember for next time, and/or use on the batch server) In this example the class declaration is as follows: public class DemoRunBase extends RunBase { DialogField dialogAccount; DialogField dialogFromDate; DialogField dialogToDate; LedgerAccount ledgerAccount; FromDate fromDate; ToDate toDate; #DEFINE.CurrentVersion(1) #LOCALMACRO.CurrentList ledgerAccount, fromDate, toDate #ENDMACRO } The individual fields of the dialog will be initialized in the method dialog(). When the dialog is accepted by the user, the contents of the dialog fields are read in the method getFromDialog(). As both methods have to access the same variables, they are defined as members of the class. The manipulation in the method ru

What is RunBase Class in MSD axapta ?

What is RunBase Class? The RunBase class is an abstract class which defines common structure for all data manipulation functions in AX. The minimum implementation of a RunBase class includes following methods a. ClassDeclaration b. Dialog c. getFromDialog d. Pack e. UnPack f. Run g. Description (static) h. Main (static)

Describe Args in Microsoft dynamics axapta MSDAX

1. The Args Class defines information communicated between running application 2. This Communication can occur automatically without any X++ programming. 3. If the caller is activating the called object by a menu item the Args object is automatically initialized and set as a parameter to the object called. AOT properties of the menu item  will be used. 4. Different type of Args sent to caller as follows. Type of Args Args.record(Table_Obj) Used to access the value of the caller’s record of Table_Obj Args.Caller(this) Send the Caller as an object to the called object. Args.ParamEnumType(Enum_Obj) Send ID of enumType that is specified in param Enum. Args.ParamEnum(Enum_Obj::Value1) Sends an EnumValue Args.ParamObject(AnyObject) To transfer any object ,Args.Param(str) To transfer a string, but this method is not considered as best practice.

Execution sequence at the time of Report run in MSD axapta

  Report Run with execution sequence 1. Init – Called on Report is initialized. 2. Dialog / getFromDialog – Called before fetch to interact with Client. 3. Fetch – Do the following     a. Initialized the QueryRun     b. Prompt a Query     c. Prompt printer settings     d. Fetch the data     e. Send the data 4. Send – This method is activated every time a record is to be printed. 5. SectionId.ExecuteSection – print the control/s of the section

Purpose of Ledger Account statement report in MSD axapta

Ledger Account statement report in axapta Ledger Account statement report  is a very important report for accounting purpose in Axapta ERP.  Main tables used to fetch data is ledgertrans, ledgerTable and balancedimtrans. To show opening balance and ledger transaction one temparary tables tmpdimtrans . There are some fields like accomulatedAmountMST and AmountDebitCredit. AccumulatedAmountMSt gives calculated opening balances as per transaction and amountDebitcredit should debit and credit amount for particular period. One important class used in this  report is LedgertransReportEngine. All functionality of data handled through this class. Ledger report work as per dimesions through this class.

How to define Common Table in MSD Axapta?

Common Table in Axapta The system table Common is the base for all tables. The table contains no data, and the table can be compared with a temporary application table. Common is used like the base type anytype. You can set any table equal to the table Common. This is useful if you need to transfer a table as a parameter and not knowing the exact table before execution time. static void DataDic_Common(Args _args) { Common common; CustTable custTable; ; common = custTable; if (common.tableId == tablenum(custTable)) { while select common { info(common.(fieldnum(custTable, name))); } } } The example above is initializing Common with CustTable. A check is made to assure that Common is now equal to CustTable. All records from CustTable are looped, and the customer name is printed in the InfoLog. Notice, the system function fieldnum() is used to get the field name printed. If you do not know the fieldname at runtime, you can enter the field id

List of Dynamics Axapta ERP Top companies All over world

Following is a List of Dynamics Axapta ERP Top companies in the world Godrej Infotech MSBS Business solution Logica Sverige AB Avande Asea Pvt ltd BDO Dunboody LLP GMCS verix ABsys cyborge SA COSMO Consult Yokogava solution corporation 2e2 UK ltd Sonoma partners veri park Sable system pty ltd Second foundation consulting inc Demand mangement Dynamic software Tectura Sonata Columbus IT Other companies in India Dev Information technology India Pvt Ltd,Ahmedabad Synoverge, Ahmedabad  Tieto pune SHRISHAIL,Noida  LnT Infotech ,Mumbai Blue Star InfoTech ,Mumbai CGI,Bangalore PRoV International,Chennai  Hitachi Solutions ,Pune IL&FS Technologies ,Gurgaon Indusa,Ahmedabad Fujitsu,Gurgaon MPG,Gurgaon Ali Technologies ,Delhi  S3 infotech,Noida Persistent,Pune NDS Infotech ,Mumbai Capgemini,Mumbai KPIT,Pune TCS,Bangalore HCL,Noida GE,Gurgaon Infosys,Bangalore CorporateServe,Gurgaon Zylo

How to add Hyperlink in share point List with WSS 3.0

How to add Hyperlink in sharepoint List 1. You have to create custom field types in WSS 3.0 2. For creating custom field types, you need to have an '.ascx' which holds the sharepoint rendering template along with the dotnet web control (which is your hyper link) 3. You need to deploy this '.ascx' using custom field types by making use of WSS 3.0 feature framework 4. Finally you have to create a field of type 'custom field type' created.

Create new user in the share point for MSD axapta EP

Go to your Domain Controller Start --> Run --> type dsa.msc. It opens active directory users and groups.right click on Users and go to new from there select user and provide user details.that's it you created users in Active directory. Assign User to EP Site

Interview questions and answers on share point

1.Master page deployment. How? 2. Can Master page has .cs file and if yes where is it placed? 3. Can you deploy a web part in a web part? 4. Why do you use InfoPath forms over asp.net pages? 5. What are content types? why we need site columns? 6. Difference Site Definition and Site Template. 7. How can you create Master page using Object model 8. In ASP.Net- difference between Website and Web Application 9. Is String builder Value type or Reference type 10. How do you configure search 11. Why we need SSP 12. Difference between SSP and Central Admin 13. What are new features in Share point 14. Different authentications in share point 15. Scenario and write code in object model- In a web part input name,phone and address fields and two lists on different servers should be updated with the entered data. 16. Why we need features 17. Difference between web part manual deployment and using features 18. How do you develop connectible web parts 19. How many web part managers

Solution for Error unable to load usercontrols and .ascx file not found in MSDAX

1. Create a Directory called “usercontrols” in the root of your share point web site on the file system E.g. C:\Inetpub\wwwroot\wss\VirtualDirectories\moss.litwareinc.com80\UserControls 2. Open IIS manager and in the root of your Share Point site create a Virtual Directory called “_controls” and point it to that newly created directory. 3. Put your user control in that newly created directory on the file system 4. Open the web.config file and add the following: 5. In your ASPX page add the following: <%@ Register src="~/_controls/SomeControl.ascx" mce_src="~/_controls/SomeControl.ascx" TagName="somecontrol" TagPrefix="uc2" %"> 6. Run your ASPX page and your control should render correctly.

Difference between master pages and layout pages in MSD Axapta EP

Though there might me a confusing point in Pagelayout and MasterPage, Difference lies in the processing of files and contents in SP. Page Layout is first streamed and compiled with Content Page and then only the Associated Master Page is queried to SP File provider and again master page is compiled and a complete page is returned back to the Client or to the requesting Browser. Page Layout is just an ASPX page which holds Page Content and you must know the mapping of Page Content and Page layout. But, master page is the same master page which you use on asp.net

Future of microsoft dyanamics MSD Axapta

Future of microsoft dyanamics Axapta I hope the Microsoft Dynamcis is doing good in the meduim segment industries right now. I feel that the future versions of AX might come in more robust and  support(integrate) the .NET architecture rather than improve the X++ language. As always Microsoft knows how to create markets for AX. I feel we cannot compare AX with SAP or other tier-1 applications as they have their own strengths and target market areas. Microsoft Axapta ERP doning well on production area,financial,trades and logistic and secondary sales modules. In future Axapta future is bright because its license comes on affordable prices and implementation of ax is so easy and completed in small time frame.

Tables used in production picking order in MSD axapta

Tables used in production picking order If you are trying to create production picking order through code then you may know two table prodtable and prodjournalbom but if you will insert record only on two table then some error you face. One internal table used which is prodbom table you also need to insert record in that table then you will not face any error.

Custom Invoice posting problem in MSD axapta

Some time Ax system not allowed to post custom invoice or sales order due to some restriction in coding.If sales order created in other currency instead of dollars then that type of problem come. To resolve that problem you can take following action. Go to SalesFormLetter_Invoice class there one method name is Journal post-> just put debug on that method you will able to find solution.

Code to check for current user have admin rights in MSD axapta

Code to check for current user have admin rights Str CcuruserID; UserInfo userInfo; UserGroupList UserGroupList1; ; CcuruserID=curuserID(); #Admin info(CcuruserID); select firstfast UserGroupList1 where UserGroupList1.groupId == #AdminUserGroup && UserGroupList1.UserId == curuserid(); if (UserGroupList1) info("Current User have admin rights");

Disable delegated authentication for user account in MSD axapta

Disable delegated authentication for user accounts Delegated authentication occurs when a network service accepts a request from a user and assumes that user’s identity in order to initiate a new connection to a second network service. By default, user accounts are not configured for delegated authentication, but you must verify that no user accounts that will use Kerberos authentication in Enterprise Portal are currently configured for delegated authentication. 1. In Active Directory Users and Computers, right-click a user account and select Properties. 2. On the Account tab, under Account Options, clear the Account is sensitive and cannot be delegated check box (if applicable), and click OK. Enable delegated authentication for IIS application pool accounts. Use this procedure to enable delegated authentication for the IIS application pool account. 1. In Active Directory Users and Computers, right-click the name of the IIS application pool account and select Properties. 2. C

Configure the HTTP Service Principal Name in MSD axapta

Configure the HTTP Service Principal Name Use this procedure to create an HTTP SPN for each Enterprise Portal and SQL Server Report Server computer. You can perform this procedure from one computer. It is not necessary to perform this procedure locally on each server. 1. Open the Windows Support Tools command prompt (Start > All Programs > Windows Support Tools > Command prompt). 2. At a command prompt, type the following command and press Enter: Setspn.exe -A HTTP/{server name} {application pool account} For this command, remove the braces {}, replace server name with the name of the server computer, and replace application pool account with the domain\name used for the IIS application pool. Here is an example of this command: Setspn.exe -A HTTP/EnterprisePortal1 contoso\WebAccount 3. Type the following command and press Enter: Setspn.exe -A HTTP/{the server fully-qualified domain name} {application pool account} For this command, remove the braces {}, replace the

Customer Portal in MSD Axapta

Customer Portal in Axapta Customer Portal gives service customers access to their service related data over an enterprise portal whenever required, thereby providing a new 365 days a year,24 hours a day kind of interaction between the service company nd the customer. A decrease in the tasks associated with giving service customers access to the data through other communication channels (telephone, e-mail messages, and so on) is expected. Basically, Customer Portal helps the Service customer who has two groups of requirements: • The need to view the data relevant for the service operation done on service items • The need to connect to the service company to initiate a service request

Tasks in Lead Management of MSD Axapta CRM

Tasks in Lead Management of Axapta CRM Lead Management enables users to manage and maintain lead records by: • Creating records - manual entries in the Lead maintenance or Lead entry forms • Reviewing records - records can be viewed in multiple ways such as by status or subject • Modifying records - specific information about a lead can be changed to update records • Deleting records - permanently remove lead records from the database. Users have the option to restrict deletion of records that a company does not want deleted

Lead Management in MSD Axapta CRM

Lead Management in Axapta CRM Lead Management is a feature of Sales Force Automation that enables sales teams to collect and store information about a lead and also develop sales activities and tasks that qualify leads into opportunities. Lead Management consists of two main components: • Lead Management - creating, reviewing, updating, and deleting lead information. • Lead Qualifying Process - creating, reviewing, updating, and deleting stages or steps and also activities that are needed to qualify or disqualify a lead.

Microsoft Dynamics Axapta 2009 CRM Module Introduction

Introduction of CRM module in Axapta Microsoft Dynamics™ AX 2009 has many new features in the CRM module that enable a clearer view of a company’s sales processes. These clearer views enable companies to better manage and conduct their sales processes, as well as enable better documentation of processes and procedures for future use. The CRM module, together with the rest of the modules in Microsoft Dynamics AX 2009, has new navigation features that enable users to configure their own workspace. Users can decide what forms and lists to display on their home page to avoid having to search for forms and lists used most frequently. Preconfigured role pages help users in setting up their home page. Another new feature is the ability to view and conduct sales force activities through the Enterprise Portal. Almost any sales force activities in the application can now be performed through the portal. This enables mobile workers, customers, and vendors access to information and tasks t

Create a Quality Miscellaneous Charge in MSD axapta

Create a Quality Miscellaneous Charge in axapta To create a quality miscellaneous charge, follow these steps: 1. Open Inventory management > Setup > Quality management >Quality Miscellaneous  . charges. 2. Press CTRL+N to create a new quality miscellaneouse charge. 3. In the Misc. charges code field, type the name or identifier. 4. Optionally, type the description in the Description field. 5. Press CTRL+S to save the new record

Exporting Project Controls to Excel in MSD axapta

Exporting Project Controls to Excel in Axapta 1. Click the Export to Microsoft Office Excel button 2. Designate the file name and location. 3. Select the measurements to be included in the pivot table. These measurements are the data fields generated by the Project control screen. 4. Select the dimensions to be used in the pivot table. These dimensions will vary by control screen, but will frequently include things such as Project, category, employee/item, transaction type, project date, and more 5. Select desired layout options (these vary by project control screen). 6. Click the OK button to generate the pivot table