9.9 Run Open PO Report
Updated on
- Parameter fields
- Selection parameters
- Plant
- Document Date (always use current date as the last date of range)
- Execute
- Choose DELIVERY SCHEDULE layout
- Export to Excel
- Delete Col. A (Purchasing Doc. Type) and any yellow rows at the top of the spreadsheet
- Re-label column headings
- Purchasing Group > SITE
- Collective Number > CODE
- Purchasing Document > PO#
- Order Quantity > QTY
- Do any additional clean up on the spreadsheet
- Delete Req. Tracking Number column
- Save spreadsheet in Expediting folder on L: Drive
- L:>Stores Records>Expediting>current month folder file name: Exp Report mmddyy
- Label Sheet1 tab on spreadsheet as ALL
0 Comments
Add your comment