Sir, i need a TDL-XML to export all the vouchers available for the current company in tally. Please help me to achieve this one Thanks in advance
My first question is, why you need this. If you want just to export Transaction from Tally, you can open Day book report and specify the Dates and export as xml file.
Hello Sir, i need to export a particular voucher form tally by using its MasterID. For this i am used the following TDL-XML, <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>OBJECT</TYPE> <SUBTYPE>Voucher</SUBTYPE> <ID TYPE="Voucher ID">104</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE> i am getting error message as follows, <ERRORMSG>Could not find Voucher:104!</ERRORMSG> Please help me to clear this one.
Hello sir , Thanks for your reply. i tried with this one but i am getting the same error message. My TDL-XML is as follows , <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>OBJECT</TYPE> <SUBTYPE>Voucher</SUBTYPE> <ID TYPE="Voucher ID">ID:104</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE> Error Message : <ERRORMSG>Could not find Voucher:ID:104!</ERRORMSG> Please help me to clear this one.
I am in same situation, please let me know if any one know how to fetch single order details by passing orderid... Please provide XML Post request for it.
<ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>Object</TYPE> <SUBTYPE>VOUCHER</SUBTYPE> <ID TYPE="Name">ID:24422</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <SVCURRENTCOMPANY>Company Name</SVCURRENTCOMPANY> </STATICVARIABLES> <FETCHLIST> <FETCH>Date</FETCH> <FETCH>VoucherTypeName</FETCH> <FETCH>VoucherNumber</FETCH> </FETCHLIST> </DESC> </BODY> </ENVELOPE> Try this
Yes its working ! and i got the correct voucher in reponse. It would be convinient if the response xml contains data listted in fetchlist tag instead of unnecessary tags.
@Vinothkumar S How do find the voucher id for those voucher which already exist in tally. for example my purchase voucher loook like this when i manually export voucher from tally ; <ENVELOPE> <HEADER> <TALLYREQUEST>Import Data</TALLYREQUEST> </HEADER> <BODY> <IMPORTDATA> <REQUESTDESC> <REPORTNAME>All Masters</REPORTNAME> <STATICVARIABLES> <SVCURRENTCOMPANY>Demo</SVCURRENTCOMPANY> </STATICVARIABLES> </REQUESTDESC> <REQUESTDATA> <TALLYMESSAGE xmlns:UDF="TallyUDF"> <VOUCHER REMOTEID="2321da9c-d56f-4eaf-a7fe-8a58b4bf3540-0000002c" VCHKEY="2321da9c-d56f-4eaf-a7fe-8a58b4bf3540-0000a3d7:00000010" VCHTYPE="Purchase" ACTION="Create" OBJVIEW="Invoice Voucher View"> <OLDAUDITENTRYIDS.LIST TYPE="Number"> <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS> </OLDAUDITENTRYIDS.LIST> <DATE>20141101</DATE> <GUID>2321da9c-d56f-4eaf-a7fe-8a58b4bf3540-0000002c</GUID> <PARTYNAME>Aroma Traders</PARTYNAME> <VOUCHERTYPENAME>Purchase</VOUCHERTYPENAME> <VOUCHERNUMBER>1</VOUCHERNUMBER> <PARTYLEDGERNAME>Aroma Traders</PARTYLEDGERNAME> <BASICBASEPARTYNAME>Aroma Traders</BASICBASEPARTYNAME> <CSTFORMISSUETYPE/> <CSTFORMRECVTYPE/> <FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE> <PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW> <BASICBUYERNAME>Demo</BASICBUYERNAME> <BASICDATETIMEOFINVOICE>1-Nov-2014 at 12:58</BASICDATETIMEOFINVOICE> <BASICDATETIMEOFREMOVAL>1-Nov-2014 at 12:58</BASICDATETIMEOFREMOVAL> <VCHGSTCLASS/> <DIFFACTUALQTY>No</DIFFACTUALQTY> <AUDITED>No</AUDITED> <FORJOBCOSTING>No</FORJOBCOSTING> <ISOPTIONAL>No</ISOPTIONAL> <EFFECTIVEDATE>20141101</EFFECTIVEDATE> <ISFORJOBWORKIN>No</ISFORJOBWORKIN> <ALLOWCONSUMPTION>No</ALLOWCONSUMPTION> <USEFORINTEREST>No</USEFORINTEREST> <USEFORGAINLOSS>No</USEFORGAINLOSS> <USEFORGODOWNTRANSFER>No</USEFORGODOWNTRANSFER> <USEFORCOMPOUND>No</USEFORCOMPOUND> <ALTERID> 87</ALTERID> <EXCISEOPENING>No</EXCISEOPENING> <USEFORFINALPRODUCTION>No</USEFORFINALPRODUCTION> <ISCANCELLED>No</ISCANCELLED> <HASCASHFLOW>No</HASCASHFLOW> <ISPOSTDATED>No</ISPOSTDATED> <USETRACKINGNUMBER>No</USETRACKINGNUMBER> <ISINVOICE>Yes</ISINVOICE> <MFGJOURNAL>No</MFGJOURNAL> <HASDISCOUNTS>No</HASDISCOUNTS> <ASPAYSLIP>No</ASPAYSLIP> <ISCOSTCENTRE>No</ISCOSTCENTRE> <ISSTXNONREALIZEDVCH>No</ISSTXNONREALIZEDVCH> <ISEXCISEMANUFACTURERON>Yes</ISEXCISEMANUFACTURERON> <ISBLANKCHEQUE>No</ISBLANKCHEQUE> <ISVOID>No</ISVOID> <ISONHOLD>No</ISONHOLD> <ISDELETED>No</ISDELETED> <ASORIGINAL>No</ASORIGINAL> <VCHISFROMSYNC>No</VCHISFROMSYNC> <MASTERID> 44</MASTERID> <VOUCHERKEY>180143813296144</VOUCHERKEY> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <INVOICEDELNOTES.LIST> </INVOICEDELNOTES.LIST> <INVOICEORDERLIST.LIST> </INVOICEORDERLIST.LIST> <INVOICEINDENTLIST.LIST> </INVOICEINDENTLIST.LIST> <ATTENDANCEENTRIES.LIST> </ATTENDANCEENTRIES.LIST> <ORIGINVOICEDETAILS.LIST> </ORIGINVOICEDETAILS.LIST> <INVOICEEXPORTLIST.LIST> </INVOICEEXPORTLIST.LIST> <LEDGERENTRIES.LIST> <OLDAUDITENTRYIDS.LIST TYPE="Number"> <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS> </OLDAUDITENTRYIDS.LIST> <LEDGERNAME>Aroma Traders</LEDGERNAME> <GSTCLASS/> <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE> <LEDGERFROMITEM>No</LEDGERFROMITEM> <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES> <ISPARTYLEDGER>Yes</ISPARTYLEDGER> <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE> <AMOUNT>420000.00</AMOUNT> <BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST> <BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST> <INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST> <TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST> <TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST> <VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST> <COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST> </LEDGERENTRIES.LIST> <LEDGERENTRIES.LIST> <OLDAUDITENTRYIDS.LIST TYPE="Number"> <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS> </OLDAUDITENTRYIDS.LIST> <BASICRATEOFINVOICETAX.LIST TYPE="Number"> <BASICRATEOFINVOICETAX> 5</BASICRATEOFINVOICETAX> </BASICRATEOFINVOICETAX.LIST> <TAXCLASSIFICATIONNAME>Input VAT @ 5%</TAXCLASSIFICATIONNAME> <LEDGERNAME>Input VAT @ 5%</LEDGERNAME> <GSTCLASS/> <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE> <LEDGERFROMITEM>No</LEDGERFROMITEM> <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES> <ISPARTYLEDGER>No</ISPARTYLEDGER> <ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE> <AMOUNT>-20000.00</AMOUNT> <VATASSESSABLEVALUE>-400000.00</VATASSESSABLEVALUE> <BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST> <BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST> <INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST> <TAXOBJECTALLOCATIONS.LIST> <CATEGORY>Input VAT @ 5%</CATEGORY> <TAXTYPE>VAT</TAXTYPE> <TAXNAME>1</TAXNAME> <PARTYLEDGER>Aroma Traders</PARTYLEDGER> <REFTYPE>New Ref</REFTYPE> <ISOPTIONAL>No</ISOPTIONAL> <ISPANVALID>No</ISPANVALID> <ZERORATED>No</ZERORATED> <EXEMPTED>No</EXEMPTED> <ISSPECIALRATE>No</ISSPECIALRATE> <ISDEDUCTNOW>No</ISDEDUCTNOW> <ISPANNOTAVAILABLE>No</ISPANNOTAVAILABLE> <ISSUPPLEMENTARY>No</ISSUPPLEMENTARY> <ISPUREAGENT>No</ISPUREAGENT> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <SUBCATEGORYALLOCATION.LIST> <STOCKITEMNAME>IMac</STOCKITEMNAME> <SUBCATEGORY>VAT</SUBCATEGORY> <DUTYLEDGER>Input VAT @ 5%</DUTYLEDGER> <SUBCATZERORATED>No</SUBCATZERORATED> <SUBCATEXEMPTED>No</SUBCATEXEMPTED> <SUBCATISSPECIALRATE>No</SUBCATISSPECIALRATE> <TAXRATE> 5</TAXRATE> <ASSESSABLEAMOUNT>-400000.00</ASSESSABLEAMOUNT> <TAX>-20000.00</TAX> <BILLEDQTY> 5 Nos</BILLEDQTY> </SUBCATEGORYALLOCATION.LIST> </TAXOBJECTALLOCATIONS.LIST> <TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST> <VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST> <COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST> <UDF:MAHWCASSESSABLEVALUE.LIST DESC="`MAHWCAssessableValue`" ISLIST="YES" TYPE="Amount" INDEX="10007"> <UDF:MAHWCASSESSABLEVALUE DESC="`MAHWCAssessableValue`">-400000.00</UDF:MAHWCASSESSABLEVALUE> </UDF:MAHWCASSESSABLEVALUE.LIST> </LEDGERENTRIES.LIST> <ALLINVENTORYENTRIES.LIST> <STOCKITEMNAME>IMac</STOCKITEMNAME> <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE> <ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE> <ISAUTONEGATE>No</ISAUTONEGATE> <ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE> <ISTRACKCOMPONENT>No</ISTRACKCOMPONENT> <ISTRACKPRODUCTION>No</ISTRACKPRODUCTION> <ISPRIMARYITEM>No</ISPRIMARYITEM> <ISSCRAP>No</ISSCRAP> <RATE>80000.00/Nos</RATE> <AMOUNT>-400000.00</AMOUNT> <ACTUALQTY> 5 Nos</ACTUALQTY> <BILLEDQTY> 5 Nos</BILLEDQTY> <BATCHALLOCATIONS.LIST> <GODOWNNAME>Main Location</GODOWNNAME> <BATCHNAME>Primary Batch</BATCHNAME> <DESTINATIONGODOWNNAME>Main Location</DESTINATIONGODOWNNAME> <INDENTNO/> <ORDERNO/> <TRACKINGNUMBER/> <DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED> <AMOUNT>-400000.00</AMOUNT> <ACTUALQTY> 5 Nos</ACTUALQTY> <BILLEDQTY> 5 Nos</BILLEDQTY> <ADDITIONALDETAILS.LIST> </ADDITIONALDETAILS.LIST> <VOUCHERCOMPONENTLIST.LIST> </VOUCHERCOMPONENTLIST.LIST> </BATCHALLOCATIONS.LIST> <ACCOUNTINGALLOCATIONS.LIST> <OLDAUDITENTRYIDS.LIST TYPE="Number"> <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS> </OLDAUDITENTRYIDS.LIST> <TAXCLASSIFICATIONNAME>Input VAT @ 5%</TAXCLASSIFICATIONNAME> <LEDGERNAME>Purchase A/c</LEDGERNAME> <GSTCLASS/> <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE> <LEDGERFROMITEM>No</LEDGERFROMITEM> <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES> <ISPARTYLEDGER>No</ISPARTYLEDGER> <ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE> <AMOUNT>-400000.00</AMOUNT> <BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST> <BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST> <INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST> <TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST> <TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST> <VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST> <COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST> </ACCOUNTINGALLOCATIONS.LIST> <TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST> <EXCISEALLOCATIONS.LIST> </EXCISEALLOCATIONS.LIST> <EXPENSEALLOCATIONS.LIST> </EXPENSEALLOCATIONS.LIST> </ALLINVENTORYENTRIES.LIST> <PAYROLLMODEOFPAYMENT.LIST> </PAYROLLMODEOFPAYMENT.LIST> <ATTDRECORDS.LIST> </ATTDRECORDS.LIST> <UDF:VATRESTRICTINVOICE.LIST DESC="`VATRestrictInvoice`" ISLIST="YES" TYPE="Logical" INDEX="10002"> <UDF:VATRESTRICTINVOICE DESC="`VATRestrictInvoice`">Yes</UDF:VATRESTRICTINVOICE> </UDF:VATRESTRICTINVOICE.LIST> </VOUCHER> </TALLYMESSAGE> <TALLYMESSAGE xmlns:UDF="TallyUDF"> <VOUCHER REMOTEID="2321da9c-d56f-4eaf-a7fe-8a58b4bf3540-0000000c" VCHKEY="2321da9c-d56f-4eaf-a7fe-8a58b4bf3540-0000a3d8:00000010" VCHTYPE="Purchase" ACTION="Create" OBJVIEW="Accounting Voucher View"> <OLDAUDITENTRYIDS.LIST TYPE="Number"> <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS> </OLDAUDITENTRYIDS.LIST> <DATE>20141102</DATE> <GUID>2321da9c-d56f-4eaf-a7fe-8a58b4bf3540-0000000c</GUID> <VOUCHERTYPENAME>Purchase</VOUCHERTYPENAME> <VOUCHERNUMBER>2</VOUCHERNUMBER> <PARTYLEDGERNAME>Cash</PARTYLEDGERNAME> <CSTFORMISSUETYPE/> <CSTFORMRECVTYPE/> <FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE> <PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW> <VCHGSTCLASS/> <DIFFACTUALQTY>No</DIFFACTUALQTY> <AUDITED>No</AUDITED> <FORJOBCOSTING>No</FORJOBCOSTING> <ISOPTIONAL>No</ISOPTIONAL> <EFFECTIVEDATE>20141102</EFFECTIVEDATE> <ISFORJOBWORKIN>No</ISFORJOBWORKIN> <ALLOWCONSUMPTION>No</ALLOWCONSUMPTION> <USEFORINTEREST>No</USEFORINTEREST> <USEFORGAINLOSS>No</USEFORGAINLOSS> <USEFORGODOWNTRANSFER>No</USEFORGODOWNTRANSFER> <USEFORCOMPOUND>No</USEFORCOMPOUND> <ALTERID> 12</ALTERID> <EXCISEOPENING>No</EXCISEOPENING> <USEFORFINALPRODUCTION>No</USEFORFINALPRODUCTION> <ISCANCELLED>No</ISCANCELLED> <HASCASHFLOW>Yes</HASCASHFLOW> <ISPOSTDATED>No</ISPOSTDATED> <USETRACKINGNUMBER>No</USETRACKINGNUMBER> <ISINVOICE>No</ISINVOICE> <MFGJOURNAL>No</MFGJOURNAL> <HASDISCOUNTS>No</HASDISCOUNTS> <ASPAYSLIP>No</ASPAYSLIP> <ISCOSTCENTRE>No</ISCOSTCENTRE> <ISSTXNONREALIZEDVCH>No</ISSTXNONREALIZEDVCH> <ISEXCISEMANUFACTURERON>No</ISEXCISEMANUFACTURERON> <ISBLANKCHEQUE>No</ISBLANKCHEQUE> <ISVOID>No</ISVOID> <ISONHOLD>No</ISONHOLD> <ISDELETED>No</ISDELETED> <ASORIGINAL>No</ASORIGINAL> <VCHISFROMSYNC>No</VCHISFROMSYNC> <MASTERID> 12</MASTERID> <VOUCHERKEY>180148108263440</VOUCHERKEY> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <INVOICEDELNOTES.LIST> </INVOICEDELNOTES.LIST> <INVOICEORDERLIST.LIST> </INVOICEORDERLIST.LIST> <INVOICEINDENTLIST.LIST> </INVOICEINDENTLIST.LIST> <ATTENDANCEENTRIES.LIST> </ATTENDANCEENTRIES.LIST> <ORIGINVOICEDETAILS.LIST> </ORIGINVOICEDETAILS.LIST> <INVOICEEXPORTLIST.LIST> </INVOICEEXPORTLIST.LIST> <ALLLEDGERENTRIES.LIST> <OLDAUDITENTRYIDS.LIST TYPE="Number"> <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS> </OLDAUDITENTRYIDS.LIST> <LEDGERNAME>Cash</LEDGERNAME> <GSTCLASS/> <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE> <LEDGERFROMITEM>No</LEDGERFROMITEM> <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES> <ISPARTYLEDGER>Yes</ISPARTYLEDGER> <ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE> <AMOUNT>19500.00</AMOUNT> <BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST> <BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST> <INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST> <TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST> <TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST> <VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST> <COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST> </ALLLEDGERENTRIES.LIST> <ALLLEDGERENTRIES.LIST> <OLDAUDITENTRYIDS.LIST TYPE="Number"> <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS> </OLDAUDITENTRYIDS.LIST> <LEDGERNAME>Purchase A/c</LEDGERNAME> <GSTCLASS/> <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE> <LEDGERFROMITEM>No</LEDGERFROMITEM> <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES> <ISPARTYLEDGER>No</ISPARTYLEDGER> <ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE> <AMOUNT>-19500.00</AMOUNT> <BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST> <BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST> <INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST> <OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST> <ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST> <AUDITENTRIES.LIST> </AUDITENTRIES.LIST> <TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST> <TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST> <TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST> <VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST> <COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST> </ALLLEDGERENTRIES.LIST> <PAYROLLMODEOFPAYMENT.LIST> </PAYROLLMODEOFPAYMENT.LIST> <ATTDRECORDS.LIST> </ATTDRECORDS.LIST> </VOUCHER> </TALLYMESSAGE> <TALLYMESSAGE xmlns:UDF="TallyUDF"> <COMPANY> <REMOTECMPINFO.LIST MERGE="Yes"> <NAME>2321da9c-d56f-4eaf-a7fe-8a58b4bf3540</NAME> <REMOTECMPNAME>Demo</REMOTECMPNAME> <REMOTECMPSTATE>Delhi</REMOTECMPSTATE> </REMOTECMPINFO.LIST> </COMPANY> </TALLYMESSAGE> </REQUESTDATA> </IMPORTDATA> </BODY> </ENVELOPE> Kindly reply
Ok found it my self while clearly analysing the tags, so the voucher id is there in <MASTERID>44</MASTERID> of the voucher generated from tally in xml format. Thanks
Hello Anto George, I think you want to export voucher from tally...?? 1. Draw a report, then filter it for FROM - TO ( As well as date wise or Voucher ID wise) 2. Export the all voucher thru XML then you got your data. Or 1. Just write a command when User save a voucher in Tally then it should export in to particular path . 2. write a from in your software (what ever platform you use) Read the data from the Path filter it & User according to requirement. If have any query post here. Manish
Thanks for your kind reply Manish. I am having a huge data. and i would like to sync to MSSQL Database. fetching all data always makes lot of time. so Instead of fetching all data i need to fetch some vouchers. I am able to fetch data between two dates Via SVFROMDATE and SVTODATE in the same way can i fetch with condition between VoucherID or Greater than VoucherID Thanks in Advance
I want to get a single invoice details using Voucher Number. <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>Object</TYPE> <SUBTYPE>VOUCHER</SUBTYPE> <ID TYPE="Name">INV/1617/02/0738</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <VoucherTypeName>TAX INVOICE</VoucherTypeName> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <FETCHLIST> <FETCH>Date</FETCH> <FETCH>VoucherTypeName</FETCH> <FETCH>VoucherNumber</FETCH> </FETCHLIST> </DESC> </BODY> </ENVELOPE> Error Message : <ERRORMSG>Could not find VOUCHER:INV/1617/02/0738!</ERRORMSG> Please help me to clear this one.
