cancel
Showing results for 
Search instead for 
Did you mean: 

OJDT TABLE

Former Member
0 Kudos
725

Hello,

I am creating a Crystal Report, i want to replace the "jdt1.syscred" by 0 if the Journal Entry is Canceled or Reversed. IF the Journal Entry is canceled the Canceled Check Box is checked. but i cant see this on OJDT Table.

My Question is how can i indicate on my crystal report of the OJDT TransID is canceled.

Thanks for your support.

Regards,

John

View Entire Topic
former_member1269712
Active Contributor
0 Kudos

Hi John,

Try this...

select autostorno,* from ojdt

Thanks

Sachin

Former Member
0 Kudos

Thanks for the reply...

I cant used the autostorno, same autostorno for Canceled JE and not canceled...

Thanks,

John

former_member1269712
Active Contributor
0 Kudos

Hi John,

There are two different fields for Cancellation and Reverse for Manual JE.

1. If you done it is Reverse transaction click on Reverse check box then "autostorno" will "Y".

2. If you right click on JE and Cancelled then you will find your orginal JE's nos in "stornoToTr"

select T0.Transid,T1.SysCred,T2.stornoToTr,T0.autostorno,
(case when T0.autostorno='Y' or T2.stornoToTr is not null then 0 else T1.SysCred end) cred
from ojdt T0
inner join jdt1 T1 on T0.Transid=T1.transid
left outer join ojdt T2 on T0.Transid=T2.transid

Thanks

Sachin

Edited by: SachinD on Oct 30, 2010 11:28 AM

Former Member
0 Kudos

Hi Sachin,

Thanks for your help...i already fix my prob...

Regards,

John

Former Member
0 Kudos

Please indicate whose postings helpful.

Former Member
0 Kudos

Thanks for the help guys....