Balance Accumulation Report

The Balance Accumulation report displays these fields:

Field or Control Description

Bal Accum ID (balance accumulation ID)

You can calculate cumulative balances for a nearly unlimited set of key combinations in PeopleSoft Billing. Each balance accumulation ID represents a set of accumulation rules, which you establish on the Accumulation Description page.

Start Date

Date on which you defined this accumulation to begin.

Key

Display all of the fields to which you have defined this accumulation to pertain. Every key that you add after the first functions to increase the level of detail that you retrieve. For example, if you accumulate by customer, you get a total for each customer. If you accumulate by customer and order number, you receive subtotals for each combination of customer and order number, which significantly increases the number of rows in the database. In the example, this accumulation updates bill-to customer balances. On the Accumulation Description page, you can define the keys from a list that includes most of the informational fields that are found in the bill header and bill line tables.

Amount

Display the amounts that you want to maintain and for which you want to balance. Balances are maintained for invoiced bills, uninvoiced bills, and total (invoiced plus uninvoiced). In the example, this accumulation updates cumulative balances for quantity (because you selected Accumulate Quantity), gross extended amount, and net extended amount.

Accum Qty (accumulation quantity)

Quantities that you define for accumulation.

Related Topics