This form enables the user to select criteria to extract information from Oracle and download into the worksheet.
Position the cursor somewhere in the sheet below row 11. Data will be downloaded from this point, pushing all existing rows downwards.
Click on the ‘Download’ button and select ‘Download Form’ from the ribbon.
The following form will display:
To select the relevant invoices enter criteria into one or more of the fields above. You may use the wildcard character ‘%’ to increase the search capacity.
Once the selection criterion has been entered into the relevant field(s), click on the ‘Search’ button. The Invoices that meet the criteria will show on the ‘Available Invoices’ section.
You can select a number of Invoices with the following actions:
•Hold down the Shift key, and then click individual invoices. The invoices selected and invoices between will be highlighted.
•Hold down the Ctrl key and click any number of invoices. All invoices selected will be highlighted.
Once you have selected the invoices you wish to download, click on the ‘>’ button. The invoices selected will move to the ‘Selected Invoices’ section. To remove an invoice from this section highlight it and click the ‘remove’ button.
Multiple searches can be performed in this form and the existing 'Selected Invoices' section added to.
Once you have selected the invoices you wish to download click on the ‘Download’ button. A processing form will display the download progress:
On closing the processing form the worksheet will be populated with the invoice details:
