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
Using Excel for Contract Maintenance Import/Export
Contract Maintenance Filter (SOE567)