Stock Running Total
Hoping someone can help me....I have an order report which shows all our open orders specific to a customer and date range specified in a cascading parameter. The report is grouped on Part number.
What I want is to be able to see the available stock which is a running total from our current stock and the running total is based on the open qty on each line. To achieve this I created a formula field that is current.stock-open.qty. I then created a running total which is based on the formula I just wrote and that resets on the group.
This appears to be working perfectly when there is 0 stock but when there is stock, the figures produced don't add up - though they are close. See below:
As you can see, the first 3 lines show my issue (within the red box). The totals for these lines should read -117 (so first line is ok), -130 & -131.
Any help you can give would be greatly appreciated.