Unit Cost Not Updated

Jonathan2708

Hi,

I have an item (FIFO) history as follows (in entry no. order) :

31/12/08 Pos Adj. Qty=244 Unit Cost=16.88
31/12/08 Neg Adj. Qty=244 Unit Cost=16.88
31/12/08 Pos Adj. Qty=244 Unit Cost=0.00

(The opening stock should have been booked in at zero cost originally)

The Inventory Valuation shows the correct value of zero, the G/L has been updated with the correct value. It's just that the Item Card still shows a Unit Cost of 16.88. Surely this should now show 0.00?

I have automatic cost posting on, automatic cost adjust=Always. I have also run adjust cost entries batch job for good measure.

Any ideas why the Unit Cost field hasn't been updated? Any help appreciated.

Jonathan

DaveT

Hi Jonathan,

It might be a problem with the allocations. Go to the Application Worksheet and check it out. (under the application button on the item ledger entry list). Try remove and re-appling the entries.

Alex_Chow

Unit Cost on the item card is only updated when the average cost is not 0. This has been the case since version 3.x.

DaveT

Thanks Alex - good to know

Jonathan2708

Hi Guys,

Thanks for the replies. I can see the reason now. Any sales orders raised against the item will have the cost adjusted back to zero at time of posting invoice.

Thanks