request - Fetching all the vouchers using tally server xml api

I am using the following xml payload to fetch all the vouchers, I am able to pull all the details except PAN and Narration for the voucher. Any help will be appreciated.

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>DATA</TYPE>
        <ID>TC_VOUCHER</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:xml</SVEXPORTFORMAT>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <REPORT ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHER">
                        <FORM>TC_VOUCHER</FORM>
                    </REPORT>
                    <FORM ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHER">
                        <PART>TC_VOUCHER</PART>
                        <XMLTAG>Voucher.LIST</XMLTAG>
                    </FORM>
                    <PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_BASETALLYOBJECT">
                        <LINE>TC_BASETALLYOBJECT</LINE>
                        <REPEAT>TC_BASETALLYOBJECT:TC_BASETALLYOBJECTCOLLECTION</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_TALLYOBJECT">
                        <LINE>TC_TALLYOBJECT</LINE>
                        <REPEAT>TC_TALLYOBJECT:TC_TALLYOBJECTCOLLECTION</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHER">
                        <LINE>TC_VOUCHER</LINE>
                        <REPEAT>TC_VOUCHER:TC_VOUCHERCOLLECTION</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHERLEDGER">
                        <LINE>TC_VOUCHERLEDGER</LINE>
                        <REPEAT>TC_VOUCHERLEDGER:ALLLEDGERENTRIES</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_BASETALLYOBJECT">
                        <FIELDS>TC_GUID</FIELDS>
                        <XMLTAG>BASETALLYOBJECT</XMLTAG>
                    </LINE>
                    <LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_TALLYOBJECT">
                        <FIELDS>TC_ALTERID,TC_MASTERID</FIELDS>
                        <XMLTAG>TALLYOBJECT</XMLTAG>
                        <USE>TC_BASETALLYOBJECT</USE>
                    </LINE>
                    <LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHER">
                        <FIELDS>TC_DATE,TC_VOUCHERTYPE,TC_VOUCHERNUMBER</FIELDS>
                        <XMLTAG>VOUCHER</XMLTAG>
                        <EXPLODE>TC_VOUCHERLEDGER:Yes</EXPLODE>
                        <USE>TC_TALLYOBJECT</USE>
                    </LINE>
                    <LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHERLEDGER">
                        <FIELDS>TC_LEDGERNAME,TC_AMOUNT,TC_NARRATION,TC_GSTIN,TC_PAN</FIELDS>
                        <XMLTAG>ALLLEDGERENTRIES.LIST</XMLTAG>
                    </LINE>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_GUID">
                        <SET>$GUID</SET>
                        <XMLTAG>GUID</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_ALTERID">
                        <SET>$AlterId</SET>
                        <XMLTAG>ALTERID</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_MASTERID">
                        <SET>$MasterId</SET>
                        <XMLTAG>MASTERID</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_DATE">
                        <SET>$Date</SET>
                        <XMLTAG>DATE</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHERTYPE">
                        <SET>$VOUCHERTYPENAME</SET>
                        <XMLTAG>VOUCHERTYPENAME</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHERNUMBER">
                        <SET>$VoucherNumber</SET>
                        <XMLTAG>VOUCHERNUMBER</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_LEDGERNAME">
                        <SET>$LEDGERNAME</SET>
                        <XMLTAG>LEDGERNAME</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_AMOUNT">
                        <SET>$AMOUNT</SET>
                        <XMLTAG>AMOUNT</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_NARRATION">
                        <SET>$NARRATION</SET>
                        <XMLTAG>NARRATION</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_GSTIN">
                        <SET>$PARTYGSTIN</SET>
                        <XMLTAG>GSTIN</XMLTAG>
                    </FIELD>
                    <FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_PAN">
                        <SET>$INCOMETAXNUMBER</SET>
                        <XMLTAG>PAN</XMLTAG>
                    </FIELD>
                    <COLLECTION ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" NAME="TC_VOUCHERCOLLECTION">
                        <TYPE>VOUCHERS</TYPE>
                        <NATIVEMETHOD>ALTERID</NATIVEMETHOD>
                        <NATIVEMETHOD>ALLLEDGERENTRIES.LEDGERNAME</NATIVEMETHOD>
                        <NATIVEMETHOD>ALLLEDGERENTRIES.PARTYGSTIN</NATIVEMETHOD>
                        <NATIVEMETHOD>ALLLEDGERENTRIES.INCOMETAXNUMBER</NATIVEMETHOD>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
 </ENVELOPE>

I added a field name TC_PAN and TC_NARRATION that are used in TC_VOUCHERLEDGER.

Since NARRATION is a native method to VOUCHER I am expecting to receive it in the response but it is not happening.
For PAN, my understanding is that $IncomeTaxNumber is a method native to Ledger therefore I defined it in the TC_VOUCHERCOLLECTION and was expecting it to return me the PAN number but that too is not happening.

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

request - Fetching all the vouchers using tally server xml api - Stack Overflow

与本文相关的文章

评论列表(0)