RELATION BETWEEN LEDGERDIMENSION AND DIMENSIONATTRIBUTEVALUECOMBINATION AX 2012 USING SQL :

RELATION BETWEEN LEDGERDIMENSION AND DIMENSIONATTRIBUTEVALUECOMBINATION AX 2012 USING SQL : SELECT  A.JOURNALID,C.[DESCRIPTION],               A.VOUCHER,               A.ITEMID,               A.TRANSDATE,               A.INVENTONHAND ,A.QTY,              ...

Read more...

FormCtrl using x++ :

FormCtrl using x++ : void clicked() {     ABUTallyHeader  _abutallyheader;     ABUTallyLine    _abutallyline;     super();     while select _abutallyheader where     _abutallyheader.RefRecId == WMSOrderTrans.RecId     {         select count(RecId), sum(Qty) from _abutallyline where _abutallyline.RefRecIdRouteLine == _abutallyheader.recid;         WMSOrderTrans.qty      ...

Read more...

Creating Financial Dimension in General Journals in AX 2012 in X++

Creating Financial Dimension in General Journals in AX 2012 in X++ : AxLedgerJournalTable header = new AxLedgerJournalTable(); AxLedgerJournalTrans trans = new AxLedgerJournalTrans(); container ledgerDimensions, offsetDimensions; header.parmJournalName("GenJrn"); header.save(); trans.parmAccountType(LedgerJournalACType::Ledger); trans.parmJournalNum(header.ledgerJournalTable().JournalNum); ledgerDimensions = ["131100-USA","131100", 1, "COUNTRY","USA"]; trans.parmLedgerDimension(AxdDimensionUtil::getLedgerAccountId(ledgerDimensions)); trans.parmAmountCurDebit(230); offsetDimensions...

Read more...

Update Default Financial Dimension in AX 2012 using X++

Update Default Financial Dimension in AX 2012 using X++  static void ABUDefaultFinancialDim_AP(Args _args) {     DimensionAttributeValue             dimAttrBUValue,dimAtrrCCValue,dimAtrrDepValue,dimAttrIGValue,dimAtrrProjValue;     DimensionAttribute                  dimAttrBU,dimAtrrCC,dimAtrrDep,dimAttrIG,dimAtrrProj;     DimensionAttributeValueSetStorage   davss;     RecId                               defaultDimension;     AssetBook                           Assetbook;    ...

Read more...