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.
- CATEGORY
- Web
- STACK
- ASP.NET Core
- LOGO REST API
- EF Core
- SQL Server
- Serilog
- NOTES
- Excel import · LOGO REST API · multi-tenant
- Excel fileper-company columns
- Column mappingsynonym dictionary
- Counterparty matchTC / VKN
- LOGO REST APIledger posting
01Problem
Producer receipts (purchase documents from agricultural producers) were kept in Excel by accounting teams and entered into LOGO ERP by hand. Every company had a different column layout; matching by tax ID and posting to the ledger was slow and error-prone.
02Solution
I built a multi-tenant portal with ASP.NET Core: the user uploads an Excel file, the system recognizes columns through synonym-dictionary based mapping, matches counterparties in LOGO by tax ID, and posts the receipts to the LOGO REST API through a queue.
03Technical Details
- Synonym-dictionary based column mapping (adapts to different Excel templates)
- Automatic LOGO counterparty matching by tax ID
- Queue-based background workers: import → LOGO reconcile → cleanup
- Structured logging with Serilog, health monitoring with HealthChecks
- Multi-tenant architecture (v1.5)