You use this program to export the Sales Order contract pricing file. The exported file is used to update contract prices at another site using the Contract Pricing Import program.
| Field | Description |
|---|---|
| Browse on | This option only applies in a client-server environment. |
| Client | Select this if the export file resides on the client machine. The browse will open on the client machine. |
| Server | Select this if the export file resides on the server. The browse will open on the server machine. |
| Export file name |
You use this field to indicate the name of the file to be exported. This defaults to xORDPOC.EDI (where x refers to the company id). If you do not specify the full path to where the file is located, the program assumes that the file must reside in your working directory on the server. |
| Start Export |
Select this to export the pricing information to the specified file. The number of records exported is displayed in a separate window at the end of the export process. |
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Selections | |||||||
| Export selection |
|
||||||
| Option | |||||||
| Export option | This applies only if the system detects that the export
file name exists and that it is a valid contract price export
file.
|
||||||
| Last export information | The following fields display information relating to the previous export processed. | ||||||
| Date of export | This displays the date the last export was performed. | ||||||
| SYSPRO version | This indicates the version of the SYSPRO Contract Pricing Export program used to perform the export. | ||||||
| Company ID | This indicates the company code from which the last export was processed. | ||||||
| Company name | This displays the company name from which the last export was processed. |
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.
1st Header record:
| Field | Start Position | Field Length | Value |
|---|---|---|---|
| Header | ;SYSPRO IMPORT - Version=001 - INTP40 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 (e.g. Version 7.0.001). |
| Constant message | 30 | 9 | Format. |
| Constant message | 39 | 8 | Format code 'ORDPOC'. |
| Date | 47 | 21 | This field indicates the date on which the file was created. The format is the normal edited SYSPRO date. |
2nd Header record:
| Field | Start Position | Field Length | Value |
|---|---|---|---|
| Header record | 1 | 2 | # indicates that this is a header record. |
| Constant message | 3 | 10 | 'Company :' |
| Company id | 13 | 2 | Company id from which the export file was created. |
| Constant message | 15 | 2 | '-' |
| Company name | 17 | 30 | SYSPRO company name. |
| Field | Start Position | Field Length | Value |
|---|---|---|---|
| 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/Buying Group | 2 | 15 | If the contract type is C, then this field contains a seven character customer number. If the contract type is B, then this field is a two character valid buying group followed by five spaces. |
| 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, Quantity breaks = Q |
| 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:
|
The following fields are used if the pricing method is not set to Q:
| Field | Start Position | Field Length | Value |
|---|---|---|---|
| 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. |
The following fields are used only if the pricing method is set to M, L or D:
| Field | Start Position | Field Length | Value |
|---|---|---|---|
| Discount % 1 | 125 | 6 | If the pricing method is M, then this is the % by
which the cost must be marked up. The format of the field is
999.99. If the pricing method is L, then this is the % by which the list price must be reduced. 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. The format of the field is 999.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 % 2 | 131 | 5 | 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 | 136 | 5 | 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. |
| Space | 141 | 10 | The next 10 characters are blank. |
| Customer list price | 151 | 17 (10.5) |
This field is used for a pricing method of F and a contract type of C. |
| Field | Start Position | Field Length | Value |
|---|---|---|---|
| Contract Type | 1 | 1 | B=Buying group, C=Customer. |
| Customer/Buying Group | 2 | 15 | Customer number if Contract Type is C; Buying Group if Contract Type is B. |
| 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 | Quantity break=Q. |
| Quantity | 68 | 19 (12.6) | |
| Price code | 87 | 10 |
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.