TALLY ERP 9 - Multiple entry altration

This query is : Resolved

Bernard (Querist)
Follow

27 August 2024 Sir,

Sir i have made 1500 entries in Tally ERP 9 Indian Rupees. Now i need to convert these entries to Omani Riyal ( Ex. INR/216). Is there is any easy way to convert these entries to Omani Riyal. I tried to export the Day book and divided the entries by 216. Then converted it to XML format, and import it to a new Tally ERP 9. But It's not working. Please help me in this matter.

Aashok Kumar Sharma

Aashok Kumar Sharma

(Expert)
Follow

12 August 2025 This is a common challenge in **Tally ERP 9**, which doesn’t natively support **bulk currency conversion** for existing entries — especially after they’re recorded in one base currency.

Let me break down the situation and possible solutions:

---

## 🎯 Objective:

You entered 1500 vouchers in **INR** but now need to **recreate them in Omani Riyal (OMR)** using a conversion rate of **₹216 = 1 OMR**.

---

## ⚠️ Why Your XML Import Isn’t Working:

1. **Tally XML import** is **very sensitive** to structure and syntax.
2. When you modify exported XML and re-import it, **currency mismatches**, **missing masters**, or **wrong data types** can cause silent failures or no import.
3. Tally doesn’t automatically recalculate foreign exchange values from XML unless you set it up properly.

---

## ✅ Practical Workarounds:

### 🔹 Option 1: Use Tally's **Multi-Currency Feature**

> This works only **if entries are not yet made** or you want to recreate them.

1. **Enable Multi-Currency**:

* Go to: `F11 → Accounting Features → Enable Multi-Currency: Yes`

2. **Create New Currency – OMR**:

* Gateway of Tally → Accounts Info → Currencies → Create
* Name: Omani Riyal (OMR)
* ISO Code: OMR
* Standard Rate: 1 OMR = ₹216

3. **Create New Ledger(s)** (if needed) under Debtors/Creditors with foreign currency set to OMR.

4. **Re-enter the Vouchers** manually (or through import) with currency set to OMR.

> ✅ You will now see the INR and OMR split in reports.

---

### 🔹 Option 2: Use **Tally TDL or Add-on Tools** (Recommended for bulk edit)

You can use a **custom TDL (Tally Definition Language)** script or a **third-party Tally data migration tool** to:

* **Read existing vouchers**
* **Recalculate the values (INR ÷ 216)**
* **Recreate new vouchers in OMR**

There are TDL developers and tools like:

* **Shweta Softwares**
* **TDL developers on Fiverr/Upwork**
* **Tally customisation partners**

> 🔐 If you need help drafting a sample TDL logic, I can help you start with that too.

---

### 🔹 Option 3: Excel + XML Import (Advanced, but risky)

Since you already tried:

* Export Day Book to Excel
* Divide values by 216
* Convert back to XML for import

Make sure of the following:

* Currency master “OMR” exists in Tally before importing.
* Ledger names and group names exactly match.
* XML format is valid (no extra characters or malformed tags).
* Each voucher has unique `VOUCHERNUMBER` and date.
* Use Tally’s sample XML structure as a base.

Still, **Tally ERP 9 is not robust with manual XML import for foreign currencies** — and even minor errors will cause it to ignore your import without messages.

---

## 🧾 Recommendation:

If re-entering 1500 vouchers manually is not an option:

* Either go for a **TDL solution**, or
* Use Tally Prime + Tally Developer Tools (if you have access) to script this conversion.

---

## ✅ Summary:

| Method | Works? | Notes |
| ----------------------- | ------ | ----------------------------------------------- |
| Manual Re-entry in OMR | ✅ | Accurate, time-consuming |
| Excel → XML Import | ⚠️ | Needs 100% correct structure, prone to failure |
| Multi-Currency in Tally | ✅ | Works well if used from the start |
| TDL Script/Automation | ✅ | Best for bulk conversion with correct structure |

---

Would you like a sample XML structure or a draft TDL logic to start with? Let me know!

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now