Home > Inventory Tools > Tally Integration

Tally Integration

Are you a Tally user? Read this article to know about integrating and setting up Vtiger CRM with Tally.

Abdul Sameer

17 Oct, 2024 - Updated 2 months ago

Introduction

Vtiger CRM’s integration with Tally allows you to sync data between Vtiger and Tally. So, you can easily transfer Sundry debtor & Creditor Ledgers, Stock Items, and Sales Vouchers from Tally to Vtiger’s Organizations, Vendors, Products, and Invoices, and vice versa. This way, you will avoid dual data entry on both platforms.

Feature Availability

	Sales Starter	Sales Professional	Sales Enterprise	All-in-One Growth	All-in-One Professional	All-in-One Enterprise
Feature Availability
Tally Integration	-	✓	✓	✓	✓	✓

To know more about feature limits, click here.

Installing Tally

Tally is a third-party app that you must install from Vtiger’s Extension Store. You can install extensions only if you are an Admin user in the CRM.

Follow these steps to install Tally:

Log in to your CRM account.
Click the Main Menu.
Click the Add-ons button on the bottom left.
Look for Tally and click Install.
Click Yes to confirm the installation.

Note: Before you start syncing data, you must ensure the following:

The base currencies in Tally and Vtiger must be the same.
You must have the latest Java version installed.

Configuring Tally

After you have installed Tally, you must configure it to sync data.

Follow these steps to configure Tally:

Log in to your CRM account.
Click the Main Menu.
Go to Organizations, Vendors, Products, Sales Orders, or Invoices.
Click Sync.
Click Add.
Click Configure.
Enter the following information:
- Vtiger username: Update automatically.
- Secret key: Enter the Secret key.
- Tally company name (case sensitive)
- GUID: Click here to know more.
- Tally base currency, default sales ledger, default discount ledger, default shipping ledger, and default adjustment ledger.
Click Save Settings.
Click the Download .vtc file button.

After you perform the steps above, you will receive a confirmation email.

Next steps:

Download the VtigerTallyConnector zip file from here. Unzip the file to your local computer where Tally is installed.
Go to the conf folder > VtigerTallyConnector.properties file after unzipping.
Set the required values for VTC_File_Path ( with Forward slashes /), Tally_Company, Tally_Server, and Tally_Port.
1. For example, if you place the vtiger.vtc file downloaded from Vtiger in your computer’s D drive, and your path will look like this - VTC_File_Path = D:/vtiger.vtc.
- Provide your Tally company name in Tally_Company. This name is case-sensitive.
- Provide the server details and port number. The default values are -
  - Tally_Server = http://localhost
  - Tally_Port = 9000
Open Tally and load the company name that you provided in the previous step.
Load the guid.tdl, VtigerCheck.tdl, VtigerDateFilter.tdl, and VtigerImport.tdl files to the Tally installation folder (C:\Program Files\Tally.ERP9 ) from the zip file you downloaded in Step 1.

In Tally ERP9, perform the following steps:

Press F12 under Gateway of Tally.
Click on Product and Features.
Click F4: Manage Local TDLs shown on the right panel.
Set LoadTDLs on startup to Yes.
Add VtigerDateFilter.tdl, VtigerCheck.tdl, and VtigerImport.tdl to List of TDLs to preload on Tally startup.
Click Tab to save.

In Tally Prime, perform the following steps:

Press F1:Help under Gateway of Tally.
Select TDLs & Addons.
Click F4:Manage Local TDLs located on the right.
Provide the TDL Path and add guid.tdl, VtigerDateFilter.tdl, VtigerCheck.tdl, and VtigerImport.tdl under File Name.
Set Load TDL to Yes for all four files
Click Tab to save.

Note: Vtiger CRM users configuring Tally sync before 4th June 2021 must follow a few additional steps to use the latest enhancements. To learn more, click here.

Syncing Data

After the configuration is successful, you can choose how you want to sync data.

