1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

XML to export Master and Voucher Maximum Alter ID from Tally

Discussion in 'Free Source Codes' started by Rutal Jadav, Aug 4, 2023.

    
Tags:
  1. Rutal Jadav

    Rutal Jadav Member


    I want to export the Maximum Alter ID of Master and Voucher using XML from the tally.

    My expected result is,
    <MASTERMAXALTERID>3256</MASTERMAXALTERID>
    <VOUCHERMAXALTERID>52</VOUCHERMAXALTERID>
     
    Rutal Jadav, Aug 4, 2023
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    you are using C#, you can simple call tallyservice.GetLastAlterIdsAsync() after installing TallyConnector
    if using other language, you can use below xml for same
    Code:
    <ENVELOPE Action="">
 <HEADER>
 <VERSION>1</VERSION>
 <TALLYREQUEST>EXPORT</TALLYREQUEST>
 <TYPE>DATA</TYPE>
 <ID>AlterIdsReport</ID>
 </HEADER>
 <BODY>
 <DESC>
 <STATICVARIABLES>
 <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
 <SVTODATE TYPE="Date">31-03-2024</SVTODATE>
 </STATICVARIABLES>
 <TDL>
 <TDLMESSAGE>
 <REPORT ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="AlterIdsReport">
 <FORMS>AlterIdsReport</FORMS>
 </REPORT>
 <FORM ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="AlterIdsReport">
 <TOPPARTS>AlterIdsReport</TOPPARTS>
 </FORM>
 <PART ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="AlterIdsReport">
 <TOPLINES>AlterIdsReport</TOPLINES>
 <SCROLLED>Vertical</SCROLLED>
 </PART>
 <LINE ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="AlterIdsReport">
 <FIELDS>TC_MastersLastId</FIELDS>
 <FIELDS>TC_VouchersLastId</FIELDS>
 </LINE>
 <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="TC_MastersLastId">
 <SET>if $$IsEmptyCollection:TC_MastersCollection THEN 0 else $$CollectionField:$ALTERID:last:TC_MastersCollection</SET>
 <XMLTAG>MastersLastId</XMLTAG>
 </FIELD>
 <FIELD ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="TC_VouchersLastId">
 <SET>if $$IsEmptyCollection:TC_VouchersCollection THEN 0 else $$CollectionField:$ALTERID:last:TC_VouchersCollection</SET>
 <XMLTAG>VouchersLastId</XMLTAG>
 </FIELD>
 <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="TC_MastersCollection">
 <TYPE>Masters</TYPE>
 <NATIVEMETHOD>ALTERID</NATIVEMETHOD>
 <SORT>@@Default: -$Alterid</SORT>
 </COLLECTION>
 <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="TC_VouchersCollection">
 <TYPE>Vouchers</TYPE>
 <NATIVEMETHOD>ALTERID</NATIVEMETHOD>
 <SORT>@@Default: -$Alterid</SORT>
 </COLLECTION>
 </TDLMESSAGE>
 </TDL>
 </DESC>
 </BODY>
</ENVELOPE>
     
    Sai Vineeth, Aug 4, 2023
    #2


Share This Page