# Correcting Item Unit Costs

**URL:** <https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722>\
**Category:** User Forum\
**Created:** [August 7, 2008, 4:26pm UTC](https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722 "2008-08-07T16:26:12Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![markianwinter](https://avatars.discourse-cdn.com/v4/letter/m/db5fbb/32.png) [@markianwinter](https://www.dynamicsuser.net/u/markianwinter)\
**Post date:** [August 7, 2008, 4:26pm UTC](https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722/1 "2008-08-07T16:26:12Z")

</div>

Due to various historical errors, an item has an incorrect unit cost. Given that the correct unit cost can be calculated manually, is there a safe way to ‘fix’ the unit cost in Navision (say, by positive and negative journals)?

Any help would be greatly appreciated!

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [August 7, 2008, 9:00pm UTC](https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722/2 "2008-08-07T21:00:35Z")

</div>

Close off all open transactions on the item, so it is fully invoiced etc.

Run Adjust Cost Item entries

Remove all of the stock

Bring in all of the stock at the correct unit cost.

You could use a revaluation journal to revalue the individual positive entries, so this may fix the odd error transaction.

It depends on the transactions, not to mention your costing method!

---

<div class="post-metadata">

**Author:** ![Romeo](https://avatars.discourse-cdn.com/v4/letter/r/e99b99/32.png) [@Romeo](https://www.dynamicsuser.net/u/Romeo)\
**Post date:** [August 8, 2008, 2:04pm UTC](https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722/3 "2008-08-08T14:04:05Z")

</div>

Off topic,

what if the item had positive and negative entries with wrong cost (increase and decrease) and the current inventory is 0.

is there a way to fix it?

(considering the positive entry is a positive adjustment)

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [August 8, 2008, 6:21pm UTC](https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722/4 "2008-08-08T18:21:22Z")

</div>

It depends where the cost issue has happened. If the positive was wrong and the cost on the negative was manually altered you could revalue the positive.

Ultimately loading the reverse will sort it out, but you need to make sure everything is posted, or it will just move!

---

<div class="post-metadata">

**Author:** ![Romeo](https://avatars.discourse-cdn.com/v4/letter/r/e99b99/32.png) [@Romeo](https://www.dynamicsuser.net/u/Romeo)\
**Post date:** [August 11, 2008, 10:17am UTC](https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722/5 "2008-08-11T10:17:01Z")

</div>

when i calculate inventory from revaluation journal dont get closed entries so i can revaluate them, only the “open” ones.

---

<div class="post-metadata">

**Author:** ![AdamRoue](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@AdamRoue](https://www.dynamicsuser.net/u/AdamRoue)\
**Post date:** [August 12, 2008, 6:39pm UTC](https://www.dynamicsuser.net/t/correcting-item-unit-costs/19722/6 "2008-08-12T18:39:06Z")

</div>

Hi Romeo

You need to manually add the closed lines. The argument being why are you revaluing when all the known costs have been processed?