Understanding the Revenue Workfile Generation Program

If you did not create workfile transactions for lump sum, unit price, revenue-only, and fee billing lines when you generated the workfile, you must use the Revenue Workfile Generation program (R52120) to add these non-T and M revenue records to the workfile before you generate preliminary G/L journal entries for revenue recognition.

Note: As an alternative to running the Revenue Workfile Generation program independently, you can set up the processing options for the Workfile Generation program (R48120) to run the Revenue Workfile Generation program.

This table describes how the Revenue Workfile Generation program creates records in the Billing Detail Workfile table (F4812), based on the billing line type:

Billing Line Type	Records Created in the F4812 Table
Unit price and lump sum	One record for each billing line.
Percent complete, percent of billing, fee, and award fee	One record for each billing line with a zero amount.

System-calculated amounts are based on actual costs and projected final costs from the cross-referenced accounts on the lump sum billing lines. Fixed amounts are also calculated for the lump sum revenue amount regardless of the actual costs that are incurred. Revenue amounts for the lump sum billing lines are calculated using the percent complete method of calculation. For units, the system-calculated amounts are based on the AU (actual units) ledger in the Account Balances table (F0902) from the cross-referenced accounts on the billing line. The date range is specified in the processing options of the Revenue Workfile Generation program.

The Revenue Workfile Generation program produces a report that lists any errors that occurred during processing.