Respected Experts, When i export, tally outputs all the fields, please guide how to export only the required field Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>COLLECTION</TYPE> <ID>COL_SALES_VOUCHERS</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <VoucherTypeName>Sales</VoucherTypeName> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <SVFROMDATE TYPE="Date">20180401</SVFROMDATE> <SVTODATE TYPE="Date">20180431</SVTODATE> </STATICVARIABLES> <TDL> <TDLMESSAGE> <COLLECTION NAME="COL_SALES_VOUCHERS" ISINITIALIZE="Yes"> <TYPE>Voucher</TYPE> <FETCH>Voucher.$PARTYLEDGERNAME</FETCH> <FETCH>Voucher.$VOUCHERTYPENAME</FETCH> <FETCH>Voucher.$DATE</FETCH> <FETCH>Voucher.$VOUCHERNUMBER</FETCH> <FETCH>Voucher.$REFERENCE</FETCH> <FETCH>LEDGERENTRIES.$AMOUNT</FETCH> </COLLECTION> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE> Thanks in Advance
Thanks for all supporting me. Finally found out how to export the vouchers using xml export Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>Voucher Sales Receipt</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <SVFROMDATE TYPE="Date">20180401</SVFROMDATE> <SVTODATE TYPE="Date">20190213</SVTODATE> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="Voucher Sales Receipt"> <FORMS>Voucher Sales Receipt</FORMS> <TITLE>Simple Voucher Sales Receipt</TITLE> </REPORT> <FORM NAME="Voucher Sales Receipt"> <TOPPARTS>Voucher Part</TOPPARTS> <XMLTAG>"VoucherList"</XMLTAG> </FORM> <PART NAME="Voucher Part"> <TOPLINES>Voucher Line Title, Voucher Details </TOPLINES> <REPEAT>Voucher Details : COL_SALERECEIPT</REPEAT> <SCROLLED>Vertical</SCROLLED> </PART> <LINE NAME="Voucher Line Title"> <USE>Voucher Details</USE> <LOCAL>Field : Default : Type : String </LOCAL> <LOCAL>Field : Field PartyLedgerName : Set as: "PartyLedgerName"</LOCAL> <LOCAL>Field : Field Voucher Date : Set as: "Date"</LOCAL> <LOCAL>Field : Field VoucherNumber : Set as: "VoucherNumber"</LOCAL> <LOCAL>Field : Field Reference : Set as: "Reference"</LOCAL> <LOCAL>Field : Field VoucherTypeName : Set as: "VoucherTypeName"</LOCAL> <LOCAL>Field : Field VoucherAmount : Set as:"VoucherAmount"</LOCAL> </LINE> <LINE NAME="Voucher Details"> <LEFTFIELDS>Field PartyLedgerName,Field Voucher Date,Field VoucherNumber,Field Reference,Field VoucherTypeName</LEFTFIELDS> <RIGHTFIELDS>Field VoucherAmount</RIGHTFIELDS> <XMLTAG>SALERECEIPT</XMLTAG> </LINE> <FIELD NAME="Field PartyLedgerName"> <USE>Name Field</USE> <SET>$PartyLedgerName</SET> </FIELD> <FIELD NAME="Field Voucher Date"> <SET>$Date</SET> </FIELD> <FIELD NAME="Field VoucherNumber"> <USE>Name Field</USE> <SET>$VoucherNumber</SET> </FIELD> <FIELD NAME="Field Reference"> <USE>Name Field</USE> <SET>$Reference</SET> </FIELD> <FIELD NAME="Field VoucherTypeName"> <USE>Name Field</USE> <SET>$VoucherTypeName</SET> </FIELD> <FIELD NAME="Field VoucherAmount"> <USE>Amount Field</USE> <SET>$Amount</SET> </FIELD> <COLLECTION NAME="COL_SALERECEIPT"> <TYPE>Voucher</TYPE> <FETCH>*.*</FETCH> <FETCH>LedgerEntries.*</FETCH> <FILTERS>Filter_IsSalesOrReceipt,Filter_DateRange</FILTERS> </COLLECTION> <SYSTEM TYPE="Formulae" NAME="Filter_DateRange">($Date>=$$Date:##SVFROMDATE) AND ($Date<=$$Date:##SVTODATE)</SYSTEM> <SYSTEM TYPE="Formulae" NAME="Filter_IsSalesOrReceipt">($$IsSales:$VoucherTypeName) OR ($$IsReceipt:$VoucherTypeName)</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE> Code: <XMLTAG>SALERECEIPT</XMLTAG> is used for exporting individual vouchers enclosed within "SALERECEIPT" XML tag. Sample Output as below Code: <VOUCHERLIST> <SALERECEIPT> <FIELDPARTYLEDGERNAME>AAAAAAAAAAAAAA</FIELDPARTYLEDGERNAME> <FIELDVOUCHERNUMBER>VOC-001</FIELDVOUCHERNUMBER> <FIELDVOUCHERDATE>01-Apr-2018</FIELDVOUCHERDATE> <FIELDREFERENCE>Ref-001</FIELDREFERENCE> <FIELDVOUCHERTYPENAME>Sales</FIELDVOUCHERTYPENAME> <FIELDVOUCHERAMOUNT>-25,000.00</FIELDVOUCHERAMOUNT> </SALERECEIPT> <SALERECEIPT>...</SALERECEIPT> <SALERECEIPT>...</SALERECEIPT> <SALERECEIPT>...</SALERECEIPT> </VOUCHERLIST>
This worked, but the DateRange Filter is not working, can someone suggest if it is some issue with new version, or has been there from starting. Thanks
Hi Sir, I am trying to export sales voucher with inventory details (stock item, rate, qty) using XML. The qty is not fetching. please check this code below Code: <?xml version="1.0" encoding="UTF-8"?> <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>Sales Vouchers</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML </SVEXPORTFORMAT> <SVFROMDATE>20190401</SVFROMDATE> <SVTODATE>20200331</SVTODATE> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="Sales Vouchers"> <FORMS>Sales Vouchers</FORMS> <TITLE>Simple Sales Vouchers</TITLE> </REPORT> <FORM NAME="Sales Vouchers"> <TOPPARTS>Voucher Part</TOPPARTS> <XMLTAG>"VoucherList"</XMLTAG> </FORM> <PART NAME="Voucher Part"> <TOPLINES>Voucher Line Title, Voucher Details</TOPLINES> <REPEAT>Voucher Details : COL_SALEVOUCHER</REPEAT> <SCROLLED>Vertical</SCROLLED> </PART> <LINE NAME="Voucher Line Title"> <USE>Voucher Details</USE> <LOCAL>Field : Default : Type : String</LOCAL> <LOCAL>Field : Field PartyLedgerName : Set as: "PartyLedgerName"</LOCAL> <LOCAL>Field : Field StockItem : Set as:"StockItem"</LOCAL> <LOCAL>Field : Field BilledQty : Set as:"BilledQty"</LOCAL> <LOCAL>Field : Field ACTUALQTY : Set as:"ACTUALQTY"</LOCAL> </LINE> <LINE NAME="Voucher Details"> <LEFTFIELDS>Field PartyLedgerName</LEFTFIELDS> <LEFTFIELDS>Field StockItem</LEFTFIELDS> <RIGHTFIELDS>Field BilledQty</RIGHTFIELDS> <RIGHTFIELDS>Field ACTUALQTY</RIGHTFIELDS> <XMLTAG>SALES</XMLTAG> </LINE> <FIELD NAME="Field PartyLedgerName"> <USE>Name Field</USE> <SET>$PartyLedgerName</SET> </FIELD> <FIELD NAME="Field StockItem"> <USE>Name Field</USE> <SET>$StockItem</SET> </FIELD> <FIELD NAME="Field BilledQty"> <USE>Name Field</USE> <SET>$BilledQty</SET> </FIELD> <FIELD NAME="Field ACTUALQTY"> <USE>Name Field</USE> <SET>$ACTUALQTY</SET> </FIELD> <COLLECTION NAME="COL_SALEVOUCHER"> <TYPE>Voucher</TYPE> <FETCH>*.*</FETCH> <FETCH>ALLLEDGERENTRIES.*</FETCH> <FETCH>ALLINVENTORYENTRIES.*</FETCH> <FILTERS>Filter_DateRange,IsSalesVoucher</FILTERS> </COLLECTION> <SYSTEM TYPE="Formulae" NAME="Filter_DateRange">($Date>=$$Date:##SVFROMDATE) AND ($Date<=$$Date:##SVTODATE)</SYSTEM> <SYSTEM TYPE="Formulae" NAME="IsSalesVoucher">$$IsSales:$VoucherTypeName</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
<FETCH>LEDGERENTRIES.$AMOUNT</FETCH> LedgerEntries is not part of Voucher Object. Tally connects internally both in data by ID