SQL Query for Journal entries details and APInvoice table join
Summary:
Need help on SQL query for the Journal entry details and Invoice details Join together.
In the below screen shot we need highlighted information.
I have written below sql query but it seems Join is missing the transaction number,Entry description is not sync with invoice data.
SELECT aia.INVOICE_ID "Invoice Id",
aia.INVOICE_NUM "Invoice Number",
aia.INVOICE_DATE "Invoice Date",
aia.INVOICE_AMOUNT "Invoice Amount",
aia.invoice_currency_code "Currency",
xah.ACCOUNTING_DATE "Accounting Date",
xah.DESCRIPTION "Invoice Description",
xte.Transaction_number "Transaction Number",
gjl.effective_date "Payment Date",
gjh.je_category "JE Category",
gjh.je_source "JE Source",
1