X++ code to get Financial Dimensions in D365FO

-

  public void getFinancialDimensions()
    {

       DimensionAttributeValueSet  dimAttrValueSet;
        DimensionAttributeValueSetItem  dimAttrValueSetItem;
        DimensionAttributeValue     dimAttrValue;
        DimensionAttribute          dimAttribute;
        LedgerJournalTable          ledgerJourTable;
        VendTable                   vendTable;
        CustTable                   custTable;
     
        ledgerJourTable = LedgerJournalTable::find('');//JournalNum

        vendTable = VendTable::find('');//AccountNum
        custTable = CustTable::find('');//AccountNum

        //ledgerJourTable.DefaultDimension,vendTable.DefaultDimension,custTable.DefaultDimension
        //Provide default dimension as below

        dimAttrValueSet = DimensionAttributeValueSet::find(ledgerJourTable.DefaultDimension);

        while select * from dimAttrValueSetItem where  dimAttrValueSetItem.DimensionAttributeValueSet == dimAttrValueSet.RecId
             join dimAttrValue  where dimAttrValue.RecId == dimAttrValueSetItem.DimensionAttributeValue
             join dimAttribute where dimAttribute.RecId ==dimAttrValue.DimensionAttribute
        {
            info(strFmt("DimName:%1---------Dim Value:%2",dimAttribute.Name,dimAttrValueSetItem.DisplayValue));
        }
}

Comments

Post a Comment

Popular posts from this blog

x++ code to add hyperlink to a field in D365FO

-
Here is a way to provide hyperlink for field. 1.Create an Extension class to the form as below. [ExtensionOf(formStr(TestHistory))] public final class  TestHistoryForm_Extension { } 2.Copy onPostRun form eventhandler and write code as below.     [FormEventHandler(formStr(TestHistory), FormEventType::PostRun)]     public static void TestHistory_OnPostRun(xFormRun sender, FormEventArgs e)     {         FormStringControl   formCtrl = sender.design().controlName(formControlStr(TestHistory,TestHistory_Voucher));         formCtrl .registerOverrideMethod(methodStr(FormStringControl, jumpRef), methodStr(TestHistoryForm_Extension, JumpRefId), sender);     } 3.write definition for JumpRefId method public void jumpRefId(FormControl _formControl)     {         MenuFunction    menuFunction;       ...
Read more

x++ code to get Vendor Email Address based on Purpose in Dynamics 365 for Operations

-
public static  Email   getVendorEmailAddress()     {               VendTable  vendTable;         DirPartyLocation dirPartyLocation;         LogisticsElectronicAddress elecAddress;         LogisticsElectronicAddressRole elecAddressRole;         LogisticsLocationRole locRole;         Str vendNum;              vendNum='205181';//Vendor Number                 select firstonly  DirPartyLocation                     where dirPartyLocation.party ==  VendTable::find(vendNum).Party//Vendor Number             join   elecAddress                     where elecAddress.Location == dirPartyLocation.Loca...
Read more

x++ code to get Customer Address based on purpose in ax 2012

-
static void  customerAddress(Args _args) {     DirPartyPostalAddressView           dirPartyPostalAddrlocal;     DirPartyLocationRolesView           dirPartyLocationRoleslocal;     LogisticsLocationRole                   logisticsLocRole;     select firstOnly   * from dirPartyPostalAddrlocal order by RecId desc         exists join dirPartyLocationRoleslocal             where dirPartyLocationRoleslocal.Location   == dirPartyPostalAddrlocal.Location                 && dirPartyLocationRoleslocal.Party     ==     CustTable::find(_accountNum).Party//_dirpartyRecid                 //&& dirPartyPostalAddrlocal.IsPrimary == NoYes::No         exists j...
Read more