cancel
Showing results for 
Search instead for 
Did you mean: 

Ref. Tracking Original JE which has been Reversed.

Rakesh_Nataraja
Explorer
0 Kudos

Hi Friends,

Is it possible to track an original journal transaction number from the reversed journal .

Does SAP B1 provide any link to identify the original Journal.

Note :1304853 does not help, because the remarks field in the JE has been used with data

For Ex:

Original journal remark : ejgdvkanjvnafufhbuoaffh boiuouaf buafydf

Reversed journal Remarks : ejgdvkanjvnafufhbuoaffh boiuouaf buafydf(Reversal)

( Missing the original number / If the data was not entered (Reversal) - 'XXX' ) Now, how can this be tracked is there any link to track the Original reversed JE which will be cancelled.

Any suggestion will be of great help.

Regards,

Rakesh

Accepted Solutions (1)

Accepted Solutions (1)

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Please check the following example query and see if it benefits to your requirement :

select StornotoTr as 'Original JE cancelled' from OJDT where transid = 'Reversal entry which is created'

Just enter the Transid as required.

Kind Regards,

Jitin Chawla

SAP Business One Forum Team

Rakesh_Nataraja
Explorer
0 Kudos

Hi Jitin,

StornotoTr has helped me, Is there a way around for this query to identify the Reversed Journal .

Regards,

Rakesh N

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

I believe you can take the Transid in select and the stornototr in the where clause and check the output.

These two fields will cater to your needs.

Kind Regards,

Jitin Chawla

SAP Business One Forum Team

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rakesh........

Just Create a JE and then reverse or cancel it.

Then run the ledger report for the same GL account.

You will get the Reversal JE written as "Reversal"

Regards,

Rahul