Follow these steps to sync data between Tally and Vtiger:

Log in to your CRM account.
Click the Main Menu.
Go to Organizations, Products, Sales Orders, or Invoices.
Click Sync.
Click View available connectors.
Select Tally.
Enable the checkbox for the modules that you want to sync.
Choose a sync direction:
1. Tally to Vtiger
2. Vtiger to Tally
3. Sync Both ways
4. Disable Sync (to stop syncing data)
Specify your Tally Credentials.
Click Save Settings.
Open VtigerTallyConnector > bin folder and run start.bat to start the sync.
Go back to the CRM and click Sync.
Click Sync Log to see the last synced report.

Syncing Adjustments to Tally

Sync adjustments as rounded-off values to Tally. Previously, the adjustments in Vtiger are synced to Tally as sales accounts.
You can:
- Provide an indirect expense ledger name to the default adjustment ledger field on the Tally settings page.
- Sync adjustments from sales orders and invoices to the ledger name you provided (from Vtiger to Tally).

Tips:

If you face any difficulty while syncing, you can debug issues from VtigerTallyConnector > logs > DebugLog.txt file.
Syncing may take a long time for the first time, depending on the number of records.

Note:

You can transfer data in batches or chunks to ensure data does not slow down or break.
You can sync data from a particular date. This is available at a module level for Sales Orders and Invoices.
You must sync the organization and products to ensure invoices and sales orders are not skipped.

How does this work?

For the first-time sync, the sync is applied from the given date.
For the next sync, the last sync time is considered.
If the sync from date is changed, records are synced from the changed date.

Admins can also view the sync log for each batch data transfer in the CRM.

Sync Direction

You can select the sync direction at the module level for individual or all the modules you want to sync. This is possible since the following sync directions are available as drop-down options in the Enable Sync column for every module:

Sync from Tally to Vtiger
Sync from Vtiger to Tally
Sync Both Ways
Disable Sync

For example, you may want to sync Organisations, Products, and Invoices from Tally to Vtiger but sync Sales Orders from Vtiger to Tally. You can select the sync direction for all these modules simultaneously per your requirement.

You could select the modules and set up the sync direction one way or another. If you wanted to sync other modules, you had to change the sync direction again.

Sync Process of GSTIN field

Vtiger to Tally - You can send GSTIN details of a related organization along with the sales order and invoice from Vtiger to Tally.
Tally Sync - You can sync the GSTIN field from Sales Orders to Sales Orders and Invoices to Sales Vouchers in Tally.
When an Invoice is generated from a Sales Order, the GSTIN details are automatically updated in the Invoice GSTIN field.

Note: Only Admin users can set up the sync direction.

Module-level Reset

The Reset option is available at the module level for CRM Admins.

With this option, you can re-sync Taxes, Charges, Discounts, and Sales Accounts (if applicable). Records will be reset, and data will again be fetched from Tally to Vtiger CRM in the sync process after reset.

Consider this example. If you make a mistake, say, adding predefined taxes before the sync from Tally, then there will be a tax mismatch between Vtiger and Tally.

At this stage, you can use the reset option to reset the values and fetch data from the modules again.

Disabling Sync

You can disable Organization details on the Tally settings page. The Disable toggle button disables the link between the company or organization and Tally, so company data will not sync to Tally and vice versa.

Note: Only the remove option is currently available on the Tally Settings page.

Field Mapping

Here is information on which Tally fields are mapped to which fields in Vtiger.

Ledgers to Organizations

Tally Field Names	Vtiger Field Names
Ledger Name	Organization Name
Company Name	Tally Company
Ledger Group	Ledger Group
Mailing Address	Billing Address
Mailing Country	Billing Country
Mailing State	Billing State
First Address of Multiple Addresses	Shipping Address
Pincode	Postal code
Phone no	Primary Phone
Fax	Fax
Mobile no	Secondary Phone
GSTIN/UIN	GSTIN - Only for Indian Instances
PAN/IT no	PAN/IT no
Specify Credit Limit	Credit Limit
Credit Period	Credit Period
Outstanding Balance of the Ledger	Tally Outstanding Balance
Email	Primary Email
Email CC	Secondary Email
Website	Website
Description	Description

