links between opor-opdn

[Former Member]

Hi Forum,

I need to write a crystal report to print the follwing:

PO.No, PO.Date, ITEMNAME, QTY, UNITPRICE, CARDNAME, GRPO.No,GRPO.Date, BATCH NUMBER,

Any ideas on how can i accomplsh this?

Regards,

Karthik B

[kothandaraman_nagarajan]

Hi,

Try below link between OPOR and OPDN and add required fields:

OPOR T0  INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry left join PDN1 T2 on  T2.[BaseEntry]  = T0.docentry and  T2.[BaseLine]  =  T1.[LineNum] INNER JOIN OPDN T3 ON T2.DocEntry = T3.DocEntry

Thanks & Regards,

Nagarajan

[former_member188586]

HI try with this Query

SELECT T0.[DocNum],T0.[DocDate],T0.[TaxDate],T0.[CardCode], T0.[CardName], T1.[Dscription], T1.[FreeTxt],T1.[Quantity], T1.[Price], T0.U_TRPSHT "Trip Sheet",T0.U_StockEntry "Stock Entry", T0.[DocStatus] FROM OPDN T0  INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[BaseType] = 22 and  T1.[BaseRef]  =[%0] and T0.[DocDate] >='01/04/2010'

if you want more filed insert it

Thanks&regards

Andakondaramudu