Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Stock Running Total

Hi,

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.

Thanks, Emily

Former Member
Not what you were looking for? View more on this topic or Ask a question