Steps in the screenshots correspond to the numbers in the headings.
The PO Detail Report was primarily designed for our Buying group but some Site Management or Supply Chain personnel have found the information useful as well.
1. From your browser, go to the ATS Report Server: https://ssrs.advancedtech.com/Reports/
2. The SQL Server will load. Go to the Browse tab.
3. Click on the ATS FMS Reports Reports.
4. The full list of available reports opens. Click on the Purchase Order Detail Report.
5. The available selection criteria loads. You have the the option of looking from a number of different ways:
5.1. Posting Date Range of Purchase Orders (Required.)
5.2. Singular PO # or All (leave checkbox as Null.)
5.3. Singular Site Number or All (leave checkmark as Null.)
5.4. If you are running this for a site level, you can further customize by a receiving date range.
5.5. Click the View Report button.
6. The Report will load.
7. Click on the floppy disc and choose a file type to save.
Fields listed on the report:
- Site Number
- Place Name
- Assigned Buyer
- Posted Date
- PO #
- PO Type
- Line #
- PO/GNS Line Status
- Part/GNS ID
- Mfg Part Number
- Material Group
- Mfg
- Description
- Search Term
- Quantity Ordered
- Total Quantity Received
- Qty
- UOM
- Unit Price
- Extended Price
- Currency
- Received Date
- Received By
- Vendor #
- Vendor Name
- WO #
- Billable
- ATS PO Status
- Expedite Status
- Approval Status
- Ship Via
- Freight Account
- Tracking Info
- Delivery Type
- Due Date
0 Comments
Add your comment