WIP Labor Import

Toolbar

Field	Description
Import	Validates the contents of the import file and import records if there are no errors.
Save Form Values	This option is only enabled in Design mode (see Automation Design). Your selections are saved and applied when the program is run in automated mode.

Options

Data source

Field	Description
Import method
From file	Indicates you want to import data from a file.
Use data grid	Indicates you want to enter data directly into the grid of the Details pane (you can paste the contents of an Excel spreadsheet into the grid).
File location
Server	Indicates the import file resides on the server.
Client	Indicates the import file resides on the client.
File name	Indicate the name of the import file (include the full path).
Review file	Loads the contents of the import file into the Details pane. This enables you to validate the lines on the grid prior to importing the file. The Import button is enabled only when all lines are valid.

Options

Field	Description
Import only if all rows are valid	When enabled, the entire import file must be valid before any records can be imported. The import aborts if any errors are encountered. When this is not enabled, valid records are imported and invalid records are ignored when the import is performed.
Batch validation required	Indicate whether you want to enter a total batch time to which your accumulated run and setup time entries must match.
Total time	Indicates the total batch time.
Posting year	Indicates the current year of your Work in Progress module.
Posting month	Indicates the current month of your Work in Progress module.
Change period	Select this to use the Change Posting Period program to indicate the month to which you want to post transactions. You can post transactions to the current or previous two months, providing that the access status of the month is set to open.

After processing completed

Field	Description
Print the Details	Generate a report of the contents of the Details entry grid.
Email the Details	Generate an email of the contents of the Details entry grid.
Print the Import Results	Generate a report of the contents of the Import Results pane.
Email the Import Results	Generate an email of the contents of the Import Results pane.
Email recipients	Indicates the email addresses of recipients to whom you want to email the information displayed in the output panes.
Delete file after use	Indicates whether you want to delete the import file after all records are successfully imported. In a client/server environment, both the import file on the server and the temporary import file created on the client are deleted.
Close the application	Exits the program once processing is complete. Do not select this if you want to be able to view the information on screen when processing is complete or you want to print or email the contents of the Details and Import Results panes.

Details

Toolbar

Field	Description
Validate	This verifies whether there are any errors in the grid, without actually importing records. Exclamation marks in the Validation status column indicates that one or more fields in the line are invalid. An explanatory error message is displayed when you hover your mouse pointer over the exclamation marks.
Print	Prints the contents of the import file, or changes made in the grid.
Export to Excel	Outputs data from the Details pane to an Excel spreadsheet.
Search text
Clear	Clears the contents in the search text field.
Edit
Copy	Copies the lines in the Details pane.
Paste (all columns)	Ensure that you have data for all the columns that can appear in the data grid before selecting this option. When you select to Paste (all columns) the date you are pasting must be in the format CCYYMMDD. Although no validation errors are displayed, the date is not converted into your SYSPRO date format.
Paste (visible columns only)	Pastes data into the columns that currently appear in the data grid, in the sequence that they appear. When you select to Paste (visible columns only) and the date you are pasting is not in CCYYMMDD format, you are prompted for the date format. The program correctly inserts it into the grid in the SYSPRO date format.
Duplicate	Copies the current row to the end of the data grid.
Find and Replace

Import Results

Displays a summary of the results of the validation/import.

This information can be printed or emailed providing you did not select to Close the application in the After processing completed section.

File layout for 7

