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??
Dear,
Check below:
valueContract = new DimensionAttributeValueContract();
valueContract.parmName(DimensionAttribute.Name);
valueContract.parmValue(DimensionAttributeValueSetItem.DisplayValue);
listValueContract.addEnd(valueContract);
Thanks,
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."
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,556
Super User 2024 Season 2
#2
Martin Dráb
228,625
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (