Understanding the Credit Analysis Refresh Program

To effectively analyze and manage account activity for a customer, you must first update the customer's account information. To do so, run the Credit Analysis Refresh program (R03B525) at the beginning or end of each business day. This ensures that the information that the system displays for the customer's account is current and helpful when you analyze the customer's account for credit and collection purposes.

When you run the Credit Analysis Refresh program, the system includes all the customers with an open balance (regardless of whether the balance is past due) in the Credit and Cash Management table (F03B15) and displays the balances on the Account Balance Inquiry form.

You must select a version of this program that has the processing option set to update the F03B15 table for the program to perform these functions:

  • Summarize all open invoice activity by customer account and company at both the parent and child levels, and write this information to the F03B15 table. You can then review this information on the Account Balance Inquiry or Parent/Child Browse form to determine the current status of an account.

  • Send a workflow message to the collection manager for accounts that require collection review by the collection manager. For example, the system can alert the collection manager when a delinquency fee is assessed on an overdue invoice or when a delinquency notice is generated for a customer.

  • Send a workflow message to the credit manager for accounts that require credit review. For example, the system might indicate that a customer has exceeded the credit limit or that a credit limit was changed.

  • Update the credit messages on the Credit tab of the Customer Master Revision form.

  • Update invoices eligible for external collections, as well as the Collection Report option on the customer record.

  • Update the temporary credit message on the customer record based on the policy.

  • Reset the temporary credit message to the value of the credit message based on the policy.

    Note: You must include Pay Status equals P in the data selection for the system to perform the reset function. Consider running a version of the program with this data selection once a week to reset temporary credit messages. The system does not display current invoice information in the Account Balance Inquiry or Parent/Child Balance Inquiry programs until you rerun the program with the data selection set to include open invoices.
  • Generate a workflow message to notify you that the process is complete.