Hi,
Service Tax Input Credit Register i don't want to show Reverse entries list and that coresponding AP Invoice and for Manula JE against that reversal Entry.
I need to find AP Invoice Reverse Entries against that AP Invoice.wich field it will store data related to reverse entry in OPCH Tables.
here we written this code for identify Reverse entries for AP:
opch.DocNum not in (select OJDT.ref2 from OJDT
inner join opch on OPCH.DocNum=ojdt.ref2 where ojdt.memo like 'A/P Credit Memos %' )
and opch.DocNum not in (select a1.Docnum from OJDT
inner join OPCH a1 on a1.DocEntry=ojdt.Ref1 --and ojdt.stornoToTr=Ojdt.transid
where OJDT. memo like '%A/P Invoices - %' and memo like '%(Reversal)%')
for JE :
a.TransID not in (select OJDT.StornoToTR from OJDT
inner join jdt1 on jdt1.transid=ojdt.transid --and ojdt.stornoToTr=Ojdt.transid
where -
ojdt.number in
OJDT.stornoToTr is not null)