Spreadsheet: daren_farmer__5862__ENA Upstream Unify Enhancements
Sheet: ENA Upstream Unify Enhancements

Unify Enhancement Tracking List for ENA Upstream
Project |  | Description |  | Impact |  | Estimated Settltments |  | Estimated Accounting |  | Comments
 |  |  |  |  |  | Duration |  | Duration
Project List-Settlements: ([NAME])
1.  Update the service p&l report during the day instead of only overnight. |  | Would like to see changes reflected as soon as possible, rather than waiting until the next morning. |  | Would help get traders to use and rely on the report.  This request ties in with the accrual variance report modifications (#6). |  | Total of 15 mandays;  4 mandays of GUI coding/testing; 6 mandays of stored procedure changes; 4 mandays of user test; 1 manday to implement. |  |  |  | Met with Bryce Baxter and other users.  IT will have to create GUI to launch process as well as enable them to extract data down to the contract level.
2.  Net statement |  | Create a statement in Unify that would show sales, supply, service verification, and service invoice amounts that were netted together. |  | Would save 20 hours/month-more convenient to print statement from Unify rather than type into Excel ([NAME]) |  | Cannot estimate at this time. |  | This will require extensive changes to acct.  Ability to show/ reflect in most processing/ reports. |  | Need to work through requirements.  Payment terms issue?  There is a netting process in place, do we use that?
3.  Pay lesser of statement |  | Create a statement in Unify that could be sent to the counterparty when the Producer Invoice price component is used. |  | Would save 30 hours/month.  Currently completing a manual Excel spreadsheet to send to the customer. ([NAME]) |  | Cannot estimate at this time. |  |  |  | Need specs from users.
4.  Imbalance valuation report |  | Create a Unify report that shows imbalances and values them in an agreed-upon manner. |  |  |  | Cannot estimate at this time. |  |  |  | On hold pending review of volume management reports
Project List-Accounting ([NAME])
1.  Cross-application of cash across entities |  | [NAME] to allow cash received by one Enron entity to be applied to receivables on another entity. |  | Would save 40 hours/month-a significant help in applying cash once correctly.  Currently, cash control must reverse Unify deposit, enter amounts in MSA, and redeposit into Unify on correct entity. ([NAME]) |  |  |  | 8 weeks |  | Significant rewrite from base ECT entity logic.  Question regarding security-allow only specific entity combinations, by user, other options?
2.  Over-application of cash to an invoice |  | [NAME] to allow cash to be overapplied to an invoice, allowing the balance to become negative. |  | Would save 35 hours/month-saves reconciliation time and eliminates paperwork.  Currently unable to see which invoice a customer is overpaying, making reconciliation of accounts inefficient and time-consuming. ([NAME]) |  |  |  | 2 days; 1 day change, 1 day user test |  | Unify team is currently testing to determine impact to netting functionality
3.  Refunds |  | Add the functionality in Unify to systematically refund money sent to Enron in error or sent to the wrong Enron entity. |  | Would save 10 hours/month.  Must reverse out of Unify, rebook in MSA, wire funds manually, and reclass between AR and AP. ([NAME]) |  |  |  | 4 weeks - 40% complete |  | Need analysis of payment procedures for receivables.
Items to be prioritized:
Settlements / Accounting ([NAME])
1. Settlement of SO2's |  | Since SO2 deals will be added to EnPower, add the ability to settle these statements through Unify. |  |  |  | Total of 10 mandays |  |  |  | Need to verify that [NAME] is currently supporting this
2. Fuel percentage volume reduction |  | Add the ability to process off of the fuel percentage reduction sent by [NAME] |  | Would save 4 hours/month-systematically price fuel at zero rate for contracts with volume reduction provisions ([NAME]) |  | Total of 8 mandays; 4 mandays of coding; 3 mandays of user test; 1 manday to implement. |  |  |  | Involves modifying the [NAME] process in Settlements.
3. Statement group accounts report |  | Create a Unify report that shows the accounts that are linked to each statement group. |  | Would save 10 hours/month-will help intercompany and monetized account coordinators review account types.  If an I/C account is assigned the incorrect A/R control account and is not caught, a manual JV entry must be created and entered by gas accounting. ([NAME]) |  | Total of 5 mandays; 3 mandays of coding; 1 manday of user test; 1 manday to implement. |  |  |  | [NAME] from [NAME] group is helping us on this one.
Settlements / Accounting ([NAME]) - cont'd
4. Cash forecasting reports and enhancements |  | Modify the existing cash forecasting report and/or add additional reports to provide more information necessary for forecasting cash. |  | Would save 10 hours/month.  Is currently done in EnAct and Excel.  Process would be more efficient if keypunching data into Excel was not necessary and reports were provided directly from Unify.  Affects both cash control and forecast provided to Corp. ([NAME]) |  | n/a |  | Cannot estimate at this time. |  | Test team is reviewing specs to present to IT team
5. Desk to desk report enhancements |  | Add the ability to run the existing report by a specified delivery month range. |  | Would save 3 hours/month.  Could run one report for a range instead of a report for each delivery period from 4/99 to current month.  [NAME] is needed to book desk to desk deals. ([NAME]) |  |  |  |  |  | Need specs from users for other report enhancements/rewrite
6. Enhance save-as functionality on list screen details |  | Add the ability to save more detail into an Excel file when using the save-as functionality from the list screen or report menu.  Large sections must currently be broken down into smaller pieces due to Sybase limitations. |  |  |  |  |  | n/a
7. Enhance notification process |  | Current process is not providing intended help.  Need to review issues before prioritizing. |  |  |  |  |  |  |  | [NAME] to coordinate discussion among users & IT.
8. Create a rate structure usage report |  | Create a report that would identify whether or not a rate structure has been used on a final statement. |  | Requested by [NAME] |  |  |  |  |  | Fairly low priority per [NAME].
9. Cosmetic changes to reference price screen |  | Would like short name field to indicate whether the price index is an internal publication.  Would like frequency field to reflect frequency per the rate handle, instead of "daily" for all records as it shows currently. |  | Requested by [NAME].  Would speed up verification process.  Impacts primarily the rates group.
10. Require deal numbers on all manual line items |  | Manual line items can be entered without having to enter a deal number.  Would like to require that a deal be entered on all manual line items. |  | Requested by [NAME].  Missing deal numbers cause a problem for [NAME] reporting, in that necessary information cannot be derived without a deal number. |  |  |  |  |  | Question as to whether everything needs a deal number (taxes, etc.).  Will try requesting users to enter deal numbers before deciding on system enhancement.
Project List-Sitara:
1. [NAME]: ([NAME]) |  | Enhance system to set up multiple deals for the same contract/meter/time period but with different rates.
2. [NAME]: ([NAME]) |  | Once bridgeback is cleared, have system automatically clear the error from the monitor.
Project List-POPS/VM: ([NAME])
1. POPS Enhancement |  | Have the ability to sort "Activities by [NAME]" by deal, counterparty, or track ID.
2. POPS-Reallocate [NAME] |  | Reallocate meter function- create carry forward feature so that coordinator can enter "reallocate immediately" only on day 1 and not have to re-enter for every day of the month.
3. POPS UA4 Report: |  | Need MCF's added to report.
4. POPS UA4 System (creation/enhancement)/VM: |  | Develop process that will calculate accounting UA4 and help to identify discrepancies between physical and accounting UA4.  Currently our systems are only set up to monitor physical UA4.
5. POPS-Automate Joint Venture Reporting: |  | This is currently all done manually on an excel spreadsheet to provide reporting to several internal and external customers.
6. POPS Allocation Exceptions: |  | Identify allocation type on report (I.e. callout, swing, etc.)  Add deal number on call out screen & activity by meter screen.
Project List-POPS/VM: ([NAME])    - cont'd
7. POPS/Settlements Enhancements: |  | Automate imbalance tracking report to an online report.  Currently Settlements and logistics manually maintains a report in Excel w/ information that resides in Unify (contract, imbalance per Settlements, imbalance per customer, BAV information, and comments.)  The report would need to have online update capability for comments and third party numbers…..
8. POPS Enhancement: |  | Ability to copy confirm volumes to actual column. Example: Currently on meter 4132 "Exxon Katy", all but 3 lines within a large number of lines at the meter need to be changed: all others are kept whole.
9. POPS Enhancement: |  | Error report identifying discrepancies between MIPS and the UA4 system.   Currently this is a manual process performed by VM ensure that every meter on the PBR (pipeline balance report) is accounted/allocated to some transport contract in POPS. |  | I realize this would probably require a new interface to be built between those 2 systems, but in the long run the man hours saved would be substantial.
Project List-MOPS:
1. MOPS Enhancement: ([NAME]) |  | Add a column with the initials of the schedulers responsible for each meter.
2. MOPS Enhancement: ([NAME]) |  | Prohibit ability to schedule/path outside deal range.  Tremendous amount of hours would be saved in VM.
3. MOPS Enhancement: |  | When volumes feed from POPS or summary level in the imbalance screen, the volumes should only allocate to valid deal days - (no negative volumes).
4. MOPS fix: |  | Brokered deals do not automatically feed from Imbalance screen Example: (PGEV TX and Oasis).
Project List-Settlements Enhancement: ([NAME])
1. Settlements Enhancement: |  | Have the option to suspend entire invoices or individual lines on an invoice- currently, if there is an entire invoice that needs to be suspended because you have not received a 3rd party invoice or whatever reason, you can not elect to suspend the entire invoice.  Instead you are required to suspend each line individually, line by line.  For larger invoices this can take hours and this month it took one employee 2 hours to suspend PG&E Texas invoices,
2. Settlements- Accrual Report: |  | Develop batch report that identifies changes that have occurred within the upstream systems of Settlements.  This report would consolidate just the variances into one report for sales, transport, and purchases.  Currently during the accrual process, we are re-running all out error reports for all the prior months just to check for any variances (this is now 16 mths worth of data and there may or may not be any changes, but we to currently run the reports just to see if there are any.
3. Settlements- Accrual Reports: |  | Batch job the monthly accrual reports to be printed after the mass draft runs: Missing Services Rates, Sales/Supply Reconciliation Service Reconciliation reports, Interdesk/Interconnect report, etc. |  | This would cut down on the amount of resources and man hours required to run the reports prior to running the accrual.  This would also possibly alleviate the bog down on the system in conflict w/ other users trying to log in during the morning hours: such as (scheduling, settlements, VM, etc.)
Project List-Other:  [NAME]
1. [NAME]:
2. Torque :
3. Hourly Transactions:
4. Bridgeline JV: