Finance | Project Operations, Human Resources, ...

Answered

Get 'Depreciation' value for selected asset from TmpDateSum

(0) Share

Report

Posted on by Sangram Shinde

2,114

Hi Techies,

I am developing a SSRS report to display year-wise fixed asset depreciation.

I need to fetch value from below form which can be navigated like - Fixed assets->Books->Profile. I need to get sum of 'Depreciation' for selected year(Date column) for each fixed asset. The table used behind is TmpDateSum

I found it is used in AssetCardDP class, it's setting and retrieving the data as per my requirement.

Whereas, when I try to use 'AssetInitDepreciationProfile::newFromBookDate(assetBook) in my DP class, it's giving error - It's protected method and can only called from methods in AssetInitiDepreciationProfile class.

Is there any other way by which I can fetch the Depreciation values or data from TmpDateSum.

Can anyone help if have developed/worked on this before.

Any response is appreciated.

Thank you in advance!

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

huijij 19,811 on at

Like (0)

Report

Hi Sangram,

This method of AssetInitDepreciationProfile::newFromBookDate(assetBook) is indeed modified by protect, why don't you create a new similar method to be called in the custom form?

Was this reply helpful? Yes No
Sangram Shinde 2,114 on at

Like (0)

Report

Hi Judy,

There are multiple different methods involved in this method which are again restricted to access.

I found 'AssetDepreciationPlanDP' class where TmpDateSum table is populating. I am trying some code around to use it my report.

Can you give any inputs in how can I use this class in my report.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Sangram,

Please try using the Electronic Reporting functionality.

A friend has designed a report for the exact same purpose and data that you describe.

Things work out fine out of the box and you don't need to code a single line.

Best regards,

Ludwig

Was this reply helpful? Yes No
Sangram Shinde 2,114 on at

Like (0)

Report

Thank you Dr. Ludwig, will check this part.

Was this reply helpful? Yes No
Sangram Shinde 2,114 on at

Like (0)

Report

Thank you Judy, Dr. Ludwig for valuable suggestion. Below solution worked. Created extension of class and created new public methods where ever I was getting access errors, kept only what is required for my logic and it worked-

Not sure why below rich formatting is not working.

[ExtensionOf(classStr(AssetInitDepreciationProfile))]

final class customAssetInitDepreciationProfile_Extension { public static AssetInitDepreciationProfile CustomNewFromBookDate( AssetBook _book, TransDate _maxPlanDate = maxDate(), System.Threading.CancellationToken _cancellationToken = System.Threading.CancellationToken::None) { AssetInitDepreciationProfile ret = new AssetInitDepreciationProfile(); ret.init(_book, _maxPlanDate, _cancellationToken); return ret; } public boolean customParmCalculateOnlyDepreciation(boolean _calculateOnlyDepreciation = calculateOnlyDepreciation) { calculateOnlyDepreciation = _calculateOnlyDepreciation; return calculateOnlyDepreciation; } }

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get 'Depreciation' value for selected asset from TmpDateSum

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Get 'Depreciation' value for selected asset from TmpDateSum

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates