1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Not able to fetch double entry data on journal and receipt voucher type through XML request

Discussion in 'Free Source Codes' started by Abisha, Mar 2, 2022.

    
  1. Abisha

    Abisha New Member


    My below code fetch all voucher type data but fails to fetch double entry data, it mainly falls on Journal voucher type..

    <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>
    <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="Daybook Details">
    <LEFTFIELDS>PartyLedgerName</LEFTFIELDS>
    <RIGHTFIELDS>vchType,GrossRevenue,GrossProfit,VoucherNumber,Amount,costcentre,Salesman,Date,Vchcost,IsDeemedPositive</RIGHTFIELDS>
    <XMLTAG>Voucher</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="GrossRevenue">
    <USE>Amount Field</USE>
    <SET>If ($$IsSalesorder:$VoucherTypeName)OR($$IsSales:$VoucherTypeName)Then $GrossRevenue else 0</SET>
    </FIELD>
    <FIELD NAME="GrossProfit">
    <USE>Amount Field</USE>
    <SET>If ($$IsSalesorder:$VoucherTypeName)OR($$IsSales:$VoucherTypeName)Then $GrossProfit else 0</SET>
    </FIELD>
    <FIELD NAME="costcentre">
    <USE>Name Field</USE>
    <SET>$CostcentreName</SET>
    </FIELD>
    <FIELD NAME="Salesman">
    <USE>Name Field</USE>
    <SET>$SalesmanName</SET>
    </FIELD>
    <FIELD NAME="Vchcost">
    <USE>Amount Field</USE>
    <SET>If ($$IsSalesorder:$VoucherTypeName)OR($$IsSales:$VoucherTypeName)Then $Cost else 0</SET>
    </FIELD>
    <FIELD NAME="IsDeemedPositive">
    <USE>Name Field</USE>
    <SET>$ISDEEMEDPOSITIVE</SET>
    </FIELD>
    <COLLECTION NAME="AllVouchers" ISMODIFY="No">
    <TYPE>Voucher</TYPE>
    <BELONGSTO>YES</BELONGSTO>
    </COLLECTION>
    <COLLECTION NAME="GetLedgerCollAmt" ISMODIFY="No">
    <SourceCOLLECTION>AllVouchers</SourceCOLLECTION>
    <FETCH>*.*</FETCH>
    <FETCH>LedgerEntries.*</FETCH>
    <FILTER>IsOptionalFilter</FILTER>
    <FETCH>VoucherNumber,LedgerName,Amount,VoucherTypeName,GrossRevenue,IsDeemedPositive,Date</FETCH>
    </COLLECTION>    ​
    <SYSTEM TYPE="Formulae" NAME="IsOptionalFilter">NOT $IsOptional</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    Abisha, Mar 2, 2022
    #1


Share This Page