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 completelyHeader 1 Header 2 Header 3
order - 1mat -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
order - 1mat -1 0 order - 2 mat-3 0
any advice on data modeling as to how do i achieve this?
Which dataosurces shall i use?