Skip to Content
0
Former Member
Apr 14, 2015 at 01:43 PM

out of stock material report based on sales orders

26 Views

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