Tuesday, 8 May 2012

Transactions Posted from AR TO GL

SELECT
l.effective_date GL Date,
l.accounted_dr Debit,
l.accounted_cr Credit,
l.description Description,
l.reference_4 AR Number,
l.reference_9 AR Type
FROM gl_je_lines l, gl_je_headers h
WHERE je_source = ‘Receivables’
AND h.je_header_id = l.je_header_id
AND h.set_of_books_id =
AND h.period_name =

No comments:

Post a Comment