EDI Contract Pricing Import

Sales Orders > Contract Pricing > EDI Contract Pricing Import

EDI Contract Pricing Import

You use this program to import a Sales Order contract pricing file that has been exported from another site using the Contract Pricing Export program.

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 (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.

Options

Data Source

Field	Description
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.

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

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.

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

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

This pane displays the import record details.

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.

Import/Export File Layout for 7

Header records

The following tables indicate the structure of the contract pricing import/export file.

The first two records in the file must be header records, followed by the contract detail records.

Field	Start position	Field length and description
Header		;SYSPRO IMPORT - Version=001 - INTP41 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.
Header record	1	2 # indicates that this is a header record.
Constant message	3	10 SYSPRO.EDI - this is a constant message to make the header more readable when viewing the file.
Space	13	1 This field is set to a space to make the header more readable.
Version	14	16 This is the SYSPRO version number of the program.
Constant message	30	7 Format
Constant message	37	9 Format code 'ORDPOC'
Date	46	19 This field indicates the date on which the file was created. The format is the normal edited SYSPRO date.

Field	Start position	Field length and description
Header record	1	2 # indicates that this is a header record.
Constant message	3	10 Company :
Company id	13	4 Company id from which the export file was created.
Constant message	17	3
Company name	20	50 SYSPRO company name.

Detail records

Field	Start Position	Field length and description
Contract type	1	1 If this contract is based on the customer, then this is C. If based on buying groups, then this is B.
Customer number / Buying Group	2	15 If the contract type is C, then this field must contain a customer number. If the contract type is B, then this field must contain a valid buying group.
Stock code	17	30 This field is a 30 character valid stock code.
Contract number	47	20 This field contains the contract number.
Record Type	67	1 Normal records = BLANK.
Contract start date	68	10 This contains the date on which the contract starts, in the format `CCYY/MM/DD`.
Contract end date	78	10 This contains the date on which the contract ends, in the format `CCYY/MM/DD`.
Pricing method	88	1 A single character from one of the following: F - Flat price C - Coded price K - Mark up list price L - List less % price M - Mark up cost by % Q - Quantity discount breaks D - List less chain discount P - Coded less chain discount U - Coded less unit discount X - Delete contract after import

The following fields are used if the pricing method is not set to Q:

Field	Start Position	Field length and description
Unit of measure	89	10 If the pricing method is F, then this is the pricing unit of measure.
Price code	99	10 If the pricing method is set to C, P or U, then this is the price code to use.
Fixed price	109	16 (10.5) If the pricing method is F, then this field contains the fixed price of the contract. If the pricing method is U, then this field contains the discount value

Field

Start Position

Field length and description

Unit of measure

If the pricing method is F, then this is the pricing unit of measure.

Price code

If the pricing method is set to C, P or U, then this is the price code to use.

Fixed price

109

16 (10.5)

If the pricing method is F, then this field contains the fixed price of the contract.

If the pricing method is U, then this field contains the discount value

The following fields are used only if the pricing method is set to M, L, D or Q:

Field	Start Position	Field length and description
Discount % 1	125	6 The format of the field is 999.99. If the pricing method is D, then this is the first discount of the chain discount by which the list price must be reduced. If the pricing method is K, then this is the percentage by which the list price must be marked up. If the pricing method is L, then this is the percentage by which the list price must be reduced. If the pricing method is M, then this is the percentage by which the cost must be marked up. If the pricing method is P, then this is the first discount of the chain discount by which the specified price code must be reduced. If the pricing method is Q, then this is the discount percentage.
Discount % 2	131	6 This field is used if the pricing method is D and it is the second discount by which the list price must be reduced. The format of the field is 99.99. If the pricing method is P, then this is the first discount of the chain discount by which the specified price code must be reduced. The format of the field is 999.99
Discount % 3	137	6 This field is used if the pricing method is D and it is the third discount by which the list price must be reduced. The format of the field is 99.99. If the pricing method is P, then this is the second discount of the chain discount by which the specified price code must be reduced. The format of the field is 999.99
Customer list price	143	17 (10.5) This field is used for a pricing method of F and a contract type of C.

Quantity break record

Field	Start Position	Field length and description
Contract type	1	1 If this contract is based on the customer, then this is C. If based on buying groups, then this is B.
Customer number/ Buying group	2	15 If the contract type is C, then this field must contain a customer number. If the contract type is B, then this field must contain a valid buying group.
Stock code	17	30
Contract number	47	20
Record type	67	1 Quantity break = Q.
Quantity	68	19 (12.6)
Price code	87	10

Import/Export File Layout for 6.1

Header records

Field	Start Position	Field length and description
Header record	1	2 # indicates that this is a header record.
Constant message	3	10
Space	13	1
Version	14	16
Constant message	30	7
Constant message	37	9
Date	46	19

Field	Start Position	Field length and description
Header record	1	2 # indicates that this is a header record
Constant message	3	10
Company id	13	2
Constant message	15	2
Company name	17	30

Detail records

Field	Start Position	Field length
Contract type	1	1
Customer number / Buying Group	2	7
Stock code	9	30
Contract number	39	6
Contract start date	45	10
Contract end date	55	10
Pricing method	65	1

The following fields are used if the pricing method is not set to Q:

Field	Start Position	Field length
Unit of measure	66	3
Price code	69	2
Fixed price	71	16 (10.5)

The following fields are used only if the pricing method is set to M, L or D:

Field	Start Position	Field length
Discount % 1	87	6
Discount % 2	93	5
Discount % 3	98	5
Space	103	28
Customer list price	131	17 (10.5)

If the pricing method is Q, then the following fields begin at position 66 (i.e. after the pricing method field):

Field	Start Position	Field length
Quantity 1	66	11
Price code 1	77	2
Quantity 2	79	11
Price code 2	90	2
Quantity 3	92	11
Price code 3	103	2
Quantity 4	105	11
Price code 4	116	2
Quantity 5	118	11
Price code 5	129	2
Discount percentage	131	6

Notes and warnings

Setup considerations

You must select the Export/import contract price modifications setup option (Interface Setup) to enable the import facility.

Import contract prices

From the Contract Pricing Import program, enter the file name of the export file created using the Contract Pricing Export program.

If you do not specify the full path to where the file is located, the program assumes that the file resides in your working directory.
Select the Start Import function to import the prices from the specified export file.