Note:

Ledger groups can be synced in two ways now. That is, Ledgers get synced from Tally to Vtiger and Vice Versa.
If the ledger values in invoices and sales orders are incorrect, the Default Sales Ledger, Default Discount Ledger and Default Shipping Leder values are considered.
Subgroups or custom groups created under Sundry Debtors or Sundry Creditors group in Tally are synced with the CRM’s organizations. A field called Ledger Group is added to the Organizations module. For example, if you create a ledger in Tally under Sundry Debtors > Subgroup 1, then the Ledger Group field in the related organization record shows Subgroup 1.
You can also sync Sundry Creditor ledgers in Tally to the Vendors module in Vtiger. Vendor records created in the process will sync back to Tally. Sundry debtors will continue to sync to the Organization ledger.

Stock Items to Products

Tally Field Name	Vtiger Field Name
Item Name	Product Name
Company Name	Tally Company
Usage Unit	Usage Units
Closing stock	Qty in stock
Rate/Value	Unit Price
Part No.	Part Number
Taxes	Taxes
CGST	In-State
IGST	SGST/Out-of-State
Description	Description
Stock Category	Product Category
Stock Sub-Groups	Tally Stock Group
HSN Code	HSN Code

Note:

Taxes are synced only one way, i.e., from tally to Vtiger. The direction of sync you choose does not affect tax sync.
Voucher taxes in Tally are mapped to the taxes synced from Tally to Vtiger.
The Closing stock under the stock summary report is synced to qty. In stock field in the product. (This will only happen when productquantity.batch file under VtigerTallyConnected>bin is run.)
Tally Stock Item GST taxes are copied to Instate and Out-of-state fields in Products.
Tally differentiates between instate and Out-of-state based on the company and Ledger (Org) locations.
- If the ledger is present in the same state as the Company, then Instate taxes are applicable. (On selecting IGST, tax will not apply to vouchers and invoices.)
- If the ledger is present in a different state other than the location of the company, the Out-of-state taxes are applicable. (Upon selecting CGST, SGST tax will not apply to vouchers and invoices).
- The Instate and Out-of-State numbers would not be automatically updated for a product in Vtiger sales orders or invoices.
The CGST field in Tally is mapped to the In-state field in Vtiger CRM. The IGST field is mapped to the SGST and Out-of-state fields in Vtiger CRM.
Tally integration ensures that when you copy stock items from Tally to Vtiger:
- The In-state field value in Vtiger is updated from the CGST field in Tally.
- The SGST and Out-of-state field values in Vtiger are updated from the IGST field in Tally.

Sales Vouchers to Invoices

Tally Field Name	Vtiger Field Name
Reference No	Subject
Voucher No	Tally Invoice No
Company Name	Tally Company
Voucher Date & Effective Date	Invoice Date
Voucher Type	Sub Voucher Type
Part’s A/C Name	Organization Name
Buyer’s Address	Billing Address
Country	Billing Country
State	Billing State
Consignee’s Address	Shipping Address
Stock Items	Products
Billed Quantity	Quantity
Rate	Selling Price
Voucher Sales Ledger	Tally Sales Ledger
Tax	Tax
Charge Ledger	Charges
Other Expenses	Adjustment Add/Deduct
Discount	Overall Discount
Item Level Discount	Item Level Discount
Narration	Description
Discount Names	Tally Discount Ledger
Sales Account Ledger	Sales Account
GSTIN	GSTIN - Only for Indian Instances
Mode/Terms of Payment	Mode or Terms of Payment
Other References	Other References
Terms of Delivery	Terms of Delivery
Dispatch through	Dispatch through
Destination	Destination
Carrier Name/Agent	Carrier Name or Agent
Bill of Lading / LR-RR No	Bill of Lading or LR-RR No
Dispatch date	Dispatch date
Place of Receipt by shipper	Place of Receipt by shipper
Vessel/Flight No	Vessel/Flight No
Port of Loading	Port of Loading
Port of Discharge	Port of Discharge
Country to	Country to
Shipping Bill No	Shipping Bill No
Port Code	Port Code
Export Date	Export Date
Dispatch Doc No	Dispatch Doc No

