Knowledgebase

There is no report available to automatically provide the information on glass sizes and quantities used when the Glass items in the Price Codes file have only one listing for all sizes. However, the information is in FrameReady and here is how you can extract it. Although it is not ideal, it is a start.

1. Perform a FIND in the Work Order file with the * (asterisk) in the Glass field to find all orders which have an entry in that field. You can also add a date range or any other criteria (Eg. complete, incomplete, oversize, etc.) Click PERFORM FIND to see the list of orders.

2. In the list view screen, click on SORT button.

3. In the Sort Records dialog box, click on Current Layout (List View) and select Current Table (Wrk_Ordr). Now, from the list below, select Glass and move it to the Sort Order Box. Then select Glass Size and move it to the Sort Order Box. Click SORT.

4. Click File on the Menu bar and select, Export Records... (You must be in Level4 and select Restore Full Menus from the Scripts Menu bar in order to see Export Records... in the list.)

5. Save the file as an Excel Workbook or .xls file. Give it a recognizable file name and note the location to where you will be saving it.

6. Click Continue in the Excel Options dialog box.

7. In the Specify Field Order for Export dialog box, click the Clear All and move only: Glass and Glass Size to the Field Export Order list. Once again, you will need to change from Current Layout (List View) and select Current Table (Wrk_Ordr) in order to see the correct list. (If for some reason there were other fields you wanted to export you could, Eg Qty.

8. A message will appear: "This export type does not support repeating fields. Only the first item from each repeating field will be exported." Click OK. (This means that if a glass item was listed in the second field, that information will not be exported.) The file will be save to the location you specified early.