Leading Hardware Provider Reports the Building of Advanced, Sophisticated Reports with the Help of GL Wand and Wand Reports

Barrette Outdoor Living leverages GL Wand and Wand Reports to build more advanced reports, save time, empower staff, and access live data

Barrette Outdoor Living Main Image

Challenge

After installing SAP in 2003, Barrette used various methods to extract data from the ERP system and create financial reports. These methods were time consuming and the data inevitably ended up in Excel for formatting and presentation, leading the company to consider alternative reporting tools that could expedite reporting processes.

Prior to exploring reporting alternatives, Barrette obtained and transferred SAP data to Excel in several ways. For some reports, data was extracted from the SAP ECC 600 system and a retrieve function was used to populate reports in Excel. For more comprehensive reports, SAP Business Objects was used to get data, after which it was exported to Excel. To build financial statements for shareholders, data was extracted from SAP, sent to Microsoft Access, and then retrieved from Access via an SQL link into Excel. Not only were these methods inefficient, but they also left the finance team dependent on expert skill sets.

Solution

After a comprehensive search and product evaluation, Barrette installed GL Wand in May 2015 and began seeing immediate results. 

“Our monthly consolidation process took half a day using Access and Excel, but with GL Wand it takes about three minutes to retrieve all the information we need,” said Yann Pourchasse, Financial Analyst. “Also, the process is much more transparent with GL Wand and we don’t rely on our Access expert. We expect even more benefits as more reports are converted.”

Barrette is also using Reports Wand to place SAP transaction codes directly into Excel. For example, if a user wishes to review accruals at month’s end without drilling into the postings, Reports Wand can directly retrieve the transaction. This was formerly a cut-and-paste process.

Da Icon Database 2
Consolidation Process Reduced to Minutes

Monthly consolidation process reduced from half a day to a matter of minutes

Da Icon Reporting 2
Sophisticated Reporting

By combining the strengths of GL Wand and Reports Wand, users can easily create sophisticated financial reports

Da Icon Upgrade
Intuitive Reporting

A smooth learning curve for users, including those without advanced database skills