SAP New GL Migration via SAP Scenario 1: Merging FI Ledgers

A couple weeks ago we wrote about the benefits of migrating to the SAP New General Ledger for utilities on SAP. SAP best practices outline five different General Ledger migration scenarios that offer increasing amounts of functionality—and corresponding complexity. For utilities looking for an efficient approach, we recommend the least costly and complex, "Scenario 1: Merging of FI Ledgers."

In this scenario, the classic General Ledger (Ledger 0) is migrated. Table GLT3 of the consolidation preparation (Ledger 09) is migrated as well if it's in use. When we work with clients on SAP New General Ledger migrations, we evaluate whether to assign profit and loss accounts from the 8A ledger or to form Ledger 0.

Depending on the utility's financials, we may recommend an "accounts approach," taking all accounts from Ledger 0. In our experience, profit center accounting (PCA) will not, nor should not, drive the migration project. Rather, PCA is planned during blueprint. Configuration changes are made as required, and then PCA is re-introduced to PRD in the new year. What we mean by "re-introduced" is a new way of tagging the PCA to the CO object using the FMDERIVER.

This approach allows our customers the most flexibility to change the PC assignment to the internal order later on. This is especially helpful to utilities that also use SAP Funds Management (FM) since the fund assignment can be updated in the FMDERIVER as well. Our latest solution, HPC Utility Financials Accelerator, automates these updates with an Excel upload program to make maintenance incredibly simple, even on a very large scale.

While there are other, more complex migration scenarios that involve segment reporting and some form of document splitting to parse the balance sheet line items to enable business area financials at a line item level, we don't often recommend them to our customers who are already running HPC Utility Financials Accelerator. For those utilities, business area reporting by balance sheet can be accomplished for all company codes using UFA's expanded functionality. Once migrated, the FERC drill-down feature in UFA is updated to source the FERC account balances from the new FAGLFLEXT table in the SAP New GL.

2011 SAP for Utilities Conference

HPC America will be attending the 2011 SAP for Utilities conference in San Antonio, Texas on September 18-20. If you'd like to meet with us to discuss implementation and enhancement of your SAP IS-U/FERC module or any other issue concerning SAP for utilities, please give us a call to set up an appointment.

We'll also have some updated information to share about our latest solution for utilities on SAP, HPC Utility Financials Accelerator, which goes beyond the capabilities of the FERC module that we originally created, which SAP acquired from us in 1996. HPC UFA is in production at four utilities across the U.S., and was certified by SAP in 2010 as powered by the NetWeaver technology platform.

Learn more about our development of the SAP IS-U/FERC module and HPC Utility Financials Accelerator.

SAP New GL Migration Benefits

HPC has implemented SAP's New General Ledger—a.k.a., the SAP New GL—at several utility companies, and we've noticed that it's under even greater consideration these days, as utilities seek to eliminate the reconciliation steps necessary under the Classic GL.

In our experience, the SAP New GL offers terrific benefits for utilities running the IS-U/FERC module and IS-Public Sector (PS-FM) in the same ECC 6.0 client—two modules common to the public power industry. Implemented properly, the SAP New GL can dramatically shorten the processing time for the month-end allocations such as distributions, assessments, and overheads

In many cases, existing SAP customers on the FERC module can migrate to the New GL with the delivered leading ledger (OL) by SAP without having to create a new parallel ledger. This process works because the FERC module is an FI-GL solution, as opposed to a special ledger solution as some other industry-specific solutions have been designed.

We also have good experience combining non-FERC company codes with FERC-relevant company codes to consolidate reporting for profit and loss (P&L) statements and balance sheets.

While some utilities are driven to migrate to the New GL because it speeds up month-end closing by reducing the number of updates required to keep FI and CO in sync, there are other reasons to undertake a New GL migration. Implementing the New GL with the FERC module is ideal, as it provides access to FERC data in real time; what you see in your orders will also appear in your FERC regulatory reports. You get "one version of the truth" as we like to say, with the same codes and no special month-end processes required.

East Coast Utility Purchases HPC Utility Financials Accelerator

We're very pleased to announce that another utility has purchased HPC America's Utility Financials Accelerator. HPC UFA integrates with SAP® solutions to help utility companies address today's more stringent regulatory reporting standards, and provides management with increased audit transparency and rate case support. In 2010, HPC UFA achieved SAP certification as powered by the SAP NetWeaver® technology platform.

Part of our team will be spending the summer in the Mid Atlantic to implement UFA for our customer. The project's goals include the following:

• Allocate costs charged to FERC accounts to transmission and distribution lines of business and state jurisdictions


• Create a controlled report distribution process with less reliance on Microsoft Excel


• Increase flexibility to use accepted cost allocation models for FERC accounts in SAP


• Provide enhanced regulatory drill-down functionality in native SAP ECC 6.0

HPC UFA is already in production at Trans Bay Cable, Arizona Electric Power Cooperative, Navajo Tribal Utility Authority, and Tacoma Power.

Phased SAP Implementation Generates Big Bang Results at Sonoma County

Last November, we announced that Sonoma County Water Agency had selected HPC America to implement SAP ECC 6.0. The project has been intense but smooth; in fact, the Water Agency completed blueprinting, realization, and go-live of its SAP license in just eight months.

This initial phase focused on enhancing critical business processes, including streamlined time card entry, cost and overhead allocation to projects and funds, and a new order management system that improves managerial visibility into business operations.

The project was successful for many reasons: the Water Agency had a truly dedicated project manager; key staff recognized the long-term benefits SAP could deliver; and our phased approach built foundational user acceptance. As a result, the implementation stayed on schedule and budget, and the Water Agency now enjoys functionality its county does not provide. It also caused stakeholders to think about their business differently and authorize the next phase of SAP implementation.

Overall, Sonoma County Water Agency is a real testament to how a smaller utility with modest resources can implement SAP successfully while still meeting the strict requirements of its municipality and contending with decades-old legacy systems. Stay tuned for a full case study later this year.

City of Palo Alto Awards HPC America Financial Supply Chain Management Contract

HPC America will be leading the City of Palo Alto's implementation of a collections management solution in SAP. Our approach will enable the City to create and maintain customer master data records efficiently and thoroughly; to automate the collections and dunning processes; to facilitate the handling of disputes and maintain coordination with external collections agencies; and to access user-friendly reporting on account history, collections data, and advanced collections analytics.

We're looking forward to working with the City on this important, revenue-generating element of municipal operations, and will share more news in the coming weeks.

FERC/NERC compliance report from InsiderResearch

InsiderResearch recently published a special report on FERC and NERC reporting and compliance. The 42-page study is packed with survey data from utility companies, best practice advice, and a chapter from HPC America on optimizing the SAP IS-U/FERC module for today's regulatory and management requirements. The report has great potential to help you prevent regulatory fines and penalties.

When you're ready to enhance your own SAP FERC module, please contact us for some personal insights on improving the accuracy and convenience of regulatory reporting for utilities on SAP.

Update: Request our white paper on enhancing the FERC module's configuration.