How To re-value Inventory

hksharmaa

HI...I want to revalue my Inventory. We have an write off policy that if a stock is lying which is more than 6 months than its value should be depreciated by 25 % and if more than 1 year than it should be depreciated 50 % and if upto 1.5 year than it should depreciate 75 % and if more than 2 year than it should completely depreciate.

Suppose i have purchased an item of quantity 10 and value per of 10 making it 100 on Jan 2012. Now on 1st July i have to depreciate 25% of the purchased value.
But if i use revaluation Journal, it is changing the value from Jan 2012 as when i select the apply to entry posting date is changed to Jan 2012. How to show depreciation entry in Month of July.??

MarkHamblin

NAV always posts adjustments as close to the original transaction as possible, but respects allowed posting date ranges and inventory periods. Your best bet is to enable inventory periods (if you're not already using them) and then close the inventory periods up to July. Any adjustments you post when then show up in July. Or you can set the allowed posting date range to start in July, and that's when the value entries will be posted.

Alex_Chow

hksharmaa wrote:

HI...I want to revalue my Inventory. We have an write off policy that if a stock is lying which is more than 6 months than its value should be depreciated by 25 % and if more than 1 year than it should be depreciated 50 % and if upto 1.5 year than it should depreciate 75 % and if more than 2 year than it should completely depreciate.

Suppose i have purchased an item of quantity 10 and value per of 10 making it 100 on Jan 2012. Now on 1st July i have to depreciate 25% of the purchased value.
But if i use revaluation Journal, it is changing the value from Jan 2012 as when i select the apply to entry posting date is changed to Jan 2012. How to show depreciation entry in Month of July.??

Have you checked out the Revaluation Journal and the entries that it creates?