1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Get Voucher masterid from BillAllocations list

Discussion in 'Tally Developer' started by Vtiger07, Oct 19, 2022.

    
Tags:
  1. Vtiger07

    Vtiger07 New Member


    Please let me know how to get voucher details and voucher masterid from bill allocations list in receipt voucher export. Following is my xml.


    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>List of Ledgers</ID>
    </HEADER>

    <BODY>
    <DESC>
    <TDL>
    <TDLMESSAGE>
    <REPORT NAME="List of Ledgers">
    <FORMS>
    List of Ledgers
    </FORMS>
    <VARIABLE>
    EXPLODEFLAG,SVEXPORTFORMAT,SVCURRENTCOMPANY,SVFROMDATE,SVTODATE,LedgerName
    </VARIABLE>
    <SET>EXPLODEFLAG:Yes</SET>
    <SET>SVEXPORTFORMAT:$$SysName:XML</SET>
    <SET>SVCURRENTCOMPANY:Testtally</SET>
    </REPORT>
    <FORM NAME="List of Ledgers">
    <PARTS>
    List of Ledgers
    </PARTS>
    </FORM>
    <PART NAME="List of Ledgers">
    <XMLTAG>Request</XMLTAG>
    <LINES>List of Ledgers</LINES>
    <REPEAT>List of Ledgers : Collection of Vouchers</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    </PART>
    <LINE NAME="List of Ledgers">
    <XMLTAG>"SALESVOUCHERS"</XMLTAG>
    <Fields>VMasterID</Fields>
    <Fields>VLedgerName</Fields>
    <Fields>VLedgerMasterId</Fields>
    <Fields>ValterID</Fields>
    <Fields>Voucherdate</Fields>
    <Fields>VoucherNumber</Fields>
    <Fields>VoucherType</Fields>
    <explode>list of bills</explode>
    <Emptyif>$$line Not between 1 and 100 </Emptyif>
    </LINE>

    <PART NAME="list of bills">
    <LINES>list of bills</LINES>
    <REPEAT>list of bills : Collection of bills</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    </PART>

    <COLLECTION name="Collection of bills">
    <SOURCECOLLECTION>Collection of Vouchers</SOURCECOLLECTION>
    <WALK>ALLLEDGERENTRIES</WALK>
    <FETCH>LedgerName, BillType,Billallocations</FETCH>
    <filter>onlyOrg</filter>
    <COMPUTE>BILLNAME : If NOT $$IsEmpty:($BILLALLOCATIONS[1].NAME) Then ($BILLALLOCATIONS[1].NAME) Else ""</COMPUTE>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="onlyOrg">$$Owner:$MasterId = $MasterId AND ($$IsLedOfGrp:$LedgerName:$$GroupSundryDebtors OR $$IsLedOfGrp:$LedgerName:$$GroupSundryCreditors)</SYSTEM>
    <LINE NAME="list of bills">
    <XMLTAG>"BILL"</XMLTAG>
    <Fields>BILLTYPE</Fields>
    <Fields>BILLNAME</Fields>
    <Fields>BILLLEDGER</Fields>
    </LINE>
    <FIELD NAME="BILLNAME">
    <USE>Name Field</USE>
    <SET>$BILLNAME</SET>
    </FIELD>
    <FIELD NAME="BILLTYPE">
    <USE>Name Field</USE>
    <SET>$BILLTYPE</SET>
    </FIELD>
    <FIELD NAME="BILLLEDGER">
    <USE>Name Field</USE>
    <SET>$LedgerName</SET>
    </FIELD>

    <FIELD NAME="VMasterID">
    <USE>Name Field</USE>
    <SET>$MasterId</SET>
    </FIELD>
    <FIELD NAME="VLedgerName">
    <USE>Name Field</USE>
    <SET>$partyledgername</SET>
    </FIELD>
    <FIELD NAME="VLedgerMasterId">
    <USE>Name Field</USE>
    <SET>$MasterID:Ledger:$PartyLedgerName</SET>
    </FIELD>
    <FIELD NAME="ValterID">
    <USE>Name Field</USE>
    <SET>$alterid</SET>
    </FIELD>
    <FIELD NAME="Voucherdate">
    <USE>Name Field</USE>
    <SET>$date</SET>
    </FIELD>
    <FIELD NAME="VoucherNumber">
    <USE>Name Field</USE>
    <SET>$vouchernumber</SET>
    </FIELD>
    <FIELD NAME="VoucherType">
    <USE>Name Field</USE>
    <SET>$vouchertypename</SET>
    </FIELD>

    <COLLECTION NAME="Collection of Vouchers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
    <TYPE>vouchers:vouchertype</TYPE>
    <childof>$$vchtypereceipt</childof>
    <BelongsTo>Yes</BelongsTo>
    <fetch>*.*</fetch>
    <SORT>$$Number:$AlterId</SORT>
    <filter>vt_isreceipt</filter>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="vt_isreceipt"> $IsReceipt</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>

    Below is response, here Agst Ref is of sales invoice. I need sales invoice masterid and sales invoice details. Please help


    <ENVELOPE>
    <REQUEST>
    <SALESVOUCHERS>
    <VMASTERID>37</VMASTERID>
    <VLEDGERNAME>Tally Ledger1</VLEDGERNAME>
    <VLEDGERMASTERID>31</VLEDGERMASTERID>
    <VALTERID>402</VALTERID>
    <VOUCHERDATE>1-Oct-22</VOUCHERDATE>
    <VOUCHERNUMBER>1</VOUCHERNUMBER>
    <VOUCHERTYPE>Receipt</VOUCHERTYPE>
    <BILL>
    <BILLTYPE>Agst Ref</BILLTYPE>
    <BILLNAME>1</BILLNAME>
    <BILLLEDGER>Tally Ledger1</BILLLEDGER>
    </BILL>
    </SALESVOUCHERS>
    </REQUEST>
    </ENVELOPE>
     
    Vtiger07, Oct 19, 2022
    #1


Share This Page