Microsoft Dynamics AX

  Last time, I have shared the code about how to   Get Main Account from Ledger Dimension in D365FO . In this article, I am sharing the one line code to get the display value using   LedgerDimensionFacade class . See the following code: //Get Display value from LedgerDimension //The argument (LedgerDimensionValue) is LedgerDimension which you can get from table or any other source as per your requirement info(strFmt("%1",LedgerDimensionFacade::getDisplayValueForLedgerDimension(LedgerDimensionValue)));

  In this article, you will get the one line code to get the Main Account from Ledger Dimension using   LedgerDimensionFacade class . See the following code: //Get MainAccountId from LedgerDimension //The argument (LedgerDimensionValue) is LedgerDimension which you can get from table or any other source as per your requirement info(strFmt("%1",LedgerDimensionFacade::getMainAccountFromLedgerDimension(LedgerDimensionValue).MainAccountId)); //Get Name of MainAccountId from LedgerDimension //The argument (LedgerDimensionValue) is LedgerDimension which you can get from table or any other source as per your requirement info(strFmt("%1",LedgerDimensionFacade::getMainAccountFromLedgerDimension(LedgerDimensionValue).Name));

  Scenario: I am assigning a value to a field in HcmEmploymentLeave form using OnInitValue form data source event handler. Lets start! Run  Visual Studio Search your desired form in  Application Explorer Right click the form -> click  Open designer Expand the  Data Sources node Expand your  desired data source node  ->  Events  -> Select  OnInitValue event  ->  Right click and copy event handler method Create a  new class Paste  the event handler method Add code  in it like below: [FormDataSourceEventHandler(formDataSourceStr(HcmEmploymentLeave, HcmEmploymentLeave), FormDataSourceEventType::InitValue)] public static void HcmEmploymentLeave_OnInitValue(FormDataSource sender, FormDataSourceEventArgs e) { FormRun formRun = sender.formRun(); Object hcmEmploymentLeave_ds = formRun.dataSource(formDataSourceStr(HcmEmploymentLeave, HcmEmploymentLeave)) as FormDataSource; HcmEmploymentLeave hcmE...

  How to: Create Query with Range through X ++ I had a hard time trying to find how use range between dates so I hope to help not only who wants to create a query but also who wants to know how to use range with date. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 // Create a new Job static void CustDateRangeQuery(Args _args) {      Query                   query;      QueryRun                queryRun;      QueryBuildDataSource    qbds;      QueryBuildRange         qbr;      CustTable               custTable;      ; ...