Tally XML Get GST Rate Setup by Stock Group

280 views Asked by At

I am able to get the GST rates grouped by Stock Group using the below XML, but How do i pass the stock group in this request so that i can get GST Rates for items under the particular stock group

<ENVELOPE>
<HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>EXPORT</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>GST Rate Setup</ID>
</HEADER>
<BODY>
    <DESC>
        <STATICVARIABLES>
            <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            
        </STATICVARIABLES>
        <FETCHLIST>
            <FETCH>*</FETCH>    
        </FETCHLIST>
    </DESC>
</BODY>
</ENVELOPE>

I tried to pass the stock group name using static variables, but since i don't know the variable name, i am getting nowhere.

1

There are 1 answers

0
sai vineeth On BEST ANSWER

We can create Custom reports by extending existing reports in TDL definition

In below xml I extended GST Rate Setup by mentioning in use Tag

To known the variable used in report we need to refer TDL code which is available in TDL Developer ApplicationSource Code Screenshot

Here we are overwriting Stock Group Name by setting testgroup

Replace testgroup with whatever group youwant

<ENVELOPE>
<HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>EXPORT</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Cust GST Rate Setup</ID>
</HEADER>
<BODY>
    <DESC>
        <STATICVARIABLES>
            <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            <SVShowAll>No</SVShowAll >
        </STATICVARIABLES>
        <TDL>
            <TDLMESSAGE>
                <Report ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="Cust GST Rate Setup">
                    <Use>GST Rate Setup</Use>
                    <Set>Stock Group Name:testgroup</Set>
                    <Form>GST Rate Setup</Form>
                </Report>
            </TDLMESSAGE>
        </TDL>
    </DESC>
</BODY>
</ENVELOPE>