1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

XML request to fetch 'GSTR1 Return B2BDetails' from Tally Prime

Discussion in 'Tally Developer' started by Researcher1, May 9, 2024.

    
Tags:
  1. Researcher1

    Researcher1 Member


    Xml TDL request required to fetch 'GSTR1 Return B2BDetails' from 'GSTR1 JsonExport' report.
    I got below TDL sample from tally developer for the same.

    TDL :
    Code:
    [Report : GSTR1 JsonExport]
 Use : GSTR VarTemplate
 Inherit Collection : GSTRTrglVchBase
 Form : GSTR1 JsonExport
 Print Set: Report Title : @@locGSTR1
 Plain JSON : Yes
[Form: GSTR1 JsonExport]
 Part : GSTR1 Return Summary
 Delete : XML Tag
[Part: GSTR1 Return B2BDetails]
Line: GSTR1 Return B2BDetails
Repeat: GSTR1 Return B2BDetails : GSTR1b2bSummary
Scroll: Vertical
    Could you please help me construct an XMLTDL request that corresponds to this TDL?
     
    Researcher1, May 9, 2024
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    Do you have Tally developer license?
     
    Sai Vineeth, May 9, 2024
    #2


  3. Researcher1

    Researcher1 Member


    No, I do not have Tally Developer License
     
    Researcher1, May 10, 2024
    #3


  4. Sai Vineeth

    Sai Vineeth Active Member


    The name before : will be xml Tag
    Code:
    <Report NAME="GSTR1 JsonExport">
<USE>GSTR VarTemplate</USE>
<InheritCollection>GSTRTrglVchBase</InheritCollection>
<FORM>GSTR1 JsonExport</FORM>
<PrintSet>Report Title : @@locGSTR1</PrintSet>
<PlainJSON>Yes</PlainJSON>
</Report>
<FORM NAME="GSTR1 JsonExport">
<PART>GSTR1 Return Summary</PART>
<DELETE>XML Tag</DELETE>
</FORM>
<PART NAME="GSTR1 Return B2BDetails">
<LINE>GSTR1 Return B2BDetails</LINE>
<REPEAT>GSTR1 Return B2BDetails : GSTR1b2bSummary</REPEAT>
<SCROLL>Vertical</SCROLL>
</PART>
     
    Last edited: May 10, 2024
    Sai Vineeth, May 10, 2024
    #4


  5. Researcher1

    Researcher1 Member


    I have tried below xml request but it gives
    .

    XML request:
    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Data</TYPE>
        <ID>GSTR1 JsonExport</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <EXPLODEFLAG>Yes</EXPLODEFLAG>
                <SVFROMDATE>20240401</SVFROMDATE>
                <SVTODATE>20240430</SVTODATE>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
<Report NAME="GSTR1 JsonExport">
<USE>GSTR VarTemplate</USE>
<InheritCollection>GSTRTrglVchBase</InheritCollection>
<FORM>GSTR1 JsonExport</FORM>
<PrintSet>Report Title : @@locGSTR1</PrintSet>
<PlainJSON>Yes</PlainJSON>
</Report>
<FORM NAME="GSTR1 JsonExport">
<PART>GSTR1 Return Summary</PART>
<DELETE>XML Tag</DELETE>
</FORM>
<PART NAME="GSTR1 Return B2BDetails">
<LINE>GSTR1 Return B2BDetails</LINE>
<REPEAT>GSTR1 Return B2BDetails : GSTR1b2bSummary</REPEAT>
<SCROLL>Vertical</SCROLL>
<PART>
</TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Researcher1, May 10, 2024
    #5


  6. Sai Vineeth

    Sai Vineeth Active Member


    Before
    </TDLMESSAGE> closing
    <PART> should be </PART>
    I edited my response accordingly check
     
    Sai Vineeth, May 10, 2024
    #6


  7. Researcher1

    Researcher1 Member


    Now the request worked for me. But I am not able to get b2b details, only the hsn details are found in the response .
    FYI: the response that I received for the request is given below.

    Code:
    <GSTIN></GSTIN>
<FP>042024</FP>
<GT>0.00</GT>
<CUR_GT>0.00</CUR_GT>
<HSN>
<DATA>
<NUM>1</NUM>
<HSN_SC></HSN_SC>
<DESC></DESC>
<UQC>OTH</UQC>
<QTY>0</QTY>
<RT>18</RT>
<TXVAL>1000.00</TXVAL>
<IAMT>0.00</IAMT>
<CAMT>0.00</CAMT>
<SAMT>90.00</SAMT>
<CSAMT>0.00</CSAMT>
</DATA>
</HSN>
    Please alter the XML request so that response includes b2b details as well.
     
    Researcher1, May 13, 2024
    #7


Share This Page