Stock Write Downs

(0) Share

Report

Posted on by CILGroup

397

Hi,

We have never done this yet, how do we update unit costs of our items for our stock write-down process? The accountants have updated the unit costs of a spread sheet so how can i now use this spread sheet to import and update into NAV? Is it via Revaluation Journals?

I tried to do a test on one item and changed the cost from 0.708 to 0.6 however when checking the item card it's 0.60033. Why would this be?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Which costing method are you using? If you are using standard please follow this link

https://msdn.microsoft.com/en-us/library/hh168409(v=nav.90).aspx

Was this reply helpful? Yes No
CILGroup 397 on at

Like (0)

Report

Sorry forgot to mention we use the Average Costing method on a item level.

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report

You can indeed use Revaluation Journals for that. Check how "How Microsoft Dynamics NAV Calculates the Unit Cost on the Item Card": www.archerpoint.com/.../how-microsoft-dynamics-nav-calculates-unit-cost-item-card

Have you run Adjust Cost – Item Entries batch job ? Please refer here: msdn.microsoft.com/.../hh169034(v=nav.90).aspx

Was this reply helpful? Yes No
CILGroup 397 on at

Like (0)

Report

If we use average cost method and 'Automatic Cost Adjustment' is on, do we still need to run the batch job?

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

Yes you should do this before revaluing the cost.

Was this reply helpful? Yes No
Verified answer

tpupko 2,048 on at

Like (1)

Report

Hi,

Steps:

1. Run Adjust Cost - Item Entries

msdn.microsoft.com/.../hh169387(v=nav.90).aspx

2. Fill entries in Revaluation journal and post

msdn.microsoft.com/.../hh168236(v=nav.90).aspx

3. Run Adjust cost - Item Entries one more time

Check what setting do you have in Item Ledger Setup for field Automatic Cost Adjustment?

if Automatic Cost Adjustment = Always do only step 2 in other cases do 1-3 steps.

Was this reply helpful? Yes No