Skip to Content
0
Former Member
Nov 26, 2011 at 05:01 AM

PRODUCTION ORDER NO. DISPLAY IN QUERY REPORT

11 Views

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