Skip to Content
avatar image
Former Member

Crystal Report For General Ledger

Hi Experts,

I want the customized crystal report of general Ledger without cancelled invoices

Any Help Would Be Greatly Appreciated

Thanks

Naresh Nagar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 13 at 10:08 AM

    SELECT A.* FROM JDT1 A
    LEFT OUTER JOIN OINV B ON A.Transid=B.Transid
    WHERE ((A.TransType='13' AND B.CANCELED='N') OR (A.TransType!='13'))

    Add comment
    10|10000 characters needed characters exceeded