Anchor
| Table of Contents | ||
|---|---|---|
|
Step 1: Complete the Job Import worksheet using the guidelines below
...
The Job Cost Import Log summarizes all the cost code information that was successfully and unsuccessfully imported into Job Cost, including cost code subtotal amounts. This detailed information is useful when there are multiple worksheet entries for the same cost code.
Adding more fields for a custom spreadsheet
You can create a custom spreadsheet by populating the Job Import worksheet with additional fields for importing in Job Cost. You may want to make a copy of the default Signature Job Import.xlsm spreadsheet to customize.
| Note |
|---|
These additional fields cannot be validated. Make sure valid values are entered before importing. |
- Open the custom spreadsheet.
- If macros have been disabled, enable content for the spreadsheet.
- Select the Job Import worksheet.
- Scroll down to locate row #59, which contains the headings for fields in the Cost Codes & Estimates section. This is where you can add more fields.
- Select column I, which is the blank column immediately after the Estimate Measure column. You can add fields beginning with column I.
The labels for these columns must match exactly what is shown in the right column of the table below; otherwise, data entered into those fields will not be imported. Pay close attention to capitalization.
...
WS_Manager_ID
...
ManagerID
...
WS_Inactive
...
Inactive
...
Profit_Type_Number
...
ProfitTypeNumber
...
Profit_Amount
...
ProfitAmount
...
Next_Subdivision_Type
...
NextSubdivisionType
...
WS_Account_Index_2
...
AccountIndex2
...
Track_Production_Qty
...
TrackProductionQty
...
Production_Estimate_Qty
...
ProductionEstQty
...
Production_Actual_Qty
...
ProductionActualQty
...
Production_Qty_Curr_Per
...
ProductionQtyCurrPer
...
Production_Best
...
ProductBest
...
Production_Best_Date
...
ProductionBestDate
...
Production_Measure_Code
...
ProductionMeasureCode
...
Bill_Type
...
BillType
...
Sched_Completion_Date
...
ScheduleCompletionDate
...
ACTCOMPDATE
...
ActualCompletionDate
...
Schedule_Start_Date
...
ScheduleStartDate
...
ACTSTARTDATE
...
ActualStartDate
...
Billing_Schedule_Line
...
BillingScheduleLine
...
WRKRCOMP
...
WorkComplete
...
Labor_Group_Name
...
LaborGroupName
...
User_Define_1
...
UserDefine1
...
User_Define_2
...
UserDefine2
...
USERDEF1
...
USERDEF1
...
USERDEF2
...
USERDEF2
...
User_Def_Integer_1
...
UserDefInteger1
...
User_Def_Integer_2
...
UserDefInteger2
...
User_Defined_Integer_3
...
UserDefInteger3
...
User_Defined_Integer_4
...
UserDefInteger4
...
User_Defined_Dollar_1
...
UserDefDollar1
...
User_Defined_Dollar_2
...
UserDefDollar2
...
User_Defined_Dollar_3
...
UserDefDollar3
...
User_Defined_Dollar_4
...
UserDefDollar4
...
USRDAT01
...
UserDefDate1
...
USRDAT02
...
UserDefDate2
...
User_Defined_Date_3
...
UserDefDate3
...
User_Defined_Date_4
...
UserDefDate4
...
User-Defined_CB_1
...
UserDefCheckBox1
...
User-Defined_CB_2
...
UserDefCheckBox2
...
User-Defined_CB_3
...
UserDefCheckBox3
...
User_Defined_CB_4
...
UserDefCheckBox4
...
VNDRNMBR
...
VendorID
...
ITEMNMBR
...
ItemNum
...
PORDMNMR
...
| Scroll ignore |
|---|
See also: |