Refresh bills

Updates account balances and mail to information for an existing batch of bills. Refreshing balances is an automatic process, done after bills are posted. Mailing information can be refreshed from the Bill Run InfoViewer.

Invocation

To refresh bill mailing information, select the Refresh Mail To Info check box in the Bill Run InfoViewer and then click Generate. Balances are refreshed when bills are posted.

Monitoring

If the Refresh Bills stage is successful, you can expect to see a series of messages similar to these in the Bill Run log:

  • Updating Bill Mail To...
  • Updating Account Balances...
  • Updating Bill Balances from Bill Batch [#] using Date Time: [date/time]
  • Successfully updated [#] Bill Balances ([#} of [#])
  • Inserting Payment Transactions...

In the BILLRUN the REFRESHBILLBALANCESFLAG column will be set to Y if you’re refreshing balances, and the REFRESHBILLMAILTOINFOFLAG will be set to Y if you’re refreshing mailing information. Each flag is set back to N when the stage is complete.

Refreshing balances will also add a record to the BILLRUNACTIVITY table with ACTIVITYTYPE = 2 (RefreshBillBalances), and refreshing mailing information will add a record with ACTIVITYTYPE = 3 (RefreshBillMailToInfo).

Data output

This table lists the database tables in which this stage adds or updates records:

TableCommentsReview
BILLING.BILLStores the updated balances and mailing information.Bill InfoViewer