udiMagic Release Notes

Applicable to : udi-Magic v8.0 Release 2.0 The following changes have been done in the Standard templates with regards to GST features : NEW TEMPLATEs (Added) 1. Vouchers-V8-Sales-Purchase-Advanced.xls 2. Vouchers-V8-Sales-Horizontal-format-without-stockitems.xls 3. Vouchers-V8-Purchase-Horizontal-format-without-stockitems.xls OLD TEMPLATEs (removed) 1. Vouchers-V7-Sales-Purchase-Advanced.xls 2. Vouchers-V7-Sales-Horizontal-format-with-VAT-without-stockitems.xls 3. Vouchers-V7-Purchase-Horizontal-format-with-VAT-without-stockitems.xls TEMPLATEs MODIFIED 1. Master-LedgerMaster.xls 2. Master-StockItemMaster.xls PS: For more details in GST features in udi-Magic, please visit https://www.rtslink.com/gst/

Excel to Tally templates - Modifications The following changes have been done in udi-Magic Standard templates : Template-Name : Master-StockItemMaster.xls 1. New fields / columns for VAT and Excise 2. If Alternate units are used, the Opening Stock is not displayed in alternate units - Now fixed. Template-Name : Master-LedgerMaster.xls 1. New fields / columns related to VAT 2. New field ISCOSTCENTREAPPLICABLE Template-Name : Voucher-Physical-Stock-Journal.xls 1. New columns for Base-Voucher-Type and Voucher-Type 2. Voucher Number not imported - Now corrected. Template-Name : Voucher-Stock-Journal.xls 1.. New VoucherTypes not created as given in the XLS - Now corrected You can download (all templates) the zip file from this link : https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

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 ( l...

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.

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

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...

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 ...