Saturday, May 20, 2017

INTRODUCING UDIMAGIC V8.0

We are pleased to announce the launch of udi-Magic v8.0. The details are as under :-

NEW TEMPLATE(s)
A new template for Flipkart Settlement / Receipts has been included in udi-Magic v8.0 as shown below :

Template Name: Vouchers-Flipkart-Receipts-and-Journal.xls
XML-File Name : Vouchers-Flipkart-Receipts-and-Journal-xml-tags.xml

Steps:
1. Download and install udi-Magic v8.0
2. Copy/paste your Flipkart settlement data into aforesaid template / xls.
3. Start udi-Magic v8.0
4. Go to "Excel to Tally >> Import data into Tally"
5. Select files :
Excel File: Vouchers-Flipkart-Receipts-and-Journal.xls
XML-File : Vouchers-Flipkart-Receipts-and-Journal-xml-tags.xml 

6. Click the Start button to import data into Tally.

Remarks:
For each Settlement Number, two entries are posted in Tally .i.e.one entry for Receipt voucher and another for Journal voucher.

SUPPORT FOR TALLY ERP 9 RELEASE 5.5.8 AND GST
udi-Magic v8.0 works with Tally ERP 9 Release 5.5.8 (latest release at the time of this post).

The GST related updations shall be made available in udi-Magic v8.0 as and when the GST features are made available in the Tally ERP.

SUPPORT FOR EXCEL 2016
udi-Magic v8.0 works with Excel 2016 (32-bit and 64-bit)

Note
1. Customer(s) who have purchased udi-Magic v7.0 on or after 01/01/2017 shall be provided free upgrade to udi-Magic v8.0.
2. Customer(s) who have upgraded to udi-Magic v7.0 on or after 21/02/2017 shall be provided free upgrade to udi-Magic v8.0
3. All eligible customers can get the link to download udi-Magic v8.0, from here: https://www.rtslink.com/customer/forgot/

Wednesday, May 17, 2017

How to fetch the Tally Serial Number ?

SQL SELECT Statement

SELECT $$SerialNumber FROM Company

Remarks:
You can use the aforesaid SELECT Statement to fetch the Tally Serial using "Tally ODBC" or "Calculator panel" in Tally.

Monday, May 8, 2017

Template modifications

Template Name : Master-V6-StockItem-Multiple-price-levels

Bug fixes
1. StockItem ALIAS gets overwritten/removed when the Price List is imported - Now fixed.

Template Name : Master-StockItemMaster

New Field
"Inclusive of Tax" column has been included. Refer blog article : http://www.udimagic.com/2017/04/inclusive-of-vat.html

Remarks
Calc VAT on MRP
Refer blog article : http://www.udimagic.com/2017/04/calculate-vat-on-mrp.html

Sunday, April 30, 2017

Calculate VAT on MRP

Applicable to : Tally ERP 9 Release 5.5.6

Recently, we noticed some issues while using the "Calc VAT on MRP" feature. We posted two SALES INVOICEs in Tally, the details being as follows :

Sale Invoice 1

Stockitem Master Name: Item CX
MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 5%

Sale Voucher
StockItem Name : Item CX
Qty : 1
Rate : Rs 238.09 (Auto computed in Tally)
Amount : Rs 238.09 (Auto computed in Tally)
VAT Amount : Rs 11.91 (Auto computed in Tally)

Sale Invoice 2

Stockitem Master Name : Item DX

MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 4%
Addl Tax : 1%

Sale Voucher
StockItem Name : Item DX
Qty : 1
Rate : Rs 237.98 (Auto computed in Tally)
Amount : Rs 237.98 (Auto computed in Tally)
VAT Amount : Rs 9.62 (Auto computed in Tally)
Addl VAT Amt: Rs 2.40 (Auto computed in Tally)

Remarks
As it can be seen, the VAT amount is incorrectly computed when we specify VAT + Addl Tax in the StockItem Master and "Calc VAT on MRP" is enabled.

VAT 5% => Rs 11.91 (Correct VAT in Sale Voucher 1)
VAT 4+1% => Rs 12.02 (Incorrect VAT in Sale Voucher 2)

Workaround
A workaround is to disable the "Calc VAT on MRP"  and enable "Is Inclusive of duties and taxes" only in the StockItem Master. This way, VAT is computed correctly in both the situations as mentioned above.

Saturday, April 29, 2017

Inclusive of VAT

A new option "Allow inclusive of tax for stock Items" has been included in Tally ERP 9 Release 5.0 onwards. This allows you to prepare Sales Invoice with Rate inclusive of VAT.

Tally ERP 9 Release 5.0
1. Go to Stockitem creation/alteration
2. Press F12 [Config]. This displays the Stockitem Configuration screen as shown underneath :

Tally ERP 9 Release 5.0

3. Enable "Allow inclusive of tax for stock items" as shown above.

4. Back in the Stockitem screen, enable VAT Applicable and specify the VAT Rate using "Set/alter VAT details"
5. Next, set "Is inclusive of duties and taxes" to Yes


Tally ERP 9 Release 5.0



Tally ERP 9 Release 4.92 or lower
1. Go to Stockitem creation/alteration
2. Press F12 [Config]

This displays the Stockitem Configuration screen as shown underneath (without the Inclusive option) :

Tally ERP 9 Release 4.92
Remarks:
The "Is inclusive of duties and taxes" is NOT there in Tally ERP 9 Release 4.92

Sunday, April 23, 2017

Incorrect Unit (UOM) when importing data into Tally

Query:
I am importing Sales/Purchase Vouchers with StockItems  using one of the Standard templates provided with udi-Magic. For a specific voucher in the XLS file, the UOM is specified as "Nos", but when I check the entry imported in Tally, it shows the UOM incorrectly as "Kgs".
Ans:
This would happen if the StockItem already exists in Tally with UOM as Kgs.

You must manually change the UOM in the StockItem Master. And this is only possible if there are no vouchers entries for that StockItem.

Friday, April 21, 2017

Template modifications

Of late, the following modifications have been done in the Standard templates :

Date : 22nd April 2017
Template : Vouchers-Bank-Statement.xls
New Column : Group-Name for Other Ledger
Remarks : If the Group-Name is not specified, then the Ledgers are created under group "New Ledgers"

Previous Changes

Date : 3rd April 2017
Template : Vouchers-V7-Sales-Purchase-Adavanced.xls
New columns in the Settings / CSV file :
NATUREOFTRANSACTION
TYPEOFINVOICE
CSTFORMRECVTYPE

Date : 3rd April 2017
Template : Master-LedgerMaster.xls
New columns for :
TaxType
NatureOfTransaction
VATRate
AdditionalTax

Date : 30th March 2017
Template : Master-LedgerMaster.xls
New fields added for :
VATDEALERTYPE, VAT Reg Date, CST Reg Date

Date : 28th March 2017
Template : Master-LedgerMaster
New column for COUNTRY

Download link (all templates) :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip