Updat SA: Cutting update time into SYSPRO from days to hours

Upat South Africa distributes international fixing and fastening brands for the building industry. The company imports thousands of products and tracks location and landed costs in an internal system, while SYSPRO handles sales and accounting.

The Challenge

Get import data into SYSPRO fast and accurately

Imported goods data had to be captured in SYSPRO so that products could be sold and accounted for. The manual process took over a week per container and involved:

  • Extracting stock items and counts from consignment data
  • Allocating costs to suppliers and agents
  • Capturing everything into SYSPRO by hand

“In the type of sales environment we operate in, the quicker a product is available on SYSPRO, the quicker it can be sold,” said Wayne Weber, Operations Manager at Upat SA.

Import data bottleneck

The quicker a product is available on SYSPRO, the quicker it can be sold,” said Wayne Weber, Operations Manager.

Automated SYSPRO imports

A Flowgear workflow now queries the internal import system, detects new data, and triggers SYSPRO updates automatically without any manual capture.

The Solution

Automate imports processing and trigger updates on new data

Upat implemented a Flowgear workflow that queries the company’s imports system and triggers SYSPRO updates whenever new data is detected.

What changed:

  • Container delivery data is ingested automatically
  • Items, counts, and cost allocations are prepared for SYSPRO
  • The workflow runs without manual capture

The Results

rom more than a week to under two hours

The time to update a container’s data into SYSPRO dropped from over a week to less than two hours.

B
enefits:

  • Products become available for sale much sooner
  • Fewer errors compared with manual entry
  • Existing staff are freed up for higher value work rather than data capture

“It’s the best investment I ever made,” commented Weber.

From a week to hours

It’s the best investment I ever made,” said Weber.

Update time dropped from over a week to less than two hours, making products sale‑ready faster.

Extending automation

Next: automate inventory picking and packing updates into invoices using the same event‑triggered approach.

Looking Ahead

Next: automate invoicing with, event driven updates.

With the imports workflow in place, the next phase is to automate the process of updating inventory picking and packing data into invoices, building on the same event triggered approach.

Flowgear, Africa’s cloud-based integration platform provider, has enabled Upat South Africa to ensure quick and accurate updates of imported goods data into SYSPRO. Importing thousands of fixing and fixture products for the building industry requires a good system for tracking the whereabouts and costs of the imported products. Upat South Africa, a leading distributor of international building and allied construction brands, had developed such a system, but it also needed to have that data in its SYSPRO ERP to manage the information for sales and accounting purposes. “In the type of sales environment we operate in, the quicker a product is available on SYSPRO, the quicker it can be sold,” said Wayne Weber, Operations Manager at Upat SA. Initially the update process was done manually and could take over a week. It involved getting data from consignments, comprising actual stock items and counts, and costs allocated against suppliers and other agents, then capturing that into SYSPRO. By implementing a workflow on the Flowgear integration platform, the time to update data from a container delivery into SYSPRO took less than two hours. Using Flowgear, the process of querying Upat SA’s imports system is automated and a Flowgear workflow is triggered whenever new data is detected. This has enabled the company to use its existing staff in far more useful ways than just entering data. “It’s the best investment I ever made,” commented Weber. Having proved the value of Flowgear in one business area, Upat SA are planning for the next phase – to automate the process of updating inventory picking and packing data into invoices.
Play Video
Flowgear excels against Magic Quadrant leaders
See what Gartner, G2 Crowd, SourceForge and Slashdot have to say.

The iPaaS market is growing exponentially as businesses seek ways to connect disparate systems and optimize workflows. Flowgear iPaaS enables businesses of all sizes to shed the workload & complexity of Data and App-to-App integration, quickly & affordably.

Flowgear was recently featured as a key player in the iPaaS industry in an insightful article by Fortune Business Insights.

iPaaS market valued at USD 10.70 billion in 2023. Projected to grow from USD 12.87 billion in 2024 to USD 78.28 billion by 2032, exhibiting a CAGR of 25.3%

GPI logo
|

“The Flowgear platform is easy to understand and easy to learn. It is very use full to build IPAAS integrations.”