cancel
Showing results for 
Search instead for 
Did you mean: 

OJDT TABLE

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

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....

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi John,

If you change cancel/reverse JE to 0, the balance will not be correct. What is the requirement for the report?

Thanks,

Gordon

Former Member
0 Kudos

Hi Sir,

I want to create a formula that if this JE is canceled it will have a text message "Cancel".. i have no problem on my reverse JE because i know if it is reverse JE because of StornoToTr field.

Thank you sir..

John

Former Member
0 Kudos

Hi John......

I dont know exactly but i can suggest you something so that you get some clue.

If any JE is canceled or reversed then OJDT.Storno will store the canceled JE TransID.....

Try this and check......

Hope this helps you.....

Regards,

Rahul

Former Member
0 Kudos

Thanks Rahul,

IF the Journal Entry is canceled then it will create another Journal Entry for reversed transaction and this JE will have the StrnoToTr (the transid of reversed JE). i have link the two table OJDT and OJDT_1 (another OJDT), i want to create a formula on Crystal report that if this OJDT have link on another OJDT (OJDT_1) with same Transid=StornoToTR then the output is O(Zero)..

Sorry for my bad english...

Example: I have created JE with TransID=91 then i canceled this JE the SAP automatic created other JE with TransID=92

Then the link between this two JE is TransID=StornoToTr

Thank,

John