Note:

Sales vouchers are synced along with sales voucher types.
The Sub-Voucher field for Invoices and Sales Orders is available as a Picklist field. The CRM fetches Sub-Voucher type values from your Tally account and displays them as Sub-Voucher picklist values.
All discount ledgers created under indirect expense will be synced to the Vtiger Tally Discount ledger picklist field.
Ledgers created under direct income are synced to shipping charred in Vtiger and Ledgers created under indirect expense are synced to Discounts under Vtiger.

Sales Orders

Tally Field Name	Vtiger Field Name
Order No	Subject
Tally Voucher No	Tally SalesOrder No
Company Name	Tally Company
Voucher Date	Due Date
Voucher Type	Sub Voucher Type
Part’s A/C Name	Organization Name
Buyer’s Address	Billing Address
Country	Billing Country
State	Billing State
Consignee’s Address	Shipping Address
Stock Items	Products
Billed Quantity	Quantity
Rate	Selling Price
Voucher Sales Ledger	Tally Sales Ledger
Tax	Tax
Charge Ledger	Charges
Other Expenses	Adjustment Add/Deduct
Discount	Overall Discount
Discount Names	Tally Discount Ledger
Narration	Description
GSTIN	GSTIN - Only for Indian Instances
Mode/Terms of Payment	Mode or Terms of Payment
Other References	Other References
Terms of Delivery	Delivered at customer godown
Dispatch through	By Road, By Air, etc
Destination	Delivery at location
Carrier Name/Agent	The name of the agent or carrier who ships the item
Bill of Lading / LR-RR No	Lading Document numbers
Dispatch date	The date of goods dispatch
Place of Receipt by shipper	The location where the shipper hands over the goods for transportation
Vessel/Flight No	Vessel or Flight No
Port of Loading	Port of Loading
Port of Discharge	Port of Discharge
Country to	Country to
Shipping Bill No	Shipping Bill No
Port Code	Port Code
Export Date	Export Date

Go-down/Location to Stockroom

Tally Field Names	Vtiger Field Names
Name	Stockroom Name
Under	Parent Stockroom
Address	Street Address

Purchase Orders

Tally Field Name	Vtiger Field Name
Order No	Subject
Tally Voucher No	Tally Purchase Order No
Company Name	Tally Company
Voucher Date	Due Date
Voucher Type	Sub Voucher Type
Part’s A/C Name	Vendor Name
Buyer’s Address	Billing Address
Country	Billing Country
State	Billing State
Consignee’s Address	Shipping Address
Stock Items	Products
Billed Quantity	Quantity
Rate	Selling Price
Voucher Sales Ledger	Tally Sales Ledger
Tax	Tax
Charge Ledger	Charges
Other Expenses	Adjustment Add/Deduct
Discount	Overall Discount
Discount Names	Tally Discount Ledger
Narration	Description
GSTIN	GSTIN - Only for Indian Instances
Mode/Terms of Payment	Mode or Terms of Payment
Other References	Other References
Terms of Delivery	Terms of Delivery
Dispatch through	Dispatch through
Destination	Destination
Carrier Name/Agent	Carrier Name or Agent
Bill of Lading / LR-RR No	Bill of Lading or LR-RR No
Dispatch date	Dispatch date
Place of Receipt by shipper	Place of Receipt by shipper
Vessel/Flight No	Vessel or Flight No
Port of Loading	Port of Loading
Port of Discharge	Port of Discharge
Country to	Country to
Shipping Bill No	Shipping Bill No
Port Code	Port Code
Export Date	Export Date

