Export Running balance from ledger voucher using TDL

Discussion in 'Tally Integration' started by jaydip prajapati, May 8, 2019.

    
  1. jaydip prajapati

    jaydip prajapati New Member


    Hi,

    I am unable to export running balance from ledger vouchers using following TDL.

    -----------------TDL---------------------------------------
    [Report: RTS FilteredVouchers]
    Form : RTS SVSendRemoteMsgs
    Object : Voucher
    Variable : SV CurrentCompany, RTSSVLedgerName, RTSSVGroupName, SVFROMDATE, SVTODATE
    Filtered : Yes
    Export : Yes
    Set: SVFROMDATE: ##SVFROMDATE
    Set: SVTODATE: ##SVTODATE
    Set: RTSSVGroupName: ##RTSSVGroupName
    Set: RTSSVLedgerName: ##RTSSVLedgerName

    [Form: RTS SVSendRemoteMsgs]
    Parts : SYNCHeader, RTS SVSRMBody
    Local : Field : SYNCRequest : Set as : "Import Data"

    [Part: RTS SVSRMBody]
    XMLTag : "BODY"
    Part : RTS SVSRMResponse
    Vertical: Yes

    [Part: RTS SVSRMResponse]
    XMLTag : "IMPORTDATA"
    Part : EXPSoapReqDesc, RTS SVSRMData
    Vertical: Yes

    [Part: RTS SVSRMData]
    XMLTag : "REQUESTDATA"
    Part : RTS SVSRMTallyMsg
    Vertical: Yes

    [Part: RTS SVSRMTallyMsg]
    Lines : RTS SVSRMMsgs Main
    Option: RTS LedgerVouchers : NOT $$IsEmpty:##RTSSVLedgerName
    Option: RTS GroupVouchers : NOT $$IsEmpty:##RTSSVGroupName

    ;;Optional definition
    [!Part : RTS LedgerVouchers]
    Repeat : RTS SVSRMMsgs Main : RTS LedgerVouchersCollection
    Scroll : Vertical

    ;;Optional definition
    [!Part : RTS GroupVouchers]
    Repeat : RTS SVSRMMsgs Main : RTS GroupVouchersCollection
    Scroll : Vertical



    [Line: RTS SVSRMMsgs Main]
    XMLTag : "TALLYMESSAGE"
    XMLAttr : "xmlns:UDF" : "TallyUDF"
    Line : RTS SVSRMMsgs

    [Line : RTS SVSRMMsgs]
    Field : Simple Field
    FullObject : Yes

    [Collection: RTS LedgerVouchersCollection]
    Type : Vouchers: Ledgers
    Child of: ##RTSSVLedgerName
    Filter : RTSVouchersFilter

    [Collection: RTS GroupVouchersCollection]
    Type : Vouchers: Groups
    Child of: ##RTSSVGroupName
    Filter : RTSVouchersFilter


    [Variable: RTSSVLedgerName]
    Type : String

    [Variable: RTSSVGroupName]
    Type : String

    [System: Variable]
    RTSSVLedgerName : ""
    RTSSVGroupName : ""


    [System: Formula]
    RTSVouchersFilter: $Date >= ##SVFromDate and $Date <= ##SVToDate
    ----------------------------------------------------------------------------------------------

    Here is a XML request which i am using to export running balance for ledger vouchers.

    ----------------------------XML Request-------------------------------------------------
    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <STATICVARIABLES>
    <RTSSVLEDGERNAME>BHAVYA ENTRPRISES</RTSSVLEDGERNAME>
    <SVFROMDATE>20080331</SVFROMDATE>
    <SVTODATE>20190401</SVTODATE>
    <DSPSHOWRUNNING>YES</DSPSHOWRUNNING>
    <DSPSHOWTRANS>YES</DSPSHOWTRANS>
    <EXPLODEALLLEVELS>YES</EXPLODEALLLEVELS>
    <EXPLODEFLAG>YES</EXPLODEFLAG>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <REPORTNAME>RTS FilteredVouchers</REPORTNAME>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>
    ----------------------------XML Request-------------------------------------------------

    Can anyone help me, please ?
     


Share This Page