Fixing Wrong Average Cost?
Fixing Wrong Average Cost?
we have some inventory parts showing the average cost as $20 to $50 on a part that has only ever cost $4.50. Is there anywhere to go to change that? I am assuming a PO was entered wrong somewhere previous.
Re: Fixing Wrong Average Cost?
Morning Blawyer41,
Thank you for posting on the forum. Average cost is reset once the quantity on hand drops to 0. It will then reference the Last Cost as Average cost. So all you need to do is have your last cost set to what it should be, set the on hand amount to 0, and then change it back to what ever amount you actually have on the shelf.
Hope this helps!
Thank you for posting on the forum. Average cost is reset once the quantity on hand drops to 0. It will then reference the Last Cost as Average cost. So all you need to do is have your last cost set to what it should be, set the on hand amount to 0, and then change it back to what ever amount you actually have on the shelf.
Hope this helps!
Re: Fixing Wrong Average Cost?
Holy mackerel, I should have asked this a long time ago, lol. Worked perfect, thanks so much!