1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Export bills with Final balance and Closing balance from tally.

Discussion in 'Free Source Codes' started by Rutal Jadav, Nov 25, 2022.

    
Tags:
  1. Rutal Jadav

    Rutal Jadav Member


    Using the below-mentioned XML to export Pending bills. Is possible to export the FINALBALANCE (Total Balance) of the Pending bill not only the Closing Balance?
    For Example, the total bill Amount is 5000, and paid it partially half. So is it possible to get as Total Amount Or Final Balance is 5000 and Closing Balance is 2500?


    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Bills Payable</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <Report ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="Bills Payable">
    <LOCAL>LINE : BillDetail:XMLTAG:"BILL"</LOCAL>
    <LOCAL>LINE : BillDetail:FIELDS:MasterId</LOCAL>
    <LOCAL>LINE : BillDetail:FIELDS:AlterId</LOCAL>
    <LOCAL>LINE : BillDetail:FIELDS:GUID</LOCAL>
    </Report>
    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="MasterId">
    <SET>$MasterId</SET>
    </FIELD>
    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="AlterId">
    <SET>$AlterId</SET>
    </FIELD>
    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="GuId">
    <SET>$GuId</SET>
    </FIELD>
    <COLLECTION ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="Company Payables">
    <COMPUTE>AlterId:$LedgerEntries.AlterID</COMPUTE>
    <COMPUTE>MasterId:$LedgerEntries.MASTERID</COMPUTE>
    <COMPUTE>GuId:$LedgerEntries.GUID</COMPUTE>
    <FILTER>AlterIdFilter</FILTER>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$LedgerEntries.AlterID &gt; 0</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>


    Result:

    <ENVELOPE>
    <BILL>
    <BILLFIXED>
    <BILLDATE>9-Nov-22</BILLDATE>
    <BILLREF>123</BILLREF>
    <BILLPARTY>Purchase Ledger</BILLPARTY>
    </BILLFIXED>
    <BILLCL>590.00</BILLCL>
    <MASTERID>7097</MASTERID>
    <ALTERID>13195</ALTERID>
    <GUID>76b505d4-a067-4007-9114-40f58c14c407-00001bb9</GUID>
    <BILLDUE>9-Dec-22</BILLDUE>
    <BILLOVERDUE></BILLOVERDUE>
    </BILL>
    </ENVELOPE>

    Expected Result:
    <ENVELOPE>
    <BILL>
    <BILLFIXED>
    <BILLDATE>9-Nov-22</BILLDATE>
    <BILLREF>123</BILLREF>
    <BILLPARTY>Purchase Ledger</BILLPARTY>
    </BILLFIXED>
    <BILLCL>2500</BILLCL>
    <FINALBALANCE>5000</FINALBALANCE>
    <MASTERID>7097</MASTERID>
    <ALTERID>13195</ALTERID>
    <GUID>76b505d4-a067-4007-9114-40f58c14c407-00001bb9</GUID>
    <BILLDUE>9-Dec-22</BILLDUE>
    <BILLOVERDUE></BILLOVERDUE>
    </BILL>
    </ENVELOPE>
     
    Rutal Jadav, Nov 25, 2022
    #1


Share This Page