Field	Start position	Field length and description
Header		;SYSPRO IMPORT - Version=001 - WIPP60 Mandatory entry of this comment on the first line of the import file to distinguish it from a SYSPRO 6.1 layout file. This comment is not case sensitive.
Line type	1	1 The first character of each line in the import file must be an `L` to indicate a labor posting file format.
Job	2	20 This can be alphanumeric or numeric, depending on the key type defined for jobs. This field can be blank. However, if an entry is made then it is validated, and you must make an entry at the Operation field. If left blank then the Operation field must also be blank and vice versa. If the Job field is left blank, then an entry must be made at the Non-productive field. You can enter a job for a notional part, but you cannot define scrap for a notional part.
Operation	22	5 The operation to which the posting must be made. This cannot be a dummy operation if the job is a hierarchical job and/or sequence checking is required for the job and not all operations are complete. If no operations exist then a dummy operation will not be created.
Work center	27	20 If blank, this defaults to the work center held against the operation. If importing non-productive time that is not directly linked to a job, then you must define a valid work center in this field.
Work center rate indicator	47	1 The work center rate to be used for the operation.
Employee	48	20 An entry is required if you indicated that employees must be validated during labor postings (WIP Setup) or the work center option: Use employee rates is selected (Browse on Work Centers).
Machine	68	30 If you indicated that machines must be validated during labor postings (WIP Setup) and the Machine field is blank, the system defaults to using the machine assigned to the operation.
Entry date	98	8 Use the date format: CCYYMMDD. If you do not make an entry at the Entry date field then this defaults to the current system date.
Run time	106	16 (8.6) If you do not make an entry at the Run time field then it defaults to zero.
Setup time	122	16 (8.6) If you do not make an entry at the Setup time field then it defaults to zero.
Startup time	138	16 (8.6) If you do not make an entry at the Startup time field then it defaults to zero.
Teardown time	154	16 (8.6) If you do not make an entry at the Teardown time field then it defaults to zero.
Non-productive code	170	10 This is the non-productive code (linked to a ledger code) to which the value of non-productive time must be apportioned. If you are posting non-productive time that is not directly linked to a job, then you must enter a valid work center in the Work center field.
Scrap reason	180	10 Can be blank Validated it an entry is made.
Quantity completed	190	20 (12.6) Can be blank.
Quantity scrapped	210	20 (12.6) Can be blank. Scrap cannot be defined against a job for a notional part.
Number of pieces	230	20 Can be blank.
Operation complete	250	1 Can be blank. If left blank, then the program establishes whether the operation is complete based on the run time issued against the run time required.
Payroll/Employee rate	251	1 An entry must be made at the Payroll/Employee rate field if the work center to which you are posting labor is configured to use employee rates.
Use the work center description held against the operation	252	1 If you enter Y at the Use work center description held against the operation field, then the work center description held against the operation is used for the posting. If you enter N (or blanks) then the default description held against the work center is used for the posting.
Head	253	10 Enter the head to which the dummy operation is linked, if you are importing labor for a dummy operation for a hierarchical job.
Section	263	10 If importing labor for a dummy operation or hierarchical job enter the 1st section (relative to the head) to which the dummy operation is linked.
Section	273	10 If importing labor for a dummy operation or hierarchical job enter the 2nd section (relative to the head) to which the dummy operation is linked.
Section	283	10 If importing labor for a dummy operation or hierarchical job enter the 3rd section (relative to the head) to which the dummy operation is linked.
Section	293	10 If importing labor for a dummy operation or hierarchical job enter the 4th section (relative to the head) to which the dummy operation is linked.
Reference	303	30 Optionally enter a reference for the labor import.
Notation	333	50 Optionally enter a notation for the labor import.

File layout for 6.1

Field	Start position	Field length and description
Line type	1	1 The first character of each line in the import file must be an `L` to indicate a labor posting file format.
Job	2	8
Operation	10	4
Work center	14	6
Work center rate indicator	20	1
Employee	21	6
Machine	27	6
Entry date	33	6
Run time	39	9 (5.2)
Setup time	48	9 (5.2)
Startup time	57	9 (5.2)
Teardown time	66	9 (5.2)
Non-productive code	75	2
Scrap reason	77	2
Quantity completed	79	12 (7.3)
Quantity scrapped	91	12 (7.3)
Number of pieces	103	8 (7)
Operation complete	111	1
Payroll/Employee rate	112	1
Use the work center description held against the operation	113	1
Head	114	3
Section	117	3
Section	120	3
Section	123	3
Section	126	3
Reference	129	9
Notation	138	30

Error messages

The following are possible error messages that can be listed when either listing or validating the import file:

