sql server - Tally database synchronization with c# Application -

i want make application sync tally sales order , sales invoice tally our sql database. testing purpose using tally erp 9 educational version.

i have created sales orders in tally , need order details tally using tally odbc sql query

uptil per research, getting few sales order details voucher number,order date,'voucher type'.. etc. tally odbc table companyvoucher. few details came empty, although related data exist in tally order. reference , party name ... etc.

also, unable find tally odbc table few other sales order related data item name, item number , item quantity, rate , order total, order no etc.

can suggest sql query or tally odbc table can find these order related data. not sure, if can not access these details due educational version, , limitations on educational version on access of these details.

so please suggest me on this.

synchronisation process of replicating data between 2 or more computers using tally.erp 9 in client – server environment. data transferred client server , vice versa. tally.erp 9 offers control on frequency of synchronisation i.e., data can replicated after each transaction or updated @ specific intervals.

configure server synchronization

to configure server company synchronization, follow steps given below:

go gateway of tally > f12: configure > advanced configuration

in advanced configuration screen,

under client/server configuration section, set option tally acting server, run tally.erp 9 sync server specify required port number (e.g. 9009) in port field....

tab down tally sync configuration section:

set option ignore clients modified voucher type masters no, modifications made voucher type masters on client updated on server

set option enable sync logging yes, generate log file contains synchronized vouchers , saved in tally folder.

set option truncate previous log before syncing should set yes, allow previous log file overwritten current log file.

go end , press enter save details.

for above changes take effect, tally.erp 9 prompt restart application shown:

press enter or select yes restart tally.erp 9 on server computer. tally.erp 9 restart , in information panel can see configured sync server shown below.

detailed reference here.

if datas present , cannot access sync there must restriction in version