Hi Team, I am getting an error when I make the below request to Tally. Sometimes It is working properly and sometime getting an error that "Description not found". Please help me to resolve this query. <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>SalesByCustomer</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVFROMDATE TYPE="Date">01-APR-2019</SVFROMDATE> <SVTODATE TYPE="Date">16-APR-2019</SVTODATE> <SVEXPORTFORMAT>$$SysName:xml</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="SalesByCustomer" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>DSP Template</USE> <FORMS>PQRReport</FORMS> <TITLE>"Sales By Customer Report"</TITLE> </REPORT> <FORM NAME="PQRReport" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>DSP Template</USE> <TOPPARTS>PQRReport</TOPPARTS> <HEIGHT>100% screen</HEIGHT> <WIDTH>100% screen</WIDTH> <DELETE>Buttons: ExplodeFlag</DELETE> <BACKGROUND>@@SV_RELEASEDLEAFGREEN_PL</BACKGROUND> <BOTTOMTOOLBARBUTTONS>BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12,</BOTTOMTOOLBARBUTTONS> </FORM> <PART NAME="PQRReport" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <TOPLINES>PQRTitile,PQRBody</TOPLINES> <BOTTOMLINES>PQRBody Total</BOTTOMLINES> <REPEAT>PQRBody:MySalesItems</REPEAT> <COMMONBORDERS>Yes</COMMONBORDERS> <SCROLLED>Vertical</SCROLLED> <TOTALS>Amount</TOTALS> </PART> <LINE NAME="PQRTitile" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>PQRBody</USE> <LOCAL>Field : Default : Type : String</LOCAL> <LOCAL>Field : Default : Style : Tiny Bold</LOCAL> <LOCAL>Field : Default : Align : Centre</LOCAL> <LOCAL>Field : StateName : Set as: $$LocaleString:"State Name"</LOCAL> <LOCAL>Field : PartyName : Set as: $$LocaleString:"Party Name"</LOCAL> <LOCAL>Field : Amount : Set as: $$LocaleString:"Amount"</LOCAL> <BORDER>Flush Totals</BORDER> </LINE> <LINE NAME="PQRBody" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <LEFTFIELDS>PartyName</LEFTFIELDS> <LEFTFIELDS>StateName</LEFTFIELDS> <RIGHTFIELDS>Amount</RIGHTFIELDS> <BORDER>Thin Bottom</BORDER> </LINE> <LINE NAME="PQRBody Total" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>PQRBody</USE> <LOCAL>Field : Default : Type : String</LOCAL> <LOCAL>Field : Default : Style : Tiny Bold</LOCAL> <LOCAL>Field : Default : Align : Centre</LOCAL> <LOCAL>Field : StateName : Align: Centre</LOCAL> <LOCAL>Field : PartyName : Align : Centre</LOCAL> <LOCAL>Field : Amount : Set as: $$Total:Amount</LOCAL> <BORDER>Flush Totals</BORDER> </LINE> <FIELD NAME="Amount" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Amount Forex Field</USE> <SET>$Amount</SET> <BORDER>Thin Left</BORDER> <ALIGNMENT>Right</ALIGNMENT> <FORMAT>"No Zero,DrCr,Symbol," + ##ShowForex</FORMAT> </FIELD> <FIELD NAME="PartyName" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Name Field</USE> <SET>$PartyLedgerName</SET> <BORDER>Thin Left</BORDER> <WIDTH>38% Screen</WIDTH> <ALIGNMENT>Left</ALIGNMENT> <VARIABLES>LedgerName</VARIABLES> <DISPLAY>Ledger Vouchers</DISPLAY> </FIELD> <FIELD NAME="StateName" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Name Field</USE> <SET>$StateName</SET> <BORDER>Thin Left</BORDER> <WIDTH>38% Screen</WIDTH> <ALIGNMENT>Left</ALIGNMENT> <VARIABLES>LedgerName</VARIABLES> <DISPLAY>Ledger Vouchers</DISPLAY> </FIELD> <COLLECTION NAME="MySalesItems" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <SOURCECOLLECTION>PQRSalesManVouchersColl</SOURCECOLLECTION> <NATIVEMETHOD> StateName,PartyLedgerName,LedgerEntries.Amount</NATIVEMETHOD> <BY>ledgerName : $PartyLedgerName</BY> <AGGRMETHOD>Amount : Sum : $Amount</AGGRMETHOD> <SORT>Amount : $Amount</SORT> <KEEPSOURCE>().</KEEPSOURCE> </COLLECTION> <COLLECTION NAME="PQRSalesManVouchersColl" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <TYPE>Voucher</TYPE> <NATIVEMETHOD> VoucherTypeName,PartyLedgerName,LedgerEntries.Amount,StateName</NATIVEMETHOD> <BY>PartyName : $PartyLedgerName</BY> <AGGRMETHOD>Amount : Sum : $LedgerEntries.Amount</AGGRMETHOD> <FILTERS>PQRSaleManVouchers</FILTERS> </COLLECTION> <MENU NAME="Gateway of Tally" ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <ITEM>SalesBYCustomer : Display : SalesBYCustomer</ITEM> </MENU> <VARIABLE NAME="SalesManName" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <TYPE>String</TYPE> </VARIABLE> <SYSTEM TYPE="Formulae" NAME="PQRSaleManVouchers" ISMODIFY="No" ISFIXED="No" ISINTERNAL="No">$$IsSales:$VoucherTypeName</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
which description not found weather its a field or part or line or variable kindly attach the screenshot of the error and one more thing why are using menu and buttons in the xml request it doesn't useful unnecessary increase of payload and processing time for tally to parse that code!
try this : Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>SalesByCustomer</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:xml</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="SalesByCustomer" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>DSP Template</USE> <FORMS>PQRReport</FORMS> <TITLE>"Sales By Customer Report"</TITLE> </REPORT> <FORM NAME="PQRReport" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>DSP Template</USE> <TOPPARTS>PQRReport</TOPPARTS> <DELETE>Buttons: ExplodeFlag</DELETE> </FORM> <PART NAME="PQRReport" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <TOPLINES>PQRTitile,PQRBody</TOPLINES> <BOTTOMLINES>PQRBody Total</BOTTOMLINES> <REPEAT>PQRBody:MySalesItems</REPEAT> <COMMONBORDERS>Yes</COMMONBORDERS> <SCROLLED>Vertical</SCROLLED> <TOTALS>Amount</TOTALS> </PART> <LINE NAME="PQRTitile" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>PQRBody</USE> <LOCAL>Field : Default : Type : String</LOCAL> <LOCAL>Field : Default : Style : Tiny Bold</LOCAL> <LOCAL>Field : Default : Align : Centre</LOCAL> <LOCAL>Field : StateName : Set as: $$LocaleString:"State Name"</LOCAL> <LOCAL>Field : PartyName : Set as: $$LocaleString:"Party Name"</LOCAL> <LOCAL>Field : Amount : Set as: $$LocaleString:"Amount"</LOCAL> <BORDER>Flush Totals</BORDER> </LINE> <LINE NAME="PQRBody" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <LEFTFIELDS>PartyName</LEFTFIELDS> <LEFTFIELDS>StateName</LEFTFIELDS> <RIGHTFIELDS>Amount</RIGHTFIELDS> <BORDER>Thin Bottom</BORDER> </LINE> <LINE NAME="PQRBody Total" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>PQRBody</USE> <LOCAL>Field : Default : Type : String</LOCAL> <LOCAL>Field : Default : Style : Tiny Bold</LOCAL> <LOCAL>Field : Default : Align : Centre</LOCAL> <LOCAL>Field : StateName : Align: Centre</LOCAL> <LOCAL>Field : PartyName : Align : Centre</LOCAL> <LOCAL>Field : Amount : Set as: $$Total:Amount</LOCAL> <BORDER>Flush Totals</BORDER> </LINE> <FIELD NAME="Amount" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Amount Forex Field</USE> <SET>$Amount</SET> <BORDER>Thin Left</BORDER> <ALIGNMENT>Right</ALIGNMENT> <FORMAT>"No Zero,DrCr,Symbol," + ##ShowForex</FORMAT> </FIELD> <FIELD NAME="PartyName" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Name Field</USE> <SET>$PartyLedgerName</SET> <BORDER>Thin Left</BORDER> <WIDTH>38% Page</WIDTH> <ALIGNMENT>Left</ALIGNMENT> <VARIABLES>LedgerName</VARIABLES> <DISPLAY>Ledger Vouchers</DISPLAY> </FIELD> <FIELD NAME="StateName" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Name Field</USE> <SET>$StateName</SET> <BORDER>Thin Left</BORDER> <WIDTH>38% Page</WIDTH> <ALIGNMENT>Left</ALIGNMENT> <VARIABLES>LedgerName</VARIABLES> <DISPLAY>Ledger Vouchers</DISPLAY> </FIELD> <COLLECTION NAME="MySalesItems" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <SOURCECOLLECTION>PQRSalesManVouchersColl</SOURCECOLLECTION> <NATIVEMETHOD> StateName,PartyLedgerName,LedgerEntries.Amount</NATIVEMETHOD> <BY>ledgerName : $PartyLedgerName</BY> <AGGRMETHOD>Amount : Sum : $Amount</AGGRMETHOD> <SORT>Amount : $Amount</SORT> <KEEPSOURCE>().</KEEPSOURCE> </COLLECTION> <COLLECTION NAME="PQRSalesManVouchersColl" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <TYPE>Voucher</TYPE> <NATIVEMETHOD> VoucherTypeName,PartyLedgerName,LedgerEntries.Amount,StateName</NATIVEMETHOD> <BY>PartyName : $PartyLedgerName</BY> <AGGRMETHOD>Amount : Sum : $LedgerEntries.Amount</AGGRMETHOD> <FILTERS>PQRSaleManVouchers</FILTERS> </COLLECTION> <MENU NAME="Gateway of Tally" ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <ITEM>SalesBYCustomer : Display : SalesBYCustomer</ITEM> </MENU> <VARIABLE NAME="SalesManName" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <TYPE>String</TYPE> </VARIABLE> <SYSTEM TYPE="Formulae" NAME="PQRSaleManVouchers" ISMODIFY="No" ISFIXED="No" ISINTERNAL="No">$$IsSales:$VoucherTypeName</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
But it is not available in the code.. "karnavati club road" is the data that is available in the tally.
the code working fine at my end and there is no system formulae named 'karnavati club road' in the request payload probably it was a conflict with other tdl's in your system disable all the tdl's in tally and give a try!
The first time it is working properly.. make requests 2 to 5 times continuously then you will get an error.
Hi @teja varma Yes, You are correct. Because, My xml request is conflicting with existing tdl. can you please help me in this?. if any way to avoid this error. Note : I can't remove existing TDL of tally.
Yes, You are correct. Because, My xml request is conflicting with existing tdl. can you please help me in this?. if any way to avoid this error. Note : I can't remove existing TDL of tally.