WIP Job Receipts Import
You use this program to import jobs and/or co-product receipts that were created using third party application software.
You can also kit issue material and/or labor allocations as part of the import routine.
Toolbar
Field | Description |
---|---|
Import | This 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 (Automation Design).
Your selections are saved and applied when the program is run in automated mode. Form values and defaults are applied at operator level (i.e. they are not saved at role or group level). |
Options
Field | Description | ||||
---|---|---|---|---|---|
Data source | |||||
Import method |
|
||||
File location |
|
||||
File name |
Indicate the name of the import file (include the full path). Select the Review file option to load the contents of the import file into the Details pane, which lets you validate the lines on the grid prior to importing the file. The Import button is only enabled when all lines are valid. The import file is deleted if you enable the Delete file after use option. |
||||
Options | |||||
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 not enabled, valid records are imported and invalid records are ignored when the import is performed. |
||||
Import rows on partial hold |
Enable this to import normal jobs that contain a stock code which is on partial hold. |
||||
After processing completed |
These options are displayed within programs that can be automated. They let you indicate the action you want to perform once processing is complete. |
||||
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 |
This indicates the email addresses of recipients to whom you want to email the information displayed in the output pane. |
||||
Delete file after use |
Indicate whether you want to delete the import file after all records are successfully imported. The file is also deleted if you enable this option and select the Review file function. 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 |
This exits the program once processing is complete. Don't 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
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. |
||||||||
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. | ||||||||
Clear | Clears the contents in the search text field. | ||||||||
Edit Options |
|
Import Results
This pane 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/Grid layout
Field | Start position | Field length and description |
---|---|---|
Header |
;SYSPRO IMPORT - Version=001 - WIPJRI This is a mandatory entry on the first line of the import file and is not case-sensitive. This only applies if importing from a file. |
|
Line type | 1 |
1 The first character of each line in the import file must be a J to indicate a job receipt. This only applies if importing from a file. |
Job | 2 | 20 |
Stock code | 22 |
30 This 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) This must be a positive value, and must be in the manufacturing unit of measure (if Manufacturing Units of Measure 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 flag | 72 |
1 When importing co-products, this indicates the cost of the co-product instead of the job cost.
|
Receipt cost | 73 |
16 (10.5) The entry here is used only if you specified M at the Cost field, and must be a positive value. |
Complete | 89 |
1
If complete, then the transaction date (i.e. the date of the import) is used as the job completion date. 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. |
Receipt flag | 90 |
1 Set to Y if you want to display an error when the receipt quantity for the job/co-product exceeds the outstanding job/co-product quantity. |
Job closure flag | 91 |
1 Set to Y if you want to display a warning when setting a job/co-product to closed that has an outstanding job/co-product quantity. |
Filler | 92 |
3 This 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 | 146 |
50 An entry is required if the item is traceable (unless you indicated that the job number must be used as the lot number). If you enabled the Use same lot on multiple stock codes setup option (Lot Traceability Setup) then you can reuse the same lot number for different stock codes. If 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 | 204 |
10 Enter the concession number in this field as you will be unable to capture it later. |
Serial number | 214 |
50 An entry is required if the item is serialized. In addition, only a single serial number can be entered per line in the import file. If you enabled the Use same serial for multiple stock codes setup option (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 flag | 272 |
1
The quantities and/or time is calculated from the quantity of the finished item being received into stock. 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. |
Sales order update | 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. 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 (Set Key Information) or automatic WIP inspection reference numbering (Set Key Information). |
Inspection narration | 358 | 100 |
Inspection flag | 458 |
1 Set 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 Codes). 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. |
Notes and warnings
Restrictions and limits
-
Imported receipts that exceed the acceptable cost variance percentage are rejected during processing if the Reject import receipts option is enabled (Setup Options > Preferences > Distribution > Inventory).
-
The import fails if a stock item being imported is on full hold.
However, if you enable the Import rows on partial hold option you can import normal jobs that contain a stock code which is on partial hold.
-
Jobs that are linked to incomplete job nests can't be receipted.
Process considerations
-
Only one FIFO bucket is output for the receipt when you receipt an ECC-controlled item that is not lot traceable and the Actual costing setup option is defined as Lot Traceable.
-
If a job is linked to a job nest that is complete, you can perform the receipt as per normal. The WipNestCost table is then updated with the receipt cost.
Messages
-
Job completed with outstanding materials
This message is displayed in the data grid when one or more allocations could not be issued against a job. The job receipt is still performed, and all valid remaining allocations are issued.
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 Operators program.
Activity | Description |
---|---|
Listview/Forms - Export or print data | Controls whether an operator can print the contents of a list view and/or output the contents of a list view 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. |
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 eSignature Setup program.
eSignature Transaction | Description |
---|---|
WIP Stocked job receipts |
Controls access to the Post function in the Job Receipts and WIP Job Receipts Import programs. |
Copyright © 2022 SYSPRO PTY Ltd.