Re: Fixed Asset Accumulated Depreciation is Higher!
hi,
Regarding this subject i made a testing in my test database
i found that FA00200,FA00902 is using to save the data in the database.My client is facing problem for depreciation in the various month in the year 2011 (the value became triples).
For the testing purpose, I use to update the value in this tables using SQL update statement
UPDATE FA00902 SET AMOUNT=8.75 WHERE FAYEAR=2011 AND GLINTBTCHNUM='FATRX00000113' AND ASSETINDEX=978
UPDATE FA00200 SET ltddepramt=516.25 , CURRUNDEPRAMT=8.75 WHERE ASSETINDEX=978
UPDATE FA00902 SET AMOUNT=-8.75 where FAYEAR=2011 AND GLINTBTCHNUM='FATRX00000113' AND ASSETINDEX=978 AND TRANSACCTTYPE=1
And its result showing fine. But when i am running the depreciation which is already run in the period couldn't run again to generate new JV's.
My plan is to void all the JV transaction which is wrong for depreciation and post new batch which i explained.
when i try to rerun new Jv's (Tool=>Routine=>Fixed Asset=>depreciate) and
(Tool=>Routine=>Fixed Asset=>GL POsting) their is no result is appearing to affect which i made change in FABOOK.
please advice me how can i achieve the result or if my way of approch is not fair . please advice how can i do the depreciation for the same period which already posted.