SYSPRO Ribbon bar > Imports > Manufacturing > Job Receipts Import

Job Receipts Import

You use this program to import jobs/co-product receipts that were created using 3rd party application software.

You can also kit issue material and/or labor allocations as part of the import routine.

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.

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 - WIPJRI

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 a J to indicate a job receipt.

Job number 2 20
Stock code 22 30

Must match the stock code assigned to the job header, or if importing co-products it must match the stock code assigned to the co-product line.

Receipt quantity 52 20 (12.6)

Must be a positive value, and must be in the manufacturing unit of measure, if MUM is in use. When importing co-products, this quantity indicates the co-product receipt quantity. The job manufactured quantity for the notional part is updated as a ratio of the co-product quantities received.

Cost 72 1

When importing co-products, this indicates the cost of the co-product instead of the job cost.

  • Enter Spaces to use the current cost.

  • Enter C to use the current cost.

  • Enter W to use the WIP value.

  • Enter A to use the actual cost.

  • Enter E to use the expected cost.

  • Enter M to manually enter the receipt cost.

Entered receipt cost 73 16 (10.5)

The entry at this field is used only if you specified M at the Cost field, and must be a positive value.

Complete 89 1
  • Enter Y to set the job to complete.

    When you set a job to complete:

    • outstanding operations are also set to complete, unless the option: Work in Progress load levelling required (WIP Setup - General 1 tab) is enabled.

    • all allocations are set to complete and any reserved stock for them is released. This applies when the Reserve stock for allocations option is enabled (WIP Setup) and stock was reserved for the allocation.

  • Enter N to set the job to be not complete.

    When you set a job to complete, all allocations are set to complete and any reserved stock for them is released.

    Setting the job to incomplete thereafter does not re-reserve stock for allocations. Stock for these allocations must be manually re-reserved using the WIP Reservations Review program as required.

    This applies when the Reserve stock for allocations option is enabled (WIP Setup).

  • Enter Spaces if you want the completion status to be determined by the import program (i.e. the quantity already manufactured for the job/co-product is added to the quantity being received in. A comparison is made to the original quantity that was required to be manufactured. If the result is equal to (or greater than) the original quantity to be manufactured, then the job/co-product is set to complete. If it is less than the original quantity to be manufactured, then the job/co-product is set to be not complete.

If complete, then the transaction date (i.e. the date of the import) is used as the job completion date.

[Note]

When importing co-products, this field indicates whether the co-product must be set to complete and not the job. A notional job cannot be set to complete via the import function.

Received qty exceeding outstanding job qty to be treated as an error (Y - Yes) 90 1

Enter Y if you want to indicate an error when the receipt quantity for the job/co-product exceeds the outstanding job/co-product quantity.

Closure of job with outstanding job qty to be treated as an error (Y - Yes) 91 1

Enter Y if you want to indicate an error when setting a job/co-product to closed that has an outstanding job/co-product quantity.

Filler 92 3

These must be blank.

Reference 95 30

If left blank, then this defaults to Import.

Bin location 125 20

If left blank, then the bin held against the warehouse is used.

Update default bin 145 1
Lot number 146 50

You must make an entry here if the item is traceable (unless you indicated that the job number must be used as the lot number).

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup):

  • you can reuse the same lot number for different stock codes.

  • and the lot number is manually submitted (i.e. it is not created automatically or only entered after inspection), then an error is returned if the lot number exists more than once in the import file for different stock codes.

Lot expiry date 196 8
Concession number 204 10

Enter the concession number in this field as you will be unable to capture it later.

Serial number 214 50

You must make an entry here if the item is serialized. In addition, only a single serial number can be entered per line in the import file.

If you selected the setup option: Same serial to be used for multiple stock codes (Inventory Setup ), then you can reuse the same serial numbers for different stock codes. If you did not select this option then an error is returned if the serial number already exists within the import file.

Serial expiry date 264 8
Kit issue 272 1
  • Enter Spaces to indicate that no kit issue is required.

  • Enter M to issue materials only.

  • Enter L to issue labor only.

  • Enter B to issue both material and labor.

