Business intelligence solution presents customer data without delay

The accounts receivable (A/R) department at Virtek Vision International had its hands full. Credit managers at the Ontario-based supplier of laser marking products needed to keep collections up-to-date by identifying those potentially delinquent before they became problems. Until recently, workers relied on spreadsheets that pulled information from the company's ERP system.

05/01/2008


The accounts receivable (A/R) department at Virtek Vision International had its hands full. Credit managers at the Ontario-based supplier of laser marking products needed to keep collections up-to-date by identifying those potentially delinquent before they became problems.

Until recently, workers relied on spreadsheets that pulled information from the company's ERP system. The process was slow, cumbersome, and inflexible.

“We couldn't identify key accounts on one screen, and we didn't have access to certain data,” says Katherine Campbell, corporate controller. “In our ERP system, customer information is in one massive table and the data is located by field, but not labeled. It used to take credit managers an entire day to run the collections report, which was then emailed to those needing it.”

This process is much more efficient since the company deployed a business intelligence (BI) solution from a German company known as AXLE Studio . Using AXLE Studio 2007, credit managers get automatic warnings when an account becomes 45 days past due. The system also identifies which companies should be given restrictions on future orders.

Reports are generated and sent on-demand via email to unit managers.

“Our IT staff is working on getting the reports to run daily automatically,” says Campbell. “We want to enable users to create their own customized reports specific to their product lines. Managers should be able to see their receivables, backlog, and revenue.”

The AXLE system is part of a four-phase implementation process that began last year. It runs on an SQL Server database that also partially supports the BI functionality in Virtek's ERP system. In the future, the company plans to extend the system to include more users; and offer new functionality, including volume of order shipping, global cash reporting, and multiple currencies.

Right now, Virtek is working with Dynac , an Ontario-based value-added reseller for AXLE Studio, to build an extraction layer in the system that creates triggers to pull knowledge from disparate systems and display it in a meaningful way.

“Users can see how many new orders were booked today or how many were changed,” says Gary MacFarlane, Dynac CEO and cofounder. “Instead of having to look up the data in five or six places, the system gives it to them on one screen.”

Since the system is Intranet-based, it does not require any additional hardware or servers. It uses a fat client and is housed within the corporate structure.

Unlike most BI systems, AXLE Studio does not require building a data warehouse, so it's deployed more quickly.

“Data can be refreshed automatically, and query loading can be done at off-peak hours,” says MacFarlane. “Data warehouses typically are refreshed periodically, and often users must wait for current data to be uploaded.”



Laser marking systems specialist Virtek Vision International recently completed a four-phase deployment of an AXLE Studio business intelligence (BI) system. Now BI functionality is supported in Virtek’s ERP system, and cumbersome spreadsheets and reporting processes are part of the past.

Meant for small to midsize businesses, or divisions of larger companies, “The system does not have functionality like regression analysis or extensive statistical analysis tools common to large BI systems,” says MacFarlane. “However, it connects to key data sources such as general ledgers and ERP systems, and links to multiple database tables, and across multiple databases.”

AXLE Studio users can learn to become designers, building their own queries and cubes.

“There's no need for special licenses or extra modules, and users easily can turn functions on and off,” says MacFarlane. “They don't have to build extension modules, as is often required with traditional BI solutions.”

There are nearly 6,000 users of AXLE Studio worldwide, and the company only recently entered the North American market. Dynac represents AXLE in the Americas, offering installation, technical support, and user training.





No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2015 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
World-class maintenance: The three keys to success - Deploy people, process and technology; 2016 Lubrication Guide; Why hydraulic systems get hot
Your leaks start here: Take a disciplined approach with your hydraulic system; U.S. presence at Hannover Messe a rousing success
Hannover Messe 2016: Taking hold of the future - Partner Country status spotlights U.S. manufacturing; Honoring manufacturing excellence: The 2015 Product of the Year Winners
The digital oilfield: Utilizing Big Data can yield big savings; Virtualization a real solution; Tracking SIS performance
Getting to the bottom of subsea repairs: Older pipelines need more attention, and operators need a repair strategy; OTC preview; Offshore production difficult - and crucial
Digital oilfields: Integrated HMI/SCADA systems enable smarter data acquisition; Real-world impact of simulation; Electric actuator technology prospers in production fields
Improving flowmeter calibration; Selecting flowmeters for natural gas; Case study: Streamlining assembly systems using PC-based control; CLPM: Improving process efficiency, throughput
Putting COPS into context; Designing medium-voltage electrical systems; Planning and designing resilient, efficient data centers; The nine steps of designing generator fuel systems
Warehouse winter comfort: The HTHV solution; Cooling with natural gas; Plastics industry booming

Annual Salary Survey

Before the calendar turned, 2016 already had the makings of a pivotal year for manufacturing, and for the world.

There were the big events for the year, including the United States as Partner Country at Hannover Messe in April and the 2016 International Manufacturing Technology Show in Chicago in September. There's also the matter of the U.S. presidential elections in November, which promise to shape policy in manufacturing for years to come.

But the year started with global economic turmoil, as a slowdown in Chinese manufacturing triggered a worldwide stock hiccup that sent values plummeting. The continued plunge in world oil prices has resulted in a slowdown in exploration and, by extension, the manufacture of exploration equipment.

Read more: 2015 Salary Survey

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.
This article collection contains several articles on the vital role that compressed air plays in manufacturing plants.
This article collection contains several articles on the Industrial Internet of Things (IIoT) and how it is transforming manufacturing.
This article collection contains several articles on strategic maintenance and understanding all the parts of your plant.
click me