Special Processing in the Calculated Grid Columns

The system displays a line for each related order record that has either a sales order or a work order. Purchase orders and related order records that do not have a related order number are not included. The system retrieves and populates the related order cost and revenue in the grid amount columns. Below the related order lines for a contract, the system adds a line that contains the rental revenue and the calculated columns for total revenue, cost, and profit.

The system records information in the grid columns that is related to the special processing considerations in the header. These columns facilitate reporting over data that is not available in the database in a form easy to report on. The reports delivered with the application are possible because of these columns. You can also use them when defining custom reports.

The One View Rental Contract Profitability Inquiry application uses the following special processing in these calculated columns in the grid:

• Related Order Cost

  The total cost of related orders for a contract. For work order, the system retrieves the cost from the actual labor cost, actual material cost, and actual other cost fields from the Work Order Master File table (F4801). For sales order, the system retrieves the cost using the quantity and unit price from the Sales Order Detail table (F4211) when the billing Method is 3 (one-off sales order billing). When the billing method is 1 (recurring contract billing) or 2 (one-off contract billing), the system retrieves the cost for the sales order from the Rental Contract Detail table (F54R11).

• Related Order Revenue

  This is the revenue amount for the contract from sales order or service order billing. For sales order, the system derives the revenue amount using the quantity, unit price 2, and extended amount fields from the Sales Order Detail table (F4211) when the billing Method is 3 (one-off sales order billing). For work order, the system retrieves the revenue amount from the Billing Workfile - History table (F4812H) for billed work orders.

• Rental Revenue

  This is the revenue amount from rental billing. The system retrieves the rental billing revenue from the Billing Workfile - History table (F4812H).

• Total Revenue Amount

  This is the total revenue generated from related orders and rental revenue for a contract.

• Total Cost Amount

  This is the total cost from all related orders (work order and sales order) for a contract.

• Profit Amount

  The total profit generated for the contract. The system subtracts the total cost from the total revenue to calculate the total profit amount.

• As If Related Order Cost

  The related order cost converted to a common currency. The system uses the values in the As If Currency Code and the As Of Exchange Rate Date fields to convert the related order cost from domestic currency to a common currency.

• As If Related Order Revenue

  The related order revenue converted to a common currency. The system uses the values in the As If Currency Code and the As Of Exchange Rate Date fields to convert the related order revenue from domestic currency to a common currency.

• As If Rental Revenue

  The rental revenue converted to a common currency. The system uses the values in the As If Currency Code and the As Of Exchange Rate Date fields to convert the rental revenue from domestic currency to a common currency.

• As If Total Revenue Amount

  The total revenue converted to a common currency. The system uses the values in the As If Currency Code and the As Of Exchange Rate Date fields to convert the total revenue from domestic currency to a common currency.

• As If Total Cost Amount

  This is the total cost converted to a common currency. The system uses the values in the As If Currency Code and the As Of Exchange Rate Date fields to convert the total cost from domestic currency to a common currency.

• As If Profit Amount

  This is the total profit amount converted to a common currency. The system uses the values in the As If Currency Code and the As Of Exchange Rate Date fields to convert the total profit amount from domestic currency to a common currency.