Invoice History Report

TICKET 2        :Invoice History Report

WHAT IS: The Invoice History Report is needed to justify the balance for a given range of invoices. It helps you to quickly identify and review a detailed list of all activities pertaining to a specific invoice including all payments, gain/loss, credit/debit memos, and discounts.

In addition, this report can help you to identify activities on prepayments and credit/debit memos.

The balance of the invoices is then summed for each supplier site, for each supplier, and for the entire report.

                                 To Get Invoice History Report and Also need to add three more columns               1.PAYMENT_METHOD_LOOKUP_CODE(PAYMENT METHOD)-wire/eft/check,

2. BANK NAME,

3. BANK ACCOUNT NUMBER

COLUMNS ADDED IN DATA MODEL:

i.   PAYMENT_METHOD_LOOKUP_CODE,

ABB.BANK_NAME,

ABAA.BANK_ACCOUNT_NUM,

FROM

--code modified by teju

AP_BANK_ACCOUNTS_ALL ABAA,

AP_BANK_BRANCHES ABB,

WHERE

--code modified by teju

ABB.BANK_BRANCH_ID=ABAA.BANK_BRANCH_ID

AND ABAA.BANK_ACCOUNT_ID=ck.BANK_ACCOUNT_ID

TABLES:

AP_BANK_ACCOUNTS_ALL ABAA,

AP_BANK_BRANCHES ABB,

 po_vendors  PV,

    po_vendor_sites  PVS,

    ap_invoices  I,

    ap_checks CK,

    fnd_document_sequences f,

    fnd_document_sequences f2,

    ap_invoice_payments AIP,

    xla_transaction_entities ATE,

    xla_events AAE ,

    xla_ae_headers AEH,

    xla_ae_lines AEL,

    ap_lookup_codes ALC,

    ap_payment_history APH,

PAPER  LAYOUT:

Added columns: Payment Method

                               Bank Name

                                Bank Account Number

Parameters of Concurrent Program: