Articles in this section
Tally Integration
Table of Contents
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
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.
|
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.
- 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.
|
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:
- Tally to Vtiger
- Vtiger to Tally
- Sync Both ways
- 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).
|
|
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.
|
Field Mapping
Here is information on which Tally fields are mapped to which fields in Vtiger.
Ledgers to Organizations
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Stock Items to Products
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CGST | In-State |
IGST | SGST/Out-of-State |
|
|
|
|
|
|
|
|
|
Sales Vouchers to Invoices
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
Sales Orders
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GSTIN | |
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
|
|
|
|
|
|
|
|
Purchase Orders
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Receipt Notes
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.
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:
- Open the VtigerTallyConnector folder.
- Open the logs folder.
- 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:
- Open the VtigerTallyConnector folder.
- Open the conf folder > Open the VtigerTallyConnector.properties file.
- 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:
- 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.
- 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:
- Go to Tally Gateway.
- Click on F1:Help > TDLs & AddOn’s.
- 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
- 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:
- Go to Tally Gateway.
- Click on Z: Exchange > Data Synchronisation > Client/Server Configuration.
- Tally Prime acts as “Both”.
- If discounts are not showing up in picklist values of sales orders and invoices.
- Check whether the ledger type is discount, in the Tally discount ledger.
- If Taxes are not reflected properly in products:
- Make sure that the taxes are in the Active state in Tax Management settings.
- 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.
- Create CESS tax in Tally with 0 percentage.
- 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.
- Click on the skipped records count to get the exact reason.
- Check if Tally company name, Invoice date, and due date have values in records.
- 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.