Skip to Content
0
Former Member
Dec 07, 2009 at 04:01 PM

Planning Stock using Forward Sales Orders and Future POs

48 Views

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