Fixed Assets - EBS (MOSC)

MOSC Banner

Depreciation calc query for RB method DPIS in past

edited Jun 25, 2016 5:02AM in Fixed Assets - EBS (MOSC) 1 commentAnswered

Hi,

Please could someone assist in the below query:

I don't agree with Oracle's depreciation calculation on an asset I have copied to the Tax Book from a Statutory book. Below are the asset details and the output of the depreciation report. We are using a Reduced Balance method of 25% of NBV. A pro-rate convention of mid-month is in use which means the depr start date of the asset should be 01JUL13. The current period is Feb16. Fiscal year is Jan to Dec. Please also see the excel document attached to view my formulas to do the recalculation.

Further to this, when I query this asset and change the DPIS date to 29JUN13 which still results in a depreciation start date of 01JUL13 and save and query the asset again, the Accumulated Depreciation is then calculated correctly (see screenshot below and bare in mind that this calculation will be to end of Jan16 and not Feb16. Also see the 2nd line on the calculation above which is until Jan16 and agrees to calculation below). (This calculation stays the same as below when the DPIS is changed back to 30JUN13)

Tagged:

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