Skip to main content
All CollectionsCustomizationCommon Customization ScenariosCustomization Scenarios
How is the Cost field in the ActivityJobItems table Calculated?
How is the Cost field in the ActivityJobItems table Calculated?

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

Updated over 8 months 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?