AvacPlano: intelligent search over Sage 50c and project management
Intelligent search across thousands of Sage 50c articles, invoices and documents — with semantic AI via Google Gemini, relevance indexing and centralised project management.
Sector: HVAC engineering and construction
The challenge: finding items and invoices in Sage 50c without the code
AvacPlano is an HVAC engineering and construction firm working daily with thousands of articles, suppliers and invoices stored in Sage 50c. Finding the right part for a project, cross-referencing supplier data or recovering an invoice from months ago was slow manual work — someone needed to know the exact code.
The team needed a tool that searched by meaning — not just by code — across the entire ERP history, and that gave a view of ongoing projects without opening Sage for every query.
The solution: AI search over Sage 50c, plus project management
We built an intelligent search layer on top of Sage 50c, with semantic AI via Google Gemini, relevance indexing and a centralised dashboard for project management.
AI semantic search. An engine powered by Google Gemini that finds articles and invoices by approximate description — type the term you know and the system maps it to what Sage has stored.
Indexing and relevance. The entire Sage 50c article base indexed — instant relevance search, with synonyms and typo tolerance.
Direct Sage 50c integration. A connection to the ERP via a .NET API — clients, articles, prices and invoices always in sync, with no stale copies living in parallel.
Project management. A dashboard with status, budget and documentation per project. Each project has its own space with its clients, invoices and files.
Centralised documentation. PDFs, technical specifications and supplier datasheets reachable from the same interface — no jumping between server folders.
Multiple users, with permissions. Engineering, administration and management working at the same time, each with the permissions of their role.
Results: natural-language search across the ERP
Natural-language search. No need to know Sage's exact codes — the AI translates what the user types into what the ERP has stored.
No system hopping. All the information in one interface, instead of switching between the ERP, the file server and Excel sheets.
Always current data. The direct Sage 50c integration means every search returns the real state, never a stale copy.
Questions about the AvacPlano Engenharia case
A semantic engine powered by Google Gemini finds articles and invoices by approximate description: you type the term you know and the system maps it to what is stored in Sage 50c.
Yes. The connection to the ERP goes through a .NET API — clients, articles, prices and invoices stay in sync, with no stale copies living in parallel.
Want a solution like this for your company?