← All case studies

Integrations · SAP B1 · Pipelines

Smaller automations that removed hours of manual work

A set of integrations and pipelines on top of SAP Business One that turned manual, slow processes into reliable ones.

Key result
~70%
less time in the SAP B1 sync

Case studies are anonymised: client names and data are omitted, and any screenshots use synthetic data.

Context and problem

Several day-to-day processes depended on manual work or on slow synchronisation across branches.

Each of these automations had to be reliable on real ERP data, handle errors and report its state.

My role

PENDIENTEtu rol en cada automatización

What I automated

SAP B1 sync pipeline

Problem
A massive, slow synchronisation of products across branches.
Solution
Redesigned with an orchestrator / worker / callback pattern, parallel tasks, retries and checkpoints.
Result
~70% less sync time, with ~150,000 products across ~30 branches.

Bulk document upload

Problem
Documents of ~500 products each had to be captured by hand.
Solution
Upload of ~500 products per file, with validation of existence and duplicates, and retries and checkpoints per item.
Result
Replaced manual data entry.

Inbound goods distribution

Problem
Each incoming document was distributed by hand in a spreadsheet, taking ~1–2 hrs per document.
Solution
Automated the distribution of incoming goods.
Result
~6 documents a day, saving ~6–8 hrs a day.

Invoice stamping (CFDI) and bulk purchase orders

Problem
PENDIENTEdescribe cómo se hacía antes del proceso de timbrado y carga de órdenes
Solution
Automated both, with error handling and status tracking.
Result
PENDIENTEcifra de impacto, si la tienes

Decisions and discarded alternatives

Sync pipeline architecture

What I chose
An orchestrator / worker / callback pattern with parallel tasks, retries and checkpoints.
Alternatives I discarded
PENDIENTEalternativas que se evaluaron y por qué se descartaron
Why
PENDIENTEpor qué

Architecture

Orchestrator, workers and callback in the SAP B1 sync pipeline.

Results

  • SAP B1 sync Slow, massive sync ~70% less time (~150,000 products, ~30 branches)
  • Inbound goods distribution ~1–2 hrs per document ~6–8 hrs saved per day
  • Bulk document upload ~500 products per file, validated, with per-item retries

Technologies

ERP

  • SAP Business One

Patterns

  • Orchestrator / worker / callback
  • Parallel tasks
  • Retries and checkpoints

Other

  • PENDIENTElenguajes, colas, base de datos y servicios usados

What I would do differently

PENDIENTEqué harías distinto en el pipeline de sincronización

Demo

The pipeline running, with synthetic data.