cancel
Showing results for 
Search instead for 
Did you mean: 

PRODUCTION ORDER NO. DISPLAY IN QUERY REPORT

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Pushpa......

Is there any relation between Production Order table and any of the table taken in your query report?

If yes then please let me know.......

Then only you can get it linked with Production order......

Regards,

Rahul

Former Member
0 Kudos

Yes, that is the relationship between Subcontracting GRN, this is the add on document...

Regards,

Pushpa