Astera Case Studies GaP Solutions uses Astera ReportMiner to process invoices within 3 minutes

Edit This Case Study Record

	GaP Solutions uses Astera ReportMiner to process invoices within 3 minutes Astera

GaP Solutions uses Astera ReportMiner to process invoices within 3 minutes

Astera

Technology Category	Analytics & Modeling - Data-as-a-Service Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Retail
Applicable Functions	Business Operation Procurement
Use Cases	Inventory Management Supply Chain Visibility
Services	Data Science Services System Integration
Challenge	GaP Solutions, a retail solutions provider, was facing challenges with its invoice processing system. The company received around 3,000 invoice variations from vendors in various formats, all containing unstructured data that needed to be transformed into a structured format for further processing. The company had to process 6,000-10,000 files monthly, with employees manually inputting invoice data into their store systems for payment processing, reporting, analysis, etc. The existing invoice processing approach was inefficient and slow, leading to higher processing order time. GaP Solutions tried multiple data extraction solutions but experienced several issues pertinent to data transformation and quality. The company couldn't afford sub-optimal data extraction performance as it would lead to inaccurate payment processing and reporting. Read More
About Customer	GaP Solutions is a point of sale & retail management software developer, systems integrator, supermarket, food processing, and weighing equipment supplier. Based in Australia, the company is recognized as the foremost innovator of retail solutions. GaP Solutions provides custom software and hardware solutions to clients across a range of industries. The company has installed more than 4,000 POS systems in 1,000 stores all over Australia. GaP Solutions receive around 3,000 Invoices variations from vendors in various formats. These invoices contain unstructured data that needs to be transformed into a structured format, i.e., columns and rows, for further processing. Read More
Solution	After trying multiple data management software, GaP Solutions selected Astera Report Miner to eliminate manual efforts and fully automate invoice processing. Astera ReportMiner is designed to cater to a variety of data extraction jobs as it supports multiple data formats. It enabled GaP to fully automate the data extraction process by helping them implement a document management transformation system that fetches invoice files directly from emails, extracts the required text fields into XML, and sends it for fact-checking and validation. ReportMiner's template-based extraction allow GaP to capture a set defined fields from each invoice, such as invoice id, vendor name, total cost, and a table for breakdown of cost. The company reuse the report model for invoices that share the same structure and layout. Using ReportMiner's built-in transformations, GaP easily manipulate and transforms data in the desired format. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Data-as-a-Service

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Retail

Applicable Functions

Business Operation

Procurement

Use Cases

Inventory Management

Supply Chain Visibility

Services

Data Science Services

System Integration

Challenge

GaP Solutions, a retail solutions provider, was facing challenges with its invoice processing system. The company received around 3,000 invoice variations from vendors in various formats, all containing unstructured data that needed to be transformed into a structured format for further processing. The company had to process 6,000-10,000 files monthly, with employees manually inputting invoice data into their store systems for payment processing, reporting, analysis, etc. The existing invoice processing approach was inefficient and slow, leading to higher processing order time. GaP Solutions tried multiple data extraction solutions but experienced several issues pertinent to data transformation and quality. The company couldn't afford sub-optimal data extraction performance as it would lead to inaccurate payment processing and reporting.

About Customer

GaP Solutions is a point of sale & retail management software developer, systems integrator, supermarket, food processing, and weighing equipment supplier. Based in Australia, the company is recognized as the foremost innovator of retail solutions. GaP Solutions provides custom software and hardware solutions to clients across a range of industries. The company has installed more than 4,000 POS systems in 1,000 stores all over Australia. GaP Solutions receive around 3,000 Invoices variations from vendors in various formats. These invoices contain unstructured data that needs to be transformed into a structured format, i.e., columns and rows, for further processing.

Solution

After trying multiple data management software, GaP Solutions selected Astera Report Miner to eliminate manual efforts and fully automate invoice processing. Astera ReportMiner is designed to cater to a variety of data extraction jobs as it supports multiple data formats. It enabled GaP to fully automate the data extraction process by helping them implement a document management transformation system that fetches invoice files directly from emails, extracts the required text fields into XML, and sends it for fact-checking and validation. ReportMiner's template-based extraction allow GaP to capture a set defined fields from each invoice, such as invoice id, vendor name, total cost, and a table for breakdown of cost. The company reuse the report model for invoices that share the same structure and layout. Using ReportMiner's built-in transformations, GaP easily manipulate and transforms data in the desired format.

Impact #1	Astera ReportMiner's robust automation capabilities not just eliminate the manual work and dramatically speed up the invoices processing activity.
Impact #2	The accurate and reliable data extracted from invoices is securely transferred to Amazon S3 with an encrypted path for reporting and analytics.
Impact #3	GaP uses ReportMiner to complete the integration process overnight and make the data available in a report-ready format before the start of the workday.

Impact #1

Astera ReportMiner's robust automation capabilities not just eliminate the manual work and dramatically speed up the invoices processing activity.

Impact #2

The accurate and reliable data extracted from invoices is securely transferred to Amazon S3 with an encrypted path for reporting and analytics.

Impact #3

GaP uses ReportMiner to complete the integration process overnight and make the data available in a report-ready format before the start of the workday.

Benefit #1	Processing an invoice took 24 hours, but ReportMiner cut down this time to under 3 minutes.
Benefit #2	Automated stock replenishment systems, so their customers can update inventory almost immediately rather than waiting 24 hours.

Benefit #1

Processing an invoice took 24 hours, but ReportMiner cut down this time to under 3 minutes.

Benefit #2

Automated stock replenishment systems, so their customers can update inventory almost immediately rather than waiting 24 hours.

Download PDF Version

Overview

GaP Solutions uses Astera ReportMiner to process invoices within 3 minutes

Operational Impact

Quantitative Benefit