Hello Members

Can anyone help me in the following query. I wrote the following query to fetch R21 AP invoice with both functional and invoice currency, I will be glad for assistance if there is a better way.

Select

---ou.name Company

.concatenated_segments

.transaction_number,

.invoice_num,

.invoice_date,

.gl_date,

.terms_date "due Date",

.segment1 "Vendor Number",

.vendor_name,

SUM (NVL (entered_rounded_cr, 0)) - SUM (NVL (entered_rounded_dr, 0)) INVOICE_CURRENCY,

SUM (NVL (acctd_rounded_cr, 0)) - SUM (NVL (acctd_rounded_dr, 0)) FUNCTIONAL_CURRENCY_GHS

FROM xla.xla_trial_balances xtb,

.gl_code_combinations_kfv cc,

.xla_transaction_entities xte,

.ap_invoices_all ai