Finding Then & Now PO's
- Bethann Simon
When an invoice is created for a purchase order where the Vendor Invoice Date or Invoice Date entered is prior to the purchase order date, the system will mark the purchase order as a Then and Now by checking the Then and Now box on the PO transaction. You can then use the purchase order grid or advanced query to easily locate the purchase orders marked as Then and Now.
Adding Then and Now to PO Grid
Add the Then and Now property to your PO grid by using the 'More' button.
Filter for records that are 'true'
Use the Report option on the grid to print and/or save the report for future use.
Advanced Query Then and Now
Click on Advanced Query on the PO grid
Drag and Drop (or double click) 'Then And Now' from the properties box on the left to the display name box on the right.
Change the operation drop down to Equals
Enter a Filter Value of true
Click on Apply Query
Enter a Query Name and click on Save Query so it may be loaded at any time.
Use the Report option on the grid to print and/or save the report for future use.
Click on Clear Query and then Hide Advanced Query Controls.
