You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Natural Account (SEGMENT2) Description on a custom report

Summary:


Hello,

We have built a custom report to compare the FA SLA balances to GL which contains an account column but which GL table do we use to include the account description (read COA value set value descriptions for the natural account segment).

I have tried some queries with SEGMENT2 and DESCRIPTION from GL_CODE_COMBINATIONS as well as GL_JE_LINES, GL_JE_HEADERS. I see a description column but with blank values,

Regards

Rajesh

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


24B

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!