79477100

Date: 2025-03-01 04:19:50
Score: 2.5
Natty:
Report link

how to create custom TDL report.I am new to this.somehow i have managed to get data godown wise. but it is not able to return the GUID of the product or godowns with it ,it only able to return stock item name, godown name, quantity, value and rate.

This is my payload

<ENVELOPE>
<HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>
<BODY>

    <EXPORTDATA>
        <REQUESTDESC>
            <REPORTNAME>Stock Summary</REPORTNAME>
            <STATICVARIABLES>
                <SVCURRENTCOMPANY>{{company}}</SVCURRENTCOMPANY>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <SVFROMDATE>20240401</SVFROMDATE>
                <SVTODATE>20250331</SVTODATE>
                <EXPLODEFLAG>Yes</EXPLODEFLAG>
                <ISITEMWISE>Yes</ISITEMWISE>
                <ISINCLUDEOPENING>Yes</ISINCLUDEOPENING>
            </STATICVARIABLES>

        </REQUESTDESC>
    </EXPORTDATA>
</BODY>

this is my response

<DSPACCNAME>
    <DSPDISPNAME>Electronic TV</DSPDISPNAME>
</DSPACCNAME>
<DSPSTKINFO>
    <DSPSTKCL>
        <DSPCLQTY>185.00 PCS</DSPCLQTY>
        <DSPCLRATE>9797.30</DSPCLRATE>
        <DSPCLAMTA>-1812500.00</DSPCLAMTA>
    </DSPSTKCL>
</DSPSTKINFO>
<SSBATCHNAME>
    <SSGODOWN>Main Location</SSGODOWN>
</SSBATCHNAME>
<DSPSTKINFO>
    <DSPSTKCL>
        <DSPCLQTY>50.00 PCS</DSPCLQTY>
        <DSPCLRATE>9500.00</DSPCLRATE>
        <DSPCLAMTA>-475000.00</DSPCLAMTA>
    </DSPSTKCL>
</DSPSTKINFO>
<SSBATCHNAME>
    <SSGODOWN>Odio cradle1</SSGODOWN>
</SSBATCHNAME>
<DSPSTKINFO>
    <DSPSTKCL>
        <DSPCLQTY>125.00 PCS</DSPCLQTY>
        <DSPCLRATE>9940.00</DSPCLRATE>
        <DSPCLAMTA>-1242500.00</DSPCLAMTA>
    </DSPSTKCL>
</DSPSTKINFO>

How can i get GUID attached with it for sotck item and godowns

Reasons:
  • Blacklisted phrase (0.5): How can i
  • RegEx Blacklisted phrase (1.5): I am new
  • Long answer (-1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Starts with a question (0.5): how to
  • Low reputation (1):
Posted by: HAASH Technologies