Skip to Content
0
Former Member
Mar 26, 2009 at 08:18 PM

how to change the AvgPrice in the OITM table

271 Views

We are managing items by warehouse. When the first imports were done a price was entered in the field OITM.AvgPrice as well as a price in the warehouses.

Transactions have been posted so we cannot change the OITM.AvgPrice. I know the system takes the price in the OITW table, but the issue is that we are creating new warehouses, and the cost price is getting posted there automatically. It's taken the price in OITM.AvgPrice, which is wrong. We need to change this price, and make it 0. how could we do this ?

Thanks

Sophie