Microsoft Dynamics AX (Archived)

Validate Dimension Value with Account Structure

(0) Share

Report

Posted on by Community Member

Hi All,

I have a DimensionValue and Account Structure and i have to validate that Dimension Value with Account Structure.....

Dimension Value as [MainAccount-BusinessUnit-Department-CostCenter-ItemGroup]

Accounting Structure as "Manufacturing P&L"

Any Help Guys??

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Khaled Alloud 3,658 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Vairam,

For this there are 2 ways, either from AX or by code:

1- By code you might use this sample code (i can't share the full code here because too long):

ledgerAccountContract.parmValues(listValueContract);

dimStorage = DimensionServiceProvider::buildDimensionStorageForLedgerAccount(LedgerAccountContract);

dimensionAttributeValueCombination = DimensionAttributeValueCombination::find(dimStorage.save());

ledgerDimension = dimensionAttributeValueCombination.RecId;

dimStorage = DimensionServiceProvider::buildDimensionStorageForLedgerAccount(ledgerAccountContract);

dimensionValidationStatus = DimensionValidation::validateByTreeForCombination(dimStorage,dateNull(),true,true);

2- You can create a new PO and add an item to the lines. Then go to Line details > Financial dimension tab. Here you can insert the combination you want, and then click on Financials > Distribute amounts : if the combination is not valid you will see red box in the line. You can change the Main account from Item group > Purchase order > Purchase expenditure for product , and then Reset the validation from Distribute amounts.

Make sure to reset the correct setup if you change it.

Thank you,

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kaled Alloud,

Thank you for your response , may i know the input format of LedgerAccountContract , i'm getting error when i pass it as

listValueContract.addEnd("MainAccount");

listValueContract.addEnd("401300");

listValueContract.addEnd("BusinessUnit");

listValueContract.addEnd("003");

listValueContract.addEnd("Department");

listValueContract.addEnd("024");

listValueContract.addEnd("CostCenter");

listValueContract.addEnd("013");

listValueContract.addEnd("ItemGroup");

listValueContract.addEnd("AudioRM");

Error : "Function DimensionDefaultingEngine::constructForMainAccountId has been incorrectly called."

Was this reply helpful? Yes No
Verified answer

Khaled Alloud 3,658 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear,

Check below:

valueContract = new DimensionAttributeValueContract();

valueContract.parmName(DimensionAttribute.Name);

valueContract.parmValue(DimensionAttributeValueSetItem.DisplayValue);

listValueContract.addEnd(valueContract);

Thanks,

Was this reply helpful? Yes No
Sachin Mittal 6 on at

Like
a
(0)

Report
Copy link

Link copied!

hi , DimensionValidation::validateByTreeForCombination is this method no longer exists , and if exists in which class can ypu please help

Was this reply helpful? Yes No