Receipt Notes

Tally Field Name	Vtiger Field Name
Reference No	Subject
Voucher No	Tally Receipt Note No
Company Name	Tally Company
Voucher Date	Receipt date
Voucher Type	Sub Voucher Type
Part’s A/C Name	Vendor Name
Buyer’s Address	Billing Address
Country	Billing Country
State	Billing State
Consignee’s Address	Shipping Address
Stock Items	Products
Billed Quantity	Quantity
Rate	Selling Price
Voucher Sales Ledger	Tally Sales Ledger
Tax	Tax
Charge Ledger	Charges
Other Expenses	Adjustment Add/Deduct
Discount	Overall Discount
Item Level Discount	Item Level Discount
Narration	Description
Discount Names	Tally Discount Ledger
Sales Account Ledger	Sales Account
GSTIN	GSTIN - Only for Indian Instances
Mode/Terms of Payment	Mode or Terms of Payment
Other References	Other References
Terms of Delivery	Terms of Delivery
Dispatch through	Dispatch through
Destination	Destination
Carrier Name/Agent	Carrier Name or Agent
Bill of Lading / LR-RR No	Bill of Lading or LR-RR No
Dispatch date	Dispatch date
Place of Receipt by shipper	Place of Receipt by shipper
Vessel/Flight No	Vessel/Flight No
Port of Loading	Port of Loading
Port of Discharge	Port of Discharge
Country to	Country to
Shipping Bill No	Shipping Bill No
Port Code	Port Code
Export Date	Export Date
Dispatch Doc No	Dispatch Doc No

Note:

Vtiger Invoices will display a Sales Order (SO) tab. You can:
- Select and link an SO to an invoice, provided the SO is not linked to another invoice (previously).
- Link only one SO to an invoice at any given time.
- Link an SO to an invoice for the Contact or Organization mentioned in the invoice.
Sales order vouchers and their sub-vouchers are synced along with sales orders in Vtiger CRM.
When you create a sales order or invoice and select the Organization, the GSTIN will be automatically copied from Sundry debitors and organization. It will also be reflected in the Party details pop-up window.
When you generate a sales order in Vtiger for an organization with a GSTIN number and then synchronize the sales order with Tally, the GSTIN number doesn't appear in the Party details of the sales order in Tally

Key Points to Remember

Multiple shipping charges and discount ledgers are synced from Tally to vtiger CRM and vice versa.
Tax on charges is synced from Tally to Vtiger CRM and vice versa.
All taxes are synced to the taxes column under charges.
When you select the Individual Tax (item taxes) mode when you create an invoice and set the sync direction from Vtiger to Tally, individual discounts are synced to Tally.
You can map taxes (with custom names for CGST, SGST, and IGST) between Vtiger and Tally.
Grouping: When a product is synced to Tally, it goes under the name of the primary or default group if multiple groups are available.
Charts of Accounts Add-on must be installed to sync sales account ledgers from tally to Vtiger.
All the sales account ledgers are fetched from Tally and reflected in the CRM in the Chart of Accounts.
Taxes are also fetched along with the sales account ledgers.
Multiple companies’ data can be synced from Tally to CRM.
Any levels of groupings of ledgers and vouchers can be synced to the CRM.
Multiple Companies can now be added from the Vtier settings page.
If multiple addresses of an organization are present in the tally, they will be synced to the multiple address module. ( For this to work, the user must first install the Multiple Addresses Add-on).
Outstanding Invoices are now synced from Tally to Vtiger and are displayed in one view in the organization record.
Taxes on Charges are now allowed to be synced in both ways.
Sales accounts synced from the tally are marked as Sales Account type in Charts of Accounts.
Account code starts with T-100 for sales accounts synced from the tally.
On Installing the COA add-on, Item account taxes and Record account taxes under Tax mode are added Item details block in the Invoices and Sales orders.
If the Tax mode is set as Record account taxes and an account is selected from the Record Sales Account picklist, then the taxes under this account will apply to all the line items in the invoice.
If the Tax mode is set as Item account taxes, users can select different sales accounts for each line item.
Taxes are applied to the line items depending on the taxes configured under the selected account from the COA.

