I need a list of purchase orders with full accounting information for the last week/month/quarter/year..
The PO Accounting Detail report provides header information about accounts to be billed for items on purchase orders. It does not provide line items ordered on that purchase order. You can search this report by entering information in boxes on the report. Below is an image of the searchable items on this report.
To specifically find purchase orders for your organization, you should enter the organization code in the org code field. You can enter more than one organization separated by commas.
To retreive purchase orders for a specific date range, you should enter a start date in the PO Initial Open Begin Date field and an end date in the PO Initial Open End Date field. The format of these dates should be mm/dd/yyyy
An Example is shown above.
After you have set up the search criteria. You can select the output type, your output destination, and other available options.
You can only select Excel as the report type for this report. The Excel version will open in Excel and can be saved on your departments server just as you would any excel document you have created. Be sure the location you are saving the document to is secure.
You can choose to wait for the query to finish running, or you can have it run in the background and you will receive an email link to the completed report when it is finished running.
When you have made all of your selections click on the Run button.
You should be able to answer most questions about PO account information using this report.
If you have any questions please contact purchasing-l@indiana.edu.