L.A. government struggling with new inventory system
Computerworld - The Los Angeles Police Department would have had to write a lot of tickets to break even after it got a $750,000 invoice for new citation books that should have cost just $7,500. The culprit: incorrect data entered into a new procurement and inventory-management system that Los Angeles' city government began using in January.
And the Police Department isn't the only agency that's having problems with the $11 million system, which is based on PeopleSoft Inc.'s enterprise resource planning (ERP) applications. City officials this week confirmed that multiple departments have voiced complaints about inadequate end-user training and help desk support, resulting in billing problems, late payments to suppliers and inventory shortages.
"The [system] was meant to speed things up and save money," said Laura Chick, a member of the Los Angeles City Council and the incoming city controller. "So far, we are not reaching all the goals we have set. There's a laundry list of problems." Chick and other city officials noted that training, or a lack thereof, is the major cause of the problems.
The city is using PeopleSoft's procurement, inventory-management and accounts payable modules. The applications have "bugs like every software package, but we've [reported] them to PeopleSoft, and they've been good at turning them around," said Bob Jensen, assistant general manager of the city's General Services Department.
Jensen, who's overseeing the project for the city, wrote in a report dated May 9 that problems with PeopleSoft's inventory module "have resulted in inaccurate shelf counts" of some supplies. Manual processes for doing the counts have since been implemented, he said, adding that other bugs related to receiving and inventory-replenishment procedures were mostly resolved earlier this month.
But Jensen said this week that the software bugs aren't to blame for most of the start-up pains being felt with the new system. "The procurement problems have to do with people problems," he said. In one case, Jensen noted, employees unfamiliar with the system populated PeopleSoft tables with inaccurate data, causing glitches.
According to a memo issued last Friday by the city's Office of Administrative and Research Services, many departments indicated in detailed reports "that additional training on the new system needs to be provided" to their workers. Jensen said extensive training programs are already offered on an ongoing basis, but he added that more training is planned.
The design of the new system and many of the employees who are using it have changed since the initial training was done, Chick said. In addition, she said, some departments don't have



- Excel 2010 Cheat Sheet
- Register for this Computerworld Insider Cheat Sheet and gain access to hundreds of premium content articles, guides, product reviews and more.
- Overcome Top 7 Admin Challenges of Active Directory
- As Active Directory's role in the enterprise has drastically increased, so has the need to secure the data. Gain insight on creating repeatable,...
- Insiders Can Ruin Your Company. Take Action.
- Did you know that 80 percent of threats to an organization come from the inside? The threat from insiders is often overlooked in...
- Top Solutions and Tools to Prevent Devastating Malware
- Custom malware frequently goes undetected. According to Forrester Research, the best way to reduce risk of breach is to deploy file integrity monitoring...
- Streamline Compliance and Increase ROI
- Streamline, simplify, and automate compliance related activities; especially those that impact multiple business units. This white paper from NetIQ, outlines solutions that will...
- X-Ray of the PCI Process-4 Proactive Steps
- This white paper from Forrester Research Inc., helps break PCI into understandable components. Security and risk professionals will gain knowledge and insight into... All ERP White Papers
- Optimizing Networks for the Cloud
- Join guest speaker, Rohit Mehra, IDC Director of Enterprise Communications Infrastructure, to explore current trends, discuss best practices for optimizing Data Center and...
- Apps QuickStart Series Part 2: Designing and Deploying SQL Server on VMware vSphere
- Download this webcast to learn about the design considerations for virtualizing SQL workloads, performance and scalability information and high-availability options, as well as...
- Apps QuickStart Series Part 1: Designing and Deploying Exchange 2010 on VMware vSphere
- Download this webcast to learn the virtual hardware design considerations for Exchange 2010, deployment using the building block approach, options for high-availability and...
- Customer Spotlight: How IPC The Hospitalist Company Implemented Oracle on VMware
- Have you been looking to hear about customer's experiences with the new VMware vCenter Site Recovery Manager product? View this webcast to learn...
- Virtualize Business-Critical Applications with Confidence
- Virtualizing business-critical applications has become a key focus for organizations as they move along their virtualization journey. With the launch of VMware vSphere®... All ERP Webcasts