Hi Experts
We have a requirement in SAP for a report which can be triggered by an Item Code in Sales Orders which shows the future stock balance of the item.
For example: we have customers who have regular order of 1000 items per month. We add these to SAP in advance for 4 months with a future delivery date in the DocDueDate field so there may be a comittment of 4000 items in SAP but some of the are not required for 120 days in advance by which time we will have Purchased more and be able to meet the supply.
Ideally we need a report or query which can show us the following:
Item Code Doc Type Doc Number Due Date Qty Balance
Opening Balance 1000
021A S/O 23456 15/12/2009 500 500
021A P/O 12345 19/12/2009 400 900
021A S/O 23457 05/01/2009 600 300
In this way our sales staff would have a better idea of when creating a forward order whether or not we will actually have the stock on that day. At the moment it is confusing to have a commitment figure of 4000 when most of the items are not due to be despatched for some time. Alternately is there a way to stop SAP accounting for anything with a future DocDueDate when calculating stock availability?
Regards
Jon