Special Processing in the Calculated Grid Columns

The system displays a line for each related order record that has either a sales order, work order, or purchase order. 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 for sales order and work order in the grid amount columns. Purchase order in rental contracts are used only for tracking and reporting purpose, and are not linked to amounts. Hence, the purchase order lines in the grid do not have values for cost and revenue.

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 Related Order 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.

• 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.