Merge unwanted duplicate ledgers Duplicate Ledgers are created through a typo or oversight. When vouchers refer to them they can not be deleted easily. Manually opening all the vouchers that contain them and changing reference to correct ones is a laborious process. Here is a utility that makes the task easily. Steps Open Tally; Open some company. Open MergeDupLed Click Refresh Ledger List Select Duplicate ledger Click post
Merge Duplicate Item Steps Open Tally; Open some company. Open MergeDupItem. Click Refresh Item Lis. Select Duplicate, Item to be replaced with. Click post.
1. Ledger Vouchers / Stock Vouchers Report to find vouchers involved. Actually to get Dates as full Day book search is slow. 2. Voucher Register Report to get full details of the vouchers. I remember from earlier versions Day book though powerful has some limitation. It works only on CurrentDate. (Edited) 3. Alteration of individual voucher in Object mode. Here I export all details I got to avoid any side effect. Unfortunately I could not do this in Data mode.
Source for Merge Duplicate Ledger https://sourceforge.net/p/excel2tally/code/ci/master/tree/xmldb_ML.pas
I assume the message / exception was from Tally. Right? Do you have a large number of vouchers in a single day?
These apps do not work with Tally 2.0.1. Updated sources are in https://github.com/sridharxp/excel2tally/tree/master/merge. In xmldb_MI.pas find required changes to xml. Also I found it necessary to call many times Merge Duplicate Ledger. The reason is Tally modified the SVToDate due to some internal logic in 'Ledger Vouchers' report.
<ENVELOPE><HEADER><VERSION>1</VERSION><TALLYREQUEST>Export</TALLYREQUEST><TYPE>Data</TYPE><ID>Voucher Register</ID></HEADER><BODY><DESC><STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT><SVFROMDATE TYPE="Date">01-12-2021</SVFROMDATE><SVTODATE TYPE="Date">31-12-2021</SVTODATE></STATICVARIABLES><TDL><TDLMESSAGE><REPORT NAME="Sales Vouchers" ISMODIFY="Yes"></REPORT></TDLMESSAGE></TDL></DESC></BODY></ENVELOPE> Above XML for requesting Day Book between dates is failing after tally 2.0.1 update,Getting error as "Error in TDL. 'PartB Body'No 'PARTS' or 'LINES' or 'BUTTONS'!" please help sir
Thank you very much sir, but after removing <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> tag from our XML request,we are getting correct response sir,Dont no why sir
I mean using which language you are sending request to Tally? Are you setting content/type header and removing xml comments?