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.

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

3	After reviewing the records and ensuring you have the ones you want, add the additional data used in QAD CSS as described in the item 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.

4	Save your changes and return to the Catalog Load function in preparation for the next step.