Hello All, I'm hoping someone can help me as I'm new to Sage 200. 

About 6 months ago a business we acquired had migrated from Sage 50 to Sage 200 Professional. Unfortunately the information which was migrated in respect of stock was vastly incorrect as the company were using an excel file to manage stock rather than Sage and no one thought to correct the data before migration! 

Anyway to cut a long story short I'm trying to get the stock records inside of Sage corrected, I'm not expecting to bring the historic monthly positions in but would really like to be able to get a revised opening balance position to use going forward. We are doing a full stock take at the end of this month which I'd like to use for the opening balances. The company uses the BOM's functionality so we need to factor this in going forward.  

Looking at the help files, if we amend/adjust the price book and quantities this will create adjustment nominals which presumably we will then need to write off against historic data. Is this the best way to resolve the mess, or would starting again from scratch with a new company in Sage be more appropriate? 

Any feedback/experiences/tips would be more than welcome!

Many thanks in advance.