AR Adjustment Register

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Application: Receivables
Source: Adjustment Register
Short Name: ARRXARPB

The report has now been enhanced to allow multiple accessible Ledgers or Operating Units to be selected in the Reporting Context parameter. Additionally, the Reporting Context parameter has been made optional. Leaving it null will allow the report to be run across all accessible Ledgers or Operating Units.
select
  rx.organization_name ledger,
  rx.functional_currency_code functional_currency,
  rx.debit_balancing "&bal_segment_p",
  rx.debit_balancing_desc "&bal_segment_d",
  rx.postable,
  rx.adj_currency_code currency,
  rx.adj_class adjustment_class,
  rx.trx_number invoice_number,
  rx.adj_name "Type",
  rx.customer_name,
  rx.customer_number,
  rx.trx_date invoice_date,
  rx.gl_date,
  rx.due_date,
  rx.adj_number adjustment_number,
  rx.adj_type_meaning adjustment_type,
  rx.adj_amount entered_adjustment_amount,
  rx.acctd_adj_amount functional_adjustment_amount,
  rx.d_or_i "D/I",
  rx.doc_sequence_name,
  rx.doc_sequence_value
from
  ar_adjustments_rep_itf rx
where
    1=1
and rx.request_id = fnd_global.conc_request_id 
order by
  rx.organization_name,
  rx.functional_currency_code,
  rx.debit_balancing,
  rx.postable,
  rx.adj_currency_code,
  rx.adj_class,
  rx.customer_name
Parameter NameSQL textValidation
Reporting Level
 
LOV Oracle
Reporting Context
rx.organization_name in (select distinct gsob.name from hr_operating_units hou,gl_sets_of_books gsob where to_number(hou.set_of_books_id) = gsob.set_of_books_id and decode(:p_reporting_level,'1000',gsob.name,'3000',hou.name,null) = :p_reporting_entity_name)
LOV
Company Segment Low
 
LOV
Company Segment High
 
LOV
GL Date From
 
Date
GL Date To
 
Date
Entered Currency Low
 
LOV Oracle
Entered Currency High
 
LOV Oracle
Transaction Date Low
 
Date
Transaction Date High
 
Date
Transaction Due Date Low
 
Date
Transaction Due Date High
 
Date
Transaction Type Low
 
LOV
Transaction Type High
 
LOV
Adjustment Type Low
 
LOV Oracle
Adjustment Type High
 
LOV Oracle
Document Sequence Name
 
LOV
Document Sequence Number From
 
LOV
Document Sequence Number To
 
LOV
Download
Related Blitz Reports
JG Statutory Asset Cost/Reserve Detail Report- Not Supported: Reserved For Future Use AR Transaction Register APL: AR Transaction Register AR Transaction Register(GST) XXEOS ZM-Bericht AR (1) AR Customer Statement AR Balance of Advance Received in Selected Currency AR Potential Reconciling Items FA Asset Maintenance Report- Not Supported: Reserved For Future Use
Blitz Report™