Oracle R12 FA depreciation from monthly to weekly.
Our FA depreciation is calculated in monthly basis. Whereas our Financial calendar is in 4/4/5 (Jan-4 weeks, Feb-4 weeks, Mar-5 weeks).
Let's say we have asset cost RM12,000 and 1 year of life years. Monthly depreciation will be RM1000/month.
Jan = 1000
Feb = 1000
Mar = 1000
Total Dep for Q1= 3000
But for weekly calculation, RM12,000/52 = RM230.77/week.
Thefore for Jan = 230.77x4 = 923.08
Feb = 923.08
Mar = 1153.84
Total Dep for Q1= 3000
What Finance do is, in Feb they will post a manual JE for the difference to adjust the depreciation.
The manual JE will b reversed in Mar as the accumulated depreciation is correct at the quarter end.
I suggested the solution to go for weekly depreciation calendar, but user doesn't agree to close the period in weekly basis as the workload will be higher.