out of stock material report based on sales orders

[Former Member]

Hi,

I have a requirement to create a report where I need to show the unfulfilled sales orders due to materials were out of stock for those sales orders.

e.g. there were 3 orders placed yesterday. we partialy delivered order - 1 as one of the material was available but second material was out of stock and order - 2 was not delivered at all due to out of stock materail and order - 3 was delivered completely

Header 1	Header 2	Header 3
sales order	material	quantity
order -  1	mat -1	0
	mat - 2	2
order - 2	mat-3	0
order - 3	mat - 4	2

required out put it to show only those sales orders which has 0 quantity materials.

Header 1	Header 2	Header 3
sales order	material	quantity
order -  1	mat -1	0
order - 2	mat-3	0

any advice on data modeling as to how do i achieve this?

Which dataosurces shall i use?

regards,

Biapp

[former_member186399]

Hello

Make use of 2LIS_11_V_SCL data source. This data source gives you open quantity as a part of the standard extractor

Regards

Gajesh

[Former Member]

Hi Ganesh,

thank you for your reply. I looked at the 2lis_11_v_scl datasource and yes it does give open quantity but it does not give me detail that open quantity was due to material unavailability. unfortunately it doesn't satisfy my requirement.

thanks,

BIapp

[former_member186399]

Hello,

Please check for the field material availability date in 2lis_11_v_scl. That will tell you as on date the material was available or not.

Regards

Gajesh

[Former Member]

Hi Gajesh,

let me work with this data source and will update you on the progress.

thank you very much for your input.

regards,

Biapp

[Former Member]

Hi Gajesh,

I have looked in to the material availability date and it gives me the required result about 80%.

only problem is e.g.

if the customer placed order for a material for 10qty and if we had 5 in stock same day and the rest of the 5 qty is available after the month but material availability picks up that 5 qty and it does not show that we were not able to fullfill the order 100%. material availability date does not pick up the second date.

how do i overcome this issue? do you have any idea?

regards,

BIapp

[former_member185132]

Have you tried to use a condition in the BEx query for qty = 0?

And please describe your current data model

[Former Member]

I am using copa datasource and it does not have material quantity it has only sales order material quantity which customer ordered. I looked at 2lis_11_vaitm datasource as well but it does not give data which i am looking for.