Monday, June 7, 2021

udiMagic v11 Release 2.7

 TEMPLATE MODIFICATIONS


1. Vouchers-V11-Sales-Purchase-With-Stockitems-Basic.xls
New column for ITEM AMOUNT in FOREX

2. Vouchers-V11-Sales-Purchase-With-Stockitems-Advanced.xls
a. New column for ITEM AMOUNT in FOREX
b. FOREX RATE does not appear correctly as it is rounded to two (2) decimals. This has been corrected now.


IMPORTANT NOTES for FOREX entries

  1. All the AMOUNT or RATE figures (in the aforesaid templates) are to be specified in BASE CURRENCY. 
  2. For FOREX transactions, you have to specify the CURRENCY and the ROE for which separate columns have been provided (at the end of the sheet). Based on the ROE, the FOREX AMOUNT is automatically computed.
  3. The FOREX figures are computed using the formula (BASECURRENCY_AMOUNT * ROE).
  4. As these automatically computed FOREX figures may differ (in decimals points) from the actual transaction figures, we have provided additional columns to specify the following :
    • ITEM RATE in forex
    • ITEM AMOUNT in forex
  5. All other FOREX figures will be computed automatically using the BASECURRENCY_AMOUNT and the ROE.


Tuesday, February 16, 2021

udiMagic v11 Release 2.6

 udiMagic now supports SSL / HTTPS to securely connect over the internet.

Saturday, January 16, 2021

udiMagic v11 Release 2.5

TEMPLATE MODIFICATIONS

1. Vouchers-V11-Sales-Purchase-With-Stockitems-Advanced.xls

New Features : EInvoicing 

The following new columns have been added :

       a. MailingName (Under Buyer details)

       b. PinCode (Under Buyer)

       c. MailingName (under Consignee details)

       d. PinCode (Under Consignee datails)

       e. BillToPlace (Under EInvoicing)

       f. ShiptoPlace (Under EInvoicing)

Fixes

a.  For Sales or Purchase entries with multi-currency, the Forex Rate is not shown in Tally (if the option "Inclusive Tax" is enabled for stockitems). This has been rectified now.

b. When a stockitem includes Cess "Based on Quantity", it is incorrectly imported in Tally as Cess "Based on Value". This issue has been resolved now.

2. Vouchers-V11-Financial-Transactions-Single-line-entry-Basic.xls

Fixes:

1. Incorrect Column Reference given for the following fields. This has been now corrected.    

    a. BankersDate

    b. IFSCODE

    C. BankName


Thursday, December 31, 2020

udiMagic v11 Release 2.4

FIXES

Out of Memory Error
While importing financial vouchers using the standard excel template, if there are more than 2000 ledgers in a single voucher then "Out of Memory" error is displayed and the udiMagic software halts.

This issue has been resolved now.

Tuesday, October 13, 2020

udiMagic v11 Release 2.3

Template Modifications

1. Vouchers-V11-Sales-Purchase-With-Stockitems-Advanced.xls
This template now supports Sales with TCS under section 206C. Please refer the sample data given in the template relating to TCS.

2. Master-StockItemMaster.xls
This template now supports TCS. You can enable TCS for stock items using this template.

3. Vouchers-V11-Receipts-and-Payments-with-multiple-references.xls
New Field : PARENT GROUP. This is an optional field.

You can now specify the PARENT GROUP for the Party ledger. However, the Parent Group must be a pre-defined group or must exist in Tally ERP.

Tuesday, September 1, 2020

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.



Monday, August 24, 2020

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, specify the Tally IPAddress and Port Number.

Case 1 (IPv4 Address)
Tally IP Address : 127.0.0.1
Tally Port : 9000

or

Case 2 (IPv6 Address)
Tally IP Address : [::1}
Tally Port : 9000

or

Case 3 (Localhost name)
Tally IP Address : localhost
Tally Port : 9000

After savings the udiMagic Settings, click the "Test Tally Connection" icon or restart udiMagic Software to automatically connect to Tally ERP 9.

Remarks:
If you are using IPv6 loopback address, then you must use square brackets as shown above.

For Advanced Users
You can use netstat to check the Tally Port Number.

a. Start Windows PowerShell in admin mode
b. Type the following:
netstat -aon | Select-String -pattern ":9000"

Add the required Address (if missing)
netsh http add iplisten 127.0.0.1