Export Group Outstanding Bill-Party Wise

Discussion in 'Tally Integration' started by Bhushan Cellica, Nov 18, 2019.

    

  1. Hello All

    I am able to export Group Outstanding and Group Outstanding -> Bill Wise using xml.
    I want to export Group Outstanding -> [ALT+F7] Bill-Party Wise.

    Following is the XML for
    Gateway of Tally -> Display -> Statement of Accounts -> Outstandings
    Group >> F7 [BillWise] -> F12 [with All Bills]

    Code:
    <ENVELOPE>
       <HEADER>
         <TALLYREQUEST>Export Data</TALLYREQUEST>
       </HEADER>
       <BODY>
         <EXPORTDATA>
           <REQUESTDESC>
           <STATICVARIABLES>
             <SVFROMDATE>20070401</SVFROMDATE>
             <SVTODATE>20090331</SVTODATE>
             <GROUPNAME>Sundry Debtors</GROUPNAME>
             <SHOWBYBILL>YES</SHOWBYBILL>
             <EXPLODEFLAG>Yes</EXPLODEFLAG>
             <SHOWBILLTYPE>$$SysName:AllBills</SHOWBILLTYPE>
             <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
           </STATICVARIABLES>
           <REPORTNAME>Group Outstandings</REPORTNAME>
           </REQUESTDESC>
         </EXPORTDATA>
       </BODY>
    </ENVELOPE>
    
    Able to export [ALT + F7] Bill-Party Wise Group OutStanding using following XML, But it does not export Party Name.
    Please suggest changes if i miss it.
    Code:
    <ENVELOPE>
       <HEADER>
         <TALLYREQUEST>Export Data</TALLYREQUEST>
       </HEADER>
       <BODY>
         <EXPORTDATA>
           <REQUESTDESC>
           <STATICVARIABLES>
             <SVFROMDATE>20190401</SVFROMDATE>
             <SVTODATE>20191118</SVTODATE>
             <GROUPNAME>Sundry Debtors</GROUPNAME>
             <SHOWBYLEDBILL>Yes</SHOWBYLEDBILL>
             <EXPLODEFLAG>Yes</EXPLODEFLAG>
             <SHOWBILLTYPE>$$SysName:AllBills</SHOWBILLTYPE>
             <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
           </STATICVARIABLES>
           <REPORTNAME>Group Outstandings</REPORTNAME>
           </REQUESTDESC>
         </EXPORTDATA>
       </BODY>
    </ENVELOPE>
    
    Thanks,
    Bhushan Akole
     
    Last edited: Nov 18, 2019


  2. teja varma

    teja varma Active Member


    try this:
    Code:
    <ENVELOPE>
        <HEADER>
            <VERSION>1</VERSION>
            <TALLYREQUEST>Export</TALLYREQUEST>
            <TYPE>Data</TYPE>
            <ID>Group OutStandings</ID>
        </HEADER>
        <BODY>
            <DESC>
               <STATICVARIABLES>
               <SVFROMDATE Type='Date'>1-4-19</SVFROMDATE>
               <SVTODATE Type='Date'>31-3-19</SVTODATE>   
               <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
               <GROUPNAME>Sundry Debtors</GROUPNAME>
               <SHOWBYBILL>Yes</SHOWBYBILL>
               <EXPLODEFLAG>Yes</EXPLODEFLAG>
               <SHOWBYLEDBILL>Yes</SHOWBYLEDBILL>
            </STATICVARIABLES>
    </DESC>
    </BODY>
    </ENVELOPE>
    no need to set show bill type because default is AllBills
     
    saravanan1999 likes this.


Share This Page