Dynamics AX & D365FO Insights Hub

static void queryEnumValue(Args _args) {     Query                   query;     QueryRun                queryrun;     QueryBuildDataSource    qbds;     QueryBuildRange         qbr;     PurchTable              purchTable;     ;         query = new Query();         qbds = query.addDataSource(tableNum(PurchTable));     qbds.addSortField(fieldNum(PurchTable, PurchId), SortOrder::Ascending);     qbr     = qbds.addRange(fieldNum(PurchTable, PurchStatus));         qbr.value(enum2str(PurchStatus::Received));         queryrun = new QueryRun(query);         while(queryrun.next())     {         purchTable = query...

static void QueryDateRange(Args _args) {     Query                   query;     QueryRun                queryrun;     QueryBuildDataSource    qbds;     QueryBuildRange         qbr;     PurchLine               purchLine;     TransDate               fromDate, Todate;     ;         fromDate = mkDate(19,11,2016);     Todate   = mkDate(20,12,2016);         query = new Query();         qbds = query.addDataSource(tableNum(PurchLine));         qbds.addSortField(fieldNum(PurchTable, PurchId), SortOrder::Ascending);         qbr     = qbds.addRange(fieldNum(PurchLine, deliveryDate));     ...

In this post we'll see how easily we can create a custom lookup. Suppose I have two fields  1. Country/Region 2. StateId Now I want to create a lookup so that If I will select any country then state lookup must show states which belongs to my selected country for example If I have selected India in country field then it must show only indian state in state field Lets see how can we achieve it. Step 1: Create a table and then create two fields            1. CountryRegionId            2. StateId Step 2: Create a form Step 3: For custom lookup we will use State master table i.e. LogisticsAddressState here we can see there is a method lookupStateId public client static void lookupStateId(     FormStringControl               _ctrl,     LogisticsAddressCountryRegionId _countryRegionId) {     SysTableLookup ...

By this we can use same MenuItem at different place and for different data source. --------------------------------------------------------------------------- Public static void main(Args _args) {     RetailStatementTable    retailStatementTable;     RetailStatementLine     retailStatementLine;     RetailStatementId         StatementID;     RetailCountedAmountUpdate  RetailCountedAmountUpdate = new RetailCountedAmountUpdate();     ;      switch (_args.dataset())     {             case tablenum(RetailStatementTable) :             retailStatementTable =  _args.record();             StatementID = retailStatementTable.statementId;             break;                        ...

static void CreateFolder(Args _args) {     str  path = 'C:\\2017\\Jan';     ;     if (!WinApi::pathExists(path))     {         WinApi::createDirectoryPath(path);     } }

public void Run() {     PurchFormLetter             purchFormLetter;     PurchFormletterParmData     purchFormLetterParmData;     PurchParmUpdate             purchParmUpdate;     PurchParmTable              purchParmTable;     PurchParmLine               purchParmLine;     PurchTable                  purchTable,purchTable1;     PurchLine                   purchLine;     InventTrans                 inventTrans;     InventTransOrigin           inventTransOrigin;     PurchId                     purchId;     Num     ...