Skip to Content
avatar image
Former Member

links between opor-opdn

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 13, 2015 at 06:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 06:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded