required details of payable entry

[hitesh81]

source is payables and entry is posted to gl in summary .
we need the detail data of particular month in exce sheet for which source is payable how it is possible kindly help

[oteixeira]

Hello.

See if this query has enough info for you:

SELECT h.name,
l.effective_date,
l.accounted_dr,
l.accounted_cr,
l.description,
l.reference_1,
l.reference_3,
l.reference_4
FROM gl_je_lines l,
gl_je_headers h
WHERE l.je_header_id = h.je_header_id
AND h.period_name = '<your period name>'
AND h.set_of_books_id = <your set_of_books_id>
AND h.je_source = 'Payables'


Hope this helps.
Octavio