Skip to Content
0
Former Member
Mar 02, 2009 at 03:57 AM

How we can find Reversal Entries List in OPCH Tables.

195 Views

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)