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