Job Cost Category Viewer


Create and maintain the Cost Category records required to describe expenses and labor for job costing purposes. May also be used to assign Worker's Comp Category for hours entered for this Category.


Job Cost Category records are not job-specific. They are required for the Job Journal, Payroll Journal, and Labor Journal, and for Job Costing entries in the Inventory Journal. They determine how your reports will break out.

Cost Categories are referenced in the Other Rate records. The Cost Type will drive the behavior of the Rate Schedule. A Cost Type of Material will look to the Material Markup; whereas, a Cost Type of Other will look to the Other Rate Table.

Special Find Data Ranges / Indices:

GL Account Id: - GL Account Type Id:
These range is sensitive to the Index selected:

When JobCostCategorybyGLExpenseAccountById is selected, the Cost Category's GL Expense Account (or the Account Type Id it references) will be filtered on.

When JobCostCategorybyGLIncomeAccountById is selected, the Cost Category's GL Income Account (or the Account Type Id it references) will be filtered on.

When one of the other Indices is selected, the system will filter for a match using both the GL Income and GL Expense Account.


Assembly, Supervision, Expenses, Maintenance, etc.

Important Fields: Upper Section

Job Cost Category Id: (15 character, only . and - special characters)
Uniquely identifies this record.

Job Cost Category Description: (40 character)
Briefly describes this record. Recommended but not required.

Cost Category Group
This optional field has been added to support future reporting needs.

Posting Cost Type: Labor - Material - Subcontract - Other
This category will be used by the system for posting purposes. Select the option (Labor, Material, Subcontract or Other) that best describes this cost category by double-clicking on its radio button (or pressing the spacebar when the focus is on the option). The Selection Cost Type field determines where this Cost Category will be available.

Posting Cost Type Changes: The user will be warned when the Posting Type is changed in Cost Categories having Job History. Note that edits made to work order detail lines AFTER a change has been made to the Posting Type of the a Cost Category. From this point onward, changes made in the WO viewer to be updated into the JCH using the original Cost Type.  For example, if a cost type was changed from Material to Other, the changed amounts continue to be classified as Other.

Selection Cost Type: Labor - Material - Subcontract - Other  - Equipment
In most journals, the Cost Categories that you may select (by double-clicking on this field or entering a valid id) are limited to those referencing the ‘appropriate’ cost type: labor in the Labor Journal, material on the Inventory tab of the Work Order, and so on. This field controls which Cost Categories may be selected, while the Post Cost Type field above controls the actual posting behavior.

The Selection Cost Type of Equipment should be reserved for Job Cost Categories that are used to charge company equipment (Assets) to jobs to enable proper tracking of costs and reporting. The Posting Cost Type of Other should be chosen when the Selection Cost Type of Equipment is selected.

Generally the Posting and Selection Cost Type fields will remain the same. However, the Selection Cost Type would be set to a different value if, for example you would want a Cost Category with a Posting Type of "Other" to be made available for "selection" in areas that would normally post to Labor (Labor Journal, WO Labor Tab, Job Journal Labor tab).

Job Use: All Direct Indirect
The default value of All preserves the existing validation behavior which means there are no restrictions on the combinations. Direct and Indirect (Overhead) are used to indicate the type of jobs that can be used with records having this attribute.

The following viewers are affected by this functionality, and will not allow records with the Job Use field set to Direct to be used with Indirect (Overhead) Jobs. Likewise, Direct Jobs (Overhead flag not checked) may not be used with Cost Categories flagged as Indirect.

AP Journal   Recurring AP Journal
Sales Journal   Cash Receipts Journal
Site Equipment  Employee
Inventory Adjustment Jrnl  Job
Job Journal  Labor Journal
Master Contract  Purchase Order
Quote   Shop Order
Work Order  Work Order Entry
Quote viewer   Flat Rate viewer - Job Use in Cost Category must be All or Direct

GL Income Account
If this field is completed it will supersede the default income account found in the cost code when automated invoicing posts lines to the Sales Journal. If this field is blank, the default income account in the cost code will be used.

GL Expense Account
This field will be used when creating PO's to provide a default expense account. The system will first look for the default GL expense account in the Cost Category (if present), then in the Vendor if no account is specified in the Cost Category.

For cost types of Labor this expense account is only used in Job EOM processing.  If you accrue labor to GL (as specified in the Payroll Period), the GL expense account used for cost types of Labor is determined by the Pay Type or Earnings ID depending on your configuration.

See Inventory Group Viewer for details on usage when Inventory WO to GL is turned on (as specified in the Accounting Period Viewer ).

This field also provides the default GL Debit Account for Work Order Other lines if the Accounting Period option Work Order Other to GL is flagged.

This field is also in conjunction with the Create EOM Unvouchered AP GL Entries function.

Default Labor Rate:
This field should be completed if you want to replace what defaults from the employee record when a given cost category is selected within the Remote Time Applet or Labor Journal. It will also be used to override the labor rate from the Technician record when entering time in the Work Order Labor tab.

Job Cost Category User1:  Job Cost Category User2: (30 character x 2)
These optional fields may be used to record additional information.

Job Cost Category User3-5:
These fields are designed for use with web-based PO processing if implemented on your system.

Avalara Tax Code:
This field is reserved for future use.

If this field is checked, the record is considered Obsolete, and it may not be directly specified during data-entry (either by entering the Id or selecting it from a list). Obsoleted records can be edited and the Obsolete option can be un-done when necessary. When you check the Obsolete field, the following message box will be displayed:

“You have elected to obsolete this record. Would you like to see existing references to this record?”

If you click Yes, the system will display a viewer that provides click-through access to all tables referencing this record: see References List for details.

Important Fields: Lower Section

Worker’s Comp

The Worker's Comp Category normally defaults from the employee when recording hours...but is replaced if designated in this tab so that different tasks can lead to different category assessments for Field hours. Registry options are needed to also apply this methodology to Office hours.

WC Category:
Enter the Worker’s Comp Category that should override the default value in the Employee record. If you maintain Worker’s Comp Categories for multiple states, a line should be entered for each state. The system will use the state field to determine which Workers Comp category to use for each journal entry.

Discipline Id:
This field supports multiple Worker's Comp Categories per Worker's Comp State. When Field time is entered, the system uses the entries on this tab to determine the correct WC Category using the state (from the Job record) and the Discipline (from the Job Cost Code record). It this field is NOT completed, only a single Worker's Comp Category per state is supported.