Thanks so much tim, for your reply
Here is how i have done it,
- searched for items missing in valuation report as per sql query matching it with the stockmaster
- deleted selected items in stockmoves table
- deleted selected items from stockrequestitems
- deleted selected items from stockmaster and locstock tables
- used dispatchid to delete selected items from the stockrequest table
- re applied the key restrictions on the locstock and stockmaster table
(11-06-2013, 10:17 PM)timschofield Wrote: Obsolete parts can still be adjusted, but this should be the only stock movement that is allowed on these items. It is necessary because you might at some time wish to write off stock which is marked as obsolete.
If the system is set up correctly stock adjustments should only be very rarely used, and then should only be used by a senior person. I tend to give StockAdjustments.php a security token of 15 meaning only an administrator can use it.
Tim