Availability check for Sales order
I have Material e.p A whose BOM conatin Items X,Y AND Z.
Now I have production Order of A which requires X-10,Y-20,Z-30,
I have stock of Items X-10,Y-20,Z-30
Now I am also selling item X as Spare Part and at same time I have requirement of 10 from customer so i will create sales order of 10 and system will confirm delivery date of today as stock is available in system.But this stock is require for my Production order of A.
So how I can avoid this confliction between production and Sales
Is there any method by which system should not consider stock which is reserved to Production order.