Error Message	Description
First field not 'L'	The first character of the line to be imported does not begin with L.
Import file not found	The import file name, or path name specified, does not exist.
Illegal file name	The file name entered does not exist.
Job number is not numeric	If you defined the Job numbering as numeric (Company Maintenance - Key Types tab), then any import lines with alphanumeric job numbers will cause the import to be aborted.
Job is not on file	The import is only permitted if a valid job number is specified.
Job is on hold	The import is not allowed if the job number specified is on hold.
Job not confirmed	The import is not allowed if the specified job has not been confirmed.
Employee no. not numeric	This message is only displayed if a non-numeric employee number was specified in the import file, and you selected the option: Validate employee number during labor posting (WIP Setup - Labor Posting tab).
Invalid employee number	This message is only displayed if a non-existent employee number was specified in the import file, and you selected the option: Validate employee number during labor posting (WIP Setup - Labor Posting tab).
Employee not on file	This message is only displayed if a non-existent employee number was specified in the import file, and you selected the option: Validate employee number during labor posting (WIP Setup - Labor Posting tab).
No operations required
Job already complete - warning	The job to which you are posting is set to complete.
Invalid operation number	The operation number is not defined or does not exist.
Operation not on file	The operation does not exist.
Subcontract operation
Operation is complete - warning	The operation to which you are posting is already set to complete.
Previous op. not on file	The previous operation does not exist.
Previous op. not started - warning	The previous operation has not yet started and the option: Sequence checking on operations required was selected at the time of creating the job (Job Entry).
Work center blank standard assumed - warning
Invalid work center	The work center is not defined or does not exist.
Subcontract work center
Rate ind. taken as 1 - warning
Rate ind. used rate from operation - warning
Invalid emp. rate indicator	The employee rate indicator is invalid.
Time unit of measure conversion not set up
Zero employee rate. Will use work center rates	The employee rate is zero, so the work center rate will be used.
Machine blank std assumed - warning
Machine not on file	The machine code is not on file.
Invalid date
Run time not numeric	The value in the run time field is not numeric.
Run time > 5 integers	The value in the run time field has more than 5 integers.
Run time > 2 decimals	The value in the run time field has more than 2 decimals.
Set-up time not numeric	The value in the set-up time field is not numeric.
Set-up time > 5 integers	The value in the set-up time field has more than 5 integers.
Set-up time > 2 decimals	The value in the set-up time field has more than 2 decimals.
Startup time not numeric	The value in the startup time field is not numeric.
Startup time > 5 integers	The value in the startup time field has more than 5 integers.
Startup time > 2 decimals	The value in the startup time field has more than 2 decimals.
Shutdown time not numeric	The value in the shutdown time field is not numeric.
Shutdown time > 5 integers	The value in the shutdown time field has more than 5 integers.
Shutdown time > 2 decimals	The value in the shutdown time field has more than 2 decimals.
Non-prd code not on file	The non-productive code does not exist.
Job number blank/non-prd code not on file	The job number field is blank and the non-productive code does not exist.
Pieces comp. not numeric	The value in the pieces complete field is not numeric.
Pieces completed has decs	The value in the pieces complete field contains decimals.
Pieces completed > 7 integers	The value in the pieces completed field has more than 7 integers.
Qty comp not numeric	The value in the quantity completed is field is not numeric.
Qty completed > 3 decimals	The value in the quantity completed field has more than 3 decimals.
Qty completed > 3 integers	The value in the quantity completed field has more than 3 integers.
Qty scrapped = zero - warning	The value in the quantity scrapped field is zero.
Qty scrapped not numeric	The value in the quantity scrapped field is not numeric.
Qty scrapped > 7 integers	The value in the quantity scrapped field has more than 7 integers.
Qty scrapped > 3 decs	The value in the quantity scrapped field has more than 3 decimals.
Invalid scrap reason	The scrap reason code does not exist.
Scrap reason ignored - warning
Invalid pay rate	The pay rate is invalid.
Hierarchy not on file
Hierarchical job - hierarchy cannot be spaces	You are posting to a hierarchical job and the hierarchy field is blank.
Cannot import scrap for a notional part job	You are importing an operation for a notional part and are trying to allocate scrap. You cannot define scrap against a job for a notional part.
Dummy op not allowed until all ops complete	You are importing a dummy operation for a job that requires sequence checking but not all operations are complete.

Notes and warnings

Restrictions and limits

The maximum value allowed against each time field (i.e. run time, setup time, startup time and teardown time) is 99999.99. An overflow message is displayed if any labor posting causes this value to be exceeded.
The unit of measure for time defaults to hours. If you want to enter time in 30 minutes, you need to enter it in terms of hours (e.g. as 0.5)

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.

eSignature Transaction	Description
WIP Labor posting	Controls access to the posting of labour in the WIP Labor Import and Labor Posting programs.

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operator Maintenance program.

Activity	Description
Listview/Forms - Export or print data	Controls whether an operator can print the contents of a listview and/or output the contents of a listview to an HTML page, XML document or Excel spreadsheet.
Maintain data in import programs	Controls whether an operator can maintain import data in a data grid within any SYSPRO import program before the import is performed.
Allowed to import from client	Controls whether an operator can use a SYSPRO import program to import data from a client machine (in a client/server environment).
File Browse on server (C/S system)	Controls whether an operator use the browse function to load the Browse on Files and Folders program to locate files on the server in a client/server environment. Operators can still navigate to a file or folder on the server by typing in the full path name in the entry field.