Limitations

Product taxes will not be overwritten from Vtiger to Tally if the product updated in Vtiger is synced from Tally earlier.
Taxes can be synced only one way, that is, from Tally to Vtiger. Even if the Sync Direction is Vtiger to Tally, Taxes get synced only from Tally to Vtiger.
The default Sales Order Number in Vtiger gets synced to the Voucher Number in Tally. Tally’s Sales Order No is a redundant field when syncing from Vtiger to Tally.
If the default tax mode is Group, and Charges on taxes are present in Vtiger, then records get skipped.

Best Practices for Setting Up the Vtiger Tally Connector

Do’s

Ensure JAVA is Installed on your Tally system to run the Vtiger Tally Connector.
Download and extract the Vtiger Tally Connector file
1. Download the VtigerTallyConnector zip file from the provided link.
2. Unzip the TDL files and save them in a suitable location.
Load TDL Files to Tally:
1. Load the following TDL files from VtigerTallyConnector into Tally (under Help > TDLs and Addons):
2. VtigerCheck.tdl
3. VtigerDateFilter.tdl
4. VtigerImport.tdl
5. Guid.tdl
6. After loading guid.tdl, the GUID option will appear in the Tally gateway.
Install Necessary Add-ons in Vtiger
1. Go to the Add-ons page in Vtiger.
2. Install the following add-ons:
  1. Tally Add-on
  2. Chart of Accounts Add-on
  3. Vtiger Inventory Add-on
  4. Stockroom Add-on (if applicable)
Set Up Tally Sync Settings in Vtiger
1. Go to the Tally Sync Settings page.
2. Set the sync direction for the organization to Sync from Tally to Vtiger.
3. Provide the secret key.
4. Copy the company name and GUID from the Tally GUID section and paste them into the Tally settings page in Vtiger.
5. Specify the following default ledgers:
  1. Default Sales Ledger
  2. Default Discount Ledger
  3. Default Shipping Ledger
  4. Default Adjustment Ledger
6. Save the sync settings.
Download and Configure the VTC File
1. After saving the Tally settings, download the VTC file.
2. Open the Conf file in the VtigerTallyConnector folder.
3. Update the VTC file location path, company name, and port number (from the Tally client/server configuration).
4. Save the Conf file.
Enable Third-Party Access in Tally
1. Ensure third-party application access is enabled in Tally/Server.
2. Set TallyPrime to Both modes in the Client/Server configuration.
Check Tax Settings in Tally
1. For seamless integration, ensure that individual item tax names in Tally are exactly CGST, SGST, and IGST.
2. Set up Cess within the Duties and Taxes category before synchronization.
Install Multiple Addresses Add-on
If your ledgers have multiple addresses, install the Multiple Addresses Add-on.
Configure Sync Directions for Different Modules
1. For Organizations:
  1. Set the sync direction to Sync from Tally to Vtiger.
  2. Once synced, change the direction to Sync from Vtiger to Tally and sync again.
