Skip to Content
avatar image
Former Member

Crystal Report For General Ledger

Sep 21, 2017 at 07:35 AM | 30 Views | Last edit Sep 21, 2017 at 07:39 AM 2 rev.

Hi Experts,

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

Any Help Would Be Greatly Appreciated

Thanks

Naresh Nagar

SAP Crystal Reports, version for SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    jaheer ussain babu shajakhan
    Jun 13, 2018 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