You are here
Home > Accounts Receivable > Managing Credit and Collection Information > Reviewing Account Balance Information

Reviewing Account Balance Information

Reviewing Account Balance Information

Concept

When managing customer accounts for collection purposes, you can quickly access and review various types of accounts receivable information that facilitate decision making and customer analysis. For example, you might want to review the open balance of a customer’s account as of a certain date, or the amount of the customer’s balance that is past due.

 

When you run the Credit Analysis Refresh program (R03B525), the system updates account information in the Credit and Cash Management table (F03B15) and displays the records by customer and company on the Account Balance Inquiry form. The system displays account information in order by company. The record for company 00000 represents the total of all other company records.

 

The system calculates the open amount by adding the amounts in the Amount Past Due, Unapplied Amount, Future Due, and Credits Entered fields.

 

When reviewing account balance information, the system displays the account’s status as of the last time you ran R03B525 program, but you can also enter a specific date for the system to recalculate aging information for online display. For example, you can specify today’s date to review account information as current as today.

Procedure

In this task, you will review the status of a customer’s account balance and recalculate aging information.

Step Action
Navigate to the Account Balance Inquiry program (P03B218) on the Credit/Collections Management menu (G03B15).

Click the Credit/Collections Management menu.

Click the Account Balance Inquiry menu.

Use the Account Balance Inquiry form to review account information.

Step Action
Click in the Customer Number field.

Enter the desired information into the Customer Number field. Enter “970170“.

To limit your display to parent records only, turn on the Parent option. When using the Parent option, you can view the child accounts summarized and displayed with the parent record.

The Account Balance Inquiry form shows parent/child information for one generation. Use Parent/Child Balance Inquiry program (P03B151) to view multiple generations of parent/child relationships.

Use the View Accounts options to specify whether to limit the display of accounts to those for which you have entered a promise message (Worked) or those for which you have not entered a promise message (Unworked).
Click the Find button.

The system displays a record for each company for which the customer has invoices entered, as well as a summary record for company 00000, which reflects the total of all companies. The system displays amounts for non-zero companies in the currency assigned to the company record. The system displays amounts for company 00000 in the currency assigned to the customer record in the A/B Amounts Code field (CRCA).
Review the Amount Past Due and the Open Amount fields.
Click the Row menu.

Click the Real Time Aging menu.

Use the Real Time Aging form to review account information as of a specific date.

Step Action
Click in the Age as of Date field.

Enter the desired information into the Age as of Date field. Enter “10132016“.

Click the Form button.

Click the Recalculate menu.

The system recalculates and displays aging information based on the date that you entered.
Note that if you click OK on the Real Time Aging form, the system displays the new aging information on the Account Balance Inquiry form, but does not update the Credit and Cash Management table (F03B15).
Click the Cancel button.

Step Action
Click the Close button.

You have successfully reviewed the status of a customer’s account balance and recalculated aging information.

End of Procedure.

Ayman Refat
Over 20 years of experience in IT area, working as Oracle JD Edwards Developer with expertise in Windows Server, SQL Server and Microsoft Exchange Server, experience in Linux operating systems (Debian and Redhat), VMWare ESX / ESXi, Novell Netware, relational databases like Oracle 10/11g and backup solutions from Computer Associates. Large experience in high-end servers from Dell and HP, having the following certifications: Microsoft: MCP, MCSE, MCDBA, MCSA and MCT (2008 ~ 2013), Computer Associates: Technical Specialist – Storage and Backup Solutions,
http://www.AymanRefat.com

Leave a Reply

Top