Collection Export function sends 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.
Field Descriptions
Use the following 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
Enter the warehouse or warehouses to use when exporting cost information for contracts.
Note: If you do not enter 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
Buttons:
Ok
Press OK to export the contract collection.
Cancel
Press Cancel to stop the export process.
See Also
Using Excel for Contract Maintenance Import/Export
Contract Maintenance Filter (SOE567)