Skip to main content

How is the Cost field in the ActivityJobItems table Calculated?

The Cost field in the ActivityJobItems table is a read-only field.

Updated over a year ago

The ActivityJobItems table is a table used in the Work Orders and Field Crew apps. Just like a transaction has a table to hold line items, a work order uses the ActivityJobItems table to hold line items.

This table has a Cost field that cannot be manually updated. It is a calculated field which uses other fields within the ActivityJobItems table.

How the Cost field is calculated

The calculation differs depending on the type of item:

  • For Service items:

    • Cost = CostPer & ActManHrs

  • For other item types:

    • Cast = CostPer * Qty

Did this answer your question?