Friday, May 29, 2009

How to overwrite or SKIP Voucher if it already exists in Tally ?

Excel to Tally

UDIMagic v3.0 Release 1.90 provides a new configuration-setting for "Treatment of entries already existing in Tally".

In simple words, you can specify how the existing Vouchers in Tally are handled by UDIMagic. i.e. whether the :-
a) Vouchers must be overwritten, if they already exist in Tally Software or;
b) Vouchers must be SKIPPED, if they already exist in Tally Software

STEPS
1) Open the file UDIMagic.ini in Notepad (configuration file which is there in c:\udi-magic folder)
2) Add the line IgnoreDuplicateVouchers=Yes under section [UDIMAGIC] as shown below :-

[UDIMAGIC]
;;Alternative 1
;;Vouchers will NOT be overwritten if already existing in Tally
IgnoreDuplicateVouchers=Yes

;;Alternative 2
;;Vouchers will be overwritten if already existing in Tally. Un-comment if required
;;IgnoreDuplicateVouchers=No

3) Next, save the file.




Thursday, May 28, 2009

Sales Vouchers with Cash, Scheme Discounts

Excel to Tally

Sample Excel-sheet format for Sales vouchers containing :-

a) Cash discount
b) Scheme discount

Download the Excel Sheet and XML tags

Journal Vouchers

Excel to Tally

Sample Excel-sheet format for Journal (JV) vouchers

Download the Excel Sheet and XML tags

Sales vouchers of a FMCG distributor-firm

Excel to Tally

Sample Excel-sheet format for Sales vouchers of a FMCG distributor-firm.


Download the Excel Sheet and XML tags

Sales and Receipt Vouchers in a single file

Excel to Tally

Sample Excel-sheet format for Sales & Receipt vouchers containing :-

a) Multiple-VAT Rates (i.e. Sales 4%, Sales 12.5%, Sales Exempt
b) CST Sales
c) Freight, Postage and other charges
d) Receipt Voucher entries (Auto-posting for Cash Sales)

Download the Excel Sheet and XML tags

Sales and Receipt Vouchers

Excel to Tally

Sample Excel-sheet format for Sales & Receipt vouchers containing :-

a) Stock-Items
b) Multiple-VAT Rates
c) Multiple BYB References

Download the Excel Sheet and XML tags


Saturday, May 16, 2009

UDI-Magic FAQs

Here are some Frequently asked questions about UDI-Magic.


Friday, May 8, 2009

Tally ERP 9 SPEED Issues

Recently while working on Tally ERP 9 we faced some problems. Tally ERP 9 was very slow in processing SQL-SELECT statements.

Click here for more details on the Tally ERP 9 SPEED Tests that we performed.