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
0