Wednesday, December 19, 2012

Multi-Currency feature enabled in Tally

If you have enabled multi-currency feature in Tally, you must set the following option before transferring data from Tally to your database.

"Gateway of Tally >> Accounts Info >> Currencies >> Alter". Next, select your currency and set the option "Put a space between Amount and Symbol" to NO. This is to be done for all currencies.

DX-Fusion transfer data from Tally to your database in BASE CURRENCY only. The multi-currency figures / values are not transferred to your database.

Monday, January 16, 2012

Vouchers in Tally ERP and your database

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



Saturday, December 17, 2011

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

Tuesday, December 13, 2011

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

Friday, August 5, 2011

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.


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


Thursday, July 28, 2011

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, as vchtype,mv.parent as basevchtype, as stockitem, 
vchinv.actualqty,vchinv.billedqty, as unit,vchinv.rate,vchinv.amount, 
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