Spreadsheet: sally_beck__33723__ENERGY_OPS_000629
Sheet: Sheet1

ENERGY OPS - SETTLEMENTS/VM
[NAME] REPORT
2000-06-29 00:00:00
REPORT NAME | ACTION REQUIRED | RESPONSIBLE | DUE DATE
#1-The Matrix-Transaction Detail | 1.  Review and sign off on Matrix summary report. | [NAME], J. Valdes, [NAME] | [NAME]
 | 2. Show BU users Matrix detail line item solution with VLOOKUPS. | [NAME], [NAME] | 2000-06-29 00:00:00
 | 3. Review and sign off on Matrix detail report | [NAME], J. Valdes, [NAME] | 2000-06-30 00:00:00
 | 4. If necessary, develop action plan for long term solution for Matrix detail report | [NAME], [NAME], [NAME] | TBD based on BU comments
#2-G/L Line Item Report (GL 110 | 1.  User Acceptance Received |  | [NAME]
#3-Unify A/R Cash Flow Report- | 1.  [NAME] sent [NAME] A/R Line Item Upload file. | [NAME] | [NAME]
(Apache Report) | 2.  Use upload and create report in Access for BU. | [NAME] | 2000-06-30 00:00:00
#5-A/R and A/P Aging | 1.  Develop solution to include xref field in AP/AR aging report
 | 1a.  Configure posting keys to open fields for xref field for manual population | [NAME], [NAME] | [NAME]
 | 1b.  Develop method for automated population of xref fields | [NAME], [NAME] | 2000-08-01 00:00:00
 | 2.  Develop solution for capturing settlement period and application info on AP/AR aging report
 | 2a.  [NAME] design spec for report, determining logic for obtaining and reporting on "Delivery Period" and "Applications (Cash/Net)" | [NAME], [NAME], [NAME],  [NAME] | [NAME]
 | 2b.  Review netting document types (AB and ZO) and determine if consistent document type is required across business units.  Develop action plan as necessary. | K. Cantu | [NAME]
 | 2c.  Create new document type for account clear.  [NAME] fields in document type configuration. | [NAME], K. Cantu | 2000-06-29 00:00:00
 | 2d.  [NAME] technical spec and report development | [NAME] | TBD based on complexity of report spec
 | 2e.  [NAME] testing of report and user sign-off | [NAME], [NAME] | TBD based on completion of report development above
 | 3.  Determine tool to manipulate AR/AP data for ad hoc queries.
 | 3a.  Determine if ENA has an in-house Excel expert to write macros to convert SAP line item detail to excel | [NAME] | 2000-06-28 00:00:00
 | 3b.  Accumulate 5-10 samples of frequently requested ad hoc queries. | [NAME], [NAME] | 2000-06-28 00:00:00
 | 3c. Review examples & determine most effective tool | [NAME], [NAME], [NAME] | 2000-06-29 00:00:00
 | 3d. Make final recommendation of tool(s) necessary to meet BU requirement (i.e., on-line query,  Excel, ABAP, data warehouse). | [NAME], [NAME], [NAME] | 2000-06-30 00:00:00
 | 3e.  Develop action plan to implement final recommendation | K. Lesley | 2000-06-30 00:00:00
#7-Past Due A/R Invoices > 60 Days Excluding Invoices Prior to 1/30/99 (for insurance policy) | 1. Review Invoice Flex Sort file as a tool/report to meet reporting requirements and sign off if acceptable, or develop plan if not acceptable. | [NAME], [NAME], [NAME] | [NAME]
#16-Cash Forecast Report (Detail) & #17-Forecasted Invoices by Expected Date | 1a. Send completed/revised spec to BU for final approval | [NAME] | [NAME]
 | 1b. Review and approve spec | [NAME], [NAME] | [NAME]
 | 1c. SAP to review and approve spec.  Provide comments on what can be changed vs. what can't be changed. | [NAME] | 2000-06-29 00:00:00
 | 2. Re-write ZCASH code based on approved BU spec. | [NAME] | 2000-07-07 00:00:00
 | 3. Test report and sign off | [NAME], [NAME] | 2000-07-14 00:00:00