OpenRFID ERP Gateway: Open-Source Tally & SAP RFID Connector
Open-source Python and Node.js starter scripts for translating LLRP and handheld RFID tag scan streams into Tally Prime XML, SAP Service Layer JSON, and REST Webhooks.
Try Live RFID-to-ERP Integration Sandboxes
Test real RFID tag streams, TDL XML envelopes, and SAP OData payloads directly inside our interactive browser testbeds before writing backend integration code:
TallyPrime Live RFID Integration Tester
Test real-time RFID Stock Journals, Physical Stock counts, and ledger synchronization with your local TallyPrime (Port 9000). Run safe read queries and inspect raw TDL XML responses with zero accounting risk.
SAP S/4HANA & B1 Live RFID Tester
Verify SAP Service Layer OData v4 JSON payloads, Goods Receipt PO (GRPO), and Goods Movement 101/311 BAPI transactions without waiting for live ERP server downtime.
Zoho Inventory Live Webhook Tester
Simulate dock door pallet scans, batch array slicing, and automated inventory adjustments via Zoho OAuth 2.0 Webhooks and Fastify payloads.
Project Overview & Architecture
Proprietary RFID-to-ERP connectors often demand expensive per-terminal licenses and recurring middleware contracts. The OpenRFID ERP Gateway is a production-grade, MIT open-source integration bridge designed to connect physical RFID tag streams directly to TallyPrime, SAP S/4HANA, and Microsoft Dynamics 365. Built with a high-throughput C# / .NET 8 runtime, the gateway includes built-in sliding-window deduplication, Tally XML Port 9000 envelope builders, and resilient offline SQLite queues to guarantee zero dropped scans during ERP network outages.
4-Tier Edge Pipeline Architecture
LLRP & Reader Listener
Establishes asynchronous TCP sockets to fixed readers (Impinj, Zebra) or HTTP listeners for Android handheld batch posts.
Ring-Buffer Filtering
Eliminates dock door multipath duplicates using a 3-second sliding window ring buffer to ensure 1 transaction per physical asset.
SQLite WAL Queue
Guarantees zero-data-loss during ERP server maintenance or network drops by writing transactions to local disk.
TDL XML & OData JSON
Generates formatted Tally XML vouchers (Port 9000) or dispatches SAP Service Layer JSON payloads (/b1s/v2/).
Supported Enterprise ERP Connectors
| Target System | Protocol / Transport | Payload Format | Voucher / Transaction Type |
|---|---|---|---|
| Tally Prime / ERP 9 | HTTP POST on TCP 9000 | TDL XML <ENVELOPE> | Stock Journal / Physical Stock |
| SAP Business One | HTTPS OData v4 Service Layer | JSON (/b1s/v2/PurchaseDeliveryNotes) | Goods Receipt PO (GRPO) |
| SAP S/4HANA | RFC BAPI / OData v4 | BAPI_GOODSMVT_CREATE | Goods Movement (101/311) |
| Zoho Inventory | HTTPS OAuth 2.0 REST Webhook | JSON (/api/v1/inventoryadjustments) | Inventory Adjustment |
Feature Benchmark: OpenRFID Solution vs. Proprietary Alternatives
| Feature Capability | OpenRFID Solution (MIT) | Commercial Paid Solutions | Hardware Rig / Manual |
|---|---|---|---|
| Integration Approach | 100% Automated Open-Source Connector Scripts | Custom ERP Consultancy ($5,000 - $15,000) | Manual Excel CSV Export & Import |
| Tally Prime Support | ✓ Native TDL XML over HTTP TCP 9000 (Real-Time) | Batch ODBC sync only (10-15 min delay) | Manual keyboard barcode typing |
| SAP Service Layer | ✓ OData v4 JSON GRPO & Serial Number Mapping | Direct database query (violates SAP warranty) | Manual SAP transaction UI typing |
| Multipath Debounce | ✓ 3-Second In-Memory Ring Buffer Filter | Basic timer debounce | Duplicate scan errors in ERP |
| Edge Hardware Footprint | ✓ Runs on Raspberry Pi, Mini PC, or Windows (<40MB RAM) | Requires dedicated on-premise Windows VM | Manual workstation terminal |
CLI Arguments & Configuration Reference
| Parameter / Flag | Type | Default | Description & Action |
|---|---|---|---|
| --tally-host <ip> | string | "127.0.0.1" | Target IP address of the Tally Prime machine with HTTP server enabled. |
| --tally-port <port> | integer | 9000 | Tally Prime XML ODBC/HTTP server port (default 9000). |
| --sap-url <url> | url | "https://sap.local:50000/b1s/v2" | SAP Business One Service Layer OData v4 endpoint URL. |
| --debounce-sec <sec> | float | 3.0 | Sliding window dwell-time debounce duration to eliminate multipath duplicate reads. |
| --offline-db <path> | filepath | "./data/erp_queue.db" | SQLite Write-Ahead-Log database path for fail-safe offline buffering. |
Code & Integration Blueprint
Copyable starter templates, CLI flags, and CI/CD pipelines:
Technical Specifications & Runtime Environment
| Target Architecture | Python 3 / TypeScript / TDL XML / OData v4 • MIT Open Source License |
| Supported Protocols | REST API, WebSockets, MQTT, TCP Raw Sockets, Serial RS232 |
| Supported ERP Platforms | Tally Prime / ERP 9, SAP Business One, SAP S/4HANA, Zoho Inventory |
| Tally Transport Protocol | Direct TDL XML <ENVELOPE> HTTP POST on TCP Port 9000 |
| SAP Service Layer | HTTPS OData v4 JSON REST endpoints (/b1s/v2/PurchaseDeliveryNotes) |
| Debounce Filter Window | 3-Second sliding ring-buffer eliminating multipath dock-door duplicates |
Key Features & Capabilities
- ✓ Tally Prime Automated Stock Journal XML Generator via HTTP TCP Port 9000
- ✓ SAP Business One Service Layer GRPO Client (OData v4 HTTPS /b1s/v2/)
- ✓ SAP S/4HANA Goods Movement 101/311 BAPI & OData Connector
- ✓ In-Memory Disruptor Ring-Buffer with 3-Second Dwell-Time Debounce Filter
- ✓ Encrypted SQLite Write-Ahead-Log (WAL) Queue for Factory Offline Resilience
- ✓ Zoho Inventory OAuth 2.0 Webhook Dispatcher with Batch Array Slicing
- ✓ Configurable GPIO Trigger Controls for Dock Door Red/Green Indicator Lights
Related Hardware & Commercial Solutions
Explore compatible RFID readers, pre-built warehouse inventory software, and asset management systems developed by RFID Softwares:
Frequently Asked Questions
How does OpenRFID ERP Gateway integrate with Tally Prime? ↓
It connects directly to Tally Prime's integrated HTTP server on TCP Port 9000 using standard TDL XML <ENVELOPE> payloads. It creates automated Stock Journal and Physical Stock vouchers without manual operator intervention.
Does it support SAP S/4HANA and SAP Business One? ↓
Yes. For SAP S/4HANA, it connects via RFC BAPI (BAPI_GOODSMVT_CREATE) or OData v4 for Goods Movement 101/311. For SAP Business One, it dispatches JSON payloads to the Service Layer REST API (POST /b1s/v2/PurchaseDeliveryNotes) mapping serials to EPCs.
How does the gateway handle high-throughput dock door tag bursts? ↓
The gateway features an in-memory Disruptor ring-buffer with a 3-second dwell-time debounce filter. It filters multipath duplicates and micro-batches up to 1,000 tags per second into single idempotent ERP vouchers.
What happens if factory Wi-Fi drops during an inventory audit? ↓
All scanned tags are stored locally in an encrypted SQLite Write-Ahead-Log (WAL) queue. As soon as connectivity restores, an automated background worker syncs the queue with deterministic SHA-256 deduplication.
Can this connector run on an edge Raspberry Pi or Mini PC? ↓
Yes. The lightweight Python / Node.js daemon is cross-platform and runs on any edge device (Raspberry Pi, industrial fanless box, Windows PC) positioned directly beside the physical RFID reader.
Can the gateway dispatch scans to custom REST APIs and Webhooks? ↓
Yes. In addition to Tally and SAP, the gateway supports generic HTTPS Webhooks, Zoho Inventory OAuth 2.0 dispatch, and MQTT brokers with configurable JSON payloads.