Financial - JDE1 (MOSC)

MOSC Banner

Fixed Assets Depreciation Formula

edited Jan 15, 2016 10:00AM in Financial - JDE1 (MOSC) 1 commentAnswered

Hi All

I have an asset with a life of 12 months.  The asset is being entered in JDE in Period  7  and we want to depreciate the asset for the first 7 periods on a straight line basis in Period 7 and then charge pro rata depreciation (1/12) also on a SL basis  from Period 8 to 12. 

For example if the asset costs $12,000:

I want the formula to do the following:

Period 7

<period when new asset is entered in the system>

-Calculate catch up depreciation expense  on a SL basis for 7 periods  - $7,000

Period 8 to Period 12

Calculate  pro-rata depreciation expense on an SL basis for each period - $1,000 per period.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center