SQL SELECT to fetch Voucher entries

Here's a SQL SELECT statement to fetch the Voucher entries (Financial details) only from various tables created by DX-Fusion utility :-

(: TO DO - Change the CompanyGUID below - a.companyguid='xxx' :)

SELECT all a.vchid,a.vchnumber,a.reference,a.vchdate,mv.name as vchtype,mv.parent as basevchtype,m.name as ledgername,v.amount

FROM vchled v,masterledger m,vchmain a,mastervouchertype mv

where a.companyguid='6f273852-3e2d-477b-9800-8d13d6fae87b' and v.ledgerguid=m.masterguid and

v.vchguid=a.vchguid and a.vchtypeguid=mv.masterguid

DX-Fusion Standard Edition packs

DX-Fusion Standard Edition (Commercial version) is now available in following packs :-

1) DX-Fusion (Standard Edition) Normal pack
2) DX-Fusion (Standard Edition) Value pack

For more details on price and features, please refer http://www.rtslink.com/buy.html

DX-Fusion Release 1.61

The DX-Fusion v1.0 Release 1.61 contains the following modifications :-

1) In the VCHMAIN table, the field-size of certain fields has been increased
2) In the MASTERLEDGER table, the field-size of certain fields has been increased.

Tally ERP 9 to SQL Server

Here's a VB6 program which allows you to get data from Tally ERP 9 into SQL Server database.

RTSXQuery Error : Class not registered.

The aforesaid error appears if the C:\WINDOW\SYSTEM32\DX-FUSION.DLL  is not registered automatically during installation due to lack of administrator rights.

Solution:-
1) Un-install the DX-Fusion module
2) Log-in as Administrator and re-install DX-Fusion.

In case, if you still face problems, contact Shweta Softwares by email at sales @ rtslink. com  (remove spaces)

How to transfer Tally data into MySQL ?

Steps to transfer Tally data into MySQL

1) Download and install DX-Fusion from :-
http://www.rtslink.com/images/dx-fusion-fe-v1.0.exe

2) Download and install MySQL driver from :-
http://www.rtslink.com/images/mysql-connector-odbc-3.51.27-win32.zip

3) Make changes in the c:\wamp\www\dx-fusion\dx-fusion.ini file

DATABASETYPE="MYSQL"

CONNECTIONSTRING="Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=tally; User=root;Password=;Option=3;"

4) Start Internet Explorer and type out :-
http://localhost:90

5) Click on myphpadmin

6) Click on databases tab and create a database named Tally.

7) Start Tally, Open your Company and then select option "DX-Fusion >> Ctrl+K" to export Tally data into MySQL database

Tally to MySQL

DX-Fusion v1.0 Release 1.2 supports transfer of data from Tally into MySQL.

You must download and install the driver for MySQL from this link :-
http://www.rtslink.com/images/mysql-connector-odbc-3.51.27-win32.zip