Exporting P.O. Line Detail Reports to Excel
Introduction
The purpose of this wiki is to give a step-by-step guide on how to export the P.O. Detail Line Report to Excel using various formats.
P.O. Line Detail Report
From the main menu, select:
| ||
|
Running the report for all data
Under "Report", select "All Data".
Enter the desired date range under "Completion Date Range".
Under "All Data Report Options", select "Export to Excel".
- Note: select the option "Condensed" if preferred.
Specify both the "Excel Output File Path" and "Output File" name.
Click Proceed.
Under "Report", select "All Data". Enter the desired date range under "Completion Date Range". Under "All Data Report Options", select "Export to Excel".
Specify both the "Excel Output File Path" and "Output File" name. Click Proceed. |
Sample report
A report will be generated, similar to the following:
Running the report only for open P.O.'s
Under "Report", select "Open". Enter the desired date range under "Completion Date Range". Under "Open PO Report Options", select "Export to Excel". Specify both the "Excel Output File Path" and "Output File" name. Click Proceed. |
Sample report
A report will be generated, similar to the following:
Related Articles
P.O. - Create/Modify Shipment in Transit
Introduction This module will allow the monitoring and receiving of incoming shipments. It is used in conjunction with existing purchase orders. Create Shipment in Transit Go to: P.O. Shipment in Transit Subsystem Processing Create/Modify Shipment ...Claire OTS Custom excel report
Introduction The following wiki explains how to generate an Excel OTS report that will show pictures, print specs, or sort by body Setup In the main JAS menu, go to: File Alternate Menu In the alternate menu, go to: Styles Create Excel OTS Report ...Setting up Crystal Reports software for use in JAS
Introduction Crystal Reports is a Business Intelligence application used to design and generate reports from a wide range of data sources (from Wikipedia). Certain JAS outputs use the Crystal Reports software for printing / formatting. Most of the ...P.O. - Shipment in Transit Receiving
Introduction Once a shipment has been created the receiving module will update the shipment, the PO(s) and the inventory. Go to: P.O. Shipment in Transit Subsystem Processing Receive Shipment Field Definitions Shipment# - Enter the Shipment number to ...Exporting the Customer List and Label Report to Excel
Table of Contents Introduction Instructions Filling in the Export to Excel options To find the template name including file path Sample Report Introduction This wiki explains to the user how to export the customer lists and labels report to Excel. ...