Unit Price and Lump Sum Billing Lines

When you enter or modify lump sum or unit billing lines, you can enter a wild card (*) in the first position of the Subledger field to indicate that all values are valid. When you do so, verify that the Subledger Type field is blank. When you run the Invoice Generation or Revenue Generation Workfile batch programs the system generates a single workfile record for every unique subledger and subledger type value when the F0911 transactions that are cross referenced to a lump sum or unit billing line have a wild card in the subledger field.

Depending on the subledger values in the Contract Billing Line Detail and the Cross-Reference Accounts tables for unit price and lump sum billing lines, the system creates either multiple workfile records (a single record for every unique value of subledger and subledger type) or a single workfile record in the Billing Workfile for each lump sum or unit price billing line on a contract. The system creates records for every period between the From Date and Thru Date.

When you run the Invoice Generation program, the system automatically summarizes the selected workfile transactions and stores the summarized records in the Invoice Summary Workfile. Depending on the subledger values in the Contract Billing Line Detail and the Cross-Reference Accounts tables for unit price and lump sum billing lines, the system creates either multiple workfile records (a single record for every unique value of subledger and subledger type) or a single workfile record in the workfile for each lump sum or unit price billing line on a contract. The system creates one summarized workfile record in the workfile for the last period.

When you need to revise a contract billing line for non-T& M and if it has only one workfile record associated with it, then you can modify the billing line details.

For unit price billing lines, if you modify the Unit Quantity field, the system updates the unit quantity in the Billing Workfile (F4812) table for the selected workfile record. The system also recalculates the units in the Invoice Summary Work File (F4822) table based on the value in the F4812 table.

For lump sum billing lines, if you modify the Stored Materials field and the Amount field, the system updates the new amount in the Invoice Total field in the F4812 table for the selected workfile record. The system also updates This Period field and the Accrual/Deferral field in the F4822 table for the selected workfile record.

If you modify the Stored Materials field but do not modify the Amount field, the system updates the new amount in the Invoiced Amount field in the F4812 table for the selected workfile record. The system also updates the Accrual/Deferral field in the F4822 table for the selected workfile record.

If a contract billing line for non-T & M has more than one workfile record associated with it, the system displays the Subledger Review selection on the Form menu. You cannot modify the billing line details from the Pay Item Billing Revisions form, except for tax information and retainage.