Microsoft Dynamics Axapta Technical,Functional Coverage

KB number 3134000 is for the issue if Transfer to GL should not run taxlink queries for documents with no tax in Accounting Framework KB number  3100992  is for the issue if Introduction of Accounting Source Explorer and Source Document Reference Identities in Accounting Framework KB number  3134000  is for the issue if Final Relieving of a vendor invoice is incorrect when the product receipt is matched to a partial invoice before and after being corrected in  Accounting Framework KB number  3147787  is for the issue if SDRI mappings are not being honored for vendor invoice in  Accounting Framework

As you know like wildcard operator to filter bunch of record in Axapta grid. In Ax 2012 you can use like wild card operator with query build range object also. QueryBuildRange QBR; QBR =SysQuery::findOrCreateRange(DS.dataSourceTable(tablenum(custtable)),fieldNum(Custtable,AccountNum)); QBR.value(SysQuery::valueLikeAfter(testTxt.text())); In above example we used value like after same way you can use valuelike also. Other you can use like SysQuery::valueUnlimited if there is no value for range purpose.

Lets you want to to Filter Records in form from Combo box in Axapta then this is sample example you need to create one method like this. WMSPickingRoute_ds.filter(fieldNum(WMSPickingRoute,ExpeditionStatus),queryValue(God_expeditionStatus.selection())); Then you can call that method in modified field method for that combo box. Like filter1 is method name then you can call it below way. public boolean modified() { boolean ret; ret = super(); this.filter1(); return ret; } I hope you get and Idea how to filter records for form in axapta.

How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way. emplTable emplTable; FieldId fieldId; ; fieldId = fieldNum(emplTable, Emplid); select emplTable; info(emplTable.(fieldId)); select emplTable where emplTable.(fieldId) == '1101'; info(emplTable.Name);

I was facing below issue  Dynamics AX 2012 R3 client crashes after opening suddenly AX client session get crashes. There is no event log to find out what exactly is the issue.  Solution: I applied below steps. 1. I Deleted AUC files in user profile. C:\Users\user1\AppData\Local 2. Reset the usage data from menu. Click File > Tools > Options. In the Options form, click Usage data then reset button press click yes.. 3. To delete all user usage data  Go to  AOT-->SystemDocumentation-->Tables-->SysLastValue. Delete all records. After then Ax client work fine.

To separate Fraction and Digit from Number in axapta like number is 878778.3000 and you want to get 878778 and .300 then below code can help you to get the same. qty t=878778.3000; str _amount = strFmt("%1",num2str(t,0,1,0,0)); boolean decimals; TextBuffer txtAmount = new TextBuffer(); txtAmount.setText(_amount); if (txtAmount.find("^[0-9]+$")) // Regular expression inside the find method { decimals = true; } info(strFmt("%1 -- %2",trunc(t),frac(t)));

How to modify funding Source for particular Project contract in Project Module. Below is the code sample to get Idea for the same. ProjFundingSource projFundingSource; ProjInvoiceTable projInvoiceTable; LogisticsLocation logisticsLocation,logisticsLocationNew; ; ttsBegin; while select projInvoiceTable where (projInvoiceTable.ProjInvoiceProjId != "PROJ_002834") { while select forUpdate projFundingSource where projFundingSource.ContractId == projInvoiceTable.ProjInvoiceProjId { projFundingSource.FundingSourceId = projInvoiceTable.fundingSourceName(); projFundingSource.InvoiceLocation = 0; projFundingSource.update(); } } ttsCommit;

Following are the Reserved words list in Ax 2012 1 abstract 54 implements 2 anytype 55 index 3 as 56 insert_recordset 4 asc 57 int 5 at 58 int64 6 avg 59 interface 7 break 60 is 8 breakpoint 61 join 9 by 62 like 10 byRef 63 maxOf 11 case 64 minOf 12 catch 65 mod 13 changeCompany 66 new 14 class 67 next 15 client 68 noFetch 16 container 69 notExists 17 continue 70 null 18 count 71 optimisticLock 19 crossCompany 72 order 20 date 73 outer 21 default 74 pause 22 delegate 75 pessimisticLock