experchange > navision

egger29 (04-17-10, 12:15 AM)
This is on a NAV 5.0 SP1 database.

Hello, I have a client that has an item with average costing. When the item
card was set up they put in a unit cost of $6. Now about a month later, they
realized that the actual unit cost of the item is $5.044

I want to Change the unit cost field but I can't because it has item ledgers
entries posted. This is what I have done.

Ran the 'adjust item cost' batch job.

Went into a Revaluation journal and selected the item, I put in the new unit
cost (revalued), and posted it, so that my inventory is revalued at the new
price.

But I still want to change the unit cost on the item card to $5.044, can
this be done ?
Alex (04-19-10, 06:45 AM)
Hi egger29

You can use Navutilus Search & Replace utility to find all the $6 item
ledger entries in database and change all of it to 5.044 (you can
change entries only if you have permissions to modify tables
containing it).
Detailed example on - "Misprints
correction in NAV" post.
Utility details:

I use that utility to correct misprints and mistakes during last
implimentation. It saves lots of time.
Alex (04-19-10, 06:48 AM)
Hi egger29!

You can use Navutilus Search & Replace utility to find all the $6 item
ledger entries in database and change all of it to 5.044 (you can
change entries only if you have permissions to modify tables
containing it).
Detailed example on - "Misprints
correction in NAV" post.
Utility details:
I use that utility to correct misprints and mistakes during last
implementation. It saves lots of time.
jbarnes - icepts (04-20-10, 07:32 PM)
Did you rerun the Adjust Cost Item Entries (not the Adjust Item Cost/Price)
after the revaluation was posted?

"egger29" wrote:
[..]
Similar Threads