udiMagic Release Notes

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

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.

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

The aforesaid error generally appears while : Uploading "StockItem Masters" into a Tally Company; which already contains the same StockItem but with a different unit of measurement. Here's a example : StockItem with name " Item A " exists in Tally Company having Unit of Measurement (UOM) as " Nos" . Let's now try to  modify it's UOM to Kgs . As you can see below,  the cursor does NOT go the the Unit field . Remarks: This is a restriction in Tally Software. You cannot alter the UOM of a StockItem if one or more records / vouchers exist which contain that StockItem