I want to make an application to sync Tally Sales Order and Sales Invoice from tally to our SQL Database. Currently for testing purpose I am using Tally ERP 9 Educational Version.
我想做一个应用程序，将理货销售订单和销售发票从理货同步到我们的SQL数据库。目前为了测试目的，我使用的是理塔ERP 9教育版本。
I have created some sales orders in tally and need all order with their details from tally using tally ODBC Sql query
我已经在统计上创建了一些销售订单，并需要所有订单的详细信息，从理货的ODBC Sql查询。
uptil as per my research, I am getting few sales order details like Voucher Number,Order Date,'Voucher Type'.. etc. from tally ODBC table CompanyVoucher. but few details came empty, although related data exist in tally order. like Reference , Party Name ... etc.
根据我的调查，我得到的销售订单信息很少，比如凭证号码、订单日期、“凭证类型”等。等从理货ODBC表公司凭证。但几乎没有什么细节是空空如也的，尽管相关数据是按一定顺序存在的。比如引用，政党名称……等。
Also, I am unable to find Tally ODBC table to get few other sales order related data like item name, item number , item quantity, rate and order total, order no etc.
另外，我无法找到理货ODBC表来获取其他一些与销售订单相关的数据，如项目名称、项目编号、项目数量、价格和订单总数、订单编号等。
Can anybody suggest SQL Query or Tally ODBC Table from where i can find these order related data. Also I am not sure, if we can not access these details due to Educational Version, and any limitations on Educational Version on access of these details.
有人能建议SQL查询或理货ODBC表，从那里我可以找到这些订单相关的数据。我也不确定，如果由于教育版的原因，我们不能访问这些细节，以及教育版对访问这些细节的任何限制。
so please suggest me on this.
所以请建议我。
1 个解决方案
#1
1
Synchronisation is the process of replicating data between two or more computers using Tally.ERP 9 in a Client – Server environment. Data is transferred from the client to the server and vice versa. Tally.ERP 9 offers control over the frequency of Synchronisation i.e., data can be replicated after each transaction or updated at specific intervals.
同步是指使用计数器在两台或多台计算机之间复制数据的过程。在客户端-服务器环境中的ERP 9。数据从客户机传输到服务器，反之亦然。理货。ERP 9提供了对同步频率的控制。，数据可在每笔交易后复制或以特定的间隔更新。
Configure Server for Synchronization
配置服务器同步
To configure the Server Company for Synchronization, follow the steps given below:
要配置服务器公司进行同步，请执行以下步骤:
Go to Gateway of Tally > F12: Configure > Advanced Configuration
转到total > F12的网关:配置>高级配置
In the Advanced Configuration screen,
在高级配置屏幕中，
Under Client/Server Configuration section, Set the option Tally is acting as to Server, to run Tally.ERP 9 as Sync Server Specify the required port number (e.g. 9009) in the Port field....
在客户端/服务器配置部分，设置选项计数作为服务器，以运行计数。ERP 9作为同步服务器指定所需的端口号(例如9009)在港口领域....
Tab down to Tally Sync Configuration section:
标签下到理货同步配置部分:
Set the option Ignore Clients modified Voucher Type Masters to No, so that modifications made to Voucher Type Masters on the Client are updated on the Server
将选项设置为忽略已修改的客户端凭证类型控制项为No，以便在服务器上更新对客户端凭证类型控制项的修改
Set the option Enable Sync Logging to Yes, to generate a Log file which contains synchronized vouchers and is saved in the Tally folder.
设置选项允许同步登录到Yes，生成一个包含同步凭证的日志文件，并保存在计数器文件夹中。
Set the option Truncate previous log before Syncing should be set to Yes, to allow the previous log file to be overwritten by the current log file.
设置选项截断以前的日志，同步应该设置为Yes，以便允许当前日志文件覆盖以前的日志文件。
Go to end and press Enter to save the details.
转到end并按Enter键保存细节。
For the above changes to take effect, Tally.ERP 9 will prompt you to restart the application as shown:
对于上述变更生效，理货。ERP 9将提示您重新启动应用程序，如下所示:
Press Enter or select Yes to restart Tally.ERP 9 on the Server computer. Tally.ERP 9 will restart and in the Information Panel you can see that it is configured as the Sync Server as shown below.
按Enter或选择Yes重新开始计数。服务器上的ERP 9。理货。ERP 9将重新启动，在信息面板中，您可以看到它被配置为同步服务器，如下所示。
Detailed reference here.
详细的参考。
If the datas are present and you cannot access the sync then there must be restriction in your version
如果数据是存在的，并且您不能访问同步，那么您的版本中必须有限制。
#1
1
Synchronisation is the process of replicating data between two or more computers using Tally.ERP 9 in a Client – Server environment. Data is transferred from the client to the server and vice versa. Tally.ERP 9 offers control over the frequency of Synchronisation i.e., data can be replicated after each transaction or updated at specific intervals.
同步是指使用计数器在两台或多台计算机之间复制数据的过程。在客户端-服务器环境中的ERP 9。数据从客户机传输到服务器，反之亦然。理货。ERP 9提供了对同步频率的控制。，数据可在每笔交易后复制或以特定的间隔更新。
Configure Server for Synchronization
配置服务器同步
To configure the Server Company for Synchronization, follow the steps given below:
要配置服务器公司进行同步，请执行以下步骤:
Go to Gateway of Tally > F12: Configure > Advanced Configuration
转到total > F12的网关:配置>高级配置
In the Advanced Configuration screen,
在高级配置屏幕中，
Under Client/Server Configuration section, Set the option Tally is acting as to Server, to run Tally.ERP 9 as Sync Server Specify the required port number (e.g. 9009) in the Port field....
在客户端/服务器配置部分，设置选项计数作为服务器，以运行计数。ERP 9作为同步服务器指定所需的端口号(例如9009)在港口领域....
Tab down to Tally Sync Configuration section:
标签下到理货同步配置部分:
Set the option Ignore Clients modified Voucher Type Masters to No, so that modifications made to Voucher Type Masters on the Client are updated on the Server
将选项设置为忽略已修改的客户端凭证类型控制项为No，以便在服务器上更新对客户端凭证类型控制项的修改
Set the option Enable Sync Logging to Yes, to generate a Log file which contains synchronized vouchers and is saved in the Tally folder.
设置选项允许同步登录到Yes，生成一个包含同步凭证的日志文件，并保存在计数器文件夹中。
Set the option Truncate previous log before Syncing should be set to Yes, to allow the previous log file to be overwritten by the current log file.
设置选项截断以前的日志，同步应该设置为Yes，以便允许当前日志文件覆盖以前的日志文件。
Go to end and press Enter to save the details.
转到end并按Enter键保存细节。
For the above changes to take effect, Tally.ERP 9 will prompt you to restart the application as shown:
对于上述变更生效，理货。ERP 9将提示您重新启动应用程序，如下所示:
Press Enter or select Yes to restart Tally.ERP 9 on the Server computer. Tally.ERP 9 will restart and in the Information Panel you can see that it is configured as the Sync Server as shown below.
按Enter或选择Yes重新开始计数。服务器上的ERP 9。理货。ERP 9将重新启动，在信息面板中，您可以看到它被配置为同步服务器，如下所示。
Detailed reference here.
详细的参考。
If the datas are present and you cannot access the sync then there must be restriction in your version
如果数据是存在的，并且您不能访问同步，那么您的版本中必须有限制。