TDL Files Error while exporting Data

Discussion in 'Free Source Codes' started by Abisha, Jul 15, 2023.

    
Tags:
  1. Abisha

    Abisha New Member


    While running my below Xml code, if any TDL file is loaded means some times get an error like could not found description. My code runs fine without the TDL files, if I import the TDL files it throws errors.

    Can you please check my code?
    Why am I getting this error?


    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>DaybookGR</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <CURRENTCOMPANY>${company}</CURRENTCOMPANY>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVFROMDATE>${fromDate}</SVFROMDATE>
    <SVTODATE>${toDate}</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <REPORT NAME="DaybookGR">
    <FORMS>DaybookGR</FORMS>
    <TITLE>DaybookGR </TITLE>
    </REPORT>
    <FORM NAME="DaybookGR">
    <TOPPARTS>DaybookGR</TOPPARTS>
    <XMLTAG>"TallyGraphs"</XMLTAG>
    </FORM>
    <PART NAME="DaybookGR">
    <TOPLINES>Daybook Line Title, Daybook Details</TOPLINES>
    <REPEAT>Daybook Details : GetLedgerCollAmt</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    <COMMONBORDERS>Yes</COMMONBORDERS>
    </PART>
    <PART NAME="Ledgerlist Line Title">
    <TOPLINES>Ledger Details</TOPLINES>
    <REPEAT>Ledger Details:LedgerEntries</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    <COMMONBORDERS>Yes</COMMONBORDERS>
    </PART>

    <PART NAME="BillAllocationlist Line Title">
    <TOPLINES>Bill Details</TOPLINES>
    <REPEAT>Bill Details:LedgerEntries.BillAllocations</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    <COMMONBORDERS>Yes</COMMONBORDERS>
    </PART>

    <PART NAME="CATEGORYALLOCATIONS Line Title">
    <TOPLINES>Category Details</TOPLINES>
    <REPEAT>Category Details:AllLedgerEntries[1, @@IsFirstLedger].CategoryAllocations</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    <COMMONBORDERS>Yes</COMMONBORDERS>
    </PART>
    <PART NAME="CostCentreAllocations Line Title">
    <TOPLINES>CostCentre Details</TOPLINES>
    <REPEAT>CostCentre Details:ACCOUNTINGALLOCATIONS.CategoryAllocations[1].CostCentreAllocations</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    <COMMONBORDERS>Yes</COMMONBORDERS>
    </PART>
    <LINE NAME="Daybook Line Title">
    <USE>Daybook Details</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    <LOCAL>Field : Field Amount : Set as: "Amount"</LOCAL>
    </LINE>
    <LINE NAME="Ledgerlist Line Title">
    <USE>Ledger Details</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    <LOCAL>Field : Field Amount : Set as: "Amount"</LOCAL>
    </LINE>
    <LINE NAME="BillAllocationlist Line Title">
    <USE>Bill Details</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    <LOCAL>Field : Field Amount : Set as: "Amount"</LOCAL>
    </LINE>

    <LINE NAME="CATEGORYALLOCATIONS Line Title">
    <USE>Category Details</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    <LOCAL>Field : Field Amount : Set as: "Amount"</LOCAL>
    </LINE>
    <LINE NAME="CostCentreAllocations Line Title">
    <USE>CostCentre Details</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    <LOCAL>Field : Field Amount : Set as: "Amount"</LOCAL>
    </LINE>
    <LINE NAME="Daybook Details">
    <LEFTFIELDS>Date</LEFTFIELDS>
    <RIGHTFIELDS>vchType,VoucherNumber,PartyLedgerName,Amount,BillAllocations</RIGHTFIELDS>
    <XMLTAG>Voucher</XMLTAG>
    <EXPLODE>Ledgerlist Line Title</EXPLODE>
    <Explode>BillAllocationlist Line Title</Explode>
    </LINE>
    <LINE NAME="Ledger Details">
    <LEFTFIELDS>PartyLedgerName</LEFTFIELDS>
    <RIGHTFIELDS>Amount,IsDeemedPositive,IsPartyLedger</RIGHTFIELDS>
    <XMLTAG>LedgerList</XMLTAG>
    <Explode>CATEGORYALLOCATIONS Line Title : NOT $$IsEmptyCollection:CategoryAllocations</Explode>
    </LINE>
    <LINE NAME="Bill Details">
    <LEFTFIELDS>BillType,BillReff,Amount</LEFTFIELDS>
    <XMLTAG>BillDetails</XMLTAG>
    </LINE>
    <LINE NAME="Account Details">
    <LEFTFIELDS>PartyLedgerName,Amount</LEFTFIELDS>
    <XMLTAG>AccountingLedger</XMLTAG>
    </LINE>

    <LINE NAME="Category Details">
    <LEFTFIELDS>Category</LEFTFIELDS>
    <XMLTAG>CategoryList</XMLTAG>
    <Explode>CostCentreAllocations Line Title</Explode>
    </LINE>
    <LINE NAME="CostCentre Details">
    <RIGHTFIELDS>Name,Amount</RIGHTFIELDS>
    <XMLTAG>CostCentreList</XMLTAG>
    </LINE>
    <FIELD NAME="PartyLedgerName">
    <USE>Name Field</USE>
    <SET>$LedgerName</SET>
    </FIELD>
    <FIELD NAME="Date">
    <USE>Long Date Field</USE>
    <SET>$$DDMMYYYYDateFormat:$Date:"-"</SET>
    </FIELD>
    <FIELD NAME="VoucherNumber">
    <USE>Name Field</USE>
    <SET>$VoucherNumber</SET>
    </FIELD>
    <FIELD NAME="Amount">
    <USE>Amount Field</USE>
    <SET>$Amount</SET>
    </FIELD>
    <FIELD NAME="IsDeemedPositive">
    <USE>Name Field</USE>
    <SET>$ISDEEMEDPOSITIVE</SET>
    </FIELD>
    <FIELD NAME="IsPartyLedger">
    <USE>Name Field</USE>
    <SET>$IsPartyLedger</SET>
    </FIELD>
    <FIELD NAME="CostCentre">
    <USE>Name Field</USE>
    <SET>$CostcentreName</SET>
    </FIELD>
    <FIELD NAME="Category">
    <USE>Name Field</USE>
    <SET>$Category</SET>
    <SET>if (NOT $$IsEmpty:$Category) then $Category else $ACCOUNTINGALLOCATIONS.CategoryAllocations.Category</SET>
    </FIELD>
    <FIELD NAME="Name">
    <USE>Name Field</USE>
    <SET>$Name</SET>
    </FIELD>
    <FIELD NAME="BillType">
    <USE>Name Field</USE>
    <SET>$BillType</SET>
    </FIELD>
    <FIELD NAME="BillReff">
    <USE>Name Field</USE>
    <SET>$Name</SET>
    </FIELD>
    <FIELD NAME="BillAllocations">
    <USE>Name Field</USE>
    <SET>$LedgerEntries[1, @@NonEmptyBill].BillAllocations[1].Name</SET>
    </FIELD>
    <COLLECTION NAME="AllVouchers" ISMODIFY="No">
    <TYPE>Voucher</TYPE>
    <BELONGSTO>YES</BELONGSTO>
    </COLLECTION>
    <COLLECTION NAME="GetLedgerCollAmt" ISMODIFY="No">
    <SourceCOLLECTION>AllVouchers</SourceCOLLECTION>
    <FILTER>IsOptionalFilter</FILTER>
    <FETCH>*.*</FETCH>
    <FETCH>LedgerEntries.*</FETCH>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="IsOptionalFilter">NOT $IsOptional</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>​
     

    Attached Files:

    Last edited: Jul 15, 2023


  2. Sai Vineeth

    Sai Vineeth Active Member


    In order to save ourselves from getting into these issues,
    I recommend sing Custom prefix or Suffix for names, which doesn't collide with other developers.
    In your case you can use Something like TG_{actualFieldName} or TGraphs_{actualFieldName} for each Report/Line/Part/Field ..etc. names

    Note : As we don't know what is actually causing issue in External TDL, Its hard to tell what to do
     
    Last edited: Jul 15, 2023
    Abisha likes this.


Share This Page