D365O - How to add financial dimension in grid - Microsoft Dynamics AX Community

17 Mar 2017 10:46 PM

This post outlines the steps; how to add financial dimensions (segmented control) in a grid in D365O.

Let's assume we are adding new table and form for below explanation;

New table contains two fields AccountType and LedgerDimension with relation to DimensionAttributeValueCombination table

Form looks like this;

Set properties for segmented control under form design;

- Auto declaration = Yes

- Account type field = AccountType

- Controller class = DimensionDynamicAccountController

- Filter expression = %1

1. Override modified method for LedgerDimension field under form's datasource

2. Override lookup and checkUserCustomLookup method on ledger dimension segmented control in form desgin

Datasource | D365O_FinancialDimension | LedgerDimension | modified

[DataSource]

class D365O_FinancialDimension

{

[DataField]

class LedgerDimension

{

void modified()

{

super();

D365O_FinancialDimension_ds.refresh();

}

Desgin | D365O_FinancialDimension_LedgerDimension | lookup

public void lookup()

{

switch (D365O_FinancialDimension.AccountType)

{

case LedgerJournalACType::Bank:

BankAccountTable::lookupBankAccount(this);

break;

case LedgerJournalACType::Cust:

CustTable::lookupCustomer(this);

break;

case LedgerJournalACType::FixedAssets:

AssetTable::lookupAccountNum(this);

break;

case LedgerJournalACType::Project:

ProjTable::lookupProjId(this, D365O_FinancialDimension);

break;

case LedgerJournalACType::Vend:

VendTable::lookupVendor(this);

break;

default:

super();

break;

}

Desgin | D365O_FinancialDimension_LedgerDimension | checkUserCustomLookup

public boolean checkUseCustomLookup(int _accountTypeEnumValue, int _secondaryAccountTypeEnumValue)

{

boolean returnValue;

LedgerJournalACType accountType = any2Enum(_accountTypeEnumValue);

switch (accountType)

{

case LedgerJournalACType::Bank:

case LedgerJournalACType::Cust:

case LedgerJournalACType::FixedAssets:

case LedgerJournalACType::Project:

case LedgerJournalACType::Vend:

returnValue = true;

break;

default:

returnValue = false;

break;

}

return returnValue;

}

Set D365O_FinancialDimensions form as startup object and run the form.

If you just want to see MainAccount in segmented control.

set the segmented control property Is default account = True

Read Complete Post and Comments

Meet the Author

Works for Sable 37 in Australia