Skip to Content
author's profile photo Former Member
Former Member

Is there any way we can differentiate in between JE's

Hello Experts,

Hope you all are well?

I have a simple question but struggling to find out the answer😭

How can I differentiate in between manual JE's and JE's which are based on Recurring Postings or Exchange Rate Differences?

Tried to search JE's based on remarks however if we change the remarks in those windows then those remarks will not be fruitful to us.

Tried to search by data source however it is coming as 'N' for both of the postings such as Recurring Postings and Exchange Rate Differences.

Is there any other way by hook or crook we can find out it?

Awaiting for your advises.


Vinod Memane

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Oct 30, 2015 at 01:12 PM

    Hi Vinod,

    You could create a simple query with the Query Generator:

    SELECT *


    WHERE TransType = 30

    This will give you a list of all manual journal entries.

    Perhaps you can then use the remarks field to filter the list even more.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Vinod,

      From your original question I understood that you had difficulty distinguishing manual JE's from system JE's. That is why I suggested the query, that would give you manual entries. Did you mean that you need the system JE's instead ?

      My comment about the remarks field was meant as just an example. You will have to give us a little more details about your scenario, if you want us to help you filter the list.



  • Posted on Oct 30, 2015 at 10:37 PM

    u can user the DocSeries field to check.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.