You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

From which do we get current YTD depreciation amount

We have below logic to get the YTD DEPRN amount, but the depriciation is not run for sep month hence the query fails as no record in summary table for sep period counter. But system shows the ytd deprn amount till aug. Can you suggest which exact table can we refer to get the latest YTD amount even if depriciation is not ran

SELECT sa1.ytd_deprn
FROM FA_DEPRN_SUMMARY sa1,FA_DEPRN_PERIODS kc2
WHERE sa1.asset_id=166003
AND sa1.book_type_code='CA_CAD_CORP'
AND kc2.PERIOD_NAME= 'Sep-25'
AND sa1.period_counter = kc2.period_counter

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!