AP Invoice
In this post, we will discuss about AP invoice. An invoice is created when organization has to pay to supplier. Supplier send invoice to company and further company pay to supplier for its goods or services.
Below query will provide invoice details, created in system.
Invoice Query
SELECT aia.invoice_id,
aia.invoice_num,
psv.vendor_name,
pssv.vendor_site_code,
gcc.segment1||'.'||gcc.segment2||gcc.segment3||'.'||gcc.segment4||gcc.segment5||'.'||gcc.segment6 account_combination,
SUM(aid.amount) invoice_amount
FROM ap_invoices_all aia,
poz_suppliers_v psv,
poz_supplier_sites_v pssv,
ap_invoice_lines_all ail,
ap_invoice_distributions_all aid,
gl_code_combinations gcc
WHERE aia.vendor_id = psv.vendor_id
AND aia.vendor_site_id = pssv.vendor_site_id
AND psv.vendor_id = pssv.vendor_id
AND aia.org_id = pssv.org_id
AND aia.invoice_id = ail.invoice_id
AND ail.invoice_id = aid.invoice_id
AND ail.line_number = aid.invoice_line_number
AND aid.code_combination_id = gcc.code_combination_id
AND aia.invoice_num = 'Test12345'
GROUP BY aia.invoice_id,
aia.invoice_num,
psv.vendor_name,
pssv.vendor_site_code,
gcc.segment1||'.'||gcc.segment2||gcc.segment3||'.'||gcc.segment4||gcc.segment5||'.'||gcc.segment6
aia.invoice_num,
psv.vendor_name,
pssv.vendor_site_code,
gcc.segment1||'.'||gcc.segment2||gcc.segment3||'.'||gcc.segment4||gcc.segment5||'.'||gcc.segment6 account_combination,
SUM(aid.amount) invoice_amount
FROM ap_invoices_all aia,
poz_suppliers_v psv,
poz_supplier_sites_v pssv,
ap_invoice_lines_all ail,
ap_invoice_distributions_all aid,
gl_code_combinations gcc
WHERE aia.vendor_id = psv.vendor_id
AND aia.vendor_site_id = pssv.vendor_site_id
AND psv.vendor_id = pssv.vendor_id
AND aia.org_id = pssv.org_id
AND aia.invoice_id = ail.invoice_id
AND ail.invoice_id = aid.invoice_id
AND ail.line_number = aid.invoice_line_number
AND aid.code_combination_id = gcc.code_combination_id
AND aia.invoice_num = 'Test12345'
GROUP BY aia.invoice_id,
aia.invoice_num,
psv.vendor_name,
pssv.vendor_site_code,
gcc.segment1||'.'||gcc.segment2||gcc.segment3||'.'||gcc.segment4||gcc.segment5||'.'||gcc.segment6