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?
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>
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>
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.