SAP for Utilities - HPC America - SAP FERC Consulting

HPC CEO Jerry Cavalieri to Join SAP Advisory Board of San Francisco State University

2012-01-19T11:17:00.000-08:00

We are pleased to announce that Jerry Cavalieri, CEO of HPC America, has joined the SAP Advisory Board of the College of Business at San Francisco State University. The Advisory Board provides guest lecturers and collaborates with the SFSU Information Systems (IS) faculty to enhance the University's curriculum with respect to SAP and the employability of IS graduates.

SFSU Professor Sam Gill commented that, "Jerry will bring his vast experience in helping organizations implement SAP to the development and implementation of SAP-enriched curricula at SFSU. In particular, Jerry will assist with the integration of SAP into the financial curriculum, which would also also include the implementation of GAAP using SAP. Jerry will also advise on how to extend the SAP curriculum to the use of the Sybase platform (acquired by SAP) to advance mobility solutions."

Open jobs: SharePoint Developer and SAP BASIS Consultant

2012-01-16T13:05:00.000-08:00

HPC is hiring for two contract positions: a Microsoft SharePoint Developer, and an SAP BASIS Consultant. Both roles are for work in the San Francisco Bay Area, so local candidates are a must. Make sure to include a cover letter with your resume that articulates how you'll add value to our team and help delight our customers.

SAP New GL Survey - Share Your Thoughts!

2011-12-19T13:24:00.000-08:00

Create your free online surveys with SurveyMonkey, the world's leading questionnaire tool.

SAP Enterprise Asset Management (EAM) Benefits

2011-11-27T13:45:00.001-08:00

