Spreadsheet: sally_beck__33724__ENERGY_OPS_000630
Sheet: Sheet1

ENERGY OPS - SETTLEMENTS/VM
[NAME] REPORT
2000-06-30 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] | [NAME]
 | 3. Review and sign off on Matrix detail report | [NAME], J. Valdes, [NAME] | 2000-07-07 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-07-14 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.  Explore method for automated population of xref fields and make a recommendation based on findings. | [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.  Review and approve A/R Aging spec. | [NAME], [NAME] | [NAME]
 | 2d.  Create new document type for account clear.  [NAME] fields in document type configuration. | [NAME], K. Cantu | 2000-07-05 00:00:00
 | 2e.  Review and approve A/R Aging spec. | [NAME], [NAME] | [NAME]
 | 2f.  Complete A/R report development, testing of report and user sign-off | [NAME], [NAME], [NAME] | 2000-07-21 00:00:00
 | 2g.  Review and approve A/P Aging spec. | [NAME], [NAME] | 2000-07-05 00:00:00
 | 2e.  Complete A/P report development, testing of report and user sign-off | [NAME], [NAME], [NAME] | TBD based on receipt of approved report spec
 | 3.  Determine tool to manipulate AR/AP data for ad hoc queries.
 | 3a.  [NAME] reports will download to Excel in a flat format.  Based on 6/30 e-mail from [NAME], this request has been dropped from the action items list. | N/A | [NAME]
#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.  User acceptance received. | [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] | [NAME]
 | 1d. Determine whether expected date and expected amount data can be added to FLEXSORT report to meet additional sorting requirements | [NAME], [NAME] | 2000-07-05 00:00:00
 | 2. Development and unit testing based on on approved BU spec. | [NAME] | 2000-07-06 00:00:00
 | 3. Test report and sign off | [NAME], [NAME], [NAME] | 2000-07-12 00:00:00