Is there a way to determine which rows are inserted in JDT1 table by the system automatically?

[rajesh_khater]

Hi,

Is there a way to determine which rows are inserted in JDT1 table by the system automatically? Example, many GLs which are mapped in GL Account Determination, like Foreign Exchange Gain / Loss, Rounding Account, etc. are inserted by the system automatically in the Journal Entry on various scenarios, like during Incoming Payment, etc.

Which SQL query can give me those rows? Basically the WHERE condition should be based on which column or multiple columns in JDT1 table?

Thanks.

[kothandaraman_nagarajan]

Hi Rajesh,

To know automatic field update, create manual JE and auto JE(AR invoice) and then compare fields.

Thanks.

[pedro_magueija]

Hi Rajesh,

I'm not entirely sure but I think the TransId is the same in the header that belongs to the transaction.

OINV.TransId = JDT1.TransId

---

Best regards,

Pedro Magueija

[rajesh_khater]

Dear Experts, any solutions? It will be great if there is a way to find this !