Post bills

Posts bills to accounts by either updating or inserting account transactions and deposit for all charges generated in the bill run. Any bill message are also added during this stage.

Invocation

You can post bills when you create a new bill run by selecting the Post Bills check box in the Batch Manager form, the Billing Calendar, or the Create Bill Run form.

To post bills from the console application, use the PostBills parameter. For example, to post bills for a new bill run right after the bills are calculated, you would use this command:

Hansen.Core.BatchManager.Console.exe -n:BillRun -p PostBills=True

To post bills for an existing bill run from the console, use the --reinvoke command, as in the example below:

Hansen.Core.BatchManager.Console.exe -n:BillRun --reinvoke -p PostBills=True

To post bills from the Bill Run InfoViewer, select the Post Bills check box and click Generate.

Monitoring

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

  • Updating bills for batch [#] using Posted Date Time: [date/time]
  • Successfully updated [#] bill posted flag(s).
  • Updating Account Transactions...
  • Successfully updated [#] Account Transaction(s).
  • Inserting service transactions for batch [#] using Tran Date Time: [date/time]
  • Successfully inserted [#] account service transactions.
  • Inserting Surcharges...
  • Successfully inserted [#} surcharge(s).
  • Inserting Discounts...
  • Successfully inserted [#] discount(s).
  • Resetting preselected flags...
  • Successfully reset [#] preselected account flag(s).
  • Updating Account Credit Flag...
  • Successfully updated [#] account credit flag(s).
  • Successfully saved [#] bill message(s).

In the BILLRUN table, the POSTINGFLAG column is set to Y while this stage is running. If the Post Bills stage is run separately from the Calculate Bills stage, the WASSECONDSTPPOSTED column is set to Y as well. When the stage is finished, the POSTINGFLAG is set back to N, and the POSTEDFLAG column is set to Y.

This stage also adds a BILLRUNACTIVITY record with ACTIVITYTYPE = 5 (PostBills), and another record with ACTIVITYTYPE = 7 (FinalizeAccounts).

Data output

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

TableCommentsReview
BILLING.ACCOUNTIf accounts were pre-selected for the bill run, sets the PRESELECTEDFORBILLRUN column to N. For accounts receiving their final bills, sets the FINALBILLFLAG column to Y.Manage Account page
BILLING.ACCTTRANInserts or updates account transactions for all charges generated in the bill run.Transaction InfoViewer
BILLING.BILLSets the POSTEDFLAG column for each bill to Y.Bill InfoViewer
BILLING. BILLMESSAGESStores messages for bills in the run.Bill InfoViewer
BILLING.DEPTRANInserts or updates transactions for all deposit charges generated in the bill run.Deposit Transaction InfoViewer