Projects

Web

ESBI-Mustahsil — Excel → LOGO Receipt Portal

A multi-tenant portal that reads producer (müstahsil) receipts from Excel and posts them to the LOGO ERP REST API. Built solo, shipped to v1.5.

v1.5 · smart column mapping · multi-tenant

ASP.NET CoreLOGO REST APIEF CoreSQL ServerSerilog

Problem

Producer receipts (purchase documents from agricultural producers) were kept in Excel by accounting teams and entered into LOGO ERP manually. Every company had a different column layout; matching by tax ID and posting to the ledger was slow and error-prone.

Solution

I built a multi-tenant portal with ASP.NET Core: the user uploads Excel, the system auto-recognizes columns via a synonym-dictionary based smart mapping, matches counterparties in LOGO by tax ID, and posts the receipts to the LOGO REST API through a queue.

Highlights

  • Synonym-dictionary based smart column mapping (adapts to different Excel templates)
  • Automatic LOGO counterparty matching by tax ID
  • Queue-based background workers: import → LOGO reconcile → hard-delete
  • Structured logging with Serilog, health monitoring with HealthChecks
  • Multi-tenant architecture, matured to v1.5 with disciplined releases