The quantities and/or time is calculated from the quantity of the finished item being received into stock.

[Note]

Kit issue does not apply when importing a co-product receipt.

Filler 273 14
Notation 287 50

This is an optional field and any entry made here is printed on the Inventory Journal.

Update sales order on over-receipt of job (Y - Yes) 337 1

This is an optional field indicating that a job linked to a sales order has been over-receipted and the sales order must be updated accordingly.

[Note]

This does not apply when importing a co-product receipt, as a notional part cannot be linked to a sales order.

Inspection reference 338 20

This field is mandatory if manual numbering is defined.

You can use the same WIP inspection reference for the same job, co-product line and lot number, enabling you to supply several lines for the same job, co-product, lot and WIP inspection reference but with different serial numbers. This does not apply if you selected automatic lot numbering (Lot Traceability Setup) or automatic WIP inspection reference numbering (WIP Setup).

Inspection narration 358 100
Sample inspection flag 458 1

Set this to Y if the receipt quantity represents a sample quantity that must be receipted into WIP inspection.

This only applies if the item is traceable and you selected the option: Sample quantity (Stock Code Maintenance).

[Note]

You need to define a separate import record for the remainder of the receipt quantity that is not subject to inspection. For that record, you do not enter a Y in this field.

Co-product line 459 6

Indicates the co-product line number to be receipted. This field is mandatory when importing co-product receipts.

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 a J to indicate a job receipt.

Job number 2 20
Stock code 22 30
Receipt quantity 52 20 (12.6)
Cost 72 1
Entered receipt cost 73 16 (10.5)
Complete 89 1
Received qty exceeding outstanding job qty to be treated as an error (Y - Yes) 90 1
Closure of job with outstanding job qty to be treated as an error (Y - Yes) 91 1
Filler 92 3
Reference 95 30
Bin location 125 20
Update default bin 145 1
Lot number 146 50
Lot expiry date 196 6
Concession number 202 10
Serial number 212 50
Serial expiry date 262 6
Kit issue 268 1
Filler 269 14
Notation 283 50
Update sales order on over-receipt of job (Y - Yes) 333 1
Inspection reference 334 20
Inspection narration 354 100
Sample inspection flag 454 1
Co-product line 455 6

Notes and warnings

Restrictions and limits

  • Imported receipts that exceed the acceptable cost variance percentage are rejected during processing if the Reject import receipts if cost variance exceeded setup option is enabled (WIP Setup).

  • If one or more allocations cannot be issued, a report indicates the import file line number and reason for the allocation not being issued. The job receipt is still performed and all remaining allocations are issued.

  • The import fails if a stock item being imported is on hold.

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 Stocked job receipts

Controls access to the Post function in the Job Receipts and Job Receipts Import programs.

File layout considerations when importing a notional job

  • When performing an import for a notional job, you must supply a record in the import file for each co-product to receipt. These are the co-products attached to the notional part. In addition, you must supply the co-product line number.

File layout considerations when importing job receipts only

  • Receipts against hierarchical jobs are not supported.

  • Receipts against jobs for non-stocked items are not supported.

  • Receipts against master/sub jobs are not supported.

  • Negative quantity receipts are not supported.

  • Only one serial number can be specified per line.

  • A maximum of 1000 serial numbers per receipt can be receipted against a single stock code.

  • A maximum of 10 warehouses can be specified per import file.

  • Inventory documents are not printed on-line.

File layout considerations when performing a kit issue

  • Kit issues with multiple bins are not supported.

  • Kit issues with serialized components are not supported.

  • Kit issues with traceable components are not supported.

  • Kit issues with negative allocations are not supported.

  • Kit issues with non-stocked components are not supported.

  • Kit issues with subcontract operations are not supported.

  • Kit issue documentation is not printed.

  • Kit issues cannot be performed for jobs for notional parts.

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.

Application Help Pane

Application Help Panes provide step-by-step instructions for various functions within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program. The intention is that the pane provides information that is uncluttered and easy to navigate.

You can embed an Application Help Pane:

  • in the main SYSPRO menu

  • in any program with panes, if not using roles

  • when adding a role layout in Design Mode.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.