Home / Open Source / OpenRFID ERP Gateway: Open-Source Tally & SAP RFID Connector
ERP & Cloud Integration Python 3 / TypeScript / TDL XML / OData v4 License: MIT / Enterprise v1.2.0

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.

Quick Clone / Terminal Setup git / bash
pip install sllurp requests && python llrp_inventory_gateway.py --tally-port 9000
Live Interactive Testing Sandboxes

Try Live RFID-to-ERP Integration Sandboxes

Live Web Testing • Instant Verification

Test real RFID tag streams, TDL XML envelopes, and SAP OData payloads directly inside our interactive browser testbeds before writing backend integration code:

Port 9000 XML Sandbox

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.

Launch Tally Live Tester →
SAP OData & BAPI Console

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.

Launch SAP Live Tester →
OAuth 2.0 REST Gateway

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.

Launch Zoho Live Tester →

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

1. Ingestion Socket

LLRP & Reader Listener

Establishes asynchronous TCP sockets to fixed readers (Impinj, Zebra) or HTTP listeners for Android handheld batch posts.

2. Dwell Debounce

Ring-Buffer Filtering

Eliminates dock door multipath duplicates using a 3-second sliding window ring buffer to ensure 1 transaction per physical asset.

3. Offline Buffer

SQLite WAL Queue

Guarantees zero-data-loss during ERP server maintenance or network drops by writing transactions to local disk.

4. ERP Dispatch

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:

tally_stock_journal.xml
<ENVELOPE>
  <HEADER>
    <TALLYREQUEST>Import Data</TALLYREQUEST>
  </HEADER>
  <BODY>
    <IMPORTDATA>
      <REQUESTDESC>
        <REPORTNAME>Vouchers</REPORTNAME>
      </REQUESTDESC>
      <REQUESTDATA>
        <TALLYMESSAGE xmlns:UDF="TallyUDF">
          <VOUCHER VCHTYPE="Stock Journal" ACTION="Create">
            <DATE>20260924</DATE>
            <VOUCHERTYPENAME>Stock Journal</VOUCHERTYPENAME>
            <VOUCHERNUMBER>RFID-SJ-0042</VOUCHERNUMBER>
            <INVENTORYENTRIESIN.LIST>
              <STOCKITEMNAME>Cotton Yarn Spool 500m</STOCKITEMNAME>
              <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
              <RATE>250.00</RATE>
              <AMOUNT>25000.00</AMOUNT>
              <ACTUALQTY>100 Nos</ACTUALQTY>
              <BILLEDQTY>100 Nos</BILLEDQTY>
              <GODOWNNAME>Finished Goods Warehouse</GODOWNNAME>
              <BATCHALLOCATIONS.LIST>
                <GODOWNNAME>Finished Goods Warehouse</GODOWNNAME>
                <BATCHNAME>BATCH-2026-09</BATCHNAME>
                <AMOUNT>25000.00</AMOUNT>
                <ACTUALQTY>100 Nos</ACTUALQTY>
                <BILLEDQTY>100 Nos</BILLEDQTY>
              </BATCHALLOCATIONS.LIST>
            </INVENTORYENTRIESIN.LIST>
          </VOUCHER>
        </TALLYMESSAGE>
      </REQUESTDATA>
    </IMPORTDATA>
  </BODY>
</ENVELOPE>

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

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.

🖥️ OpenRFID Studio Preview 1 / 5
Hi, Can I Help ? 💬
AI