AR Adjustment Register
Description
- Categories
- Enginatics, R12 only
- Application
- Receivables
- Source
- Adjustment Register
- Short Name
- ARRXARPB
- Repository
- GitHub
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.
SQL 35 lines
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 |
Parameters 19
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Reporting Level | LOV Oracle | ||
| Reporting Context | 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 |