1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

XML Request to get partynames & gstin number

Discussion in 'Tally Integration' started by rajeshca911, Aug 24, 2022.

    
Tags:
  1. rajeshca911

    rajeshca911 New Member


    Please help me to get party name and gstin number either creditors or debtors from tally through xml http request
     
    rajeshca911, Aug 24, 2022
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>DATA</TYPE>
        <ID>LISTOFLEDGER</ID>
    </HEADER>
    <BODY>
        <DESC>
            <TDL>
                <TDLMESSAGE>
                    <REPORT ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="LISTOFLEDGER">
                        <FORMS>LISTOFLEDGER</FORMS>
                    </REPORT>
                    <FORM ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="LISTOFLEDGER">
                        <TOPPARTS>LISTOFLEDGER</TOPPARTS>
                        <XMLTAG>LISTOFLEDGER</XMLTAG>
                    </FORM>
                    <PART ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="LISTOFLEDGER">
                        <TOPLINES>LISTOFLEDGER</TOPLINES>
                        <REPEAT>LISTOFLEDGER : CUSTOM_LEDGERCOLL</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <LINE ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="LISTOFLEDGER">
                        <FIELDS>NAME,GSTIN</FIELDS>
                        <XMLTAG>LEDGER</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="GSTIN">
                        <SET>$PARTYGSTIN</SET>
                        <XMLTAG>GSTIN</XMLTAG>
                    </FIELD>
                    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CUSTOM_LEDGERCOLL">
                        <TYPE>LEDGER</TYPE>
                        <NATIVEMETHOD>Name,PARTYGSTIN</NATIVEMETHOD>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Sai Vineeth, Aug 25, 2022
    #2
    rajeshca911 likes this.


  3. rajeshca911

    rajeshca911 New Member


    "I'm experiencing an issue with the code mentioned above in Tally Prime version 3.0. It seems that the code is not able to fetch GSTINs. If it's possible, could someone kindly assist me in updating the code? Your help would be greatly appreciated. Thank you in advance.
     
    rajeshca911, Jun 26, 2023
    #3


  4. Sai Vineeth

    Sai Vineeth Active Member


    Use
    $LedGSTRegDetails[last].GSTIN instead of
    $PARTYGSTIN in Tally Prime 3.0
     
    Last edited: Jul 21, 2023
    Sai Vineeth, Jun 27, 2023
    #4
    rajeshca911 likes this.


  5. rajeshca911

    rajeshca911 New Member


    Thanks a lot for your help Sai
     
    rajeshca911, Jun 27, 2023
    #5
    Sai Vineeth likes this.


  6. Sridharan S

    Sridharan S Member


    Looks like working in Prime 3 too.
    ParyGSTIN works as long as it is within Collection
     
    Sridharan S, Jul 21, 2023
    #6


  7. Sai Vineeth

    Sai Vineeth Active Member


    This works in Tally prime 3.0, if and only ledger is created in old version of Tally,
    If ledger is created in new version its using LedGSTRegDetails , so it's better to use $LedGSTRegDetails[last].GSTIN to support all clients.
     
    Sai Vineeth, Jul 21, 2023
    #7


  8. Sai Vineeth

    Sai Vineeth Active Member


    use $LedGSTRegDetails[last].GSTIN to get latest details.
    there's a chance that client may have different taxability during period, last will fetch the latest GSTIN.
     
    Sai Vineeth, Jul 21, 2023
    #8


  9. Sridharan S

    Sridharan S Member


    Yes Collections can hold multiple objects. So preferable.
     
    Last edited: Jul 23, 2023
    Sridharan S, Jul 22, 2023
    #9


  10. sattam

    sattam Active Member


    I want to filter it under group debtors and creditors and not empty $LedGSTRegDetails[last].GSTIN
     
    sattam, Oct 3, 2023
    #10


  11. Sai Vineeth

    Sai Vineeth Active Member


    you can childof inside collection and mention name of group you want to filter.
    if you want nested childs then add <Belongsto>Yes</Belongsto> also
    Code:
    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CUSTOM_LEDGERCOLL">
       <TYPE>LEDGER</TYPE>
<CHILDOF>SundryDebtors</CHILDOF>
<Belongsto>Yes</Belongsto>
     <NATIVEMETHOD>Name,LedGSTRegDetails.*</NATIVEMETHOD>
</COLLECTION>
    To filter out empty you can add filter to collection
    Code:
    </TDLMESSAGE>

<COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CUSTOM_LEDGERCOLL">
       <TYPE>LEDGER</TYPE>
<CHILDOF>SundryDebtors</CHILDOF>
<Belongsto>Yes</Belongsto>
     <NATIVEMETHOD>Name,LedGSTRegDetails.*</NATIVEMETHOD>
<FILTERS> ISContainsGST</FILTERS>
</COLLECTION>
<SYSTEM TYPE="Formulae" NAME="ISContainsGST">NOT $$ISEMPTY:$LedGSTRegDetails[last].GSTIN</SYSTEM>

</TDLMESSAGE>
     
    Last edited: Oct 6, 2023
    Sai Vineeth, Oct 5, 2023
    #11


  12. sattam

    sattam Active Member


    Thanks it works
     
    sattam, Oct 6, 2023
    #12
    Sai Vineeth likes this.


  13. Sridharan S

    Sridharan S Member


    LedGSTRegDetails collection works with newer version of Tally, old or new data
     
    Sridharan S, Mar 11, 2024
    #13


Share This Page