AP Negative Supplier Balance

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Application: Payables
Source: Accounts Payable Negative Supplier Balance
Short Name: APXNVBAL
DB package: XLA_TB_AP_REPORT_PVT

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Name SQL text Validation
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
AP Trial Balance CE General Ledger Reconciliation CAC Purchase Price Variance CE Israel - Bank Statement Reconciliation XLA Open Account Balances Listing CAC WIP Pending Cost Adjustment XLA Open Account AP Balances Listing XDO Publisher Data Definitions AP Posted Payment Register
Blitz Report™

Blitz Report™ provides multiple benefits: