{"id":40,"date":"2011-04-14T19:30:45","date_gmt":"2011-04-14T14:00:45","guid":{"rendered":"http:\/\/rtslink.com\/tally-erp\/?p=40"},"modified":"2011-04-14T19:30:45","modified_gmt":"2011-04-14T14:00:45","slug":"changing-ledger-allocation-details-for-stock-items-in-tally-erp","status":"publish","type":"post","link":"https:\/\/www.rtslink.com\/tally-erp\/2011\/04\/changing-ledger-allocation-details-for-stock-items-in-tally-erp\/","title":{"rendered":"Changing Ledger Allocation details for Stock-Items in Tally ERP"},"content":{"rendered":"

How can I change the Ledger Allocation details for multiple Stock Items in Tally ERP ? <\/em><\/p>\n

Brief description of the Query<\/strong>
\nI am using POS Sales for invoicing. I have created a Voucher class (incl VAT), so that in the Invoice the rates are inclusive of all the taxes. When creating Stock-Items, I use the option “Set\/Modify Default Ledgers for Invoicing” to specify the Ledger allocation for Sales Invoice as follows :-<\/p>\n

Sales @ 13.5% == 88.1057<\/div>\n
\n

Output VAT @ 13.5%<\/a> ==11.8943<\/p>\n

Now as the VAT rates changed from 13.5% to 14%, I will have to manually alter each and every Stock-Item.\u00a0 Around 6000 SKU’s comprising both items at 5% & 13.5% Vat rates.<\/p>\n<\/div>\n

Is there any solution to update the Ledger allocations details for multiple stock-items\u00a0 together in\u00a0 Tally.ERP ?
\n<\/em><\/div>\n

<\/p>\n

Solution<\/strong><\/div>\n
1) Take back up of Tally data (for safety purpose)<\/div>\n
2) Use the option “Gateway of\u00a0 Tally >> Display >> List of Accounts >> Alt+E” to export the STOCKITEM Masters in XML format.<\/div>\n
\n

Remarks: This will create a file named Master.xml. in Tally folder<\/em><\/p>\n

3) Next, open the Master.xml file in Notepad and search\/replace 88.1057 (whatever old rate is) with\u00a0 New Rate. After this save, the Master.xml file<\/p>\n<\/div>\n

4) Next, import the Master.xml file into Tally using option “Gateway of Tally >> Import of Data >> Masters”<\/div>\n","protected":false},"excerpt":{"rendered":"

How can I change the Ledger Allocation details for multiple Stock Items in Tally ERP ? Brief description of the Query I am using POS Sales for invoicing. I have created a Voucher class (incl VAT), so that in the Invoice the rates are inclusive of all the taxes. When creating Stock-Items, I use the<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[21,57,19],"class_list":["post-40","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-import-of-data","tag-tally-erp","tag-vat"],"_links":{"self":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts\/40","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":11,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":51,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/posts\/40\/revisions\/51"}],"wp:attachment":[{"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rtslink.com\/tally-erp\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}