Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

To get Customer,Vendor VAT Registration Number by code in Axapta in 2012 version you can try below code in data method on table label then you can use the method in string control on form . This code will work perfectly . display name Get_TaxRegistration() { TransDate _transDate = systemDateGet(); DirPartyLocation dirPartyLocation; TaxRegistration taxRegistration; TaxRegistrationTypeApplicabilityRule taxRegistrationTypeApplicabilityRule; if (_transDate) { dirPartyLocation = DirPartyLocation::findByPartyLocation( this.Party, this.invoiceAddress().Location); if (dirPartyLocation) { select firstonly validTimeState(_transDate) taxRegistration where taxRegistration.DirPartyLocation == dirPartyLocation.RecId join RecId from taxRegistrationTypeApplicabilityRule order by taxRegistrationTypeApplicabilityRule.IsPrimaryAddressRestricted desc

This is a sample Code to confirm and Post Project Item Requirement for Sales Order in Ax 2012 . You need to pass sales order in salesFormLetter class method update and you can pass transaction date or posting date as per your need it will create or post project sales order item requirement packing slip. Its same functionality as post button on project item requirement form. SalesFormLetter salesFormLetter; salesTable Salestablelocal; str 200 msg; salesid salesid; if(salesid) { select Salestablelocal where Salestablelocal.Salesid ==salesid && Salestablelocal.salestype==SalesType::ItemReq && Salestablelocal.SalesStatus==SalesStatus::Backorder; if(Salestablelocal) { ttsBegin; salesFormLetter = SalesFormLetter::construct(DocumentStatus::Confirmation); salesFormLetter.update(Salestablelocal); salesFormLetter = SalesFormLetter::constru

If you want to check opening balance for particular main account then you can check below code to get the same. This is sample Code to get opening balance for Ledger Main account in Ax 2012. LedgerBalanceMainAccountAmounts ledgerBalance; AmountMst opSum; ; ledgerBalance = LedgerBalanceMainAccountAmounts::construct(); ledgerBalance.parmIncludeRegularPeriod(true); ledgerBalance.parmIncludeOpeningPeriod(true); ledgerBalance.parmIncludeClosingPeriod(false); ledgerBalance.parmAccountingDateRange(mkDate(01,01,2000), mkDate(31,12,2017)); ledgerBalance.calculateBalance(MainAccount::findByMainAccountId('1123333')); opSum = ledgerBalance.getAccountingCurrencyBalance(); info(num2str(opSum,10,2,1,1));

This is Code to get Miscellaneous charges of purchase line in Ax 2012. You can try below code to check in job. PurchTable purchTable; PurchLine purchLine; MarkupTrans markupTrans; while select * from purchLine Join purchTable Join markupTrans Where purchTable.PurchId == purchLine.PurchId && markupTrans.TransRecId == purchLine.RecId && purchTable.PurchId=="PO-0000043" { info(strFmt("%1 , %2 , %3",purchLine.PurchId,markupTrans.Txt,markupTrans.Value)); }

Code to approve bom for product in Ax 2012.If you are creating or uploading bom list by code then auto approval may required,below code will help to approve bom item automatically. void God_setBOMActive(BOMId bomid,str 20 approver1) { BOMVersion BOMVersion1; BOMApprove bomApprove = new BOMApprove(); RecId approver = HcmWorker::findByPersonnelNumber(approver1).RecId; boolean ret=true; try { select forUpdate BOMVersion1 where BOMVersion1.BOMId==bomid; BOMVersion1.selectForUpdate(); BOMVersion1.Approved = true; BOMVersion1.Active = true; BOMVersion1.Approver = approver; ttsBegin; BOMVersion1.write(); ttsCommit; bomApprove.init(); bomApprove.parmApprover(approver); bomApprove.parmBOMId(bomid); bomApprove.run(); } catch { info(strFmt("(%1) approval failed.", bomid)); } }

Problem I am Getting below Errors on AIF Web service enabling for custom class in Ax 2012. 1. Application pool 'MicrosoftDynamicsAXAif60' is being automatically disabled due to a series of failures in the process(es) serving that application pool. 2. There was an error during processing of the managed application service auto-start for configuration path: 'MACHINE/WEBROOT/APPHOST/Default Web Site/MicrosoftDynamicsAXAif60'. The error message returned is: 'An initialization error occurred while trying to preload an application. Exception: System.Configuration.ConfigurationErrorsException Message: Duplicate type with name 'Dynamics.Ax.Application.NewItem' in assembly 'Dynamics.Ax.Application, Version=6.3.1000.309, Culture=neutral, PublicKeyToken=null'. StackTrace:    at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective)    at System.Web.Configuration.CompilationSection.LoadAllAssembl

I am Getting Error during Full CIL in Ax 2012 R3 CU11 version. " The SysWorkflowDictElement.getAttribute() reflection API could not create and return the AifCollectionTypeAttribute object. Please check the parameters." No any single report executing and giving parameter related error then tried to do full CIL then above error coming. Solution: Solution of this issue is as below. 1. first, compile the class mentioned in the error message and see if this solves the problem if not then use compile forward option. 2.Then use incremental compile option if again other class error coming then compile again till incremental compile issue not resolved. 3. Once incremental compile did then do full CIL. 4. Then if the issue still exists then do steps. 1) first stop the aos services and go to the folder of the XPPIL folder and delete all files 2) start the services of aos 3) and do the incremental CIL 4)THEN  Do FULLY CIL, THEN ALL THE SERVICE WILL BE STARTE