2004/02/12 0130

Invoice Query Dialog Window

This is a Query dialog layout, that let's the user choose the information they are going to use to locate a particular invoice.

Input/Display fields
Type: Pop-up menu - select the type of invoice you want to query: Purchase Order, Board Reimb, Imprest, Imprest PO, Payroll Support
Status: Pop-up menu - gives you the check status.; Check Printed (PD), Check # assigned but not pri...(printed), Held (HD), No Check# Assigned (OK), Locked for Invoice Approval, Not Locked
Invoice (Exact): Input the exact invoice#.
Check#: Fill-in/Pop-up menu - put initial or partial name of the Vendor to get the pop-up menu.
Inv. Date: Pop-up menu, enter Invoice date that you want to query:
Other Dates
This allows the user to query by the date the invoice was entered. The top line is the start date and the bottom line is the end date of your query
Enter: The date span the Invoices were entered.
Discount: Last date that the discount applies.
AP: Accounts payable date.
Paid: The date span the Invoices were paid.
Invoice # (Exact): Radio button - to earch by the invoice number via the value in variable text below.
Check ID # (Exact): Radio button - to search by the check number that is paid for the invoice(s) via the value in variable text below
Comment (Multi Wildcard): Radio button - The user can input in multiple segement of strings using space as seperator; any line with string(s) (parts of a word) match would be included in the comment field of the invoices.
Variable Text: Search based to the the radio buttons.

Icon Buttons
Cancel/Escape Button cancels the current action and closes the active window.
Search/Query Button searches for a particular invoice according to the query criteria. Will query all of the invoices in the database and lists them all.