My Oracle Support Banner

E1: 03B: FAQ - Frequently Asked Questions on Account Balance Inquiry (P03B218) and Parent/Child Browse (P03B151) (Doc ID 625805.1)

Last updated on FEBRUARY 01, 2019

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information in this document applies to any platform.

Purpose

Frequently Asked Questions regarding Account Balance Inquiry (P03B218)

Questions and Answers

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
Purpose
Questions and Answers
 Question 1. What is the purpose of Account Status Summary (P03B218) application?
 Question 2. How are specific fields updated on Account Status Summary inquiry screen?
 Question 3. How are the open amounts and 'As of Date' calculated?
 Question 4. How are amounts calculated by Statistical History Refresh (R03B16/R03B16A)?
  Question 5. All of the information on the Account Status Summary (P03B218) application seems to be up to date with the exception of 'General Information' section (account opened, first invoice date, last invoice date, last paid amount and date last paid). How is the 'General Information' updated?
 Question 6. Why does the 'Account Balance Inquiry' form show records for a blank company (not Company 00000) after Credit Analysis Refresh (R03B525) is run?
 Question 7. Why is the 'Over Credit Limit' field in Account Balance Inquiry only populated for Company 00000?
 Question 8. What currency does P03B218 use?
 Question 9. Why is no data being returned in Account Balances Inquiry (P03B218) or Parent Child Browse (P03B151) after upgrading to 9.0?
 Question 10: Why is the Last Invoice Date not updating for some customers in P03B218, even though these customers have been invoiced and have made payments since the last date reflected?
 Question 11: After we ran Credit Analysis Refresh (R03B525), the Account Balance Inquiry (P03B218) shows two records for the same customer, one for company 00000 and one for company xxx. The amounts and balances are correct and the same. Why does P03B218 show two records for the same customer?
References

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