Remarks field in Journal Entry form

[Former Member]

Hi All,

I am wondering how is created the Remarks field in Journal Entry form? It contains a string which describes the journal entry origin and sometimes it contains the Business Partner Code. I would like to know the origin table, field of the string (only the string without BP Code).

I would like to write a query which contains all available TransType, and one string remark field for every TransType field.

I wrote the following, but it is not good because the string contains Business Partners Code, more than one line for each TransType field, and doesn't contain every existing TransType type.

SELECT DISTINCT convert(integer,TransType) As TransType, LineMemo from JDT1 ORDER BY TransType

Thanks,

Zoltan

[Former Member · Accepted solution]

Zoltan,

there is not any single table which determines the remarks or memo for Journal entry. in the documents from which, account posting happens (such as invoice) , you will find a field called jrnlmemo in accounting tab (in master table such as OPCH). also, the transtype in OJDT can help you build the case for your query.

HTH,

regards,

Binita Joshi

[Former Member]

Thanks...