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

Need help to modify SQL to retrieve the journal approver field please

Summary: I am trying to update the GL Ledger script to include the following additional fields

  • Journal Approver name
  • beginning and closing GL account balances for the selected year

Thanks

Content (please ensure you mask any confidential information):

SELECT
'NEW' NEW,
GLL.NAME GLL_LEDGER_ID,
to_date(JEL.EFFECTIVE_DATE,'YYYY-MM-DD') EFFECTIVE_DATE_OF_TRANSACTION,
jes.JE_SOURCE_key JEH_SOURCE,
case when JEC.JE_CATEGORY_key = 'A_ADJ' THEN 'A Adjustment'
when JEC.JE_CATEGORY_key = 'A_TB' THEN 'A Trial Balance'
when JEC.JE_CATEGORY_key = 'A_ISC' THEN 'A Income Statement Close'
when JEC.JE_CATEGORY_key = 'A_INV_AM' THEN 'A Investment - AM'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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