Journal entry cancelled entry

[former_member229757]

Hi,

How to find the canceled journal entry is there any field in OJDT and JDT1 tables which specifies the journal entry have been canceled.

select sum(debit) as debit,sum(Credit) as credit from JDT1 t0 inner join OJDT t1 on t0.transid=t1.transid

where account='161011' and t1.TransType in(24,30,46)

and t1.refdate between '10-01-2022' and '10-31-2022'

Thanks

Vinoth

[LoHa]

Hi Vinoth,

you can check in OJDT:

StornoDate

StornoToTr(TransId where the Storno comes from)

AutoStorno

regards Lothar

[former_member229757]

Hi,

I need a query to remove wrong entry both wrong and actual entry. how to acheive this.

i need to remove both entries from my table.

select sum(t1.debit) from OJDT t0 inner join JDT1 t1 on t0.TransId=t1.TransId where t1.Account='161011' and t0.refdate between '10-01-2022' and '10-31-2022'