Hello Sir,
I need to display production order number in the following query, can you please reply that query,
select distinct t1.DocNum,t1.DocDate,t1.NumAtCard,t1.CardName,t4.U_desc,t4.DocEntry[GRNNO],t4.U_recqun[GRN-QTY],t6.U_PREACPT[Accepted],t6.U_BALQTY[Waiting for QC]
from OPDN t1 inner join PDN1 t2 on t1.DocEntry = t2.DocEntry inner join [@SU_SUBCONGRN] t3 on t1.DocNum= t3.U_grnno
inner join [@SU_SUBGRNLINES] t4 on t3.DocEntry = t4.DocEntry inner join [@TI_GRNINSPECTION] t5 on t3.DocNum = t5.U_SUBGRN
inner join [@TI_GRNLINE]t6 on t5.DocEntry = t6.DocEntry
where t1.DocDate>=[%0] and t1.DocDate<=[%1] and t1.CardName=[%2]
Reagards
Pushpa