2. For Products: Repeat the sync process as done for organizations.
3. For Stockroom: Repeat the sync process.
4. For Vendors: Repeat the sync process.
5. For Sales Orders: Repeat the sync process.
6. For Invoices: Repeat the sync process.
7. For Purchase Orders: Repeat the sync process.
8. For Receipt Notes: Repeat the sync process.
Final Synchronization
After syncing all records both ways, set the sync direction to Both Ways for all relevant modules if two-way synchronization is needed.
Tally Ledger Mapping
1. Sundry Debtors in Tally will sync with Organizations in Vtiger.
2. Sundry Creditors in Tally will sync with Vendors in Vtiger.
3. Use the Sundry Debtors ledger for Sales Orders and Invoices.
4. Use the Sundry Creditors ledger for Purchase Orders and Receipt Notes.
Tally Voucher Type Mapping
1. Sales Orders: Sales Order (with sub voucher type Sales Order)
2. Invoices: Sales (with sub voucher type Sales)
3. Purchase Orders: Purchase Order (with sub voucher type Purchase Order)
4. Receipt Notes: Receipt Note (with sub voucher type Receipt Note)

Don'ts: Do not delete the records in Vtiger that have been synced from Tally.

Behavior

If the Ledger Group field is empty in the Organizations module and synced to Tally, then Sundry Debtors are taken as default in Tally.
GSTIN will sync to Tally only if the Vtiger organization records’ billing country is India.
Usage Units and Categories must be present in Tally before syncing products to Tally. Otherwise, products will get skipped.
Except for Discount ledgers and Shipping Charge ledgers, any other charges present get synced to Adjustments from Tally to Vtiger.

Troubleshooting Tips

Listed below are a few common errors users often face during the sync process. Please read through.

If records do not sync in the configured direction when you run/trigger the batch file in VtigerTallyConnector, please follow the below steps:
1. Open the VtigerTallyConnector folder.
2. Open the logs folder.
3. Open the lastsynclog.txt file to check the problem.
If the error is SEVERE: VTC file not found in the lastsynclog file, please follow the steps:
1. Open the VtigerTallyConnector folder.
2. Open the conf folder > Open the VtigerTallyConnector.properties file.
3. Reverify the path of the .vtc file.
  - Note: Forward slash must be used throughout the location path.
  - Reference
All Tally companies configured in the Vtiger Settings page must be in the open state in the Tally Gateway. It should not be in the Shut form.
Check if the given company name and running company name are the same in the lastsynclog file. (Reference). If it is not matching, follow these steps to correct the issue:
1. First, verify whether the company name listed in the GUID (Tally gateway) matches the company name specified in the VtigerTallyConnector.properties file located in the conf folder.
2. If the above does not work, change the port number both in the Tally Company Client/Server Configuration and in the VtigerTallyConnector.properties file.
  - Note: There might be a possibility that another company might be running in the specified port.
Check whether all TDLs are in the Loaded state. Follow these steps:
1. Go to Tally Gateway.
2. Click on F1:Help > TDLs & AddOn’s.
3. All below 4 Vtiger TDLs must be in the loaded state and should have the path from the existing VtigerTallyConnector.
  - Guid.tdl
  - VtigerCheck.tdl
  - VtigerDateFilter.tdl
  - VtigerImport.tdl
4. If there are any additional 3rd party TDLs, we suggest unloading them and trying the sync only with Vtiger TDLs.
Make sure that Tally acts as both Client and Server. Follow these steps:
1. Go to Tally Gateway.
2. Click on Z: Exchange > Data Synchronisation > Client/Server Configuration.
3. Tally Prime acts as “Both”.
If discounts are not showing up in picklist values of sales orders and invoices.
1. Check whether the ledger type is discount, in the Tally discount ledger.
If Taxes are not reflected properly in products:
1. Make sure that the taxes are in the Active state in Tax Management settings.
2. Reset the Products module in the Vtiger Tally settings page and perform the sync again.
If CGST tax is updated as 0 in products after syncing to vtiger.
1. Create CESS tax in Tally with 0 percentage.
2. Reset the Products module in the Vtiger Tally settings page and perform the sync again.
If the Sales Order or Invoice is skipping and not syncing to Tally.
1. Click on the skipped records count to get the exact reason.
2. Check if Tally company name, Invoice date, and due date have values in records.
3. Verify whether the tax selected in the Sales Order/Invoice hasn't been generated in Vtiger. It must be a tax created in Tally and successfully synchronized.

