AR Receipt Analysis - Days Late – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Receivables · all Receivables reports

Overview

Receipt applications against all transactions except credit memos, with the days between the installment due date and the application date. Converted from the Oracle report Receipt Analysis - Days Late.

One row per receipt application. Days Late is the apply date minus the due date and is negative for an early payment. Weighted Days Late is Days Late multiplied by the amount applied, in the transaction currency.

Invoice Amount shows the installment’s original amount on its first application row only, so the column sums to the Oracle report’s currency totals.

Average Days Late and Weighted Average Days Late are calculated per operating unit, customer account and currency and repeated on every row of that group. The Oracle report prints 0 for a negative Average Days Late, and splits a customer’s currency group when receipts in another currency are applied.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Ledger, Operating Unit, Customer Name, Customer Name Low, Customer Name High, Customer Number, Customer Number Low, Customer Number High, Invoice Number, Invoice Number Low, Invoice Number High, Apply Date From, Apply Date To, Payment Term, Payment Term Low, Payment Term High, Collector, Collector Low, Collector High

Oracle EBS Tables Used

hr_all_organization_units_vl, ar_payment_schedules_all, ar_receivable_applications_all, ar_cash_receipts_all, ra_customer_trx_all, ra_cust_trx_types_all, ra_terms_vl, hz_cust_accounts, hz_parties, hz_cust_site_uses_all, hz_cust_acct_sites_all, hz_party_sites, hz_locations, hz_customer_profiles, ar_collectors, xxen_report_org_access

Report Categories

Enginatics

AR Aging, AR Cash Receipt Upload, GL Account Analysis, AR Transactions and Payments, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, AR Open Items Revaluation, AR Customer Statement

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output AR Receipt Analysis - Days Late 05-Apr-2018 190325.xlsx
Blitz Report™ XML Import AR_Receipt_Analysis_Days_Late.xml
SQL Source AR Receipt Analysis - Days Late.sql
Full Report on Enginatics www.enginatics.com/reports/ar-receipt-analysis-days-late/

© Enginatics GmbH