SYSPRO case study · Flexible Metal · ERP extension

SYSPRO, extended without touching the core.

Flexible Metal, part of the Hyspan group, manufactures and stocks on SYSPRO. Inventory was tracked partly in spreadsheets, stock didn't always match between the warehouse and the system, and the screens were hard to use. We built an inventory management portal on top of SYSPRO with inventory, purchasing and supervisor approval modules, and left SYSPRO's core exactly as it was.

The project is still in progress, with modules being added. We still support what's live.

Inventory portal · on SYSPRORunning
Barcode and QRreceiving
Warehousesmulti-site stock
Purchasingrequests to receipts
Supervisorsapprovals
Dashboardslive stock
Audit trailevery movement
07:02 Receipt PO received, batch tracked08:15 Transfer stock moved between warehouses09:40 Approval adjustment approved by supervisor07:02 Receipt PO received, batch tracked08:15 Transfer stock moved between warehouses09:40 Approval adjustment approved by supervisor
3 modules live
inventory, purchasing, approvals
The problem

Where stock went out of step.

BeforeWith the portal
Inventory trackingPartly in spreadsheets, with keying errorsEvery movement recorded in one portal, posted to SYSPRO
Physical vs system stockHard to reconcileBatch and serial tracking with a movement log
ScreensHard to use on the floorSimple screens with barcode and QR scanning
ApprovalsInformalRole-based approval workflows with accountability
WarehousesTracked separatelyMulti-warehouse stock in one view
What we built

Three modules, one portal.

Inventory transactions

Stock in and out, transfers, adjustments, batch and serial tracking, and movement logs, with FIFO, LIFO and weighted average valuation.

Purchase transactions

Purchase requests, approvals, orders, receipts and supplier coordination.

Supervisor transactions

Role-based approval workflows and accountability tracking for every change that matters.

How it's built

The stack.

LayerWhat we usedWhy
ScreensMicrosoft Power AppsQuick to build and easy for floor staff to use
Back end.NETBusiness logic and the connection to SYSPRO
IntegrationSYSPRO's own interfacesSo SYSPRO upgrades keep working
ReportingReal-time dashboards and custom reportsLive stock and movement visibility
How we ran it

Four phases, rolled out in stages.

1Phase 1

Plan

Requirements gathered on the floor and the system designed around SYSPRO.

Design
2Phase 2

Build

Modules built and connected to SYSPRO.

Integration
3Phase 3

Migrate and roll out

Legacy data migrated and modules released in phases.

Phased
4Phase 4

Test and release

End-to-end, integration and user acceptance testing, plus inventory reconciliation.

Reconciled
FAQ

About this project.

What did QServices build for Flexible Metal?

An inventory management portal on top of SYSPRO with inventory, purchasing and supervisor approval modules. SYSPRO's core was left exactly as it was.

Which technology was used?

Microsoft Power Apps for the screens, .NET for the business logic and SYSPRO's own interfaces for the integration, so SYSPRO upgrades keep working.

Is the project finished?

It is still in progress, with modules being added, and we support what is live.

Your ERP stays · we don't touch the core

Need more from your SYSPRO?

Find out what to build on SYSPRO first, with the hours behind each item.

Book Appointment
Sahil kataria (1)
Sahil Kataria

Founder and CEO

amit Kumar
Amit Kumar

Chief Sales Officer

Talk To Sales

USA

+1 270-550-1166

flag

+1 270-550-1166

Phil J.
Phil J.Head of Engineering & Technology​
QServices Inc. undertakes every project with a high degree of professionalism. Their communication style is unmatched and they are always available to resolve issues or just discuss the project.​

Turn the Microsoft Licenses
You Already Own Into an
AI Workplace

Join our live webinar on Sept 24 and see five
ways to automate meetings, approvals, and

document search with  tools already in your

tenant.

Assured
Thank You

Your details has been submitted successfully. We will Contact you soon!