Finance | Project Operations, Human Resources, ...

How to get all the financial dimensions of Fixed Asset?

(0) Share

Report

Posted on by AXBOY

607

Hi All,

I have a requirement where i need to get all the financial dimensions of a Fixed Asset,:

I tried to get atleast one of them but giving me a blank value instead :

DimensionAttributeValueSetStorage dimStorage;
Str costCenter;
Counter i;
AssetBook assetBook;

//dimStorage = DimensionAttributeValueSetStorage::find(assetBook.DefaultDimension);
dimStorage = DimensionAttributeValueSetStorage::find(AssetTable::find('167968').DefaultDimension);
for (i= 1 ; i<= dimStorage.elements() ; i++)
{
// Change the string "CostCenter" to whatever financial dimension you want
if(DimensionAttribute::find(dimStorage.getAttributeByIndex(i)).Name == "CostCenters")
{
costCenter = dimStorage.getDisplayValueByIndex(i);
}

}
Info(strFmt("%1",costCenter));
}

Can someone please explain me in detail how can I achieve this?

Thanks in Advance

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

Cant this be done by data management? it shows the default dimension.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello AXBOY,

Why do you need the default dimensions?

If somebody posts a fixed asset transaction with a different findim then those default dimension values won't help.

Don't you need the ones used for posting?

Best regards,

Ludwig

Was this reply helpful? Yes No
AXBOY 607 on at

Like (0)

Report

I need those default dimensions for custom inquiry form created for fixed asset. can you please help me to achieve the same?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi AXBOY,

The table AssetBook contains the DefaultDimension field. You now tried to get the default dimension from the Asset table. Have you tried it with enabling the first line and find the correct AssetBook record?

Was this reply helpful? Yes No
Junaid Idrees on at

Like (0)

Report

Hi AXBOY,

What kind of data you want to display in this custom inquiry screen? Would you like to share the business case? Let's say you picked the default dimension from Asset Book and while posting Fixed Asset depreciation user changed the dimension on the journal so how are you going to handle this? Did you think about it.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello AXBOY,

Can you please check out the following standard entity that has the default findim already included:

You can either use the Excel addin as I did or use the data management workspace to analyze, extract, ... those data.

Best regards,

Ludwig

Was this reply helpful? Yes No