Standard Crystal Report - Work Order Detail Cost and Billing Report
- Claire Aleman
Issue/Symptom/Question
Standard Crystal Report - Work Order Detail Cost and Billing Report
Applies To
Penta for Windows
Standard Crystal Report - Work Order Detail Cost and Billing Report
Service Management Module
Resolution/Fix/Answer
Use this report to review the complete cost and billing history for a work order as well as the resulting gross profit. The billing section includes invoice level details and the cost section includes transaction details including:
- employees that performed work (including hours and rates)
- vendors from which purchases were made
- inventory products used
- equipment charged
The bottom of this report displays totals.
Report Code: sm_woDtlCostBill_p121_cr11.rpt
Available Parameters:
Example Report Results:
Fields
Work Order ID - ID of the Work Order the report is based on.
Description - The Work Order’s Description.
Labor Transaction Fields
Work Date - The labor transaction’s posting date.
Cost Type - The transaction’s labor Cost Type.
Employee ID - ID of the employee servicing the Work Order.
Name - Name of the Employee servicing the Work Order.
Classification - The description of the Employee’s Payroll Class.
Hour Type - Hour Type associated with the time worked (e.g., Regular, Premium1, Premium 2).
Hours - The number of service hours worked by the Employee.
Rate - Pay Rate of the Employee for the work performed.
Amount - The total cost of the services performed (i.e., Hours * Rate).
Other Pay - Other pay for the Employee associated with this Work Order transaction.
Reimbursement - Any reimbursement to the Employee associated with this Work Order transaction.
Fringes - Any fringes associated with this Work Order transaction.
Overhead & Burden - Any overhead and burden associated with this Work Order transaction.
Total - The total cost of the labor transaction, calculated as: Amount + Other Pay+ Reimbursements + Overhead & Burden.
Purchase Transaction Fields
Vendor ID - ID of the vendor from which goods were purchased.
Cost Type - The Cost Type assigned to the transaction.
Name - The Vendor’s name.
Product ID - ID of the product purchased from the Vendor.
Description - Description of the Product purchased for the Work Order.
PO Number - The Purchase Order Number of each purchase transaction.
PO Line # - The Purchase Order Line Number of each purchase transaction.
Date - Issue Date of the Purchase Order.
Quantity - The quantity of products purchased.
Unit Price - The price per unit of the Product being purchased.
Sales Tax - The amount of sales tax calculated on the Purchase Order.
Total - The total cost of the purchase transaction on the Purchase Order.
Invoice # - The vendor’s invoice number.
Date - The invoice date.
Amount - The total invoiced amount for the purchase transaction.
Sales Tax - The amount of sales tax on the Accounts Payable Invoice.
Total - The total invoiced amount for each purchase transaction.
Inventory Transaction Fields
Trans Date - The Inventory Transaction date.
Cost Type - The transaction’s Cost Type.
Warehouse ID - The warehouse the product transferred from.
Product ID - ID of the transferred product.
Description - Description associated with the Product ID.
Quantity - The quantity of products transferred.
Unit of Measure - The product’s Unit of Measure.
Unit Cost - The per-unit cost of the product.
Extended Cost - This is the total of: Quantity * Unit Cost.
Pricing Factor - The Product’s Pricing Factor (e.g. price per hundred).
Sales Tax - The sales tax calculated on the transaction.
Total - The total cost of the inventory transaction including sales tax.
Equipment Transaction Fields
Trans Date - The Equipment Transaction date.
Cost Type - The cost type assigned to the transaction.
Fixed Asset ID - ID of the fixed asset being used.
Description - Description of the fixed asset.
Classification - The Asset Class the Asset is assigned to.
Unit of Measure - The unit of measure used to charge the Asset to the work order.
Quantity - The number of units (Days/Hours/Weeks) the Asset was used.
Rate - The charge rate associated with the Asset.
Amount - The total amount being charged to the work order, calculated as: Quantity * Rate
Total - The total Equipment Cost.
Other Cost Transaction Fields
Trans Date - The Cost Transaction date.
Cost Type - The transaction’s Cost Type.
Journal Entry # - The number assigned to this transaction’s journal entry.
OH Distribution Rule # - The Overhead Distribution Rule used to distribute overhead cost to the work order.
Total - The transaction’s Total cost.
Billing Fields
Trans Date - The invoice’s transaction date.
Invoice Number - Number of the customer invoice.
Billed Amount - The Amount billed on the Invoice.
Sales Tax - The total sales tax on the Invoice.
Total Billed - The sum of Billed amount + Sales tax.
Work Order Totals - This section shows the totals for the work order. The totals are:
total billed amounts with no tax,
total sales tax, total costs,
total billings with tax,
total gross profit amount, and
total gross profit %.
Refer to prior Field Definitions for explanation.