How do I set up a spreadsheet Layout to view Job Cost information in Estimating? (SQL) (Supplemental Video)
Description

Cause
Resolution
Customize a layout to view Job Cost cost codes and categories

Customize the spreadsheet layout to show Job Cost cost codes and categories:

  1. From the Home menu, select Spreadsheet Layout.
  2. Click [Add], then type Job Cost Phase.
  3. In the Visible column, select all of the following columns:
    Note: Clear any columns not listed below.
    • Group
    • Phase
    • Item
    • Description
    • Labor Amount
    • Labor JC Phase
    • Labor JC Cat
    • Material Amount
    • Material JC Phase
    • Material JC Cat
    • Sub Amount
    • Sub JC Phase
    • Sub JC Cat
    • Equip Amount
    • Equip JC Phase
    • Equip JC Cat
    • Other Amount
    • Other JC Phase
    • Other JC Cat
    • Total Amount
    • Addon Amount
    • Grand Total
  4. In Locked Columns, type 4.
  5. Click [OK] twice.

Note: This video is an example of creating a spreadsheet layout. It has Text only, no audio

Steps to duplicate
Related Solutions

Getting Started: Sage 300 CRE Job Cost interface (SQL)