1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

XML to export Master Data (Ledger, Stock Item, Groups, Etc.) Count from Tally

Discussion in 'Free Source Codes' started by Rutal Jadav, Oct 14, 2022.

    
Tags:
  1. Rutal Jadav

    Rutal Jadav Member


    I want to export master data (Ledgers, Stock Items, Groups, Inventory Data, GST Classification, Etc.) using XML for current open company from tally.

    My expected result is,
    <GROUP>3596</GROUP>
    <    STOCKGROUP>52</STOCKGROUP>
    <    STOCKCATEGORY>39</STOCKCATEGORY>
    <    UNIT>84</UNIT>
    <    GODOWN>5</GODOWN>
    <VOUCHERTYPE>41</VOUCHERTYPE>
    <LEDGER>3596</LEDGER>
    <STOCKITEM>325</STOCKITEM>
    <GSTCLASSIFICATION>11</GSTCLASSIFICATION>
    <COSTCENTRE>53</COSTCENTRE>
     
    Rutal Jadav, Oct 14, 2022
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    You can use default Statistics report
    But you won't get GST Classification count as it is not in default statistics report

    Code:
    <ENVELOPE Action="">
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>DATA</TYPE>
        <ID>MasterTypeStat</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <REPORT ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="MasterTypeStat">
                        <FORMS>MasterTypeStat</FORMS>
                    </REPORT>
                    <FORM ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="MasterTypeStat">
                        <TOPPARTS>MasterTypeStat</TOPPARTS>
                        <XMLTAG>MasterTypeStat.LIST</XMLTAG>
                    </FORM>
                    <PART ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="MasterTypeStat">
                        <TOPLINES>MasterTypeStat</TOPLINES>
                        <REPEAT>MasterTypeStat : STATObjects</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <LINE ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="MasterTypeStat">
                        <FIELDS>NAME</FIELDS>
                        <FIELDS>COUNT</FIELDS>
                        <XMLTAG>MasterTypeStat</XMLTAG>
                    </LINE>
                    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="NAME">
                        <SET>$NAME</SET>
                        <XMLTAG>NAME</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="COUNT">
                        <SET>$StatVal</SET>
                        <XMLTAG>COUNT</XMLTAG>
                    </FIELD>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Last edited: Oct 17, 2022
    Sai Vineeth, Oct 17, 2022
    #2


  3. Rutal Jadav

    Rutal Jadav Member


    Thanks, It's working fine but is there any XML to get STOCKCATEGORY, GODOWN and GSTCLASSIFICATION count.
     
    Rutal Jadav, Oct 17, 2022
    #3


  4. Sai Vineeth

    Sai Vineeth Active Member


    Stock category and Godown will also come in above report
    To get GST Classification add this collection and object

    Code:
      <OBJECT ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="STATGSTClassification">
                        <LOCALFORMULA>NAME:$$LocaleString:"GST Classifications"</LOCALFORMULA>
                        <LOCALFORMULA>StatVal:$$NUMITEMS:GSTClassification</LOCALFORMULA>
                    </OBJECT>
                    <COLLECTION ISMODIFY="Yes" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="STATObjects">
                        <OBJECT>STATGSTClassification</OBJECT>
                    </COLLECTION>
     
    Sai Vineeth, Oct 17, 2022
    #4


  5. Rutal Jadav

    Rutal Jadav Member


    Is it possible to export voucher-wise (Sales, Credit Note, Purchase, Debit Note, Payment, Receipt, Contra, Etc.) count from tally??

    Eg. result is,
    <SALES>325</SALES>
    <    PURCHASE>256</PURCHASE>
    <    CREDITNOTE>25</CREDITNOTE>
    <    DEBITNOTE>85</DEBITNOTE>
    <    PAYMENT>210</PAYMENT>
    <RECEIPT>41</RECEIPT>
    <LEDGER>3596</LEDGER>
    <STOCKITEM>325</STOCKITEM>
    <GSTCLASSIFICATION>11</GSTCLASSIFICATION>
    <COSTCENTRE>53</COSTCENTRE>
    Etc.
     
    Rutal Jadav, Nov 10, 2022
    #5


  6. Sai Vineeth

    Sai Vineeth Active Member


    For new Queries create new thread

    You can use this XML
    Refer this postman collection this has all the commonly used XML'S (Including the one shared above) for Tally Integration curated by me.

    If you understand the logic, it will be easier for you to solve queries without anyone help
    check the collection used for statistics report in Tally

    core difference between 2 XMLS provided by me is collection Name i.e.,
    for master stat - STATObjects
    for VoucherStat - STATVchType
     
    Last edited: Nov 10, 2022
    Sai Vineeth, Nov 10, 2022
    #6


Share This Page