Vouchers in Tally ERP and your database

1) Verification of Vouchers (missing vouchers) in Tally ERP and your database.

Usage:-

http://localhost:90/dx-fusion/index.php?task=3

Online Training Session - 21st Dec., 2011

Session Topic
Exporting UDFs data from Tally ERP 9 into your database using DX-Fusion.

For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Online Training Sessions

Shweta Softwares now provides live (real time) online training sessions to enable users to use its products more effectively and easily.

The Online Training Sessions are :-
i)  live (real-time), and not prerecorded,
ii) held at regular intervals.

To attend the Online Training Sessions, you must have :-
i) PC or a laptop,
ii) broadband Internet connection,
iii) headset and mike (optional)

For more details, please refer http://www.rtslink.com/online-training-sessions/

DX-Fusion developer license now available

DX-Fusion developer license is now available. Please refer http://www.rtslink.com/dx-fusion/dx-fusion-standard-edition-details.pdf  for details

DX-Fusion Release 1.7

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

1) Verification of Ledger balances in Tally ERP and your database.

Usage:-

http://localhost:90/dx-fusion/index.php?task=1

2) Verification of StockItem balances in Tally ERP and your database.

Usage:-

http://localhost:90/dx-fusion/index.php?task=2

SQL SELECT to fetch Voucher entries (Stock details)

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

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

SELECT all vchmain.vchid,vchmain.vchnumber,vchmain.reference,vchmain.vchdate,
mv.name as vchtype,mv.parent as basevchtype,ms.name as stockitem, 
vchinv.actualqty,vchinv.billedqty,mu.name as unit,vchinv.rate,vchinv.amount, 
vchinv.discount 
FROM vchinv,masterstockitem ms,vchmain,mastervouchertype mv,masterunit mu 
WHERE vchmain.companyguid='6f273852-3e2d-477b-9800-8d13d6fae87b' and 
vchinv.itemguid=ms.masterguid and vchinv.unitguid=mu.masterguid and 
vchinv.vchguid=vchmain.vchguid and vchmain.vchtypeguid=mv.masterguid 

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