This suggestion is a development on my previous suggestion which can be found here:
Sage appears to have implemented a 'Qty. Used' column in the product record activity module.
Whilst this has some benefits, it does not resolve the issues that we're facing which could be easily resolved by having a running total column.
For example, one of our products requires stock to be transferred (BOM) but there's an stocking issue with one of the components. To try to see when this issue started, how and why, I would start by checking the activity.
I can see by having a running total that the issue began around transaction number 577 so it gives me a starting point to look in to this.
| tranaction number | Qty. In | Qty. Out | Qty. Used | Total (after transaction) |
| 580 | 1 | 1 | -4 | |
| 579 | 2 | -5 | ||
| 578 | 1 | -3 | ||
| 577 | 2 | -2 | ||
| 576 | 4 | 0 | ||
| 575 | 4 | 4 | ||
| 574 | 4 | 4 | 8 | |
| 573 | 4 | 4 | 4 | |
| 572 | 2 | 0 | ||
| 571 | 2 | 2 | 2 | |
| 570 | 5 | 0 | ||
| 569 | 5 | 5 | 5 | |
| 568 | 3 | 0 | ||
| 567 | 3 | 3 | 3 | |
| 566 | 2 | 0 | ||
| 565 | 2 | 2 | 2 | |
| 564 | 2 | 2 | 0 |
Guest
This is still a problem.
Something which compounds this problem; I've just done a year end stock take and painstakingly entered all stock values that are confirmed
i.e. the program says we have 2, and yes we have 2.
When I've gone back into the activity, because an adjustment wasn't made; it has not been 'stamped' with the correct level. (I was expecting a 'brought forward balance' type of thing - not that I particularly deal with the accounting side or know what this means exactly)
This means in future if we notice something has gone astray, we can't even check to see at which point in time the stock level was correct!
Was that stock ever checked?
No one will know
What a waste of my time trying to get around this ambiguity.