Understanding Account Balance Information

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 F03B15 table 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 these fields:

  • Amount Past Due

  • Unapplied Amount

  • Future Due

  • Credits Entered

When reviewing account balance information, the system displays the account's status as of the last time you ran Credit Analysis Refresh, 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.