Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

Problem : While deploying EP form getting business connector error. Error  “The Web Part page  was not created correctly on the site. No .NET Business Connector session could be found.” . No .NET Business Connector session could be found Solution : You can  try this and check. 1. Uncheck the Anonymous user of "IIS \ Directory Security \ Authentication and access control " 2. Add the BCProxy user to the local Administration group on the IIS server. 3. Then restart IIS and AX.

These are the Steps to open or enable all AIF port in case of major issue in Ax 2012 like Workflow issues, Business logic execution etc. 1) Stop all relevant AOS server(s) 2) On your relevant AOS server(s) navigate to the following folder (default) using Windows Explorer: C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL 3) Make sure you create a safe copy of the XPPIL folder content to another new local folder on the AOS computer (example: C:\XPPIL_Backup) 4) Now delete all folders and files inside the folder “C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL” but keep the folder “XPPIL” itself. 5) Start all AOS server(s) 6) Rull full dos based compilation using axutil. (axbuild.exe xppcompileall /aos=01 /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin" /workers=4) 7) Run a full CIL creation from AOT. This will create a fresh rebuild of all files/ folders inside the XPPIL folder 8)

To Update Project Status by Code in Ax 2012 You can get help from below code sample. In this code if Project status is created then it will update to In process stage. Same way you can try as per your requirement. Projtable projTable; int cnt; ttsBegin; while select forUpdate projtable where projTable.Status==ProjStatus::Created { cnt++; projtable.Status=ProjStatus::InProcess; projtable.update(); } ttsCommit; info(strFmt("%1 Project Updated",cnt));

Following Cubes are available as standard Cube in Microsoft Dynamics Ax 2012 R3 1 Accounts payable cube (VendCube) 2 Accounts receivable cube (CustCube) 3 Budget control cube (BudgetControlCube) 4 Budget plan cube (BudgetPlanCube) 5 Demand forecast accuracy cube (ReqDemPlanAccuracyCube) 6 Demand forecast cube (ReqDemandPlanningCube) 7 Environmental sustainability cube (EMSCube) 8 Expense management cube (TrvCube) 9 General ledger cube (LedgerCube) 10 Human resources cube (HumanResourceCube) 11 Inventory value cube (InventValueCube) 12 Payroll cube (PayrollCube) 13 Production cube (ProdCube) 14 Profit tax totals cube (RTax25Registers) 15 Project accounting cube (ProjCube) 16 Purchase cube (PurchCube) 17 Retail cube (RetailCube) 18 Sales and marketing cube (smmSalesMarketingCube) 19 Sales cube (SalesCube) 20 Workflow cube (WorkflowCube)

Top Ideas for Things if You will  Develop in Axapta. Single user License You can try single instance access to Ax .As per this task user should not able to open more than on ax instance or client except admin user so all user restricted to open multiple session of ax. Screen user login and password Required login credential to open ax instance . Each user has own credential. In standard way user able to open ax without login screen. Workflow Pending Aging You can Show user details on which workflow is pending to approve. How much time its pending is treated as aging. This task done on form. Workflow actions email alerts All Pending Workflow with user need to send email to particular user as per provided template  format every day and Cancelled, Stopped, Unrecoverable workflow status should be send to email to admin user. Image in email header and signature includ

Design user control To design user control you need to open visual studio then you can create new user control on form designer you can do below steps. add data source- add formid-add axsection=add grid or group Then Add lookup.   Add dataset add control for lookup and set dataset and fields in  Add range on init method or any other method to get range value filter Autopostback to true property on field to save data immediately. selectedindexchangeevent code this.AxDataSource1.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("datasourceRefresh",DropDownList1.SelectedItem.Text);

How to restore Enterprise Price menu if its missing or  In case of database restore and you are not abe to see your EP Page. Then you need to Go to Home page on web menu ->Refresh data and dictionary If  menu is not visible then check label on menu item put label if missing on going to AOT Web node. Second step is Deploy user control if its customized one to particular module like sales or purchase etc or place where you want. Third step is you can deploy page definition Four step you need to check Manage content deploy for Web node in AOT You also  need to import url page.

Getting below error even Initialization Checklist    is completed and success. " Enter the unique sequence number in the System parameters form that is opened from the Checklist " Solution . Go to SystemParameters table Go to method validateThaiSoftwareSeqNo where you can find the field value should not be empty.  \Data Dictionary\Tables\SystemParameters\Methods\validateThaiSoftwareSeqNo I hope you have the solution for that error.

To Add Lookup Method for Dimension fields like division ,branch etc using UI Builder class in Axapta SSRS Report you can refer below code. #define.DimensionName("Branch") Query query; QueryBuildDataSource qbds,qbds1; SysTableLookup sysTableLookup; DimensionAttribute dimAttr; ; dimAttr = DimensionAttribute::findByName(#DimensionName); sysTableLookup = SysTableLookup::newParameters(tablenum(OMOperatingUnit),branchCodeLookup); sysTableLookup.addLookupfield(fieldnum(OMOperatingUnit, OmoperatingunitNumber)); sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,Name)); query = new Query(); qbds = query.addDataSource(tableNum(OMOperatingUnit)); qbds.addRange(fieldNum(OMOperatingUnit, OMOperatingUnitType)).value(queryvalue(OMOperatingUnitType::OMBusinessUnit)); sysTableLookup.parmQuery(query); sysTableLookup.parmUseLookupValue(False); sysTableLookup.performFormLookup(); Division dime

This post include Form Design and development using primary key and foreign key table relation in Microsoft Dynamics Axapta. 2012 r3 Module. How to Add primary key in table first you need to create unique key field let id is key field name for your table. Add index with allow duplicate no property to make it unique key . then add relation in tables(foreign key and primary key) as shown in below video clip. Create another table for foreign key relation then add normal relation in second table. To show data in form Add table to form datasource and set required properties in data source as shown in clip. You seen how its works table data on form . Thanks for viewing and watching if you like it please subscribe to get next video update and learning.