Why?  It's automatically calculated by the system with each transaction.  Anything you put in there would be overwritten very soon afterwards.  If it's wrong, correct the warehouse amounts (quantity / cost), and CI_Item would be updated by that adjustment.

Why?  It's automatically calculated by the system with each transaction.  Anything you put in there would be overwritten very soon afterwards.  If it's wrong, correct the warehouse amounts (quantity / cost), and CI_Item would be updated by that adjustment.

Because the customer doesn't use inventory to keep track of costing(and now they will) and all costs are negative and the amounts are BIG... ran Sage's utilities and All tables got fixed except CI_Item.  The reason this happened is because they stopped doing the quaterly adjustments... 

*UTL... run the inventory re-balancing utility if CI_Item average doesn't match the warehouse average value.

I did already... i will do it again.

Thanks

Did not work...

1 item is showing AverageUnitCost =  -568,784,628,971.218

Regards,

Average Cost is recalculated when you add inventory quantity.  If you have quantity on hand right now, you need to remove all of the inventory, and then add it back in at the cost you want it to be.  For example, export the quantity on hand by item and warehouse, do a physical count to set all counts to zero, then update the journal.  This will set all QOH to zero, but you may still see an average cost on the Item master.  Next, import or enter the correct quantities with their correct costs in an Inventory Adjustment.  When you update this journal, it will reset the Average costs to cost entered.  

I am guessing the item has zero QoH (where hyanaga's answer would apply), or the utility can't do anything with that value since it is technically too big for the field size (but again, posting a transaction might help with that).

Thnaks, I'll try it...