Posts

Max 65535 rows in XLS

XLS format files Excel 2003 and earlier versions use the XLS format. In this format, the maximum number of rows supported are 65535.  As the Standard templates provided with udiMagic Software are of XLS format, the maximum number of rows available are 65535 in Excel 2003 or lower versions. However, you can save the file as xlsx or xlsm or xlsb for more than 65535 rows as shown below. XLSX format files Excel 2007 supports XLSX format files in which the maximum number of available rows are 1048576. IMPORTANT 1. If you want more than 65535 rows, then you must install or upgrade to Excel 2007 or higher version. 2. Next, open the udiMagic Standard template and then use the option Save As to save the file with extension XLSX or XLSM or XLSB.

IPv4 vs IPv6 loopback address

In this post, we shall see how to connect to Tally ERP. Connect to Tally using a Browser You can connect to Tally ERP 9 using any browser [Chrome, Firefox etc] In the browser Address-bar, type the following : http://127.0.0.1:9000           [for IPv4 connectivity] or http://[::1]:9000               [for IPv6 connectivity] or http://localhost:9000           [Resolves to IPv4 or IPv6] On Success, you will be able to see this message in the browser : <RESPONSE>Tally.ERP 9 Server is Running</RESPONSE> Connect to Tally using udiMagic In the udiMagic Settings screen (or udimagic.ini file), specify the Tally IPAddress and Port Number. Case 1 : IPv4 Address in udimagic.ini [Tally] ServerAddress=127.0.0.1 ServerPort=9000 or Case 2 : IPv6 Address in udimagic.ini [Tally] ServerAddress=[::1] ServerPort=9000 or Case...

udiMagic v7.0 support to be discontinued from 1st Sep 2020

udiMagic v7.0 (or lower versions) customers / users are requested to note that the support for udiMagic v7.0 shall be discontinued from 1st September 2020 and there shall be no product enhancements in udiMagic v7.0 thereafter. Also, to avail technical support and / or product enhancements, users will have to subscribe / buy the udiMagic Subscription license. Perpetual license users can continue to use udiMagic v7.0 even after 1st September 2020 in accordance with the licensing agreement, but no support or upgradation to latest version shall be available after the said date.

udiMagic v11 Release 2.2

Template Modifications 1. Vouchers-V11-Sales-Purchase-With-Stockitems-Advanced.xls a. New Field : Currency Conversion factor . This is an optional field. Example : 70.15/USD   Syntax : BaseCurrency/ForeignCurrency b. New Field : NoOfPackages (under section Additional details: Exports Taxable). This is an optional field c. New Field : Marks (under section Additional details: Exports Taxable). This is an optional field 2. Vouchers-V11-Sales-Purchase-With-Stockitems-Basic.xls New Field :  Currency Conversion factor . This is an optional field. 3. Vouchers-V11-Sales-Purchase-Without-Stockitems-Advanced.xls This format now supports ROW-WISE ledgers also. Previously, only Column-wise ledgers could be used in this format. Here's what it means : COLUMN-WISE ledgers (Horizontal)   Ledger1Name Ledger1Amount Ledger2Amount Ledger2Amount ​Sales 5% ​100 Sales 18% 100 PS: Previously, you had to specify each ledger in a separate column. ROW-WISE ledgers (Vertical) Ledger1Name L...

udiMagic Perpetual licensing changes

Shweta Softwares will stop the sale of perpetual licenses of udiMagic software from August 1st, 2020. The purchase of new licenses thereafter will only be available by subscription. FAQs Q1. Does this affect existing software purchased under a perpetual license? A1. No. Existing or new perpetual licenses purchased up to July 31st, 2020, remain valid. Q2.  Can I continue to use my perpetual license? A2. Yes.  Customers having a perpetual software license and can continue to use it in accordance with their perpetual license agreement. The end-of-sale of perpetual licenses only impacts the ability to make new purchases of perpetual licenses. Q3. Why is Shweta Softwares transitioning to subscription licenses? A3. Subscription licenses offer a lower entry price and are available on pay-as-you-go model.

udiMagic v11 Release 2.1

Template Modifications 1. Master-StockItemMaster.xls a. If the group-name field is kept blank under the "Default Sales Ledger Allocation" section, then the default group is taken as "Sales Accounts" b. If the group-name field is kept blank under the "Default Purchase Ledger Allocation" section, then the default group is  taken as "Purchase Accounts" 2. Vouchers-V11-Stock-Journal.xls New fields / columns have been kept for specifying the "Additional Cost Ledger" details. Other Fixes 1. Char 160 is replaced by char 32, but the new char 32 is inserted at the  wrong position. This has now been rectified. 2. udiMagic now supports VBA macro functions with upto 20 parameters. Earlier it was limited to 8 parameters.

udiMagic v11 Release 2.0

Template Fixes: Master-StockItemMasters.xls The price-level (Qtyfrom; Qty-less-than) columns were erroneously  removed in V11 R1.8. This has been fixed now.