AP Accounts Payable Negative Supplier Balance

➜ Back to Library
Description
Categories: BI Publisher, Enginatics
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_SQL_STATEMENT
     AND :L_RUN_DETAIL_REPORT = 'Y'
    ) 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
Show Transaction Detail 
,sum(x.SRC_ACCTD_ROUNDED_ORIG_AMT) "Amount"
,sum(x.SRC_ACCTD_ROUNDED_REM_AMT) "Remaining Amount"
Show Transaction Detail 
,x.USER_TRX_IDENTIFIER_VALUE_3 "Invoice Number"
,x.USER_TRX_IDENTIFIER_VALUE_10 "Invoice Description"
,substr(x.USER_TRX_IDENTIFIER_VALUE_8,1,10)   "Invoice Date"
,x.LEDGER_CURRENCY_CODE "Currency"
,x.SRC_ACCTD_ROUNDED_ORIG_AMT "Amount"
,x.SRC_ACCTD_ROUNDED_REM_AMT "Remaining Amount"
Show Transaction Detail 
group by
 x.ACCOUNT
,x.THIRD_PARTY_NAME
order by
  1,2
Show Transaction Detail 
order by
  1,2,3,5
Account From 
 
Account To 
 
Account Balance 
 
 LOV Oracle
XLA_SRS_SUBLEDGERS 
 
 LOV Oracle
Chart of Accounts 
 
 Number
Summarize Balances 
 
 LOV Oracle
Custom Parameter 3 
 
Include Write Offs 
 
 LOV Oracle
Journal Source 
 
 LOV Oracle
Security 
 
Security Identifier (Character) 
 
Show Transaction Detail 1 
 
 LOV Oracle
Start Date 
 
 Date
Valuation Method 
 
Download
Related Blitz Reports
AP Accounts Payable Trial Balance CE Bank Statement Detail - draft CE Israel - Bank Statement Reconciliation XLA Open Account AP Balances Listing XLA Open Account Balances Listing DBA External Table Creation CE AutoReconciliation Execution - draft CE Bank Statement Import Execution - draft CE Sweep Transactions Generation Execution - draft
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: