R48139 - Revenue Journal

In addition to running summarized G/L reports, you can use this report to review additional revenue details. The system uses data for this report from the following tables:

• Billing Workfile (F4812)

• Billing Workfile History (F4812H)

• Billing Detail Journal Workfile (F48S910)

• G/L Link file (F48S912)

When you run this report for contract billing, the system lists the details of revenue amounts that were previously recognized and those that are yet to be recognized for all contracts by a customer at the pay item level. The report totals the cumulative, prior, and current values by contract and change order, and also shows a total of all change orders at the contract level. At the end of the report, the system displays the total for all contracts in the report in the contract billing total.

When you run this report for service billing, the system lists the details of revenue amounts that were previously recognized and have yet to be recognized for all transactions by a customer at the account level. The report totals the cumulative, prior, and current values by customer and job number, and also shows a total of all jobs at the customer level. At the end of the report, the system displays the total for all service billing in the report in the service billing total.

When you run this report for both contract and service billing, the system lists the service billing information first and a service billing total, followed by the contract billing information and a contract billing total. At the end of the report, the system displays a grand total, which is the sum of both the contract and service billing totals.