Skip to Content
avatar image
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.

Regards,

Vinod Memane

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 30, 2015 at 01:12 PM

    Hi Vinod,

    You could create a simple query with the Query Generator:

    SELECT *

    FROM OJDT

    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.

    Regards,

    Johan

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

      Regards,

      Johan

  • Oct 30, 2015 at 10:37 PM

    u can user the DocSeries field to check.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vinod,

      I don't think you are able to distinguish the recurring postings, but the exchange rate differences do have an indicator on them - I think from memory it is RevSource, but do check it