Unit Cost is increased (wrong) on some items.

gvolkov

I have an interesting phenomenon going on. 'Unit Cost' is way out. For example, last direct cost is: $9.69, standard cost: $9.12 and unit cost is $143.80

Costing Method is "average".

There are quite a few of these items with 'morbidly increased' unit cost. I looked in Item Ledger Entries and

Any help would be appreciated, i need to "normalize" the cost.

Savatage

have you run the Adjust Cost Batch Job?

& just curious if you are using multiple locations?

gvolkov

Yes, the adjust cost batch job is beeing run every night.
And there is only one location.
i thought it may be a data entry mistake but, after 2 days of looking, didnt find anything.

Savatage

1) are you running adjust cost using filters or letting it do everything it can find.

2)are all the po's that this item is on closed & invoiced?

--

There are many discussions about using the Revaluation Journal to fix wacked out costs. you can search the forum for "Revaluation".

I tend to want to find out why it went wrong in hope to prevent it from happening again before just forcing the correct cost back on an item.

You might want to look into credit memo's - we mistakenly (long time ago) were zeroing out the cost for items damaged in transit. That screwed up our costs..

jem_na

Have You tried using "Navision Costing Error Detection and Data Correction" White Paper?
There is a tool included which checks for correct data.

gvolkov

Where do i find this whitepaper?

BTW - we dont use POs. We use manufacturing.