Default Dimension Value

static void DefaultDiemsion(Args _args)
{

    DefaultDimensionView        ddv;

        select NAME,DISPLAYVALUE from ddv
            where ddv.DefaultDimension == 5637151332 // defaultdimension is the dimensionid
                    && ddv.Name == 'Department';   /// cost code is the default dimension  as Department, costcenter
    {
        info(ddv.DisplayValue);
    }


}

Comments

Post a Comment

Popular posts from this blog

Create RFQ through X++

static void CreateRFQ(Args _args) {     AxPurchRFQCaseTable         axPurchRFQCaseTable;     AxPurchRFQCaseLine          axPurchRFQCaseLine;     PurchRFQCaseTable           purchRFQCaseTable;     PurchRFQCaseLine            purchRFQCaseLine;     str         RFQCaseId;     NumberSeq numberSeq;     ;     numberSeq = NumberSeq::newGetNum(purchParameters::numRefPurchRFQCaseId());     numberSeq.used();     RFQCaseId = numberSeq.num();     axPurchRFQCaseTable = new AxPurchRFQCaseTable();     axPurchRFQCaseTable.parmRFQCaseId(RFQCaseId);     axPurchRFQCaseTable.parmBidType(PurchRFQBidType::Open);     axPurchRFQCaseTable.parmCurrencyCode('INR');     axPurchRFQCaseTable.save();     axPurchRFQCaseLine =...
Read more

Base enum values in Dynamics 365

By writing the statement 1 we will get the basenum id. And then writing the second statement we will get the list of total values. BaseEnum - 'LogisticsAddressElement Stataement 1 : select * from ENUMIDTABLE where name = 'LogisticsAddressElement' Stataement 1 : select * from ENUMVALUETABLE where ENUMID = 4709
Read more

Project Id through X++ code

void clicked() {     ProjTable                   projTable;     ProjInvoiceTable            projInvoiceTable;     ProjFundingSource           projFundingSource;     ProjFundingRule             projFundingRule;     ProjFundingRuleAllocation   projFundingRuleAllocation;     NumberSeq                   numberSeq,numberSeqInv;     NumberSequenceFormat        _numberSequenceMask;     ProjParameters      projParameters  = ProjParameters::find();     super();     ttsBegin;     numberSeq = NumberSeq::newGetNum(ProjParameters::numRefProjId());     numberSeqInv = NumberSeq::newGetNum(ProjParameters::numRefProjInvoiceProjId());     proj...
Read more