The latest water cooler talk at HPC was about Enterprise Asset Management. By combining elements of Plant Maintenance, Project Systems, Materials Management, and Warehouse Management, SAP EAM enables utilities to realize much higher productivity from PM orders compared to Internal Orders. After setting up a Functional Area hierarchy and identifying the location of all assets, utilities can create orders more efficiently via notifications (what we'd call a "pre-order"). So if the inspection of a pump, for example, identifies necessary corrective maintenance work, the order for that work can be created automatically. Tight integration with the MM module, plus records of prior labor and parts history, also mean that repair kits with all relevant parts can also be identified easily.

For utilities that are considering transitioning from their legacy CMMS to SAP EAM, we would make two particular recommendations. First, ensure that your project team includes subject matter experts from Engineering, Construction, Generation, Transmission and Distribution Maintenance—that is, the people who know what it takes to fix things that break. Their knowledge and requirements will ensure the success of the initiative beyond the needs of IT and Finance. Second, conduct a thorough review of all equipment so that nothing is inadvertently left out of Plant Maintenance. For selected assets, seriously consider bringing in a year or two of work history from the external CMMS.

Document Splitting and the Balance Sheet in SAP New GL

2011-11-15T21:33:00.001-08:00

In all of our previous posts about the SAP New General Ledger, we've only looked at P&L accounts. But what about the balance sheet? Using the New GL will eliminate either the accounts approach or the company code approach to IFRS compliance using SAP. A somewhat complicated feature is the use of document splitting, which we'll touch on next.

Let's suppose a vendor is paid with invoice line items charged to both generation and transmission on the same invoice, but with only one offset to the vendor account on the balance sheet. Using document splitting, the offset account charged to accounts payable is allocated or "split" between the generation and transmission lines. So, if $300 is charged to generation and $500 charged to transmission on the same invoice, the offset for the total of $800 is split to "follow" the P&L accounts that were charged originally. By doing this split, separate balance sheets can be generated for each segment (i.e., generation and transmission) below the company code level. This will save time during document entry, as the preparer doesn't have to be affected by a process change. An employee in Accounts Payable doesn't change his SAP business process. Rather, in the background, SAP will split the transactions entered to create the separation by segment.

Document splitting can be a complicated undertaking and shouldn't be conducted without ample testing. In fact, a utility's New GL conversion scenario should consider the impact of document splitting when determining a migration data and activation date. Since most large utilities can have thousands of open items during a New GL migration, it is suggested—and we highly recommend—to set an activation date as close to the migration date as possible to limit the amount of documents (and line items) that will need to be split.

New SAP for utilities email newsletter

2011-11-02T14:46:00.000-07:00

We've just launched an email newsletter for SAP for utilities professionals to get our latest news and insights. We'll send periodic product updates, customer case studies, white papers, and other tips and tricks on regulatory reporting and enhancing SAP for utilities. We won't share your personal information with anyone outside HPC, and you can unsubscribe at any time. Subscribe to our email newsletter online. If you have any requests for content that we cover, please let us know.

SAP New GL and Cost Models

2011-10-26T15:19:00.000-07:00

We've commented before about the increasing interest we're seeing from utilities in migrating to the SAP New General Ledger. In the context of SAP's recent announcement that ECC 6.0 will be supported until 2020, we expect to see even more interest—and action—since utilities are under no immediate pressure to upgrade. Instead, they can focus on a New GL migration independent of future upgrade plans.

That said, we also notice that some utilities are focusing almost exclusively on the migration itself, and not enough on their underlying cost model. Some aren't thinking about it at all, while others separate, uncoordinated initiatives in the works. This is a serious mistake. Not to discount the care with which a New GL migration must be undertaken, but it's essentially a technical procedure that can be handled smoothly with proper preparation and coordination with SAP. In contrast, there is far greater benefit potential from reassessing the cost model and transitioning from a cost center-centric to order-centric model—in other words, abandoning the approach adopted during 1990's deregulation, and going back to what most utilities did in the 70s and 80s (when they had no choice and regulation was the only business model). Here are a few quick reasons why this makes so much sense:

Cost-centric models are ideal for what we think of as the trifecta of utility financials: budgeting, regulatory reporting, and possibly in the near future, IFRS.

Using the order as the central point means evaluating activity type pricing and unbundling rates, such that the cost of labor going into each order is very close to the actual rate of pay.

By documenting secondary costs in each order, they'll be fully supported and enable easier cost recovery. They will, as we like to say, provide one version of the truth.

We'll revisit this topic in November to discuss some realistic approaches to a managing a cost model project in conjunction with a New GL migration.

Mapping SAP New GL for FERC

2011-10-10T12:29:00.000-07:00

Expanding on our post last month about the New GL and FERC data, today we're going to look at mapping the New GL for FERC, a serious consideration for utilities that are evaluating an SAP New GL migration. One immediate challenge is that all CO transaction codes for secondary movements have a single general ledger account assignment in the New GL. That would seem to be a limitation at first. Rather than focus on the GL account, however, a utility could use a pass-through GL account assigned to all secondary CO transactions, and then use SAP's functional areas to map to specific, four-digit FERC chart of account values.

Here's a practical example. Let's say an internal order has primary costs of $100 and secondary costs of $30. Both the primary and secondary costs are assigned the functional area of "583.0 Distribution Operations-Overhead Lines Expense." This could be shown (in an abbreviated way) as functional area "583.0 DM-Lines." We would then use a BAdI to add a long description through the New GL's extensibility features. The result of this functional area assignment is the posting to the correct FERC account via the CO object mapping. What's more, should the utility want to override the assigned functional area, it could simply change it during document entry. This flexibility would give corporate accounting the option to assign any natural account to any FERC account—with appropriate authorization and controls, of course.

Utilities looking to separate the core functions of supply, generation, transmission, and distribution into segments should also consider activating profit center accounting and segmentation. Since most utilities running FERC have already assigned regulatory indicators to CO objects such as PM and internal orders, these existing assignments could be used to load the initial functional areas using our FERC conversion BAdI described above. In some cases, there might be thousands of CO objects to be mapped to functional areas. Leveraging the existing regulatory indicators would make the conversion effort far less daunting a task than mapping each one individually.

Since segments are derived from profit centers, and profit centers are derived from CO objects, the building blocks would already exist to determine the correct segments. For a utility wanting to convert to IFRS, we could consider segments to be equivalent to traditional lines of business. The CO design in place may already use assessments or settlements to determine the line of business. Given that, it would be important not to start from scratch, but rather to build on the current design and leverage the links already developed in the cost flow model in CO.

Mobility and SAP for Utilities

2011-09-20T14:36:00.000-07:00

As signposted in the first day's keynotes, mobility was a recurring topic during the 2011 SAP for Utilities conference in San Antonio. Deloitte's Lee Ditmar and Mark White presented a well rehearsed message (and super slick Keynote deck) about going beyond the "veneer" of mobility to offer new operating models and services—plus including other information workers in addition to field teams alone. Again, this sounds terrific but highly aspirational; we'll be giving further thought to practical, real world examples that utilities would actually consider implementing. In fact, we'll be doing this next week at Sonoma County Water Agency, as part of our Fleet Management project.

Other notable take-aways: Mark's advocacy of single task-oriented mobile apps that deliver obvious results is another valuable best practice. And we also liked their characterization of descriptive, predictive, and prescriptive analytics—a good framework in which to think about data and actionable behavior in the workplace.

Conveniently enough, Adolf Alesch from IBM closed the loop on some of this theory later on in the conference with his presentation on Mobility Moments℠. He gave a great example of a mobile app that would enable a field team to photograph a transformer, for example, and connect the image and related GIS data to the SAP Asset Master in order to get real-time maintenance records. This "augmented reality" scenario combines a utility's system of record with its system of engagement to generate greater efficiency and better customer service.

GIS and SAP for utilities - MTEMC and Aquarion Water

2011-09-19T15:16:00.000-07:00

Building on last year's great presentation by the City of San Diego, the 2011 SAP for utilities conference included several new examples of GIS' positive impact on utilities' operations and customer service. Middle Tennessee Electric Membership Cooperative (MTEMC) spoke about their integration of GIS and SAP EAM, in which they use GIS for design and SAP for orders, accounting, Compatible Units, and materials. This configuration allows engineers to work more efficiently by staying in GIS instead of switching frequently between the two applications.

MTEMC focused on automating work orders and pick-lists for construction projects; automating fixed asset and expense accounting for GIS-generated projects; and standardizing order create, time and cost collection, and project accounting. By starting with these core elements—for example, two work order templates to cover simple jobs and complex projects‐MTEMC was able to eliminate data chasing and deliver automated, real-time views of inventory. Amidst all of the technical explanations and ambitious goals, Chip Pinion gave a little reality check by noting that, "Linemen want to be linemen, they don't want to work on computers."

Another good example of GIS and SAP was presented by Mark Fois from Aquarion Water, which uses GIS to note critical customers that can be seriously impacted by scheduled maintenance and unplanned events, such as main breaks. Aquarion uses GIS to map designated customers, such as schools, hospitals, and toxic chemical-producing businesses such as hair salons, and keeps this data fresh by contacting customers annually and updating records when move-ins and move-outs occur.

SAP for Utilities kicks off

2011-09-19T06:37:00.000-07:00

Chris Ball's welcome message had a couple of good points about innovation, one of which we interpreted as being that the customer experience of an innovation is just as important as the innovation itself. Great to highlight this. But presenting smart grid and electric vehicles as "disruptive" tech seems a bit aspirational to us at this point. Mobility solutions for sure, though. And it was cool to see screen shots of old SAP R/2 and R/3 interfaces.

Bob Corteau went on to discuss growth, and, reiterating the mobility theme, the concept of "managing anywhere." Compiling information from individuals, new enterprise apps, and external sources will facilitate quick decisions, increased productivity, and better results. His imperative to "sweat your assets" — pursue short-cycle projects, collect data, show a return — is our typical approach to client projects.

So, the emphasis on leveraging new technology sounds great in theory, and we're hoping to hear some concrete, real world examples in the coming sessions. Utilities typically move methodically, so, beyond field teams responding to (or striving to preempt) trouble, we wonder how the ability to make rapid decisions will fit into that context.

SAP New GL and FERC Data

2011-09-07T08:05:00.000-07:00

We're on an SAP New General Ledger roll. Expanding on our prior posts (1, 2, and 3), we had some further thoughts about New GL migration strategy and FERC data. For utilities that have been on the Classic GL and IS-U/FERC module for many years, a New GL migration will certainly not be undertaken without careful consideration and risk management. We recently put together some top-level deployment scenarios that mitigate risk and provide a utility with different options before committing to a specific one for production.

This SAP New GL migration approach retains the existing FERC module, while concurrently developing a prototype of the New GL that shows FERC accounts posted to GL in real-time. We would show finance stakeholders how to render the FERC account assignments to actual New GL line items in the FAGLFLEXT (totals) and FAGLFLXA (transaction) tables. Based on our combined knowledge of the New GL and the existing IS-U/FERC module, we would build a model that shows the actual FERC accounts in the Functional Area field of the New GL. In addition, based on the utility's assignment of regulatory indicators to both internal and PM orders, we could use the actual CO object assignments to regulatory indicators to create a Business Add-In to populate the Functional Areas in the New GL for both primary and secondary cost element assignments. In cases where full FERC_C3 (Trace table rules) apply for assignment of A&G (e.g. account 923 Outside Services), we would deploy substitution rules to assign the correct functional area.

As a result of this prototype, the utility would see a direct integration of CO to FERC for all activity type charges, assessments, and overheads (all CO module allocations) to each FERC account. The utility would gain real-time FERC derivation at the point of document entry. We would also demonstrate how users could overwrite the FERC assignments (a feature some accountants may find useful) during document simulation prior to posting (e.g., transactions FB50N/FB50L).

But that's not all: we could also link all secondary costs to the New GL such that any transaction posted in CO would update the Functional Area postings to capture cost movements between CO objects that affect FERC account assignments in the Functional Area.

Through this migration approach, the utility would have the choice of maintaining its existing FERC module or deploying the real-time, fully integrated New GL solution by reviewing real-world test data before making a decision on which method to use in production. With our prototype, financial stakeholders would see how to present FERC account information as each source document is entered, thereby eliminating a month-end close process to run the FERC trace and drilldown. In addition, the accounting department would be able to override FERC derivation on the fly during document entry and simulation, a feature not available with the classic FERC module.

Why Migrate to the SAP New GL?

2011-08-29T10:52:00.000-07:00

When SAP promotes a new solution, it is usually about something we haven't seen before. So when the New General Ledger solution was announced, we thought, "What could be new about something as basic as the general ledger?" Well, a lot actually. Expanding on our prior posts about the benefits of the New GL and SAP Migration Scenario 1, today we'll explore a few key reasons why a utility already running SAP would consider migrating to the New General Ledger.

First, let's be clear, if you're running the classic SAP FI-GL, you don't have to migrate to the New GL when you upgrade. SAP has made the election to migrate a separate project from an upgrade. If you're getting what you need today from Classic GL, then you can stay put. But before you jump to the conclusion that you just don't need it, here are a few observations and suggestions to consider.

If you've been running SAP for a few years, you probably already know that the Controlling module works together with the General Ledger. In some cases it doesn't. We're referring to the differences between primary and secondary cost elements. CO is used for cost accounting. In the New GL, parts of CO are resident in the New GL. For example, the functional area, profit center and segment are part of the new general ledger table now called FAGLFLEXT instead of the familiar GLT0. Why add these fields to the General Ledger? Well, with the coming of more regulation around the use of International Financial Reporting Standards (IFRS), companies will need base financials on a segment of the business to comply with SEC requirements. A segment can be shown directly in the New General Ledger.

What we really find intriguing is the melding of the traditional Controlling module with the traditionally separated FI-GL. Rather than relegate the FI-GL to merely tracking account balances with links to the CO documents, SAP put CO objects alongside FI-GL accounts in the same table. The result: no reconciliation differences between CO and FI. This in turn speeds-up monthly closing, and makes segment reporting much more streamlined.

Utilities running the IS-U/FERC module can continue to use it with the New GL. FERC will still use CO tables to run the flow of costs trace, trace post, and direct post. The FERC drilldown will continue to store source and final objects in FERC_D1 to support the FERC balances in the new FIGLFLEXT table. But with the New GL, utilities have yet another option: to use the New GL to derive functional areas equivalent to the operations, maintenance, administration and general, and customer accounts expenses to stay in compliance—for example, with Title 18 of the Code of Federal Regulation (CFR) Part 101 for electric utilities.

So what are the advantages to utilities? Well, the New GL offers a way to provide line item FERC accounting for every transaction. Rather than derive FERC at the close of each month, utilities can consider FERC derivation in real time at the point of document entry. Such real time posting to FERC is possible by linking the CO object to a functional area. When charged, the CO object (e.g., internal order, PM order, cost center, or WBS element) will assign the functional area linked to the CO object to a field on the new GL table FAGLFLEXT.

We were skeptical of this approach due to the fact that secondary costs aren't posted to the New GL. Well, indeed they can be, but not as you might expect. Since secondary cost elements result in a net zero impact to the FI-GL (with the one exception of capital orders settling externally) secondary costs can be mapped to a General Ledger account via the CO transaction code. That means that assessments, overheads, and settlement cost elements can be mapped to the New GL. This is important because the CO objects charged with a secondary cost element are assigned a functional area needed for FERC reporting. The functional area from the CO object is thus updated in the New GL.

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

2011-08-16T16:18:00.000-07:00

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

2011-08-09T15:59:00.000-07:00

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

2011-07-29T09:24:00.000-07:00

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

2011-06-10T14:15:00.000-07:00

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

2011-06-02T17:12:00.000-07:00

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

2011-03-29T18:12:00.000-07:00

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

2011-01-18T11:15:00.000-08:00

InsiderResearch recently published a special report on reporting and compliance with FERC and NERC. 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. You can purchase the report directly from WIS Publishing; it's a tremendous value not only for the breadth and depth of information provided, but also for its potential to help you prevent regulatory fines and penalties.

After you've read the report and are ready to enhance your own SAP FERC module, don't hesitate to contact us for some personal insights on improving the accuracy and convenience of regulatory reporting for utilities on SAP.

SAP Enterprise Asset Management, Plant Maintenance and Design Engineering Hierarchies

2010-12-16T10:33:00.000-08:00

HPC America has more client work to share. We're back at one of the largest utilities in the U.S., enhancing a control panel that we had originally developed a few years ago. The control panel comprises most of the functionality the utility needs to accomplish its day-to-day work, as well as manage outage or break down work using SAP Enterprise Asset Management (EAM).

We're now updating the "design engineering hierarchy" of the control panel. It enables users to select the type of work that needs to be performed, including any technical drawings to be attached, and with just a few clicks the program creates all of the required documents and manages their hierarchy. By using our custom design engineering hierarchy, the Plant Maintenance (PM) module's functional location and equipment master is updated timely and accurately without manual maintenance in SAP.

Replacing legacy CMMS with SAP Enterprise Asset Management (EAM)

2010-12-07T10:03:00.000-08:00

A transmission utility company we work with has two separate legal entities, one for Operations and another for Administration. Operations uses ManagerPlus to manage the utility's assets and their maintenance. In order to integrate that data with Administration's SAP FI/CO solution running on ECC 6.0, we're migrating the ManagerPlus data to the SAP Plant Maintenance (PM) module. The end result will be a single, integrated system that enables Operations to manage its maintenance work through PM orders, which collect the hours and rates of the employees performing the maintenance work. The SAP EAM solution will enable maintenance planning, work scheduling and a complete functional location hierarchy for fully-integrated SAP EAM work management and logistics with SAP Financials. By leveraging SAP's deep integration, the utility plans to eliminate time-consuming re-allocations of invoiced O&M work from their separate operating company for streamlined and accurate costing for rate case support.

HPC America Wins Sonoma County Water Agency SAP ECC 6.0 Implementation

2010-11-16T15:07:00.000-08:00

SAP implementation news: We recently signed a contract with Sonoma County Water Agency (Water Agency) to implement and host SAP ECC 6.0. HPC America will oversee the project and help the Water Agency to simplify its current business processes and prepare for future projects that require a robust Enterprise Resource Planning (ERP) infrastructure.

The SAP implementation will initially focus on enhancing critical, day-to-day business processes, including a streamlined time card entry for Water Agency employees, cost and overhead allocation to projects and funds, and a new order management system. Contractor billing, accounting for vehicle and equipment usage, and tracking grants the Agency receives will be addressed subsequently.

The SAP software and hosted servers will replace an IBM mainframe computer application. HPC America's hosted services will enable the Water Agency to take advantage of SAP's benefits without requiring an investment in new hardware and IT staff.

More news to follow in the coming weeks.

SAP Internal Order (IO) Settlement and the FERC module

2010-11-09T10:10:00.000-08:00

We recently had a discussion about Internal Order (IO) settlement and how it impacts the FERC module. In one scenario, a utility uses allocation structures that assign multiple primary cost elements to single secondary settlement accounts. This process results in no alignment of final settled costs in a cost center between the source primary cost elements and the secondary settlement cost elements, which concerns some users. The configuration combines the standard FERC solution results with the final fund ID from the Public Sector (PS) solution.

A question was raised. What would happen if the allocation structures were changed so that all cost elements settle on themselves and eliminate the secondary settlement cost elements? How would that impact the FERC solution?

In this example, the change should not impact FERC. While we do look at the fund assigned to the receiving cost center for each IO, we don't care if the cost elements have changed or are the original ones. When an IO is charged with either primary costs (e.g., materials, contracts, and employee expenses) or secondary costs (e.g., labor and overheads) the FERC solution ignores the settlement transaction in CO altogether. So whether a composite cost element is used for settlement or the original ones are used, settlement is not relevant.

In another scenario, a utility is settling to the original cost elements. There will be more records in the database when crediting the original cost elements. Settlements (and any reversals) will therefore take longer to process. Another drawback to crediting the original cost elements is that it will be harder to find the amount of each cost element capitalized. So if you wanted to see total labor, you would have to look in cost centers excluding the CO settlement transaction—you couldn't simply use the G/L to find total labor, since only the net to expense can be found there. For these two reasons, most utilities use the design in the first scenario, in which one composite cost element is credited for labor, one for materials, etc.

For utilities considering a change in allocation structures, we recommend looking at the budgeting model to see if the budget should be assigned a different set of receiving cost centers from the ones charged for labor. In one scenario we know about, original cost centers receiving the work from the IOs make the CO cost flow very circular. This can confuse users trying to monitor the budget by cost element.

Institutionalize Meter-to-Cash with SAP Meter Data Management and Predictive Analytics

2010-11-01T10:04:00.000-07:00

As utilities face an aging workforce — some analysts estimate 50% will be eligible for retirement in the next decade — it becomes even more important to institutionalize the meter-to-cash process. Done right, executive management will commission a cross-departmental team that looks into every piece of equipment and business process, to document what veteran staff know intuitively but haven't written down.

Within the scope of this significant endeavor, we see two SAP tools that can help utilities prepare for the imminent internal and external sea changes:

SAP Meter Data Management can capture AMI reads from various meter vendors (e.g., Itron and Lyndis+Gyr). This will help prepare for future regulatory tariff changes that require more time-of-use (TOU) metering rate schedule offerings to residential, commercial, and industrial customers.

Predictive Analytics (PA) enables a deeper utilization of Financial Supply Chain Management (FSCM). In our post-recession, high unemployment era, there is a real risk of increasing Days Sales Outstanding (DSO) and on-site collection efforts. Waiting until accounts are delinquent will only exacerbate this situation. Predictive Analytics helps illustrate the characteristics of customer accounts needing payment plans or optional payment methods, such as a push to credit card payment.

SAP World Tour - It's all about mobility, BI, and SOA

2010-10-25T10:14:00.000-07:00

Last week, we attended a local event on the SAP World Tour. Key topics included the future of in-memory computing, computing in the cloud, and mobility. The clear message was that the future is all about the iPad, iPhone, Blackberry, and Android. It's NOT about the desktop. We should expect specific apps that distill SAP software down to core information relevant to each person who needs it, whenever they need it, along with the ability to act on it. Another big takeaway was that during the next decade, we’ll see technology to enable managers to collaborate better with one other both inside and outside their companies. The new middle manager will work with customers and suppliers in real-time, with technologies that remove any semblance of corporate walls.

This is consistent with another key theme we noted at the SAP for Utilities event last month: utility customers will ultimately receive better customer service through more effective use of BI, SOA, and mobile technology.

We expect to see more granular, powerful functionality based on user roles in the future. This will be driven by leveraging Business Objects, by new analytical tools that make captured information readily available and actionable, and by increasing use of mobile devices. Service Oriented Architecture (SOA) will facilitate third-party application integration with SAP while maintaining high security and enabling bi-directional flows of information that previously were not possible without far greater effort and expense.

Given these advancements, the right information will find the right users based on specified rules and real-time analysis of operations. Customers and field crews will be the most obvious beneficiaries of these developments . Work orders, for example, will change in real time based on actual need and geographic proximity, such that the four-hour appointment window disappears. Customers will get what they need faster and with less hassle, and utilities will make even better use of their resources.

SAP's Linear Asset Management and Operation Account Assignments

2010-10-19T11:14:00.000-07:00

At last month's SAP for Utilities event we learned more about two specific enhancements in SAP Business Suite 7 that are particularly interesting to utilities. Linear Asset Management (LAM) for Plant Maintenance enables very granular documentation of assets like power lines and water pipes, such that maintenance (and associated costs) can be tracked to specific portions of the asset instead of the whole entity—for example, a segment of line between two mile markers, or a distinct vertical location on a length of pipe.

With Operation Account Assignments (OAM), utilities will gain useful functionality to assign multiple operational accounts to one work order. Tasks will be allocated to the right accounts, resulting in fewer order numbers, greater flexibility, and detailed information for Finance—without increasing complexity for the field. In fact, when properly implemented, we anticipate that crews will have an even easier time, as they won't have to think about accounting.

FERC's rational response to violations

2010-10-13T09:34:00.000-07:00

In today's issue of APPA's Public Power Daily there's a brief article by Robert Varela on FERC's "rational responses" to violations and fines, in order not to jeopardize smaller utilities. This is consistent with our own experience with FERC on behalf of clients. We've also seen a similarly constructive attitude from RUS, which offers a bi-annual educational conference on accounting for utilities. Everyone seems to recognize that complying with FERC and other regulatory reporting requirements can be a challenge for resource-constrained utilities; the financial data needed either isn't readily available, or it's there but not in the right format. Stay tuned in the coming weeks for a special report on best practices for FERC and NERC compliance. Or take a look at our enterprise solution, which was recently certified by SAP.

GIS and SAP for Utilities

2010-10-01T14:11:00.000-07:00

One of the presentations at SAP for Utilities that we enjoyed greatly was Elizabeth Mueller's on "GeoSynergy." The City of San Diego uses Geographic Information Systems (GIS) to improve customer service and increase operational efficiency.

By integrating GIS into its SAP EAM infrastructure, San Diego is better able to anticipate potential maintenance issues even before customers call to report problems. And when people do call in—for example, to report a street light outage—the City can pinpoint the specific lamp that's broken based on the customer's address, determine if it belongs to the City, and then repair it and close out the work order promptly. Huge ROI here.

GIS also helps field teams to work more efficiently by presenting the relative location of different work orders spatially; instead of relying on a basic list of addresses, crews can see their target sites overlaid on detailed maps, thereby making it easier to understand where to go next to make the best use of the day. We'd expect to see more utilities integrate GIS with their SAP systems to capitalize on opportunities like these, as the business case for them seem highly compelling.

SAP for Utilities conference 2010

2010-09-28T15:19:00.000-07:00

We attended the SAP for Utilities conference in Huntington Beach last week, and were please to run into many colleagues and industry acquaintances. In the upcoming blog posts, we’ll discuss a few hot topics from the show that we found compelling.

In the meantime, allow us a bit of shameless self-promotion. SAP presented its new utility customers at the event, 25% of which HPC America helped win. This is a real testament to the fact that utilities trust our counsel and experience, and that we're able to collaborate effectively with SAP software sales teams.

SAP Certifies HPC Utility Financials Accelerator

2010-09-01T12:15:00.001-07:00

We're pleased to announce that after several months of rigorous testing, SAP has certified our Utility Financials Accelerator (UFA) enterprise software as powered by the SAP NetWeaver® technology platform. HPC UFA is in operation at Navajo Tribal Utility Authority, Arizona Electric Power Cooperative, Trans Bay Cable, and Tacoma Power, and this latest validation of its effectiveness is gratifying. Read our full announcement about the SAP certification or learn more about UFA.

Adding new lines of business to SAP

2010-08-17T07:35:00.000-07:00

We previously wrote about how ARRA has provided millions of dollars to utilities, which presents recipients with the challenge of accounting for those grants. Beyond that, many utilities in rural parts of the country are not only considering investing in their existing infrastructure, but also expanding into new lines of business, such as broadband services, which the FCC has specifically encouraged.

Adding a new business means that SAP will be asked to handle even more data, so its reach needs to be extended for both internal financial and external regulatory views. While every such project will entail customized steps, we see a few that are worth considering:

Apply existing business processes to the new line of business. For example, in CCS (now CRB) add the new utility service to the customer's bill, while maintaining the existing services. Likewise, keep your existing reports, but simply add a new line to them covering the latest service offering.

Turn on SAP's Business Area functionality, to subdivide the Chart of Accounts and create General Ledgers for each line of business

Create dashboards for each line of business with Business Intelligence (BI) to put key financial and operational metrics within easy reach—including non-SAP data that management values for decision-making. Also consider pushing this information out to mobile devices for selected users who are often away from their desks.

We'll report further on this matter in the coming months as we assist HPC customers who are themselves expanding into new ventures.

Smart Meters and SAP AMI Integration for Utilities

2010-08-10T10:03:00.000-07:00

Smart meters have been a controversial news topic during the last year. While the idea of monitoring and pricing energy usage by time of day as a means to foster conservation sounds good, in practice it's generated concern and even backlash. Allegedly inaccurate meters make the evening news, and consumers' lack of understanding of what the technology really means precludes a clear connection between their consumption and their meters.

While raising consumer awareness and managing expectations about smart meters will take time and concerted effort, one tool in particular stands out as being integral to that process. SAP AMI Integration for Utilities holds real promise for improved communication. It can be tied into billing to provide residential customers with more information about their energy consumption and resulting costs. It can be used to identify areas for improvement, for example by advising customers on ways to adjust their usage to decrease costs. Likewise, if the system detects a spike in usage, consumers could be notified and asked to identify the cause in order to understand, if not prevent, its future occurrence.

We're also expecting utilities to have to replace outdated systems with more sophisticated solutions that are compatible with unbundled services (and their associated costs). As regulators require a greater diversity of rate plans to support conservation, and as consumers come to expect utility options that meet their individual needs—much as they do from cell phone and cable television plans—utilities will need to measure, manage, and market their services in increasingly more granular terms.

You watch: we'll bet that 20 years from now we won't even remember how it was done before.

Sustainability and SAP - Start Measuring Now

2010-08-04T12:27:00.000-07:00

In June, we outlined three different sustainability-related products from SAP: Carbon Impact, Sustainability Performance Management (SuPM), and Environmental Health & Safety (EH&S). We're anticipating that regulatory, political, and community expectations will drive utilities to increasingly embrace carbon reduction, and the first step to doing that will be to establish benchmarks based on historical data. (You can't change what you don't measure!) Utilities therefore need to start tracking generation and spend, ideally on a functional department level, and then get that data into SAP. It's not unreasonable to expect that management will be evaluated on its sustainability performance, such that IT, Power Plant, Fleet, and other department heads will have a vested interest in measuring their respective carbon footprints.

SAP Document Printing Optimization

2010-07-21T15:00:00.000-07:00

One of our customers in the nuclear power industry faced daily headaches from printing critical documents with the stock SAP forms (SAPScript). The inherent limitations of that tool for formatting, processing, and development finally became too much to bear, and the customer asked us to develop a better solution.

We solved the problem with coded custom print layouts using Smartforms for key Plant Maintenance (PM) documents, including orders, maintenance plans, and notifications. These layouts allow advanced formatting enhancements that we take for granted in everyday word processing applications—such as indenting, bulleting, and macros to insert predefined text—but that are simply not possible with out-of-the-box SAPScript forms.

As a result of this work, our customer was able to achieve a number of important benefits, including more efficient document creation, formatting, and management; increased readability with fewer errors; and more consistent presentation within and across departments. In addition, the customer is now better able to comply with its regulator's documentation requirements, such as no orphaned signature lines. The Smartforms that we created prevent unwanted line breaks, and enable the utility to print important documents correctly the first time around.

Utilities and SAP Grant Management

2010-07-13T08:55:00.000-07:00

The American Recovery and Reinvestment Act (ARRA) has directed hundreds of millions in stimulus funds to utilities, enabling new projects to get off the ground that otherwise would have never been considered.

What, then, does a utility do to track the grants it applies for and the funds it receives from federal or state agencies? Some utilities are tempted to use an Excel spreadsheet; it's easy to download SAP orders manually, and there's comfort in the application's familiarity. But what are the costs? Let's count them...

    1. Your data is static once you've downloaded it
    2. There's no drilldown functionality for detail support
    3. You can't exclude non-funded costs
    4. You can't summarize accounts into grantor categories automatically
    5. There's a serious risk of manual errors
    6. There's little or no audit capability
    7. There's no document repository

We could come up with additional reasons, but the bottom line is that Excel just won't fly with your external auditor—let alone your grantor, should they want to see how their funds were utilized.

There is a better way. SAP's own Grant Management (GM) module is ideal for tracking every grant dollar received, and it integrates seamlessly with your existing SAP infrastructure (including FM, FI, and CO in particular). GM displays each grant's lifecycle and status, and allows you to establish financial conditions, legal rules, and allowable project expenses.

After Grant Management is implemented, you'll be able to see a running total of the money remaining in each grant, plus have easy access to all of the details for each expense. This degree of transparency makes grant management a no-brainer, and we're recommending that many of our clients consider it seriously. In a future post, we'll get into some of the technical details you should know when implementing the GM module.

Case Study: SAP ECC 6.0 and Smaller Utilities

2010-07-05T11:18:00.001-07:00

Trans Bay Cable (TBC) is a $500 million energy transmission infrastructure project chosen by the California Independent System Operator (CAISO) to provide reliable energy to the City of San Francisco. Selected over a number of alternate solutions, and running a lean operation with a very small staff, TBC LLC required an ERP system that would meet the same FERC reporting standards of traditional utilities.

The outcome? HPC America architected an SAP ECC 6.0 solution that delivered best-in-class functionality with the highest cost efficiency—illustrating a replicable model for other growing utilities that cannot rationalize conventional, big company SAP installations. Read the complete case study.

Part 3: Capital Expenditures and the FERC Module

2010-06-28T09:15:00.000-07:00

Wrapping up our look at the FERC module and capital expenses, we'll use another real-world example.

Let's say we have not one, but two capital orders for the month. The first one has $1M in it. But the second one has $100K posted to it, and it settles to a cost center. Thus, the second order is expense by definition, because all orders settling to a cost center are expensed. Now, let's assume further that the order type is designed for expense. Furthermore, the order was created, but for some unexplained reason, the regulatory indicator never got assigned and was left blank.

When it comes time to run the trace, this second order, having no regulatory indicator, will still need to be translated to the FERC or RUS chart of accounts. The trace is designed with two back-up translation rules in such an event, as follows:

If the regulatory indicator is blank or invalid then:

The trace looks to the responsible cost center on the order.

If found, the regulatory indicator on the cost center (looked-up on CSKS) is used. This will most often be an expense regulatory indicator.

If there is no responsible cost center assigned to the master record on the order (table AUFK), then:

The regulatory indicator is assigned from the default indicator shown on ZFERCR010 (run using ZE_FERCTRACE.) This is the regulatory assignment of last resort.

The assigned default is set to CAPT for all instances.

Our second expense order in this example, having a blank regulatory indicator, would then trace the debits to the Holding Account, but would never get an offsetting credit. Why? Because the order is not going to be capitalized. Rather, the order really should have had another valid O&M regulatory indicator, but it was blank and went to 'CAPT' by default. So there in will sit in the Holding Account without ever getting an offsetting credit for the $100K.

What can you do about such a discrepancy? By looking at results by month, you may find a timing problem between what the trace is saying should be capitalized and when the direct post is seeing the actual settlement.

If you can verify that all five conditions for capital orders are validated, there may be at least one order each month that has a blank regulatory indicator. To pinpoint that, reverse one of the FERC periods for the given year in QAS. When re-running the trace, change the default regulatory indicator to another O&M regulatory indicator. Changing nothing else, run the trace, trace post, direct post, and drill-down as normal. Check the balance in the Holding Account for any change. If it changed, then one of the orders supporting the Holding Account was blank, causing the discrepancy.

Got it all straight? Good, this is not easy stuff. Thoroughly confused? Not a problem, we can help.

Part 2: Capital Expenditures and the FERC Module

2010-06-21T07:55:00.000-07:00

Continuing our look at the FERC module, let's walk through a hypothetical example of the process it uses to settle capital expenditures.

Suppose we have only one capital order for the month. It has $1M of cost in the order prior to settlement. The trace will see the $1M in the order, check that the regulatory indicator is 'CAPT', and use the rule in the trace translation table to convert the $1M to the Holding Account. And there it will sit waiting for a credit. Since the FERC module cannot capitalize costs, it must park this amount somewhere until the CO module (the only SAP module that can capitalize orders) settles the $1M and sends a credit (via the direct post) to the Holding Account. The Holding Account will have a zero balance if the following occurs for this one order:

The order has an order type designed for capitalizing costs.

The order has the regulatory indicator 'CAPT'.

The order has a settlement rule sending 100% of the order costs to CIP or PIS on the balance sheet.

The order settles in the same month the charges were originally posted to the order.

No back-dated charges to the order occurred after the initial settlement (this can be assured by closing the prior period).

If these five conditions above are met, the Holding Account will be zero for the month in our example. But what if it's not? Stay tuned for Part 3.

Part 1: Capital Expenditures and the FERC Module

2010-06-14T11:01:00.000-07:00

This is the first of a three-part posting about tracing capital expenditures and the SAP IS-U/FERC module (which as you may know, HPC America originally developed in 1994). We recently helped a customer troubleshoot some mystery data, and thought our approach would be worth sharing.

When utilities build a new generation plant, overhaul an existing one, or make some other type of capital improvement, the associated work orders are of course capitalized in SAP. The IS-U/FERC module uses a special account to trace all the labor, materials, outside contracts, and employee expenses to a single expense account&mdashwhat we'll refer to here as the Holding Account. Then, to capitalize (i.e., reverse) the costs in the Holding Account, the order(s) are settled, meaning the expense is credited and the capital account on the balance sheet is debited. This happens once at the end of each month.

The order settlement action creates an offset to the Holding Account used by the trace for capital orders. So, in theory, the Holding Account has a zero balance at the close of each month. When that is not the case, it's a sign that something is wrong. Stay tuned for Part 2 for advice on handling such a scenario.

So why doesn't the FERC module just trace to the capital account in the first place and forget about having to clear the Holding Account? Well, the FERC module is not allowed to capitalize costs. Only the Controlling module (CO) can do this. By having only one source for capitalizing costs, the FERC ledger will show the same net income as the natural account ledger used for Generally Accepted Accounting Principles (GAAP) reporting.

As such, the true purpose of the Holding Account is to ensure the total expense dollars are EXACTLY the same between the natural and regulatory (FERC or RUS) chart of accounts. The Holding Account is comprised of two sources: traced costs to regulatory indicator 'CAPT' (usually debits); and direct post costs (usually credits) for all capital orders that settle externally to the balance sheet to either Construction in Progress (CIP) or Plant in Service (PIS). These two sources - trace and direct - happen at different times, hence the difference in the account is always the result of these two processes.

Next time: a real-world example.

SAP Business Warehouse Queries with Virtual Key Figures

2010-06-07T09:08:00.000-07:00

Today we're going to discuss SAP Business Information Warehouse (BW) query techniques for BW users, consultants, and developers.

As you may know, Virtual Key Figures are used to handle complex algorithms and logic within a Bex query. In this linked white paper, we outline a solution that HPC America developed for one of our utility customers to split (i.e. allocate) the common administrative and general costs and common customer accounts expenses in the FERC 900 series of accounts to electric and gas lines of business based on the percentages derived from two look-up tables using FERC account and year/period. It's impossible to achieve this in a regular Bex query, but our solution worked very well.

Since the query does not use the cache when the virtual key figures are used, it can get slow at times. That depends, of course, on the data volume of the cube (or multi-cubes) and other variables, such as the usage of aggregates.

If you're facing a challenging BW coding issue, don't hesitate to get in touch with us directly for some advice. Download the HPC white paper on Virtual Key Figures.

Sustainability and SAP

2010-06-01T10:00:00.000-07:00

Many utilities are well aware of the importance of walking the talk when it comes to being good environmental citizens. With so many green initiatives either in the works or already completed, it stands to reason that organizing, tracking, and reporting progress is as imperative as the actions going on to make a business green.

SAP has addressed this with three key products:

Carbon Impact

Sustainability Performance Management (SuPM)

Environmental, Health and Safety (EH&S)

Carbon Impact is all about tracking and reducing a business' carbon footprint. Utilities that want to set an example for their customers to encourage energy conservation and purchases from renewable sources need to show how they themselves are "being green." They can do this by deliberately tracking their progress on environmental issues. The old saying holds true, "You can't change what you don't measure." SAP Carbon Impact is designed with this goal in mind. SAP acquired a company called Clear Standards Inc. to serve as a Web framework for businesses to organize their progress and report it to internal and external stakeholders. At HPC America, we're looking into greater integration between this solution and SAP ERP and SAP Business Objects, to facilitate updates through better automation.

SAP Sustainability Performance Management (SuPM) is an application for the gathering of data from a variety of sources within an organization. This is a business system designed for middle managers tasked with the execution of their company's policies and objectives to cut CO2 emissions and reduce energy consumption overall, in order to set an example for other businesses as well as the end utility consumer. The application is intended to help measure sustainability-related data and make it actionable, such that managers can transition from analysis to execution more easily.

SAP Environmental, Health and Safety (EH&S) is already part of the Governance Risk and Compliance GRC solution. For many SAP customers, EH&S may be configured and running—but utilities can look to it with renewed interest in pushing the functionality deeper into the organization for more comprehensive coverage.

Within these three solutions, we're anticipating that SuPM will take the spotlight as SAP customers look for a comprehensive tracking and reporting system for sustainability objectives.

What Makes a Rockstar SAP Consultant?

2010-05-27T18:00:00.001-07:00

The diversity of talent within the SAP community is remarkable, from technical specialists and industry experts to problem solvers and instructors. We were recently speaking with a customer about his experience with SAP consultants, and I started thinking about what distinguishes the truly great ones. Obviously this depends to some extent on what you value in a consultant (again, there's so much diversity) but four attributes of SAP Rockstars stand out.

Rockstars are technically and functionally competent. They know all of the relevant coding languages used to solve SAP challenges. ABAP, BAPI, Java, WSDL, and Object Oriented Programming fly from their fingers. They understand SAP functionality and know how to configure many modules, too. Because they can pick the right tool for the job at hand, their solutions not only work well, but also are often more elegant.

Rockstars aren't fazed by vague requirements. In fact, they may even relish the challenge of developing a detailed spec or proof of concept based on an unwritten request mentioned in passing by the water cooler. This skill comes from a learned and/or intuitive awareness of what end users really want to achieve, and how to accomplish that in SAP.

Rockstars communicate effectively with everyone. When they're across the conference table from a Director, they talk ROI; an hour later over lunch with a developer, they get into coding and assurance tests. Both audiences feel understood.

Rockstars increase productivity and efficiency. As a result of their knowledge, flexibility, and communication skills, Rockstars make a hugely positive impact on a project's outcome. They may cost (a lot) more than less experienced counterparts, but their strengths translate into far more efficient decision-making and productive development. And that often pays for itself many times over.

The next time you're evaluating a team of SAP consultants, keep an eye out for the Rockstar among them; he or she could be just the candidate your project needs to succeed.

IS-U/FERC -- Without a trace!

2010-05-26T09:45:00.000-07:00

If you're like many utilities running the SAP IS-U/FERC solution, it's time to consider turning it off. Say what? That's right, just turn it off and get even better data than you're getting now.

When you change the FERC setting in FERC_C8, you'll see options to treat secondary costs as primary. Just changing CO activity types (normally secondary cost elements) to primary for FERC reporting allows you to support FERC account balances with labor documents from CO — where often the employee name, hours worked, and PM order number are found. Imagine that; for the first time, a financial analyst will see each utility employee charge to an actual FERC account.

I've tried this and it works well. First you update V_FERC_C8 in transaction SM31. Make all the secondary cost transactions primary (ECC 6.0 has radio buttons for this) except for settlement, which stays as a secondary cost. Then assign each cost center to a regulatory indicator. Finally, update the trace translation (FERC_C3) to include secondary cost elements converted to FERC accounts.

The FERC trace will run faster, provide more accurate labor costs and assessment detail, and provide enhanced drill-down using FERD or FEOD transactions. If you have SAP HR/Payroll and PM installed, you can see the work center of the employee, the time confirmation, and the notification in PM. You can't do that by using the FERC module with the traditional trace of FI documents only.

So why didn't we think of this before? Well, for one thing, CO is not the general ledger. It was thought that FERC balances have to be supported by FI documents only. In reality, provided the FERC balances equal the natural accounts, it really doesn't matter whether FI or CO documents are used to support FERC. So, free yourself from the limitation of FI only, and unleash a new era of improved FERC reporting in SAP.

It's time to turn off the trace! If you do, users will have one source of the truth whether running order reports in CO or looking at the final objects in FERC_D1 (the FERC module drill-down tool.) Even better, this refreshing approach can be accomplished within the existing SAP FERC solution.

Give it a try, and let us know if you have any questions.

SAP for Utilities: Best practices, real-world results, and industry insights

2010-05-26T09:24:00.000-07:00

On any given day in the office, we're talking with customers, business partners, and our internal team about how to best address the SAP-related issues that utilities face — from accounting and billing complexities, to the challenges of reporting to external auditors and government regulators. As you can imagine, after more than 15 years of developing and managing SAP solutions for utility companies across the country, including the original IS-U/FERC module in 1994, we've got a lot of substantive stuff to discuss.

Unfortunately, many of these great ideas aren't as well documented as they could be; once the conference call or hallway conversation is over, they're gone, back in our collective heads.

No more. We're going to blog about our work, experience, and insights. We'll strive to make this space on the Web informative and useful for specific individuals at utilities running (or considering) SAP: executive management, plus accounting, finance, and IT professionals. Most posts will be written by HPC America's CEO, Jerry Cavalieri, with periodic contributions from our team of SAP senior solutions architects. And maybe even a guest or two from one of our utility customers.

So, thank you for reading and checking back every week or so. Please don't hesitate to contact us if you have any suggestions or questions.