Microsoft Dynamics Axapta Technical,Functional Coverage

You can Learn Power BI in easy steps . You just need to visit and view following online training videos from Technical channel. Power BI Report Design and development part first. Power BI Report Design and development part Second. , Publish Report in Power BI 

You can visit following link to view one by one videos which is related to Microsoft Dynamics Ax  Technical and functional Tutorials. Axapta Development Online clips Ax Functional Material Collection SSRS Reports And SQL SQL and SSRS Reporting You can subscribe above channel to get daily updates on new topics and get expertise in ERP .

To change SID for Domain user in Axapta you can see below clip .If you like it do not forget to subscribe it . Thanks in advance.

If you want to change tableid of particular table then you can try below code. This is sample to Change tableid of of table by code in Axapta ReleaseUpdateDB::changeTableId(104924, 205001,'Table1');

Following Code To auto generate BOM id for BOM Item in Axapta 2012. NumberSeq numberSeq; numberSeq = BOMTable::numberSeq(); numberSeq.used(); return numberSeq.num();

To change Company of Employee in Axapta by code you can get hint by below code. Its tedius task to update you need to do it very carefully and understand then code then apply in your customization. ttsBegin; hcmWorker=hcmWorker::findByPersonnelNumber(Personalumberid); select companyinfohsd where companyinfohsd.dataAreaId=="dat"; select companyinforss where companyinforss.dataAreaId=="ceu"; select forupdate hcmEmployment where hcmEmployment.Worker==hcmWorker.RecId && hcmEmployment.LegalEntity==companyinfohsd.RecId; hcmEmployment.LegalEntity=companyinforss.RecId; hcmEmployment.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction); hcmEmployment.doUpdate(); ttsCommit;

To Insert Records in Item batch Table by code in Ax 2012 you can take hints from below code. First, you need to check whether a record exists or not in the inventbatch table if it does not exist then you can insert records. if (InventBatch::exist(Itemid,Inventbatchid)) { //error("Batchnumber already exists"); } else { inventBatch.itemId=Itemid; inventBatch.inventBatchId=Inventbatchid; inventBatch.prodDate=mkDate(1,12,2017);//systemDateGet(); inventBatch.insert(); }