We seen to have a critical problem with our inventory. Our Inventory Valuation Report shows anomalies with our stock. Quantity can be at zero but still with an asset value (Some Positive, some negative). When we migrated to QBO, the first entry of a product was the combined total of all asset adjustments made in our previous system (Reckon). The problem seems to be the unit price at the time of adjustments varied, but the QBO beginning adjustments has used the most recent unit price.
I have been in email contact, the best answer I have had so far is to do an adjustment for each item. This would mean getting an Inventory Valuation Report for each item individually (the report is too large otherwise) and then comparing it to a Inventory Valuation Report from Reckon to workout the variance between the individual adjustment and the bulk adjustment. Was hoping the community may have another answer as we have 2300 products on file