Hi Guys,
I would like to create a query report where entering a production order would bring the material transferred between the warehouse . The materials being transferred between warehouses will be entered in the stock referring a production order , so when creating an alias the script does not work ,
select
ste.production_order as "Production Order:Link/Production Order:120",
ste_item.qty as "Cutting Qty:Float:60",
ste_item1.qty as "Forging Qty:Float:60"
from
`tabStock Entry` ste JOIN `tabStock Entry Detail` ste_item ON ( ste.name = ste_item.parent and ste.docstatus = 1 and ste_item.t_warehouse in ('Cutting - OGE'))
JOIN `tabStock Entry Detail` ste_item1 ON ( ste.name = ste_item1.parent and ste.docstatus = 1 and ste_item1.t_warehouse in ('Forging - OGE'))
Atleast how do I restrict where clause to specific select statement ?
Any help ?
Thanks