Skip to content

hello Dynamics AX

AX TECHNICAL BLOG

  • Home
  • AX 7
  • AX 2012
    • AX 2012 ERROR
    • AX 2012 RETAIL POS CUSTOM
  • x++
    • Forms
    • Report
    • Number Sequence
  • Retail
  • C#
  • SQL
  • Enterprise Portal
  • Technical Tutorial
  • Uncategorized
HomePosts tagged 'MAIN ACCOUNT'

MAIN ACCOUNT

combine main account with default dimension to ledger dimension

June 25, 2015October 2, 2015 Sti F. Cavendish AX 2012, x++ DEFAULT DIMENSION, LEDGER DIMENSION, MAIN ACCOUNT, RECID, X++

example code

public static DimensionDynamicAccount defaultDimension2ledgerDimension(LedgerJournalAC _ledgerJournalAC,DimensionDefault _defaultDimension )
{
    container           conDimName;
    container           conDimValue;
    int                 loop = 1;
    DimensionValue      dimValue;
    Name                dimName;

    DimensionServiceProvider    DimensionServiceProvider = new DimensionServiceProvider();
    LedgerAccountContract       LedgerAccountContract    = new LedgerAccountContract();
    List                        ListValueContract        = new List(Types::Class);
    DimensionAttributeValueContract     ValueContract;
    dimensionAttributeValueCombination  dimensionAttributeValueCombination;
    DimensionStorage                    dimStorage;

    conDimName = Global::getDimensionNameTID();

    while(loop <= conLen(conDimName))
    {
        dimName  = conPeek(conDimName,loop);
        dimValue = Global::getDimensionValueTEC(_defaultDimension,dimName);
        if(dimValue)
        {
             ValueContract = new DimensionAttributeValueContract();
             ValueContract.parmName(dimName);
             ValueContract.parmValue(dimValue);
             ListValueContract.addEnd(ValueContract);
        }
        loop++;
    }

   LedgerAccountContract.parmMainAccount(_ledgerJournalAC);
   LedgerAccountContract.parmValues(ListValueContract);
   dimStorage = DimensionServiceProvider::buildDimensionStorageForLedgerAccount(LedgerAccountContract);
   dimensionAttributeValueCombination = DimensionAttributeValueCombination::find(dimStorage.save());
   return dimensionAttributeValueCombination.RecId;

}

this below is a custom method on global class.. (or you can put it on other class)

public static container getDimensionNameTID()
{
    DimensionAttribute              dimAttr;
    DimensionAttributeSetItem       dimAttrSetItem;
    DimensionEnumeration            dimensionSetId;
    DimensionAttributeValue         dimAttributeValue;
    container                       DimensionName;

    dimensionSetId      = DimensionCache::getDimensionAttributeSetForLedger();

    while select dimAttr order by Name
                where dimAttr.Type != DimensionAttributeType::MainAccount
            join RecId from dimAttrSetItem
                where dimAttrSetItem.DimensionAttribute     == dimAttr.RecId &&
                      dimAttrSetItem.DimensionAttributeSet  == dimensionSetId
            {
                dimensionName += dimAttr.Name;

            }

    return DimensionName;
}

this below is a custom method on global class.. (or you can put it on other class)

public static str 255 getDimensionValueTEC(RecId defaultDimension, Name dimName)
 {
   DimensionAttributeValueSetStorage  dimStorage;
   Counter               i;
   DimensionAttribute         dimAttributeCostCenter;
   DimensionAttributeValue       dimAttributeValue;
   dimStorage = DimensionAttributeValueSetStorage::find(defaultDimension);
   return dimStorage.getDisplayValueByDimensionAttribute(DimensionAttribute::findByName(dimName).RecId);
 }
25 Comments
Follow hello Dynamics AX on WordPress.com

MAGIC BOX

Member of The Internet Defense League

Blog Stats

  • 298,749 hits

Top Posts & Pages

  • error : Failed to create a session, confirm that the user has the proper privileges to log on to Microsoft Dynamics
  • Calling Menu item with Args X++
  • Create Purchase Order via X++
  • AX7 Best Practices error : display method in form not cached
  • error : [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
  • Modify Query on Report DP Class example
  • Print Sales Invoice via job X++ ax 2012
  • error: The data source is not embedded within a (parent) data source.
  • lookup using view example x++
  • Get purchase invoice id from packing slip trans (VendPackingSlipTrans)

Category

AX 7 AX 7 Best Practice Error AX 2012 AX 2012 ERROR AX 2012 RETAIL POS CUSTOM C# D365 FinOps EnterprisePortal Forms Number Sequence QUERY Report Retail SQL SSRS Technical Tutorial Tutorial Uncategorized Windows Server 2012 WORKFLOW x++
January 17, 2021
The big day is here.

Recent post

  • Access D365 FinOps Services with OAuth 2.0 May 17, 2019
  • get filter value from grid November 10, 2017
  • error : “Target principal name is incorrect” when running SSRS AX 2012 R3 November 2, 2017
  • Get purchase invoice id from packing slip trans (VendPackingSlipTrans) October 5, 2017
  • Create Invoice PO base on Packing Slip/Product Receipt by X++ December 7, 2016
  • AX7 Best Practices error : display method in form not cached October 20, 2016
  • error .netModule not being present when build AX7 Project October 18, 2016
  • Missing reference for “display method returning object” error when build form in AX7 October 10, 2016
  • Unretrieve field InventDimId on InventOnHanItem Form August 30, 2016
  • Export data from Retail POS to Excel without installing Microsoft Excel July 26, 2016

Archives

  • May 2019 (1)
  • November 2017 (2)
  • October 2017 (1)
  • December 2016 (1)
  • October 2016 (3)
  • August 2016 (1)
  • July 2016 (8)
  • June 2016 (4)
  • May 2016 (1)
  • April 2016 (4)
  • March 2016 (3)
  • February 2016 (4)
  • January 2016 (2)
  • December 2015 (3)
  • November 2015 (5)
  • October 2015 (11)
  • September 2015 (3)
  • August 2015 (8)
  • July 2015 (8)
  • June 2015 (21)
  • May 2015 (18)
  • April 2015 (8)
  • March 2015 (10)
  • February 2015 (8)
  • January 2015 (5)
  • December 2014 (18)
  • November 2014 (15)
  • October 2014 (2)
  • September 2014 (16)
  • August 2014 (5)
  • July 2014 (2)
  • June 2014 (5)
  • May 2014 (1)

Facebook Page

Facebook Page

TOP CLICKS

  • hellodax.files.wordpress.…
  • community.dynamics.com/ax…
  • docs.microsoft.com/en-us/…
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy