1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

XML for bills payables and bills receivables with MasterId and AlterId from Tally

Discussion in 'Tally & TDL Learning HUB' started by Rutal Jadav, Jul 26, 2022.

    
Tags:
Page 1 of 2
  1. Rutal Jadav

    Rutal Jadav Member


    I want to export bills payables and receivables with specific data. (For Ex: MasterId, AlterId, Party Name, Outstanding Amount, Due Date, Etc.).

    Currently, I am using below mention XML to export bills from the tally.

    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <STATICVARIABLES>
    <SVFROMDATE>20200401</SVFROMDATE>
    <SVTODATE>20200402</SVTODATE>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <REPORTNAME>Bills Payable</REPORTNAME>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>

    Getting below mention result.

    <ENVELOPE>
    <BILLFIXED>
    <BILLDATE>12-Feb-20</BILLDATE>
    <BILLREF>CS/21-22/A/01</BILLREF>
    <BILLPARTY>Ankit Virani</BILLPARTY>
    </BILLFIXED>
    <BILLCL>259.32</BILLCL>
    <BILLDUE>12-Feb-20</BILLDUE>
    <BILLOVERDUE>50</BILLOVERDUE>
    <BILLFIXED>
    <BILLDATE>1-Apr-20</BILLDATE>
    <BILLREF>1</BILLREF>
    <BILLPARTY>Anurag Tallywiz</BILLPARTY>
    </BILLFIXED>
    <BILLCL>71012.40</BILLCL>
    <BILLDUE>1-Apr-20</BILLDUE>
    <BILLOVERDUE>1</BILLOVERDUE>
    </ENVELOPE>


    The expected result should be

    <ENVELOPE>
    <BILLFIXED>
    <BILLDATE>12-Feb-20</BILLDATE>
    <BILLREF>CS/21-22/A/01</BILLREF>
    <BILLPARTY>Ankit Virani</BILLPARTY>
    </BILLFIXED>
    <BILLCL>259.32</BILLCL>
    <BILLDUE>12-Feb-20</BILLDUE>
    <BILLOVERDUE>50</BILLOVERDUE>
    <MASTERID>10</MASTERID>
    <ALTERID>11</ALTERID>
    <BILLFIXED>
    <BILLDATE>1-Apr-20</BILLDATE>
    <BILLREF>1</BILLREF>
    <BILLPARTY>Anurag Tallywiz</BILLPARTY>
    </BILLFIXED>
    <BILLCL>71012.40</BILLCL>
    <BILLDUE>1-Apr-20</BILLDUE>
    <BILLOVERDUE>1</BILLOVERDUE>
    <MASTERID>9</MASTERID>
    <ALTERID>12</ALTERID>
    </ENVELOPE>
     
    Rutal Jadav, Jul 26, 2022
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    You want masterid and alterid of partyname or voucher?
     
    Sai Vineeth, Jul 26, 2022
    #2


  3. Rutal Jadav

    Rutal Jadav Member


    Yes, I want XML that gives MasterId and AlterId with bills exported data.
     
    Rutal Jadav, Jul 26, 2022
    #3


  4. Sai Vineeth

    Sai Vineeth Active Member


    At least read what I am asking carefully
    you want master id and alterid of what ? voucher or Ledger
     
    Sai Vineeth, Jul 27, 2022
    #4


  5. Rutal Jadav

    Rutal Jadav Member


    Yes, I want MasterId and AlterId of voucher.
     
    Rutal Jadav, Jul 27, 2022
    #5


  6. Sai Vineeth

    Sai Vineeth Active Member


    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Data</TYPE>
        <ID>Bills Payable</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <!-- * Supports only xml format -->
            </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:VCHMasterId</LOCAL>
                        <LOCAL>LINE : BillDetail:FIELDS:VCHAlterId</LOCAL>
                    </Report>
                    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="VCHMasterId">
                        <SET>$LedgerEntries.MASTERID</SET>
                    </FIELD>
                    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="VCHAlterId">
                        <SET>$LedgerEntries.AlterID</SET>
                    </FIELD>
                 
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
    Sample output

    Code:
    <ENVELOPE>
  <BILL>
        <BILLFIXED>
            <BILLDATE>31-May-09</BILLDATE>
            <BILLREF>3</BILLREF>
            <BILLPARTY>abc India Pvt. Ltd.</BILLPARTY>
        </BILLFIXED>
        <BILLCL>300.00</BILLCL>
        <VCHMASTERID>4248</VCHMASTERID>
        <VCHALTERID>4513</VCHALTERID>
        <BILLDUE>31-May-09</BILLDUE>
        <BILLOVERDUE>4748</BILLOVERDUE>
    </BILL>
    <BILL>
        <BILLFIXED>
            <BILLDATE>31-May-09</BILLDATE>
            <BILLREF>2</BILLREF>
            <BILLPARTY>Supplier A</BILLPARTY>
        </BILLFIXED>
        <BILLCL>3000.00</BILLCL>
        <VCHMASTERID>4185</VCHMASTERID>
        <VCHALTERID>4344</VCHALTERID>
        <BILLDUE>31-May-09</BILLDUE>
        <BILLOVERDUE>4748</BILLOVERDUE>
    </BILL>
</ENVELOPE>
     
    Sai Vineeth, Jul 27, 2022
    #6


  7. Rutal Jadav

    Rutal Jadav Member


    Thank you, it works perfectly. Is it possible to pass the date range limit (For Ex. 01.04.2021 to 31.3.22) and the condition on bills vouchers should be greater than the specific AlterId (For Ex. AlterId >4513 - To get only updated bills vouchers only.)
     
    Rutal Jadav, Jul 27, 2022
    #7


  8. Sai Vineeth

    Sai Vineeth Active Member


    for date you could use static variables svfrom and todate
    For filter on alterid we need to alter collection

    Code:
    <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:VCHMasterId</LOCAL>
                        <LOCAL>LINE : BillDetail:FIELDS:VCHAlterId</LOCAL>
                    </Report>
                    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="VCHMasterId">
                        <SET>$VCHMasterId</SET>
                    </FIELD>
                    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="VCHAlterId">
                        <SET>$VCHAlterId</SET>
                    </FIELD>
                    <COLLECTION ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="Company Payables">
                        <COMPUTE>VCHAlterId:$LedgerEntries.AlterID</COMPUTE>
                        <COMPUTE>VCHMasterId:$LedgerEntries.MASTERID</COMPUTE>
                        <FILTER>AlterIdFilter</FILTER>
                    </COLLECTION>
                    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$LedgerEntries.AlterID &gt; 4343</SYSTEM>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Sai Vineeth, Jul 27, 2022
    #8


  9. Rutal Jadav

    Rutal Jadav Member


    Thank you, it works fine. One more thing I want to ask about voucher invoices (For Ex: Payment, Receipt, Sales, Purchase, Contra, Etc) exported from the tally. Can we also apply greater than condition on voucher export XML also? to get updated vouchers only?

    Currently, I am using below mention XML to export vouchers from the tally.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Voucher Register</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVCURRENTCOMPANY>Rutal Pvt Ltd1</SVCURRENTCOMPANY>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVFROMDATE TYPE='Date'>20200401</SVFROMDATE>
    <SVTODATE TYPE='Date'>20210331</SVTODATE>
    </STATICVARIABLES>
    </DESC>
    </BODY>
    </ENVELOPE>

    Also is it possible to export limited required fields for vouchers along with MasterId, AlterId, and other specified fields?
     
    Rutal Jadav, Jul 28, 2022
    #9


  10. Sai Vineeth

    Sai Vineeth Active Member


    If want to get based on existing report only then you need to find the collection used in Voucher Register report and add filter to collection(Same as I did above)

    If you want to limit fields then you need to create custom report which is time consuming to achieve in XML
    I have an example using plane XML - Custom Group Report generated through Tally Connector
    for 10 + fields total 137 lines , so if you want to customize for voucher it will be more depending on fields
     
    Sai Vineeth, Jul 28, 2022
    #10


  11. Rutal Jadav

    Rutal Jadav Member


    As you mention in your above response I have created the below XML to export updated vouchers data conditions based on AlterId but not getting the expected result.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Voucher Register</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVCURRENTCOMPANY>Rutal Pvt Ltd1</SVCURRENTCOMPANY>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVFROMDATE TYPE='Date'>20200905</SVFROMDATE>
    <SVTODATE TYPE='Date'>20200905</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <Report ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="Voucher Register">
    <LOCAL>LINE : VoucherDetail:XMLTAG:"VOUCHER"</LOCAL>
    <LOCAL>LINE : VoucherDetail:FIELDS:MasterId</LOCAL>
    <LOCAL>LINE : VoucherDetail:FIELDS:AlterId</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>
    <COLLECTION ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="Voucher Register">
    <COMPUTE>AlterId:$LedgerEntries.AlterID</COMPUTE>
    <COMPUTE>MasterId:$LedgerEntries.MASTERID</COMPUTE>
    <FILTER>AlterIdFilter</FILTER>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$LedgerEntries.AlterID &gt; 357</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    Rutal Jadav, Jul 29, 2022
    #11


  12. Sai Vineeth

    Sai Vineeth Active Member


    may be Collection name is wrong, you need to refer collection that is used in Voucher Register
    Filter is wrong It should be '$AlterID &gt; 357'
    If you want vouchers you can use
    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>CusVouchers</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <!-- * Supports only xml format -->
                <SVViewName>Accounting Voucher View</SVViewName>
                <SVFROMDATE TYPE="Date">01-Apr-2021</SVFROMDATE>
                <SVTODATE TYPE="Date">31-Mar-2022</SVTODATE>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="Yes" ISOPTION="No" ISINTERNAL="No" NAME="CusVouchers">
                        <TYPE>Voucher</TYPE>
                        <FETCH> *</FETCH>
                    </COLLECTION>
    
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Sai Vineeth, Jul 29, 2022
    #12


  13. Rutal Jadav

    Rutal Jadav Member


    It works fine. One more thing I want to ask about voucher invoices exported from the tally. In Voucher data we get the ISDELETED field as No. Is it possible to get deleted voucher's MasterId?

    One thing I noticed was when I created a new voucher for any voucher Type one unique MasterId(Ex: 215) and AlterId(Ex: 438) are given to that particular voucher. If I do some change in the voucher then MasterId(215) will remain the same but the AlterId(439) will change and if we delete this particular voucher and create a new voucher then the new voucher's MasterId(Ex: 216) but the AlterId will be (440).

    So here AlterId(439) is used as deleting that voucher with MasterId(215).

    Is it possible to get all deleted vouchers with their MasterId??
     
    Rutal Jadav, Aug 1, 2022
    #13


  14. Sai Vineeth

    Sai Vineeth Active Member


    First thing You can get deleted vouchers only if edit log is enabled - (Tally Prime 2.1) else deleted vouchers are not saved

    Add this
    Code:
    <IncludeDeleted>Yes</IncludeDeleted>
    inside collection tag
    If you want to get only deleted vouchers then add filter $ISDELETED = Yes
    this will get all deleted vouchers

    Further if you want to get deleted vouchers based on MasterId and AlterId then add filters accordingly or else use and operator in same filter formulae
    $ISDELETED = Yes AND MasterId > 200
     
    Sai Vineeth, Aug 1, 2022
    #14


  15. Rutal Jadav

    Rutal Jadav Member


    I have tried the below code but doesn't work as expected.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>CusVouchers</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <!-- * Supports only xml format -->
    <SVViewName>Accounting Voucher View</SVViewName>
    <SVFROMDATE TYPE="Date">20220701</SVFROMDATE>
    <SVTODATE TYPE="Date">20220801</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="Yes" ISOPTION="No" ISINTERNAL="No" NAME="CusVouchers">
    <TYPE>Voucher</TYPE>
    <IncludeDeleted>Yes</IncludeDeleted>
    <FETCH>*,ALLINVENTORYENTRIES.LIST,LEDGERENTRIES.LIST,ALLLEDGERENTRIES.LIST</FETCH>
    <FILTER>AlterIdFilter</FILTER>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$ISDELETED = Yes AND MasterId > 215</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    Rutal Jadav, Aug 1, 2022
    #15


  16. Sai Vineeth

    Sai Vineeth Active Member


    As I said earlier edit log should be enabled in Tally Prime 2.1
    AlterIdFilter you need to escape > symbol &gt;
    Code:
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$ISDELETED = Yes AND $MasterId &gt; 215</SYSTEM>
     
    Last edited: Aug 4, 2022
    Sai Vineeth, Aug 1, 2022
    #16


  17. Rutal Jadav

    Rutal Jadav Member


    I have already enabled the edit log but still, it's working neither for vouchers nor pending bills.
    Also second way without giving MasterId condition and only by giving $ISDELETED = Yes to get all deleted vouchers and pending bills is also not working.
    Can you please help me with that??
     
    Rutal Jadav, Aug 2, 2022
    #17


  18. Sai Vineeth

    Sai Vineeth Active Member


    I checked on vouchers and its working
    Not working means it is showing any error or blank response
    and also provide your tally data(Sample) and reproduction steps
     
    Sai Vineeth, Aug 2, 2022
    #18


  19. Rutal Jadav

    Rutal Jadav Member


    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>CusVouchers</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <!-- * Supports only xml format -->
    <SVViewName>Accounting Voucher View</SVViewName>
    <SVFROMDATE TYPE="Date">20220701</SVFROMDATE>
    <SVTODATE TYPE="Date">20220831</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="Yes" ISOPTION="No" ISINTERNAL="No" NAME="CusVouchers">
    <TYPE>Voucher</TYPE>
    <FETCH>*,ALLINVENTORYENTRIES.LIST,LEDGERENTRIES.LIST,ALLLEDGERENTRIES.LIST</FETCH>
    <FILTER>AlterIdFilter</FILTER>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$ISDELETED = Yes AND MasterId &gt; 215</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>

    I have used above mention XML to export deleted vouchers' MasterId and get the below-mentioned response while exporting data from the tally.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <STATUS>1</STATUS>
    </HEADER>
    <BODY>
    <DESC>
    <CMPINFO>
    <COMPANY>0</COMPANY>
    <GROUP>0</GROUP>
    <LEDGER>0</LEDGER>
    <COSTCATEGORY>0</COSTCATEGORY>
    <COSTCENTRE>0</COSTCENTRE>
    <GODOWN>0</GODOWN>
    <STOCKGROUP>0</STOCKGROUP>
    <STOCKCATEGORY>0</STOCKCATEGORY>
    <STOCKITEM>0</STOCKITEM>
    <VOUCHERTYPE>0</VOUCHERTYPE>
    <CURRENCY>0</CURRENCY>
    <UNIT>0</UNIT>
    <BUDGET>0</BUDGET>
    <CLIENTRULE>0</CLIENTRULE>
    <SERVERRULE>0</SERVERRULE>
    <STATE>0</STATE>
    <TDSRATE>0</TDSRATE>
    <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
    <STCATEGORY>0</STCATEGORY>
    <DEDUCTEETYPE>0</DEDUCTEETYPE>
    <ATTENDANCETYPE>0</ATTENDANCETYPE>
    <FBTCATEGORY>0</FBTCATEGORY>
    <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
    <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
    <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
    <SERIALNUMBER>0</SERIALNUMBER>
    <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
    <INCOMETAXSLAB>0</INCOMETAXSLAB>
    <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
    <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
    <TAXUNIT>0</TAXUNIT>
    <RETURNMASTER>0</RETURNMASTER>
    <VOUCHER>0</VOUCHER>
    </CMPINFO>
    </DESC>
    <DATA>
    <COLLECTION ISCMPDEPTYPE="Yes" CMPLOCUS="4" CMPDEPTYPE="64"> </COLLECTION>
    </DATA>
    </BODY>
    </ENVELOPE>

    Followed Steps:
    1) Create a new voucher in tally.
    2) Export vouchers using XML vouchers with AlterId condition.(Getting new voucher as result)
    3) Delete that newly created voucher from the tally.
    4) Export deleted vouchers using above mention XML and got an empty response from tally.
     
    Rutal Jadav, Aug 3, 2022
    #19


  20. Sai Vineeth

    Sai Vineeth Active Member


    There is no
    Code:
     <IncludeDeleted>Yes</IncludeDeleted>
    tag inside collection tag
     
    Sai Vineeth, Aug 3, 2022
    #20


  21. Rutal Jadav

    Rutal Jadav Member


    I have copied another XML in the above message but with <IncludeDeleted>Yes</IncludeDeleted> result still remains the same.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>CusVouchers</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVViewName>Accounting Voucher View</SVViewName>
    <SVFROMDATE TYPE="Date">20220701</SVFROMDATE>
    <SVTODATE TYPE="Date">20220831</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="Yes" ISOPTION="No" ISINTERNAL="No" NAME="CusVouchers">
    <TYPE>Voucher</TYPE>
    <IncludeDeleted>Yes</IncludeDeleted>
    <FETCH>*,ALLINVENTORYENTRIES.LIST,LEDGERENTRIES.LIST, ALLLEDGERENTRIES.LIST</FETCH>
    <FILTER>AlterIdFilter</FILTER>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$ISDELETED = Yes AND MasterId &gt; 215</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    Rutal Jadav, Aug 4, 2022
    #21


  22. Sai Vineeth

    Sai Vineeth Active Member


    what is the date and masterid of voucher you are deleting?
     
    Sai Vineeth, Aug 4, 2022
    #22


  23. Rutal Jadav

    Rutal Jadav Member


    P
    The purchase Voucher date was (20220801) and MasterId was 218.
    The payment Voucher date was (20220802) and MasterId was 219.
     
    Rutal Jadav, Aug 4, 2022
    #23


  24. Sai Vineeth

    Sai Vineeth Active Member


    Add dollar sign before MasterId
    Code:
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$ISDELETED = Yes AND $MasterId &gt; 215</SYSTEM>
     
    Sai Vineeth, Aug 4, 2022
    #24


  25. Rutal Jadav

    Rutal Jadav Member


    Is it possible to get deleted vouchers data from the tally without enabling Edit Log in tally for lower versions than Prime 2.1 (For Ex: Prime 2.0 or lower than that, or Tally ERP 9 versions)?
     
    Rutal Jadav, Aug 7, 2022
    #25


Page 1 of 2

Share This Page