Setting line item calculation order

You can use the Define Calc Order button on the Line Items tab of the Update Bill Type Setup dialog box to set the order in which Infor Public Sector calculates the values of a bill type's line items. Line item values are calculated in ascending order.

Note: A line item's value is not the amount for which the customer is billed, but the value that Infor Public Sector sends to the line item's rate table to calculate the final billed amount.

Set a calculation order to use data associated with one line item to calculate the value of another one. Specifically, you can access the services that have already been processed in a bill run for use in line item value formulas.

For example, use the total billable usage for a water service to calculate the value of a drought surcharge line item, which is separate from the water line item. In that case you can assign the water line item a lower calculation order than the drought line item, so the water service is processed first in a bill run.

The processed water service will then be available for use in the drought line item's value formula. When working in the Formula Editor, you can find the processed services under oAccount.BillRunContext.ProcessedServices.

You can also use a discount or surcharge to calculate one line item based on the amount of another one. Setting the calculation order applies specifically to cases where you want to use the service associated with one line item to calculate the value of another one.