Receivables - EBS (MOSC)

MOSC Banner

How to calculate the outstanding balance of a customer as of date?

edited Jul 12, 2017 5:00AM in Receivables - EBS (MOSC) 6 commentsAnswered
can anyone suggest query to calculate the outstanding balance of a customer as of date?

 

(Let’s say: - today is 10-aug. but I want to know what the o/s balance of a customer was on 15-May)

 

My requirement:-

 

Need to create a report which has the provision to select date range (i.e.:- 10-May to 14-Jul). I want to show the opening balance as on 10-May, then show all the transaction that hits the customer account within the specified period and then show the calculated closing balance of customer as on 14-Jul.

 

Can anyone suggest me the query to find out the opening balance of customer as on date?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Receivables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center