Dear members, Please help me to fetch the "price list" from tally using http xml request. Gateway of Tally > Inventory Info. > Price List
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.
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
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
Not in TDL code in XML code <FETCH>GSTHSNCode</FETCH> & <FETCH>GSTIGSTRATE</FETCH> NOT WORKING PLZ GUIDE
<?xml version="1.0" encoding="UTF-8"?> <Harmonized_System_of_Nomenclature> <DATA> <GSTHSNCode>12345678</GSTHSNCode> <DESC>18%</DESC> </DATA> </Harmonized_System_of_Nomenclature>