Ref. Tracking Original JE which has been Reversed.

[Rakesh_Nataraja]

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

[jitin_chawla · Accepted solution]

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 · Accepted solution]

Hi Jitin,

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

Regards,

Rakesh N

[jitin_chawla · Accepted solution]

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

[Former Member]

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