Stock Balances

SUGGESTED

Is there any way to start a fresh with basically a blank stock slate?

Currently using 200c on site and we're having a nightmare with batch traceable items being booked in by HH scanners (datalinx) they are managing to slip into the system with no batch number assigned to them, despite batch entry upon POP receipt, and despite the stock card within stock control (Batch Traceable tab) stating catagorically this product MUST be assigned a batch upon goods reciept.

There are locations that are no longer used - The business i'm with has never used the priority locations to define to the scanners where to find the locations i.e

Product Code 1 / Locations Tab

Location 1/2/3/4/5/6/7/8/9 - All with a priority of 9 - Batches held in QTY reserve.

I've analysed the TraceableItems table and indeed there are entries in there with 0 traceable item details despite the above mentioned - This only happens with certain products, but it's now cascading down at a rapid rate.

Ideally, what i'd like is to be able to import an opening balance sheet and start again. But retain trading history, without having to create a new company and start again with a new opening balance sheet.

What implications would there be if i wiped the stock qty within SQL and the traceable items table? :P - I would never do such a thing, but there must be a more elegant solution to the problems we're facing, without it costing us the earth.

Help =D