Automating Daily Import of Tally Sales Vouchers into ERPNext

ERPNext
1

Hi everyone,

I’m working on integrating the Tally with ERPNext and need some guidance on automating the import of Sales Vouchers.

My requirement:

  • I have Sales Voucher data in Tally
  • I want to import this data into ERPNext on a daily basis
  • For example:
    • Day 1: Records 1–5 → Imported into ERPNext
    • Day 2: Records 6–10 → Only new records should be imported
  • I want to trigger this using a button (or scheduled job), so that:
    • Only new/unimported vouchers are fetched
    • No duplicate entries are created in ERPNext

Current situation:

  • I’m not sure:
    • How to fetch data from Tally (XML / API / ODBC?)
    • Where to implement this logic in ERPNext (Custom Script / Server Script / Integration App?)
    • How to track already imported records

My questions:

  1. What is the best way to fetch Sales Vouchers from Tally into ERPNext?
  2. Should I use Tally XML API, ODBC, or any middleware?
  3. How can I implement incremental sync (only new records each day)?
  4. Where should this logic be implemented in ERPNext:
  • Server Script
  • Custom App
  • Integration Tool
  1. What is the recommended way to avoid duplicate entries?

If anyone has implemented a similar Tally → ERPNext integration, I would really appreciate your guidance or any reference/documentation.

Thanks in advance! :folded_hands: