User Tools

Site Tools


Changing Stocktake Status

First you will need to take a note of the Stocktake Number. Once you have the stocktake number you are able to then change that status to which is require. Status references can be found at the following query:

use priarch
select * from x_stocktake_status

To see the stocktake you can use the following query and adding the stocktake number:

  Select * from stocktake..stocktake_log where session_no = 3569

Once you have found the stocktake, got the required status, you will need to change the record to correct status. Use the following update query to change the status of the stocktake:-

begin transaction
Update stocktake..stocktake_log set stocktake_status = ? where session_no = ?
commit transaction
changing_stocktake_status.txt · Last modified: 2016/09/22 10:53 by