Stocktake logic seems to be incorrect. Stocktake run on one date -- items booked in/out -- stocktake then physically taken place and entered on sage but the count ignores the bookings in/out and makes the adjustment based on the actual stock at the stocktake run date.
Date |
Movement Type |
Quantity |
Instock |
19/02/2016 |
Out - Stocktake |
7.00000 |
|
5 |
|||
04/02/2016 |
Out - Internal |
2.00000 |
-2.00000 |
03/02/2016 |
Out - Internal |
2.00000 |
0.00000 |
15/01/2016 |
Out - Internal |
3.00000 |
2.00000 |
5 |
|||
19/02/2016 |
Out - Stocktake |
7.00000 |
5.00000 |
14th Jan |
In stock |
12.00000 |
12.00000 |