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:



1 Comments :

I want rdf invoice history report query

Reply

Post a Comment