You use this program to import single level components or multi-level parent/component structures from a flat ASCII file or a data grid.
| Field | Description |
|---|---|
| Import | Validates the contents of the import file and imports records according to your selection at the Import only if all rows are valid option. |
| 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. They are not saved at role or group level. |
| Field | Description | ||||
|---|---|---|---|---|---|
| Import method | |||||
| From file | Select this to import data from a file. | ||||
| Use data grid | Select this to enter the import data directly into the grid
of the Details pane You can paste the contents of an Excel spreadsheet into the grid. A blank line is created as the first line in the grid because by default, focus is set on the first editable line for all import program grids. |
||||
| 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 | This loads 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 enabled only when all lines
are valid.
|
||||
![[Note]](images/note.png)
| 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 not enabled, valid records are imported and invalid records are ignored when the import is performed. |
| Overwrite existing components |
Select this to automatically replace existing components with those on the import file. If you select this option then the message prompting you to overwrite existing components is not displayed. |
| 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 | Indicate the email addresses of recipients to whom you want to email the information displayed in the output panes. | ||||
| Delete file after use | Indicate whether you want to delete the import file after
all records are successfully imported.
|
||||
| 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. | ||||
| 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. |
| 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 |
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.
| Field | Start position | Field length and description | ||||
|---|---|---|---|---|---|---|
| Header | ;SYSPRO IMPORT - Version=001 - BOMPSI 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 Field Type - Alpha The first character of each line in the import file must start with the character M. |
||||
| Parent stock code | 2 | 30 Field Type - Alpha |
||||
| Route number | 32 | 2 This only applies if you selected the option: Alternate routings (Bill of Materials Setup). |
||||
| Component stock code | 34 | 30 Field type - Alpha A stock item defined as a Kit of type 'K' or 'S' can be attached as a component to a parent part that has a Part category of Planning bill.You cannot attach a component item defined as a co-product if that co-product is attached to a Notional part (BOM Co-Product Maintenance) on the same route. The component stock code cannot be an item defined as a Notional part (Stock Codes). |
||||
| Quantity per | 64 | 20 (12.6-) Field type - Signed decimal Although 14 spaces are allocated to the Quantity per field, a maximum entry of 6 whole numbers and 6 decimals is permitted (i.e. a positive quantity of up to 999999.999999 can be specified here).In addition, if decimals are included in the quantity entered, then you must specify the decimal point. |
||||
| Sequence number | 84 | 6 Field type - Unsigned integer |
||||
| Operation no. or offset days | 90 | 5 Field type - Alpha Assign an operation number to the component that will indicate when the component must be available for the manufacture of the parent part. This number can be in the range 1 to 999, where 1 indicates that the material is required at the first operation (i.e. at the start of the job). If you enter an operation number other than 1 then the operation must exist on file.Alternatively, you use this field to indicate when the component must be available for the manufacture of the parent part. The number of days entered is offset backwards from the finish date of the job. |
||||
| Scrap percentage | 95 | 5 (2.2) Field type - Signed decimal Enter a percentage factor by which the quantity per must be increased, to take account of scrap.A decimal point must be included in the percentage entered in this field. For example, if you want 99.99%, then you enter 99.99 in this field. |
||||
| Scrap quantity | 100 | 20 (12.6) Field type - Signed decimal Enter the quantity by which the quantity per must be increased, to take account of scrap. |
||||
| Offset period or operation no. | 120 | 1 This entry can be O (operation) or D (offset days) and qualifies your entry made at the Operation no. or offset days field. |
||||
| Structure on date | 121 | 8 Field type - SYSPRO Date Indicate when the component must become active in the structure. The default entry of 00/00/00 indicates that the component is active from the date of entry.This only applies if you indicated that Structure on/off dates are required (Bill of Materials Setup). |
||||
| Structure off date | 129 | 8 Field type - SYSPRO Date Indicate when the component must be de-activated from the structure. The default entry of 00/00/00 indicates that structure off dates are not required.This only applies if you indicated that Structure on/off dates are required (Bill of Materials Setup). |
||||
| Optional component for order entry | 137 | 1 Field type - Alpha An entry of Y (yes) indicates that you want to be able to make the decision at the time of order entry concerning whether to include the component on an order.An entry of N (No) indicates that the component is regarded as mandatory and is inserted automatically into the sales order. |
||||
| Print components on order docs | 138 | 1 Field type - Alpha Entry at this field can be Y (yes) or N (no). |
||||
| Include scrap % in kit issues | 139 | 1 Field type - Alpha Entry at this field can be Y (yes) or N (no). |
||||
| Reason for change | 140 | 30 Field type - Alpha Enter up to 10 alphanumeric characters describing the reason for the addition or change. |
||||
| Include component in kit issues | 170 | 1 Field type - Alpha Entry at this field can be Y (yes) or N (no). Y indicates that the component must be used during kit issues. |
||||
| Create sub job for component | 171 | 1 Field type - Alpha Entry at this field can be Y (yes) or N (no). The entry at this field is applied only if the parent part is made-in, or subcontracted, or bought-out, or a phantom part, the component part is made-in, or subcontracted and is not a bulk issue or floorstock item. |
||||
| Component revision | 172 | 5 This indicates the revision number of the component and only applies if the component is defined as ECC controlled (Stock Codes). If you enter '- - -' then the current revision is used. If the route does not require ECC (Browse on Routings) then the current revision is used, irrespective of your entry here. |
||||
| Component release | 177 | 5 This indicates the release number of the component and only applies if the component is defined as ECC controlled (Stock Codes). If you enter '- - -' then the current release is used. If the route does not require ECC (Browse on Routings) then the current release is used, irrespective of your entry here. |
||||
| Optional batch bills | 182 | 1 Select this to indicate that the component is included in the bill as a percentage instead of a quantity (i.e. the wet weight percentage of the parent must be used instead of the quantity per for the components). |
||||
| Percentage of wet weight | 183 | 10 (2.6) No decimal point must be included in the percentage entered in this field. For example, if you want 99.99%, then you enter 9999 in this field. |
||||
| Include component in job | 193 | 1 This defaults to N if left blank. Y indicates that you want to define the range of jobs for which the component can be include in jobs. This is only relevant if the option: Component inclusion by job number is enabled (Bill of Materials Setup). |
||||
| From job | 194 | 20 Enter the job number from which the component can be included in jobs. This is only relevant if the option: Component inclusion by job number is enabled (Bill of Materials Setup). |
||||
| To job | 214 | 20 Enter the job number to which the component can be included in jobs. This is only relevant if the option: Component inclusion by job numberis enabled (Bill of Materials Setup). |
||||
| Job warning | 234 | 1 This is used to validate whether the job is greater than the next job number to be used. See Include component in job. |
||||
| Fixed quantity | 235 | 1 This defaults to N if left blank. Y indicates that the number of components required to make a single parent part is fixed - either regardless of the number of parent parts being made, or specifically in relation to the number of parent parts being made. This is determined by your entry at the Parent per fixed quantity field. |
||||
| Parent per fixed quantity | 236 | 20 Enter the number of parent parts to which the component quantity per applies.
|
||||
| Warehouse | 256 | 10 Optionally enter the warehouse from which the component must be issued to the job. In addition, the inventory cost from this warehouse is used when costs are rolled up. The component must be stocked in the warehouse you enter here. When creating a job, this field is overwritten by any component warehouse to use you defined. |
||||
| Filler | 266 | 1 | ||||
| Ignore floorstock bulk-issue | 267 | 1 This defaults to N if left blank. Y indicates that you want a component defined as a floorstock or a bulk issue item (Stock Codes) to be treated as an ordinary component (i.e. not as a floorstock or bulk issue item). This means that the item will not automatically be issued when you confirm the job. |
||||
| Unit of measure flag | 268 | 1 Indicate the unit of measure to use:
If you leave this field blank, then the stocking unit of measure is used.
|
||||
| Component type | 269 | 20 Field type - Alpha Enter up to 20 alphanumeric characters for the component type. |
||||
| ECC Consumption | 289 | 1 Field type - Alpha Enter up to 1 alphanumeric character for the ECC consumption. |
||||
| Reference designator | 290 | 50 Field type - Alpha Enter up to 50 alphanumeric characters for the reference designator. |
||||
| Assembly place | 340 | 50 Field type - Alpha Enter up to 50 alphanumeric characters for the assembly place. |
||||
| Item number | 390 | 50 Field type - Alpha Enter up to 50 alphanumeric characters for the item number. |
||||
| Override rev/rel | 440 |
1 Enter a Y (Yes) or N (No) to override the planned revision and release during a specific issue. This option will be ignored for components that are not ECC controlled. |
||||
| Field | Start position | Field length and description | ||||
|---|---|---|---|---|---|---|
| Header | ;SYSPRO IMPORT - Version=001 - BOMPSI 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 start with the character S. |
||||
| Component stock code | 2 | 30 A stock item defined as a Kit of type 'K' or 'S' cannot be attached to a parent part as a component. A stock item defined as a co-product cannot be attached as a component if that co-product is attached to a Notional part (BOM Co-Product Maintenance) on the same route. The component stock code cannot be an item defined as a Notional part (Stock Codes). Components cannot be attached to a parent item defined as a By-product (Stock Codes). |
||||
| Quantity per | 32 | 20 (12.6) Although 14 spaces are allocated to the Quantity per field, a maximum entry of 6 whole numbers and 6 decimals is permitted (i.e. a positive quantity of up to 999999.999999 can be specified here). In addition, if decimals are included in the quantity entered, then you must specify the decimal point. This must be entered in the unit of measure defined in the Unit of measure flag field of the import file. |
||||
| Sequence number | 52 | 6 This indicates the sequence number for the component in relation to the parent stock code. This is only used if you indicated that structure sequencing is required (Bill of Materials Setup). This number can be in the range 00 to 99 and enables you to show more than one occurrence of the parent/component relationship. |
||||
| Operation no. or offset days | 58 | 5 Assign an operation number to the component that will indicate when the component must be available for the manufacture of the parent part. This number can be in the range 1 to 999, where 1 indicates that the material is required at the first operation (i.e. at the start of the job). If you enter an operation number other than 1 then the operation must exist on file. Alternatively, you use this field to indicate when the component must be available for the manufacture of the parent part. The number of days entered is offset backwards from the finish date of the job. |
||||
| Scrap percentage | 63 | 5 (2.2) Enter a percentage factor by which the quantity per must be increased, to take account of scrap. A decimal point must be included in the percentage entered in this field. For example, if you want 99.99%, then you enter 99.99 in this field. |
||||
| Scrap quantity | 68 | 20 (12.6) Enter the quantity by which the quantity per must be increased, to take account of scrap. This must be entered in the unit of measure defined in the Unit of measure flag field of the import file. |
||||
| Offset period or operation no. | 88 | 1 This entry can be O (operation) or D (offset days) and qualifies your entry made at the Operation no. or offset days field. |
||||
| Structure on date | 89 | 8 Field type - SYSPRO date. Indicate when the component must become active in the structure. The default entry of 00/00/00 indicates that the component is active from the date of entry.This only applies if you indicated that Structure on/off dates are required (Bill of Materials Setup). |
||||
| Structure off date | 97 | 8 Field type - SYSPRO date Indicate when the component must be de-activated from the structure. The default entry of 00/00/00 indicates that structure off dates are not required.This only applies if you indicated that Structure on/off dates are required (Bill of Materials Setup). |
||||
| Optional component for order entry | 105 | 1 Entry at this field can be Y (yes) or N (no). |
||||
| Print components on order docs | 106 | 1 Entry at this field can be Y (yes) or N (no). |
||||
| Include scrap % in kit issues | 107 | 1 Entry at this field can be Y (yes) or N (no). |
||||
| Reason for change | 108 | 30 Field type - Alpha Enter up to 10 alphanumeric characters describing the reason for the addition or change. |
||||
| Include component in kit issues | 138 | 1 Entry at this field can be Y (yes) or N (no). Y indicates that the component must be used during kit issues. |
||||
| Create sub job for component | 139 | 1 Entry at this field can be Y (yes) or N (no). The entry is applied only if:
|
||||
| Component revision | 140 | 5 This indicates the revision number of the component and only applies if the component is defined as ECC controlled (Stock Codes). If you enter '- - -' then the current revision is used. If the route does not require ECC (Browse on Routings) then the current revision is used, irrespective of your entry here. |
||||
| Component release | 145 | 5 This indicates the release number of the component and only applies if the component is defined as ECC controlled (Stock Codes). If you enter '- - -' then the current release is used. If the route does not require ECC (Browse on Routings) then the current release is used, irrespective of your entry here. |
||||
| Optional batch bills | 150 | 1 Select this to indicate that the component is included in the bill as a percentage instead of a quantity (i.e. the wet weight percentage of the parent must be used instead of the quantity per for the components). |
||||
| Percentage of wet weight | 151 | 10 (2.6) This indicates what percentage of weight is comprised of the component (i.e. the specific gravity multiplied by the percentage of wet weight). This field is enabled only if the parent part is configured as a batch bill of materials (Stock Codes). |
||||
| Include component in job | 161 | 1 This defaults to N if left blank. Y indicates that you want to define the range of jobs for which the component can be included in jobs. This is only relevant if you selected the option: Component inclusion by job number (Bill of Materials Setup). |
||||
| From job | 162 | 20 Enter the job number from which the component can be included in jobs. This is only relevant if the option: Component inclusion by job number is enabled (Bill of Materials Setup). |
||||
| To job | 182 | 20 Enter the job number to which the component can be included in jobs. This is only relevant if the option: Component inclusion by job numberis enabled (Bill of Materials Setup). |
||||
| Job warning | 202 | 1 This is used to validate whether the job is greater than the next job number to be used. See Include component in job. |
||||
| Fixed quantity | 203 | 1 This defaults to N if left blank. Y indicates that the number of components required to make a single parent part is fixed - either regardless of the number of parent parts being made, or specifically in relation to the number of parent parts being made. This is determined by your entry at the Parent per fixed quantity field. |
||||
| Parent per fixed quantity | 204 | 20 Indicate the number of parent parts to which the component quantity per applies.
|
||||
| Warehouse | 224 | 10 Optionally enter the warehouse from which the component must be issued to the job. In addition, the inventory cost from this warehouse is used when costs are rolled up. The component must be stocked in the warehouse you enter here. If left blank, then the warehouse to use defined against the stock item is used (Stock Codes). When creating a job, this field is overwritten by any component warehouse to use you defined. |
||||
| Filler | 234 | 1 | ||||
| Ignore floorstock bulk-issue | 235 | 1 This defaults to N if left blank. Y indicates that you want a component defined as a floorstock or a bulk issue item (Stock Codes) to be treated as an ordinary component (i.e. not as a floorstock or bulk issue item). This means that the item will not automatically be issued when you confirm the job. |
||||
| Unit of measure flag | 236 | 1 Indicate the unit of measure to use:
The Quantity per and the Scrap quantity must be entered on the import file in the unit of measure specified here. If this flag is not S or 'Blank', then the conversion factors defined in the Stock Maintenance file are used to convert these quantities back to stocking unit of measure. These are then saved in the stocking quantity fields. For the parent quantity, the BOMPAR record is read and if the record does not exist, then it is created and defaulted to the stocking unit of measure. The parent quantity is then converted according to the BOMPAR-UM-FLAG and stored in the stocking quantities. All supplied quantities are saved in the MUM entered quantities as they are. |
||||
| Component type | 237 | 20 Field type - Alpha Enter up to 20 alphanumeric characters for the component type. |
||||
| ECC consumption | 257 |
1 Indicate the ECC consumption method for ECC controlled components. This entry can by S (Specific), C (Use current) or D (Deplete oldest). If the ECC consumption, Component revision and Component release fields are all spaces, then the import program will set the ECC consumption flag to C and save '---/---' in the revision and release fields. If the ECC consumption field is left blank, then it defaults to S (Specific). Field type - Alpha. |
||||
| Reference designator | 258 | 50 Field type - Alpha Enter up to 50 alphanumeric characters for the reference designator. |
||||
| Assembly place | 308 | 50 Field type - Alpha Enter up to 50 alphanumeric characters for the assembly place. |
||||
| Item number | 358 | 50 Field type - Alpha Enter up to 50 alphanumeric characters for the item number. |
||||
| Override rev/rel | 408 |
1 Enter a Y (Yes) or N (No) to override the planned revision and release during a specific issue. This option will be ignored for components that are not ECC controlled. |
||||
| Field | Start position | Field length |
|---|---|---|
| Line type | 1 | 1 The first character of each line in the import file must start with the character M. |
| Parent stock code | 2 | 30 |
| Route number | 32 | 1 |
| Component stock code | 33 | 30 |
| Quantity per | 63 | 14 (6.6-) |
| Sequence number | 77 | 6 |
| Operation no. or offset days | 83 | 3 |
| Scrap percentage | 86 | 5 (2.2) |
| Scrap quantity | 91 | 8 (4.3) |
| Offset period or operation no. | 99 | 1 |
| Structure on date | 100 | 6 |
| Structure off date | 106 | 6 |
| Optional component for order entry | 112 | 1 |
| Print components on order docs | 113 | 1 |
| Include scrap % in kit issues | 114 | 1 |
| Reason for change | 115 | 10 |
| Include component in kit issues | 125 | 1 |
| Create sub job for component | 126 | 1 |
| Component revision | 127 | 3 |
| Component release | 130 | 3 |
| Optional batch bills | 133 | 1 |
| Percentage of wet weight | 134 | 4 |
| Include component in job | 138 | 1 |
| From job | 139 | 8 |
| To job | 147 | 8 |
| Job warning | 155 | 1 |
| Fixed quantity | 156 | 1 |
| Parent per fixed quantity | 157 | 12 |
| Warehouse | 169 | 2 |
| Filler | 171 | 1 |
| Ignore floorstock bulk-issue | 172 | 1 |
| Unit of measure flag | 173 | 1 |
| Component type | 174 | 20 |
| ECC consumption | 194 |
1 |
| Reference designator | 195 | 50 |
| Assembly place | 245 | 50 |
| Item number | 295 | 50 |
| Field | Start position | Field length |
|---|---|---|
| Line type | 1 | 1 The first character of each line in the import file must start with the character S. |
| Component stock code | 2 | 30 |
| Quantity per | 32 - | 14 (6.6-) |
| Sequence number | 46 | 6 |
| Operation no. or offset days | 52 | 3 |
| Scrap percentage | 55 | 5 (2.2) |
| Scrap quantity | 60 | 8 (4.3) |
| Offset period or operation no. | 68 | 1 |
| Structure on date | 69 | 6 |
| Structure off date | 75 | 6 |
| Optional component for order entry | 81 | 1 |
| Print components on order docs | 82 | 1 |
| Include scrap % in kit issues | 83 | 1 |
| Reason for change | 84 | 10 |
| Include component in kit issues | 94 | 1 |
| Create sub job for component | 95 | 1 |
| Component revision | 96 | 3 |
| Component release | 99 | 3 |
| Optional batch bills | 102 | 1 |
| Percentage of wet weight | 103 | 4 |
| Include component in job | 107 | 1 |
| From job | 108 | 8 |
| To job | 116 | 8 |
| Job warning | 124 | 1 |
| Fixed quantity | 125 | 1 |
| Parent per fixed quantity | 126 | 12 |
| Warehouse | 138 | 2 |
| Filler | 140 | 1 |
| Ignore floorstock bulk-issue | 141 | 1 |
| Unit of measure flag | 142 | 1 |
| Component type | 143 | 20 |
| ECC consumption | 163 |
1 |
| Reference designator | 164 | 50 |
| Assembly place | 214 | 50 |
| Item number | 264 | 50 |
-
This program can also be accessed from within the Structures and Routings program. In this case, the parent Stock code and Route columns are disabled in the Details grid, as they are passed from the Structures and Routings program. In addition, the Line type for each record must be S when importing from a file.
-
Existing operations on the Bill of Materials are not overwritten during importing. It only imports/overwrites the components (structure) part of the bill. If you need to import the routings/operations, then you need to use the Routings Import program
-
To avoid your current structure being overwritten with the imported structure, ensure that you group together multiple occurrences of the same parent item within the import file.
-
If importing components for a parent stock code against which a structure is already defined, then you must indicate whether you want to replace the existing components for the parent with the components held in the import file. When replacing, the original components are removed.
-
You cannot attach components to a parent item defined as a By-product (Stock Codes).
-
You cannot attach a stock item defined as a Kit of type 'K' or 'S' to a parent part as a component.
-
A stock item defined as a co-product cannot be attached as a component if that co-product is attached to a Notional part (BOM Co-Product Maintenance) on the same route. The component stock code cannot be defined as a Notional part (Stock Codes).
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 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. |
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.
-
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.
-
Right-click any form field.
You can also click the triangle menu icon that appears in the title area of a pane.
-
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.
-
Select the Close icon in the right-hand corner of the application help pane.
-
Confirm that you want to delete the pane.