View and Update Extracted Data

1	Review the data that has been extracted from QAD EA and ensure that the records you expected have been retrieved. If not, you can modify the query and extract data again. If necessary, you can manually remove unneeded records or add ones that are required.

If you have appended the results of multiple queries to one file, ensure that you do not have duplicate records before continuing.

2	After reviewing the records and ensuring you have the ones you want, add the additional data used in QAD CSS as described in the planning section.

Important: The load function depends on the spreadsheet columns being in an expected sequence. While you can add data to the spreadsheet, do not delete columns or modify the column order.

Important: Date format should be mm/dd/yy. If the date format changes after extraction due to your regional settings, you need to change related fields back to mm/dd/yy using the Format Cells function in Excel. For information on how to use the Format Cells function, refer to the Excel documentation.

3	Save your changes and return to the Customer Load function in preparation for the next step.