Tally ERP 9 Speed Issues
In case, if you are using Tally ERP 9 and are importing data into your existing Tally Company which contains hundreds or thousands of Masters (Ledger Masters or StockItem Masters), you may experience very slow speed while processing of Masters.
We have already written to Tally Solutions, Bangalore sometime back about this and it has been confirmed to be an issue / problem with Tally ERP 9. You can get more information about this issue (Tally ERP 9 speed issues with SELECT SQL) at http://www.rtslink.com/tally/tally-erp-9.html#speed-issues
Solution
UDIMagic v3.0 Release 1.97 uses a different technique to process the Masters records. This eliminates the use of SELECT SQL and results in improved performance.
If you are using Tally ERP 9 and experiencing slow speeds, please follow these steps :-
1) Upgrade to UDIMagic v3.0 Release 1.97 (or higher)
2) Make the following changes in the UDIMAGIC.INI (configuration file)
[UDIMAGIC]
;;Add this line under the UDIMAGIC heading
IgnoreDuplicateMasters=Yes
3) Save the UDIMAGIC.INI file and retry importing data into Tally ERP 9 using UDIMagic.
Want to import data from excel to Tally? Try udiMagic software. It comes with a wide range of pre-designed Excel templates with GST features. It is created and distributed by Shweta Softwares, and was first launched in 2007.
Friday, August 28, 2009
Tuesday, August 25, 2009
How to export Party Name's and Addresses from Tally to MS-Excel
Tally to MS-Excel
Query"How do I export the Party Names and their addresses from Tally to MS-Excel ?"
Ans:
You can get the aforesaid details in Tally using UDIMagic Free Edition.
Steps :-
1) Download and install UDIMagic Free Edition from this link
http://download.cnet.com/UDI-Magic-Free-Edition/3000-2066_4-77717736.html
2) Use the following SELECT statement to retrieve Party Names and addresses.
Select $Name,$_Address1,$_Address2,$_Address3,$_Address4,$_Address5,
$StateName,$PinCode,$LedgerPhone,$Email,$ClosingBalance From LEDGER
where $$IsChildOf:$GroupSundryDebtors
OR
Select $Name,$_Address1,$_Address2,$_Address3,$_Address4,$_Address5,
$StateName,$PinCode,$LedgerPhone,$Email,$ClosingBalance From LEDGER
where $IsBelongsTo:$GroupSundryDebtors
Remarks:-
The $$IsBelongsTo:$$GroupSundryDebtors function is used to retrieve Ledgers which fall directly under the group "Sundry Debtors" or sub-groups created under "Sundry Debtors"
Tuesday, August 11, 2009
VBA Macro - Speed up
Excel to Tally
If you have Excel VBA macro code (using with UDIMagic) that runs slow, the chances are it's caused by Excel having to recalculate at each line of code.
The code below shown how we can switch calculation into manual, run some code, then put it back how it was.
Sub GoToManual()
Dim xlCalc As XlCalculation
xlCalc = Application.Calculation
Application.Calculation = xlCalculationManual
On Error GoTo CalcBack
'YOUR CODE
Application.Calculation = xlCalc
Exit Sub
CalcBack:
Application.Calculation = xlCalc
End Sub
If you have Excel VBA macro code (using with UDIMagic) that runs slow, the chances are it's caused by Excel having to recalculate at each line of code.
The code below shown how we can switch calculation into manual, run some code, then put it back how it was.
Sub GoToManual()
Dim xlCalc As XlCalculation
xlCalc = Application.Calculation
Application.Calculation = xlCalculationManual
On Error GoTo CalcBack
'YOUR CODE
Application.Calculation = xlCalc
Exit Sub
CalcBack:
Application.Calculation = xlCalc
End Sub
Subscribe to:
Posts (Atom)