Calculation of Prorated Adjustments

The application uses a stored prorated invoice adjustment table which enables online prorating of adjustments against all standard transactions at or below adjustment level. This also enables prorated adjustments to create records in a separate table from original invoice transactions and non prorated adjustments. Calculations are done real time to disburse the adjustment amount in proper proportions to each of the detail lines viewed, for invoice and revenue amounts, excluding tax or billing amounts for ceilings. If the contract is set to prorate, when invoices are viewed in any of the Invoice Edit forms (BR20.x), the prorated invoice adjustment table is used to determine the level of adjustment done, including the amount adjusted. The prorated adjustments also fluctuate depending on what has been modified in the invoice. Use Invoice Adjustment Maintenance (BR49.1) to view all Invoice Edit Contract (BR20.1) adjustments and to delete unreleased invoices.

Note: Pro-rating will not be done against retainers, retention, fees, milestones, or ceiling overages. These are all types of records that do not display on lines in BR20.

Absolute value is used for the calculations to enable billing adjustments to be done against invoice lines that total up to zero on a screen line in BR20.1 where the adjustment is being done.