The steps below are an example of this query if you're looking for Purchase Orders open as of year end. If you want to use another date, simply change the dates in your query.
  1. In Query, click New.
  2. Query type is Purchase Order.  Query Format is Dynamic.  Click Ok.
  3. On the Criteria tab, click the plus sign to the right of Purchase Order to expand the section.
  4. Double-click Status.  Operator is equals.  Value is Closed order.  Click Ok.
  5. Click the plus sign next to Purchase Order Properties to expand the section.
  6. Double-click Created on.  The operator is less than or equal to.  The value is 12/31/09.  Note: Adjust the date appropriately.  Click Ok.
  7. Double-click Last Changed on.  The operator is greater than or equal to.  The value is 01/01/10.  Note: Adjust the date appropriately.  Click Ok.
  8. Place parenthesis around this section of criteria.  To do this, highlight the first piece of criteria, then click the open parenthesis at the bottom of the screen.  Next highlight the last piece of criteria and click the closed parenthesis.
  9. Click on the plus sign to the right of Purchase Order.
  10. Double-click on Status.  The operator is equals.  The value is Open purchase order.  Click Ok.
  11. Click Or at the bottom of the screen.
  12. Click Open parenthesis.
  13. Under Purchase Order Properties, double-click Date Created.  The operator is less than or equal to.  The value is 12/31/09.  Note: Adjust date appropriately.  Click Ok.
  14. Note: "And" should proceed the previous criteria.  If it does not, highlight that piece of criteria and click And at the bottom of the screen.
  15. Click the closed parenthesis at the bottom of the screen.
  16. On the Output tab, select the appropriate output.
  17. Click on the Results tab.