How To re-value Inventory

hksharmaa
hksharmaa Member Posts: 55
edited 2013-01-02 in NAV/Navision Classic Client
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.??

Comments

  • MarkHamblin
    MarkHamblin Member Posts: 118
    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
    Alex_Chow Member Posts: 5,063
    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?
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Categories