SubJob Creation Wizard

Additional SubJobs can be created from the SubJob Tab of the Job by using the Add SubJob button.

With Job versions 9.03.280 / 10.0.110, a new option, Import SubJobs, has been added to the ‘You Can Also’ button.  Selecting Import SubJobs will open the SubJob Import Wizard.

1. Import Settings.

Line Exchange Rate

• Import Exchange Rate from File – indicates that the exchange rates will be provided in the import file
• Use Current Exchange Rate from Define Exchange Rate Table – this option will use the exchange rate that is currently set in SAP

Cost Center Handling

• Copy Missing Cost Centers from Job – if Cost Centers are not supplied (or found for Material type lines), this option will copy any cost centers defined on the Job to the Sub Jobs being imported

Once settings are chosen, click on the Next button and you will be presented with the Choose Import File page.

 2. Choose Import File

Once you choose an import file, the file will be parsed. Each line will be displayed in the grid with any Errors that were encountered while parsing and/or filling in missing data.

Refer to the Import File Format section below for the specifications for the import file.

If the previous step resulted in no Errors, the Next button will be enabled. Clicking Next will present you with the Select SubJobs to Import page.

3. Select SubJobs to Import

On this page there are 2 grids; SubJobs and Quote Lines. The SubJobs grid allows you to pick and choose which SubJobs to import. The Quote Lines grid shows all Quote Lines from all selected SubJobs. To review an individual SubJob, click on the SubJob line to select it. Then the Quote Lines grid will only show Quote Lines for the selected SubJob. There is a Select All checkbox to select all SubJobs after reviewing.

Once you click Next on this page, the new SubJobs will be created and a results page will be displayed.

Import File Format

The import file is a comma separated file.  The first 2 rows of the file are mandatory and define the columns to be imported.

• The first row is the SubJob Header row.
  • This row must have IMPORTTYPE included.
  • This row can contain column names for internal use, but these cannot be named the same as columns from the ENPRISE_JOBCOST_SUBJOB table
  • This row can contain column names from the ENPRISE_JOBCOST_SUBJOB table. It must include JOBTITLE
• The second row is the Quote Line Header row
  • This row must have IMPORTTYPE included
  • This row can contain column names for internal use, but these cannot be named the same as columns from the ENPRISE_JOBCOST_JOBLINES table
  • This row can contain column names from the ENPRISE_JOBCOST_ JOBLINES table. It must include QUOTELINETYPE and STOCKCODE
• Next comes the data rows. They are grouped with a SubJob row starting each group. Each group can have any number of Text Lines and Quote Lines in any order. The Text and Quote Lines are optional if you are simply importing SubJobs, however you still must have the Quote Line Header row included.
• SubJob rows must have
  • IMPORTTYPE set to S
  • JOBTITLE
• Quote Line rows must have
  • IMPORTTYPE set to Q
  • QUOTELINETYPE set to (M, S or R)
  • Valid STOCKCODE
• Text Line rows must have
  • IMPORTTYPE set to T
  • The last column (if there are more than 2 columns) set to the text value
• Dates must be in yyyy-mm-dd format
• NULL is not an allowed value. It will be interpreted literally. Just omit the value ie. value1,,value3

Import File Examples

Example 1 (Minimum information)

IMPORTTYPE,JOBTITLE

IMPORTTYPE,QUOTELINETYPE,STOCKCODE

S,SubJob title a

Q,M,A00001

S,SubJob title b

S,SubJob title c

Q,M,A00002

Example 2 (Includes some pricing and UDFs)

IMPORTTYPE,JOBTITLE,STATUS,JOBTYPE,CATEGORY,DESCRIPTION,QUOTEDATE,STARTDATE,ENDDATE,DUEDATE,U_CustInfo

IMPORTTYPE,QUOTELINETYPE,TRANSDATE,STOCKCODE,DESCRIPTION,QTY,AVECOST,ORIGSELLPR,LINEDISCOUNT,SELLPR,NONCHARGEABLE,VENDORCODE,U_CUST_TEXT

S,SubJob title a, 2, 2, 2,,2020-04-27,,,,"Customer information,and some else"

T,This is a text line at the start

Q,M,2020-04-27,A00001,IBM Infoprint 1312 test,1,132.00,700.00,10.00,630.00,N,V10000,Custom text

Q,M,2020-04-27,A00001,IBM Infoprint 1312 test,1,132.00,700.00,10.00,630.00,N,V10000,Custom text

T,random data,This is a text line at the end

S,SubJob title b, 2, 2, 2,,2020-04-27,,,,Customer information

S,SubJob title c, 2, 2, 2,,2020-04-27,,,,Customer information

Q,M,2020-04-27,A00001,IBM Infoprint 1312 test,1,132.00,700.00,10.00,630.00,N,V10000,Custom text

S,SubJob title d, 2, 2, 2,,2020-04-27,,,,Customer information

ENPRISE_JOBCOST_SUBJOB columns (Mandatory columns in bold) (Filled from Job if not supplied)         

ENPRISE_JOBCOST_JOBLINES columns (Mandatory columns in bold)