Vans > Modules > Job Cost > Inquiries

The Job Cost Inquiry is used to display, print, and maintain Job Cost information for a specific order. A date range of detail to display can be specified. You can also display the information in summary or detail form.

Screens

Name	Description
Job Cost Inquiry	Displays all current lock transactions.
Add/Edit Transaction	Add a new transaction or edit an existing transaction.
Job Cost Listing	Generate a report of the displayed transactions.

Job Cost Inquiry

Jc.Inq.JobCost

Field Descriptions

Name

Description

Order Reference

Enter the order reference number (if known) to display an order. You can also enter a partial key (starts with) and press the lookup button to find all orders starting with that partial key.

BTN_LookupExactOptions

The default lookup sorts the orders by Reference Number, to change the lookup method, position the mouse over the icon and press the right mouse button. A window will be displayed showing the available lookup options (Reference Number, Order Number, Shipper Name or Customer Reference) with a check mark next to the current option. Click on the desired option to change the lookup method.

Order Information

This section is display only and contains general order information.

Order#

The order# assigned to this order.

Cust

The customer number and customer name assigned to this order.

Address 1

The first order address (origin) line.

Address 2

The second order address line (origin).

City

The origin city.

State

The origin state.

Zip Code

The origin zip code.

Customer Ref

The customer reference number (if any) assigned to the order

Branch

The branch assigned to the order.

Authority

The authority (M for local, V for van line) for this order.

Origin Phone/Contact

The origin phone# and contact name.

Destination Phone/Contact

The destination phone# and contact name.

Customer Phone/Contact

The customer phone# and contact name.

Job Cost Details

Begin Date

Enter the earliest date to appear in the detail grid.

End Date

Enter the latest date to appear in the detail grid.

Detail/Summary

The summary version combines all major detail types (1-9) and displays them as a single line with the exception of payroll types (3 and 4). These types include a single line for each class code. The detail version displays each line individually.

Total Revenue

The total of all revenue displayed.

Total Cost

The total of all costs displayed.

Profit Amount

The total profit (Revenue-Cost) displayed.

Profit Percent

The profit percent (profit / total revenue)

Detail Grid

You can right-click on items in the grid and select Insert, Delete or Edit. Delete and Edit will only be available if an existing non-blank row is selected.

Type

This is the type of the transaction. It can be 0-9 and represents the following:

Type	Description
0 - Header	There is one of these for each order and shows the order date, customer and shipper
1 - Revenue	All booked revenue will appear under this type
2 - Material or Revenue Overhead	This is created only if the revenue code has an overhead percentage defined.
3 - Labor Cost	All payroll transactions that have a job number entered wil have this type of job cost transaction.
4 - Labor Overhead	All payroll transactions for a job class/order type that have an overhead percentage defined will create this type of transaction.
5 - Driver Costs	If a driver amount was entered when the revenue was booked it will appear under this type.
6 - 3rd Party Vendor Costs	A/P invoices processed for orders will appear with this type.
7 - Sales Commission Costs	Any sales commissions paid and approved on a month-end sales report will appear as this type.
8 - Undefined
9 - Miscellaneous User Entered Costs	Any costs manually added to the job cost for this order.

Detail Type

What this column represents varies depending on the type of transaction as shown below:

Type	Detail Type Contains
0 - Header	Order Type
1 - Revenue	Sales Column
2 - Material or Revenue Overhead	Sales Column
3 - Labor Cost	Labor Class Code
4 - Labor Overhead	Labor Class Code
5 - Driver Costs	Driver Column
6 - 3rd Party Vendor Costs	Cost Type from A/P
7 - Sales Commission Costs	Sales Column
8 - Undefined	Undefined
9 - Miscellaneous User Entered Costs	User Defined

Date

The date of this transaction

Code/Reference

What this column represents varies depending on the type of transaction as shown below:

Type	Detail Type Contains
0 - Header	National Account or Customer Code
1 - Revenue	Moving/Service Code
2 - Material or Revenue Overhead	Moving/Service Code
3 - Labor Cost	Pay Type Description
4 - Labor Overhead	Pay Type Description
5 - Driver Costs	Driver Number
6 - 3rd Party Vendor Costs	Vendor Number
7 - Sales Commission Costs	Salesperson Number
8 - Undefined	Undefined
9 - Miscellaneous User Entered Costs	User Defined

Description

What this column represents varies depending on the type of transaction as shown below:

Type	Detail Type Contains
0 - Header	Shipper Name
1 - Revenue	Revenue Description
2 - Material or Revenue Overhead	Revenue Description
3 - Labor Cost	Pay Description
4 - Labor Overhead	Pay Description
5 - Driver Costs	Driver Name
6 - 3rd Party Vendor Costs	Vendor Name
7 - Sales Commission Costs	Salesperson Name
8 - Undefined	Undefined
9 - Miscellaneous User Entered Costs	User Defined

Pre-Discount Revenue

If this is a revenue transaction (1 or 9 if entered) and a pre-discount revenue amount exists, it will appear here.

Revenue

If this is a revenue transaction (1 or 9 if entered) then the net revenue posted will be displayed.

Cost

If this is a cost type (2-7 or 9 if entered) then this will contain the cost amount.

Add/Edit Transaction

Jc.Inq.JobCost.Edit

If you double-click on an existing line in the grid, then you will be able to manually edit the transaction and change values as necessary. If you double-click on the blank row at the bottom of the grid to add new records.

Job Cost Listing

If you select the print button BTN_Print in the toolbar the screen below will open and generate a report of the displayed transactions.

Jc.Inq.JobCost.Listing

Jc.Inq.JobCost.ListingOutput