My Oracle Support Banner

Aging Report By Invoice Type Does Not Distinguish On Account Receipt (Doc ID 390382.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
Aging - 4 Bucket Report
Aging - 7 Bucker Report

Symptoms

When running Aging - 4 Buckets Report & Aging - 7 Buckets Report by Invoice types with Report Type=Brief, amounts from on-account receipt show on both reports differently.

For example:

Run the Aging - 4 Buckets Report with these parameters:

Reporting level : Operating Unit

Reporting context : xxx, Inc

Order By : Customer

Summary Type : Customer Summary

Report Format : Brief

As Of Date : 31-AUG-06

Bucket Name : Standard

Open Credits : Age

Receipts At Risk: Do Not Show

Currency :

Type :  Intl CM   To   Intl Invoice

Customer Name : To

Customer Number : To

Balance Due : To

Balancing Segment : To

Results for one of the customers listed on the report show

Customer Name with   -162.00  outstanding and -162.00 in the 61+ Days Past Due

 

The same report using the Type :  Conversion CM  To   Domestic Invoice shows the following for the same customer.

                                                                   
Customer Name  with   -896.00  outstanding and -896.00 in the 61+ Days Past Due



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.