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 |
