TDL Error! - Description not found

Discussion in 'Tally Developer' started by Praveen Suthar, Oct 22, 2019.

    
  1. Praveen Suthar

    Praveen Suthar New Member


    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>&quot;Sales By Customer Report&quot;</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:&quot;State Name&quot;</LOCAL>
    <LOCAL>Field : PartyName : Set as: $$LocaleString:&quot;Party Name&quot;</LOCAL>
    <LOCAL>Field : Amount : Set as: $$LocaleString:&quot;Amount&quot;</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>&quot;No Zero,DrCr,Symbol,&quot; + ##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>
     


  2. teja varma

    teja varma Active Member


    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!
     


  3. Praveen Suthar

    Praveen Suthar New Member


    Thanks, Teja Varma.

    Please find an error image below. Please help me to resolved this issue.

    Error2.PNG Error1.PNG
     


  4. teja varma

    teja varma Active Member


    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>&quot;Sales By Customer Report&quot;</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:&quot;State Name&quot;</LOCAL>
    <LOCAL>Field : PartyName : Set as: $$LocaleString:&quot;Party Name&quot;</LOCAL>
    <LOCAL>Field : Amount : Set as: $$LocaleString:&quot;Amount&quot;</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>&quot;No Zero,DrCr,Symbol,&quot; + ##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>
     


  5. Praveen Suthar

    Praveen Suthar New Member


    Still, I am getting an error. Please check below tally image.


    upload_2019-10-23_14-17-51.png
     


  6. SUNIL MAURYA

    SUNIL MAURYA New Member


    karnavati club road Descriptions is not declared in coding.
     


  7. Praveen Suthar

    Praveen Suthar New Member


    But it is not available in the code.. "karnavati club road" is the data that is available in the tally.
     


  8. teja varma

    teja varma Active Member


    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!
     
    Last edited: Feb 22, 2020
    Praveen Suthar likes this.


  9. Praveen Suthar

    Praveen Suthar New Member



    The first time it is working properly.. make requests 2 to 5 times continuously then you will get an error.
     


  10. Praveen Suthar

    Praveen Suthar New Member


    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.
     


  11. Praveen Suthar

    Praveen Suthar New Member


    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.
     


Share This Page