How to Fetch Price List Using xml request

Discussion in 'Tally Integration' started by Shaheer, Mar 27, 2015.

    
  1. Shaheer

    Shaheer New Member


    Dear members,

    Please help me to fetch the "price list" from tally using http xml request.
    Gateway of Tally > Inventory Info. > Price List
     


  2. admin

    admin Administrator Staff Member


    Price List is inbuilt in Stock Item XML itself... Only the Price List screen is different but it will be saved into Stock Item Master It self. So, you need to use Stock Item XML for Price list update.
     


  3. s.srini

    s.srini New Member


    You can use the followings for price details

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>All items under Groups</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
    <SVEXPORTFORMAT>$$SysName:HTML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION NAME="All items under Groups" ISMODIFY="No">
    <TYPE>stock item</TYPE>
    <FETCH>Name,Parent,BaseUnits,ClosingBalance,ClosingRate,ClosingValue,FULLPRICELIST</FETCH>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>

    Sample Source code : http://coimbatore-biz.com/blog/techsupport/Tally Integration Capabilitiesp0st415
     
    Last edited: Oct 28, 2015


  4. Mukesh Garg

    Mukesh Garg Member


    Sir Plz help Unable to fetch GST Details HSN Code, GST Rate of Stock Items through XML
     


  5. Jenny

    Jenny Active Member


    First ur xml file paste in tally installed folder
    after that create a collection like

    [Collection:XmlCollection]
    Data Source:File XML :"Your xml data path"
    XML Object Path : DATA : 1 :ROOT
    Client Only:Yes

    [Collection:TableColl]
    Source Collection:XmlCollection
    Fetch :value ;;;your created xml value
    Format:$Value,10
     


  6. Mukesh Garg

    Mukesh Garg Member


    Not in TDL code in XML code <FETCH>GSTHSNCode</FETCH> & <FETCH>GSTIGSTRATE</FETCH> NOT WORKING PLZ GUIDE
     


  7. Jenny

    Jenny Active Member


    <?xml version="1.0" encoding="UTF-8"?>
    <Harmonized_System_of_Nomenclature>
    <DATA>
    <GSTHSNCode>12345678</GSTHSNCode>
    <DESC>18%</DESC>
    </DATA>
    </Harmonized_System_of_Nomenclature>
     


Share This Page