Reusable X++ code snippets

 Cratedtransaction id , settalbeconnection parmuserconnections Independent transaction in AX Sometimes we need to write some data into a database independently on the currently running DB transaction. For example, we want to log some state occurred in the application, however any exception could cause a rollback of the whole transaction, including the log entry. It could look as follows: LogTable logTable; ; ttsbegin ; logTable. Message = "Something happens" ; logTable. insert ( ) ; //some following code in the same transaction throws an exception throw Exception :: Error ; ttscommit ; It can be resolved quite easily. We need to create a separate database connection and possibly our own transaction. The modification of the preceding code would look as follows: LogTable logTable; UserConnection connection = new UserConnection ( ) ; ; ttsbegin ; //use another connection logTable. setConnection ( connection ) ; //beginning of the independent transaction logTable. ttsbegi...

 public class BFSPrepaymentTableEntity extends common { // Postload & mapEntityToDataSource for virtual fields which helps you to push the values instead of recids      public void postLoad()     {         super();         //Populate virtual field once entity has been loaded from database         this.PrepayIdStr = this.PrepayId;         this.JournalNumStr = this.JournalNum;         this.IsCreatedStr = this.IsCreated;         EcoResCategory  ecoResCategory;         select firstOnly ecoResCategory             where ecoResCategory.RecId   == this.PrepayCategoryId;         this.EcoResCategoryCommodityCode = ecoResCategory.Code;     }     Public void mapEntityToDataSource(DataEntityRuntimeContext entityCtx, DataEntityDataSourceRuntimeCo...

Check SysQueryForm form logic reference  [Form] public class NXR_TableFileldsUpdate extends FormRun {     int selectedTableId;     int selectedFieldId;     Str1260 fieldValueStr;     RefRecId    recIdValue;     int defaultTableId;     /// <summary>     ///     /// </summary>     public void init()     {         super();         TableName.text("EDF_ContractLine");         SqlDictionary sqlDict;         Select tabId From sqlDict                 Where sqlDict.name =="EDF_ContractLine"                 && sqlDict.fieldId==0;         selectedTableId = sqlDict.tabId;         defaultTableId = selectedTableId;         TableRecId.enabled(false); ...

 in AX 2012   only whereas d365fo ,we have ledgerdimensionfacade is there //SIG_22435_BudgetsInAXByCostCentre - 19- Sep -2023 - Hreddy public  LedgerDimensionDefaultAccount getDefaultAccountFromMainAccountRecId(MainAccountRecId _mainAccountRecId) {     recId                   dimAttributeId;     DimensionAttributeValue dimAttributeValue;     int                     segmentIndex;     str                     newValue;     /*DimensionAttributeValue mainAcctDimAttrValue;     DimensionStorage        dimStorage;     MainAccount             mainAccount;     container               result;     DimAttributeMainAccount attrMainAcc;  ...

  Commands  Cd C:\ K: C:\cd K:\AosService\PackagesLocalDirectory\bin xppbp.exe -metadata=K:\AosService\PackagesLocalDirectory -all -model=EDF -xmlLog=C:\BPCheckLogcd.xml -module=EDF -car=c:\temp\CAReport.xlsx

  1.        Power Point basics - https://make.powerapps.com/   Model driven apps -   This type of app used for data entry purpose and to accommodate lot of functionalities and process Ex:- CRM , Projops App e.tc. 2.          Canvas app :-   This type of apps used for mobile/tablet compatibility   which have lesser functionalities and process EX:-   LMS Powerapp e.t.c   1.          Patch funciton -   it is used to trigger the F&O data entity with some data     Ex:-   Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])   2.        SubmitForm function – its   used to trigger the F&o data entity same like above function , But can be used on form only   SubmitForm(Form1);   3.        UpdateContext   - To ...