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

Last updated on DECEMBER 01, 2022

Applies to:

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

Frequently Asked Questions regarding Account Balance Inquiry (P03B218)

	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

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?

Question 12: Why does the Over Credit Limit value on P03B218 grid show at the child level even when Credit Check Level is set at the parent level in the Billing Information screen on P03013?

Question 13: On the Account Status Summary form (P03B218, form W03B218C) what is the source for the values of the Contact, Phone Number, and Prefix fields?

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