Skip to Content
0

Crystal Report For General Ledger

Sep 21, 2017 at 07:35 AM

16

avatar image
Former Member

Hi Experts,

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

Any Help Would Be Greatly Appreciated

Thanks

Naresh Nagar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

jaheer ussain babu shajakhan Jun 13 at 10:08 AM
0

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'))

Share
10 |10000 characters needed characters left characters exceeded