AP Negative Supplier Balance

➜ Back to Library
Description
Categories: Enginatics, R12 only
Repository: Github
Application: Payables
Source: Accounts Payable Negative Supplier Balance
Short Name: APXNVBAL
DB package: XLA_TB_AP_REPORT_PVT
select 
 x.account liability_account
,x.third_party_name supplier_name
&sum_or_detail_cols
from
 (select
    xtb.account
  ,xtb.third_party_name
  ,xtb.user_trx_identifier_value_3
  ,xtb.user_trx_identifier_value_10
  ,xtb.user_trx_identifier_value_8
  ,xtb.ledger_currency_code
  ,xtb.src_acctd_rounded_orig_amt
  ,xtb.src_acctd_rounded_rem_amt
  ,sum(xtb.src_acctd_rounded_rem_amt) over(partition by xtb.account,xtb.third_party_name)  sum_supp_liability
  from 
    (&p_template_sql_statement
     &p_sql_statement
    ) xtb
 ) x
where
      1=1
and x.sum_supp_liability < 0
&summary_group_by
Parameter NameSQL textValidation
Operating Unit
 
LOV Oracle
Report Definition
 
LOV Oracle
As of Date
 
Date
Third Party Name
 
LOV Oracle
Show Transaction Detail
 
LOV Oracle
Download
Related Blitz Reports
XLA Subledger Period Close Exceptions AP Trial Balance CE General Ledger Reconciliation CAC Receiving Expense Value (Period-End) CAC WIP Pending Cost Adjustment CAC Manufacturing Variance CAC Material Account Summary XLA Open Account Balances Listing XLA Open Account AP Balances Listing
Blitz Report™