Get 'Depreciation' value for selected asset from TmpDateSum

(0) Share

Report

Posted on by Sangram Shinde

2,120

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 (1)

All responses (5)

Answers (1)

Sort by

Verified answer

huijij 19,811 on at

Like (0)

Report
Copy link

Link copied!

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,120 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,120 on at

Like (0)

Report
Copy link

Link copied!

Thank you Dr. Ludwig, will check this part.

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

Like (0)

Report
Copy link

Link copied!

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