Excel Spreadsheet Columns - Grid Copy

$image\btnseeal.gif$

· Right mouse click either the line item or "select all" option on the menu

· A window will open with your selection in an excel spreadsheet

· To export Process Areas/ Levels to the spreadsheet, display them in the grid first: select View | Process Areas on the grid's right -click menu.

The spreadsheet will have the following columns:

Column heading:
Process Area Process Level	Columns only display when Process Area/Levels are displayed on the Basket grid
Item	Constant columns
Qty	Constant columns
Req Date	Constant columns
Product Type	Constant columns
Model	Constant columns
AuxSpec 1	Constant column
. . .	One more column per additional AuxSpec.
AuxSpec n	Constant columns
Short Description	Constant columns
Long Description	Constant columns
Each List	Constant columns
Each Net	Constant columns
Total List	Constant columns
Discount	Constant columns
Total Net	Constant columns
Each Xfer List	With transfer price access
Each Xfer Net	With transfer price access
Total Xfer List	With transfer price access
Total Xfer Discount	With transfer price access
Total Xfer Net	With transfer price access
Vendor Code	Constant columns
Market Group	Constant columns
Weight	Constant columns
Set Net	Constant columns
Discount A	Constant columns
Discount B	Constant columns
Discount C	Constant columns
Discount D	Constant columns
Discount E	Constant columns
LeadTime	Constant columns
TagSet 1	Constant column
. . .	One more column per additional Tag Set.
TagSet n

è To Paste Excel into Basket Grid

· Select the column headers that you want in your basket – Model Column must be copied.

· Copy

· On the Basket Grid : Go to the description field

· Right Mouse Click | Paste

· OR Create a new Basket

· Right Mouse Click | Paste

Hint – Click the Options button located at the top of the basket page and select "paste"