Vtiger and Tally Sync Issues

If you encounter errors during the sync between Vtiger and Tally, follow these steps to resolve common issues:

No Records Syncing and Sync Log Shows No Entries

If the sync process was interrupted, and no records are syncing:

Step 1: Go to the Vtiger Tally settings page.
Step 2: Reset the affected modules.
Step 3: Perform the sync again.

Error: Permission to perform the operation is denied.

This indicates the records have been permanently deleted in Vtiger.

Step 1: Reset the affected modules from the backend to sync the deleted records.
Step 2: Go to the Tally sync settings page and reset the module from the UI.
Step 3: Enable duplicate prevention for these modules under Module Layouts & Fields.
Step 4: Sync again.

Error: VTC File parse error

If you see this error, follow these steps:

Step 1: Navigate to the VtigerTallyConnector folder.
Step 2: Open the conf folder.
Step 3: Open the VtigerTallyConnector.properties file.
Step 4: Ensure the content is in the correct format.

Error: Incorrect or Empty Ledger for Invoices/Sales Orders

If invoices or sales orders are skipped due to incorrect or empty ledgers:

Step 1: Open the skipped records in Tally.
Step 2: Change the ledger type to Sundry Debtors or select the appropriate ledger.
Step 3: Save the changes.
Step 4: Sync again.

Error: Incorrect or Empty Ledger for Receipt Notes/Purchase Orders

If receipt notes or purchase orders are skipped due to incorrect or empty ledgers:

Step 1: Open the skipped records in Tally.
Step 2: Change the ledger type to Sundry Creditors or select the appropriate ledger.
Step 3: Save the changes.
Step 4: Sync again.

Error: Please select the Tally company to sync the record.

Step 1: Go to the skipped record.
Step 2: Provide the appropriate Tally company for that record.
Step 3: Sync again.

Error: Selected organization in the record is not available in mapped tally company

This occurs when the organization is not found in Tally.

Solution: Sync the organizations first before syncing other records.

Error: Taxes in Vtiger Invoices are not available in Tally.

This happens because Vtiger-created taxes are not supported. Only Tally-created taxes can be used in invoices.

Step 1: Open the skipped invoice in the Invoice module.
Step 2: Go to the Edit View.
Step 3: Scroll to the Item Details section.
Step 4: Remove the Vtiger-created taxes.
Step 5: Save the invoice.
Step 6: Sync again.

Error: Record you are trying to access is not found.

If a record is missing, follow these steps:

Step 1: Go to the Recycle Bin.
Step 2: Restore the specific record.
Step 3: Sync again.

Error: Voucher totals do not match (e.g., Dr: 1,330.00 Dr Cr: 1,320.00 Cr Diff: 10.00 Dr)

Step 1: Go to the sync settings page.
Step 2: Provide a Default Adjustment Ledger.
Step 3: Save the sync settings.
Step 4: Sync again.

Error: Vtiger Invoices must be linked to an organization.

Step 1: Go to the Invoice module.
Step 2: Open the skipped invoice.
Step 3: Enter the organization name.
Step 4: Save the invoice.
Step 5: Sync again.

Was this article helpful?

1 out of 1 found this helpful.

Comments 0

Be the first to comment

Tally Integration

Table of Contents

Introduction

Feature Availability

Installing Tally

Configuring Tally

Syncing Data

Sync Direction

Module-level Reset

Disabling Sync

Field Mapping

Ledgers to Organizations

Stock Items to Products

Sales Vouchers to Invoices

Sales Orders

Go-down/Location to Stockroom

Key Points to Remember

Limitations

Best Practices for Setting Up the Vtiger Tally Connector

Behavior

Troubleshooting Tips

Vtiger and Tally Sync Issues

Comments 0