Collection Export (SOE567)

Use the Collection Export function to send the displayed contract collection to Excel. Only certain fields will be sent. Refer to the spreadsheet first row for descriptions of those values that are exported. Excel must be open before the export can succeed.

Click Sales Orders>Contract Pricing>Collection Export (SOE567).

Use these fields used when exporting contracts to Excel.

1. Manual Cost

Indicate whether manual cost should be exported to the Excel spreadsheet. This value is protected, and is included as information-only for use in determining the contract prices - it cannot be changed.

2. List/Price

Indicate whether list price should be exported to the Excel spreadsheet. This value is protected, and is included as information-only for use in determining the contract prices - it cannot be changed.

3. Standard

Indicate whether the standard cost should be exported to the Excel spreadsheet.

Changing the contract number will redisplay the effective date.

4. Average

Indicate whether the average cost should be exported to the Excel spreadsheet.

5. Last

Indicate whether the last cost should be exported to the Excel spreadsheet.

6. Warehouse

Specify the warehouse or warehouses to use when exporting cost information for contracts.

Note: If you do not specify at least one warehouse, no cost information will be exported. Cost data will only be displayed from those warehouses that carry the item the contract is for. All warehouse cost data on the spreadsheet is protected from edit. If any warehouse costs are selected, an additional UM column for pricing will be displayed before these columns.

Click OK to export the contract collection.

-OR_

Click Cancel to stop the export process.

 

See also  

Contract Maintenance (SOE567)

Using Excel for Contract Maintenance Import/Export

Import Contracts (SOE567)

Contract Maintenance Filter (SOE567)

Quick Contract Add (SOE567)

Chain a Contract

Chain All Contracts