TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Govind Lumia
NA
27
1.1k
I want to import stock purchase order to tally from excel.
Jun 19 2019 8:04 AM
Hi,
I am creating a .net application for import PO and SO excel data into tally by XML
my code is below. The XML I use is export from the tally. I don't know its correct or not but when I runt that code its give error 1.
try
{
string
xmlpo =
"<ENVELOPE>"
+
"\r\n"
;
xmlpo +=
"<HEADER>"
+
"\r\n"
;
xmlpo +=
"<TALLYREQUEST>Import Data</TALLYREQUEST>"
+
"\r\n"
;
xmlpo +=
"</HEADER>"
+
"\r\n"
;
xmlpo +=
"<BODY>"
+
"\r\n"
;
xmlpo +=
"<IMPORTDATA>"
+
"\r\n"
;
xmlpo +=
"<REQUESTDESC>"
+
"\r\n"
;
xmlpo +=
"<REPORTNAME>Vouchers</REPORTNAME>"
+
"\r\n"
;
xmlpo +=
"<STATICVARIABLES>"
+
"\r\n"
;
xmlpo +=
"<SVCURRENTCOMPANY>Abc</SVCURRENTCOMPANY>"
+
"\r\n"
;
xmlpo +=
"</STATICVARIABLES>"
+
"\r\n"
;
xmlpo +=
"</REQUESTDESC>"
+
"\r\n"
;
xmlpo +=
"<REQUESTDATA>"
+
"\r\n"
;
xmlpo +=
"<TALLYMESSAGE xmlns:UDF='TallyUDF'>"
+
"\r\n"
;
xmlpo +=
"<VOUCHER REMOTEID='9536a79f - d21d - 48d5 - 968c - ecfe2j5c91cb - 00000678' VCHKEY='9536a79f - d21v - 48d5 - 968c - ecfe2e5c91cb - 0000aa44: 00000078' VCHTYPE='Purchase Order' ACTION='Create' OBJVIEW='Invoice Voucher View'>"
+
"\r\n"
;
xmlpo +=
"<ADDRESS.LIST TYPE='String'>"
+
"\r\n"
;
xmlpo +=
"<ADDRESS>testaddress1</ADDRESS>"
+
"\r\n"
;
xmlpo +=
"<ADDRESS>testaddress2</ADDRESS>"
+
"\r\n"
;
xmlpo +=
"</ADDRESS.LIST>"
+
"\r\n"
;
xmlpo +=
"<BASICBUYERADDRESS.LIST TYPE='String'>"
+
"\r\n"
;
xmlpo +=
"<BASICBUYERADDRESS>Warehouse Complex,</BASICBUYERADDRESS>"
+
"\r\n"
;
xmlpo +=
"<BASICBUYERADDRESS>Mumbai</BASICBUYERADDRESS>"
+
"\r\n"
;
xmlpo +=
"</BASICBUYERADDRESS.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS.LIST TYPE='Number'>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS> 201124739</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"</OLDAUDITENTRYIDS.LIST>"
+
"\r\n"
;
xmlpo +=
"<DATE>20190504</DATE>"
+
"\r\n"
;
xmlpo +=
"<GUID>9536a79f-d51d-48d5-968c-ecfe2e5c91cb-00000678</GUID>"
+
"\r\n"
;
xmlpo +=
"<NARRATION>being items ordered to HQ</NARRATION>"
+
"\r\n"
;
xmlpo +=
"<COUNTRYOFRESIDENCE>Delhi</COUNTRYOFRESIDENCE>"
+
"\r\n"
;
xmlpo +=
"<PARTYNAME>Easy Co. Ltd.</PARTYNAME>"
+
"\r\n"
;
xmlpo +=
"<VOUCHERTYPENAME>Purchase Order</VOUCHERTYPENAME>"
+
"\r\n"
;
xmlpo +=
"<REFERENCE>LGM0119058523</REFERENCE>"
+
"\r\n"
;
xmlpo +=
"<VOUCHERNUMBER>99</VOUCHERNUMBER>"
+
"\r\n"
;
xmlpo +=
"<PARTYLEDGERNAME>Easy Co. Ltd.</PARTYLEDGERNAME>"
+
"\r\n"
;
xmlpo +=
"<BASICBASEPARTYNAME>Easy Co. Ltd.</BASICBASEPARTYNAME>"
+
"\r\n"
;
xmlpo +=
"<CSTFORMISSUETYPE/>"
+
"\r\n"
;
xmlpo +=
"<CSTFORMRECVTYPE/>"
+
"\r\n"
;
xmlpo +=
"<FBTPAYMENTTYPE>Default</FBTPAYMENTTYPE>"
+
"\r\n"
;
xmlpo +=
"<PERSISTEDVIEW>Invoice Voucher View</PERSISTEDVIEW>"
+
"\r\n"
;
xmlpo +=
"<CONSIGNEEGSTIN>27AANCS6E3ZP</CONSIGNEEGSTIN>"
+
"\r\n"
;
xmlpo +=
"<BASICBUYERNAME>ABC"
+
"\r\n"
;
xmlpo +=
"<BASICDUEDATEOFPYMT>180 Days</BASICDUEDATEOFPYMT>"
+
"\r\n"
;
xmlpo +=
"<VCHGSTCLASS/>"
+
"\r\n"
;
xmlpo +=
"<CONSIGNEESTATENAME>Palam</CONSIGNEESTATENAME>"
+
"\r\n"
;
xmlpo +=
"<ENTEREDBY>
[email protected]
</ENTEREDBY>"
+
"\r\n"
;
xmlpo +=
"<DIFFACTUALQTY>No</DIFFACTUALQTY>"
+
"\r\n"
;
xmlpo +=
"<ISMSTFROMSYNC>No</ISMSTFROMSYNC>"
+
"\r\n"
;
xmlpo +=
"<ASORIGINAL>No</ASORIGINAL>"
+
"\r\n"
;
xmlpo +=
"<AUDITED>No</AUDITED>"
+
"\r\n"
;
xmlpo +=
"<FORJOBCOSTING>No</FORJOBCOSTING>"
+
"\r\n"
;
xmlpo +=
"<ISOPTIONAL>No</ISOPTIONAL>"
+
"\r\n"
;
xmlpo +=
"<EFFECTIVEDATE>20190504</EFFECTIVEDATE>"
+
"\r\n"
;
xmlpo +=
"<USEFOREXCISE>No</USEFOREXCISE>"
+
"\r\n"
;
xmlpo +=
"<ISFORJOBWORKIN>No</ISFORJOBWORKIN>"
+
"\r\n"
;
xmlpo +=
"<ALLOWCONSUMPTION>No</ALLOWCONSUMPTION>"
+
"\r\n"
;
xmlpo +=
"<USEFORINTEREST>No</USEFORINTEREST>"
+
"\r\n"
;
xmlpo +=
"<USEFORGAINLOSS>No</USEFORGAINLOSS>"
+
"\r\n"
;
xmlpo +=
"<USEFORGODOWNTRANSFER>No</USEFORGODOWNTRANSFER>"
+
"\r\n"
;
xmlpo +=
"<USEFORCOMPOUND>No</USEFORCOMPOUND>"
+
"\r\n"
;
xmlpo +=
"<USEFORSERVICETAX>No</USEFORSERVICETAX>"
+
"\r\n"
;
xmlpo +=
"<ISEXCISEVOUCHER>No</ISEXCISEVOUCHER>"
+
"\r\n"
;
xmlpo +=
"<EXCISETAXOVERRIDE>No</EXCISETAXOVERRIDE>"
+
"\r\n"
;
xmlpo +=
"<USEFORTAXUNITTRANSFER>No</USEFORTAXUNITTRANSFER>"
+
"\r\n"
;
xmlpo +=
"<IGNOREPOSVALIDATION>No</IGNOREPOSVALIDATION>"
+
"\r\n"
;
xmlpo +=
"<EXCISEOPENING>No</EXCISEOPENING>"
+
"\r\n"
;
xmlpo +=
"<USEFORFINALPRODUCTION>No</USEFORFINALPRODUCTION>"
+
"\r\n"
;
xmlpo +=
"<ISTDSOVERRIDDEN>No</ISTDSOVERRIDDEN>"
+
"\r\n"
;
xmlpo +=
"<ISTCSOVERRIDDEN>No</ISTCSOVERRIDDEN>"
+
"\r\n"
;
xmlpo +=
"<ISTDSTCSCASHVCH>No</ISTDSTCSCASHVCH>"
+
"\r\n"
;
xmlpo +=
"<INCLUDEADVPYMTVCH>No</INCLUDEADVPYMTVCH>"
+
"\r\n"
;
xmlpo +=
"<ISSUBWORKSCONTRACT>No</ISSUBWORKSCONTRACT>"
+
"\r\n"
;
xmlpo +=
"<ISVATOVERRIDDEN>No</ISVATOVERRIDDEN>"
+
"\r\n"
;
xmlpo +=
"<IGNOREORIGVCHDATE>No</IGNOREORIGVCHDATE>"
+
"\r\n"
;
xmlpo +=
"<ISVATPAIDATCUSTOMS>No</ISVATPAIDATCUSTOMS>"
+
"\r\n"
;
xmlpo +=
"<ISDECLAREDTOCUSTOMS>No</ISDECLAREDTOCUSTOMS>"
+
"\r\n"
;
xmlpo +=
"<ISSERVICETAXOVERRIDDEN>No</ISSERVICETAXOVERRIDDEN>"
+
"\r\n"
;
xmlpo +=
"<ISISDVOUCHER>No</ISISDVOUCHER>"
+
"\r\n"
;
xmlpo +=
"<ISEXCISEOVERRIDDEN>No</ISEXCISEOVERRIDDEN>"
+
"\r\n"
;
xmlpo +=
"<ISEXCISESUPPLYVCH>No</ISEXCISESUPPLYVCH>"
+
"\r\n"
;
xmlpo +=
"<ISGSTOVERRIDDEN>No</ISGSTOVERRIDDEN>"
+
"\r\n"
;
xmlpo +=
"<GSTNOTEXPORTED>No</GSTNOTEXPORTED>"
+
"\r\n"
;
xmlpo +=
"<IGNOREGSTINVALIDATION>No</IGNOREGSTINVALIDATION>"
+
"\r\n"
;
xmlpo +=
"<ISVATPRINCIPALACCOUNT>No</ISVATPRINCIPALACCOUNT>"
+
"\r\n"
;
xmlpo +=
"<ISBOENOTAPPLICABLE>No</ISBOENOTAPPLICABLE>"
+
"\r\n"
;
xmlpo +=
"<ISSHIPPINGWITHINSTATE>No</ISSHIPPINGWITHINSTATE>"
+
"\r\n"
;
xmlpo +=
"<ISOVERSEASTOURISTTRANS>No</ISOVERSEASTOURISTTRANS>"
+
"\r\n"
;
xmlpo +=
"<ISDESIGNATEDZONEPARTY>No</ISDESIGNATEDZONEPARTY>"
+
"\r\n"
;
xmlpo +=
"<ISCANCELLED>No</ISCANCELLED>"
+
"\r\n"
;
xmlpo +=
"<HASCASHFLOW>No</HASCASHFLOW>"
+
"\r\n"
;
xmlpo +=
"<ISPOSTDATED>No</ISPOSTDATED>"
+
"\r\n"
;
xmlpo +=
"<USETRACKINGNUMBER>No</USETRACKINGNUMBER>"
+
"\r\n"
;
xmlpo +=
"<ISINVOICE>No</ISINVOICE>"
+
"\r\n"
;
xmlpo +=
"<MFGJOURNAL>No</MFGJOURNAL>"
+
"\r\n"
;
xmlpo +=
"<HASDISCOUNTS>No</HASDISCOUNTS>"
+
"\r\n"
;
xmlpo +=
"<ASPAYSLIP>No</ASPAYSLIP>"
+
"\r\n"
;
xmlpo +=
"<ISCOSTCENTRE>No</ISCOSTCENTRE>"
+
"\r\n"
;
xmlpo +=
"<ISSTXNONREALIZEDVCH>No</ISSTXNONREALIZEDVCH>"
+
"\r\n"
;
xmlpo +=
"<ISEXCISEMANUFACTURERON>No</ISEXCISEMANUFACTURERON>"
+
"\r\n"
;
xmlpo +=
"<ISBLANKCHEQUE>No</ISBLANKCHEQUE>"
+
"\r\n"
;
xmlpo +=
"<ISVOID>No</ISVOID>"
+
"\r\n"
;
xmlpo +=
"<ISONHOLD>No</ISONHOLD>"
+
"\r\n"
;
xmlpo +=
"<ORDERLINESTATUS>No</ORDERLINESTATUS>"
+
"\r\n"
;
xmlpo +=
"<VATISAGNSTCANCSALES>No</VATISAGNSTCANCSALES>"
+
"\r\n"
;
xmlpo +=
"<VATISPURCEXEMPTED>No</VATISPURCEXEMPTED>"
+
"\r\n"
;
xmlpo +=
"<ISVATRESTAXINVOICE>No</ISVATRESTAXINVOICE>"
+
"\r\n"
;
xmlpo +=
"<VATISASSESABLECALCVCH>No</VATISASSESABLECALCVCH>"
+
"\r\n"
;
xmlpo +=
"<ISVATDUTYPAID>Yes</ISVATDUTYPAID>"
+
"\r\n"
;
xmlpo +=
"<ISDELIVERYSAMEASCONSIGNEE>No</ISDELIVERYSAMEASCONSIGNEE>"
+
"\r\n"
;
xmlpo +=
"<ISDISPATCHSAMEASCONSIGNOR>No</ISDISPATCHSAMEASCONSIGNOR>"
+
"\r\n"
;
xmlpo +=
"<ISDELETED>No</ISDELETED>"
+
"\r\n"
;
xmlpo +=
"<CHANGEVCHMODE>No</CHANGEVCHMODE>"
+
"\r\n"
;
xmlpo +=
"<ALTERID> 4209</ALTERID>"
+
"\r\n"
;
xmlpo +=
"<MASTERID> 166</MASTERID>"
+
"\r\n"
;
xmlpo +=
"<VOUCHERKEY>25874159</VOUCHERKEY>"
+
"\r\n"
;
xmlpo +=
"<EXCLUDEDTAXATIONS.LIST> </EXCLUDEDTAXATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<AUDITENTRIES.LIST> </AUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<DUTYHEADDETAILS.LIST> </DUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<SUPPLEMENTARYDUTYHEADDETAILS.LIST> </SUPPLEMENTARYDUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EWAYBILLDETAILS.LIST> </EWAYBILLDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INVOICEDELNOTES.LIST> </INVOICEDELNOTES.LIST>"
+
"\r\n"
;
xmlpo +=
"<INVOICEORDERLIST.LIST> </INVOICEORDERLIST.LIST>"
+
"\r\n"
;
xmlpo +=
"<INVOICEINDENTLIST.LIST> </INVOICEINDENTLIST.LIST>"
+
"\r\n"
;
xmlpo +=
"<ATTENDANCEENTRIES.LIST> </ATTENDANCEENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<ORIGINVOICEDETAILS.LIST> </ORIGINVOICEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INVOICEEXPORTLIST.LIST> </INVOICEEXPORTLIST.LIST>"
+
"\r\n"
;
xmlpo +=
"<LEDGERENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS.LIST TYPE='Number'>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS> 201724369</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"</OLDAUDITENTRYIDS.LIST>"
+
"\r\n"
;
xmlpo +=
"<LEDGERNAME>Easy Co. Ltd.</LEDGERNAME>"
+
"\r\n"
;
xmlpo +=
"<GSTCLASS/>"
+
"\r\n"
;
xmlpo +=
"<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<LEDGERFROMITEM>No</LEDGERFROMITEM>"
+
"\r\n"
;
xmlpo +=
"<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>"
+
"\r\n"
;
xmlpo +=
"<ISPARTYLEDGER>Yes</ISPARTYLEDGER>"
+
"\r\n"
;
xmlpo +=
"<ISLASTDEEMEDPOSITIVE>No</ISLASTDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED>"
+
"\r\n"
;
xmlpo +=
"<ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED>"
+
"\r\n"
;
xmlpo +=
"<AMOUNT>28.22 USD @ ₹ 69.9001/ USD = ₹ 1972.58</AMOUNT>"
+
"\r\n"
;
xmlpo +=
"<SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<AUDITENTRIES.LIST> </AUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST>"
+
"\r\n"
;
xmlpo +=
"<DUTYHEADDETAILS.LIST> </DUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEDUTYHEADDETAILS.LIST> </EXCISEDUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<RATEDETAILS.LIST> </RATEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<SUMMARYALLOCS.LIST> </SUMMARYALLOCS.LIST>"
+
"\r\n"
;
xmlpo +=
"<STPYMTDETAILS.LIST> </STPYMTDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEPAYMENTALLOCATIONS.LIST> </EXCISEPAYMENTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<REFVOUCHERDETAILS.LIST> </REFVOUCHERDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INVOICEWISEDETAILS.LIST> </INVOICEWISEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VATITCDETAILS.LIST> </VATITCDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<ADVANCETAXDETAILS.LIST> </ADVANCETAXDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"</LEDGERENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<ALLINVENTORYENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<STOCKITEMNAME>football</STOCKITEMNAME>"
+
"\r\n"
;
xmlpo +=
"<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<ISAUTONEGATE>No</ISAUTONEGATE>"
+
"\r\n"
;
xmlpo +=
"<ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE>"
+
"\r\n"
;
xmlpo +=
"<ISTRACKCOMPONENT>No</ISTRACKCOMPONENT>"
+
"\r\n"
;
xmlpo +=
"<ISTRACKPRODUCTION>No</ISTRACKPRODUCTION>"
+
"\r\n"
;
xmlpo +=
"<ISPRIMARYITEM>No</ISPRIMARYITEM>"
+
"\r\n"
;
xmlpo +=
"<ISSCRAP>No</ISSCRAP>"
+
"\r\n"
;
xmlpo +=
"<RATE>4.36 USD = ₹ 304.76/pcs</RATE>"
+
"\r\n"
;
xmlpo +=
"<AMOUNT>-17.44 USD @ ₹ 69.90/ USD = -₹ 1219.06</AMOUNT>"
+
"\r\n"
;
xmlpo +=
"<ACTUALQTY> 4 pcs</ACTUALQTY>"
+
"\r\n"
;
xmlpo +=
"<BILLEDQTY> 4 pcs</BILLEDQTY>"
+
"\r\n"
;
xmlpo +=
"<BATCHALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<GODOWNNAME>Main Location</GODOWNNAME>"
+
"\r\n"
;
xmlpo +=
"<BATCHNAME>Primary Batch</BATCHNAME>"
+
"\r\n"
;
xmlpo +=
"<DESTINATIONGODOWNNAME>Main Location</DESTINATIONGODOWNNAME>"
+
"\r\n"
;
xmlpo +=
"<INDENTNO/>"
+
"\r\n"
;
xmlpo +=
"<ORDERNO>LGM011905925184</ORDERNO>"
+
"\r\n"
;
xmlpo +=
"<TRACKINGNUMBER/>"
+
"\r\n"
;
xmlpo +=
"<DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED>"
+
"\r\n"
;
xmlpo +=
"<AMOUNT>-17.44 USD @ ₹ 69.90/ USD = -₹ 1219.06</AMOUNT>"
+
"\r\n"
;
xmlpo +=
"<ADDLEXPENSEAMOUNT>0.00 USD @ ₹ 69.90/ USD = -₹ 0.00</ADDLEXPENSEAMOUNT>"
+
"\r\n"
;
xmlpo +=
"<ACTUALQTY> 4 pcs</ACTUALQTY>"
+
"\r\n"
;
xmlpo +=
"<BILLEDQTY> 4 pcs</BILLEDQTY>"
+
"\r\n"
;
xmlpo +=
"<ORDERDUEDATE JD='43588' P='180 Days'>180 Days</ORDERDUEDATE>"
+
"\r\n"
;
xmlpo +=
"<ADDITIONALDETAILS.LIST> </ADDITIONALDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VOUCHERCOMPONENTLIST.LIST> </VOUCHERCOMPONENTLIST.LIST>"
+
"\r\n"
;
xmlpo +=
"</BATCHALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<ACCOUNTINGALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS.LIST TYPE='Number'>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS> 201724739</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"</OLDAUDITENTRYIDS.LIST>"
+
"\r\n"
;
xmlpo +=
"<LEDGERNAME>Purchase Import</LEDGERNAME>"
+
"\r\n"
;
xmlpo +=
"<GSTCLASS/>"
+
"\r\n"
;
xmlpo +=
"<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<LEDGERFROMITEM>No</LEDGERFROMITEM>"
+
"\r\n"
;
xmlpo +=
"<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>"
+
"\r\n"
;
xmlpo +=
"<ISPARTYLEDGER>No</ISPARTYLEDGER>"
+
"\r\n"
;
xmlpo +=
"<ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED>"
+
"\r\n"
;
xmlpo +=
"<ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED>"
+
"\r\n"
;
xmlpo +=
"<AMOUNT>-17.44 USD @ ₹ 69.90/ USD = -₹ 1219.06</AMOUNT>"
+
"\r\n"
;
xmlpo +=
"<SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<AUDITENTRIES.LIST> </AUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST>"
+
"\r\n"
;
xmlpo +=
"<DUTYHEADDETAILS.LIST> </DUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEDUTYHEADDETAILS.LIST> </EXCISEDUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<RATEDETAILS.LIST> </RATEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<SUMMARYALLOCS.LIST> </SUMMARYALLOCS.LIST>"
+
"\r\n"
;
xmlpo +=
"<STPYMTDETAILS.LIST> </STPYMTDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEPAYMENTALLOCATIONS.LIST> </EXCISEPAYMENTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<REFVOUCHERDETAILS.LIST> </REFVOUCHERDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INVOICEWISEDETAILS.LIST> </INVOICEWISEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VATITCDETAILS.LIST> </VATITCDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<ADVANCETAXDETAILS.LIST> </ADVANCETAXDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"</ACCOUNTINGALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<DUTYHEADDETAILS.LIST> </DUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<SUPPLEMENTARYDUTYHEADDETAILS.LIST> </SUPPLEMENTARYDUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<REFVOUCHERDETAILS.LIST> </REFVOUCHERDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEALLOCATIONS.LIST> </EXCISEALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXPENSEALLOCATIONS.LIST> </EXPENSEALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"</ALLINVENTORYENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<ALLINVENTORYENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<STOCKITEMNAME>Hockey</STOCKITEMNAME>"
+
"\r\n"
;
xmlpo +=
"<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<ISAUTONEGATE>No</ISAUTONEGATE>"
+
"\r\n"
;
xmlpo +=
"<ISCUSTOMSCLEARANCE>No</ISCUSTOMSCLEARANCE>"
+
"\r\n"
;
xmlpo +=
"<ISTRACKCOMPONENT>No</ISTRACKCOMPONENT>"
+
"\r\n"
;
xmlpo +=
"<ISTRACKPRODUCTION>No</ISTRACKPRODUCTION>"
+
"\r\n"
;
xmlpo +=
"<ISPRIMARYITEM>No</ISPRIMARYITEM>"
+
"\r\n"
;
xmlpo +=
"<ISSCRAP>No</ISSCRAP>"
+
"\r\n"
;
xmlpo +=
"<RATE>10.78 USD = ₹ 753.52/pcs</RATE>"
+
"\r\n"
;
xmlpo +=
"<AMOUNT>-10.78 USD @ ₹ 69.90/ USD = -₹ 753.52</AMOUNT>"
+
"\r\n"
;
xmlpo +=
"<ACTUALQTY> 1 pcs</ACTUALQTY>"
+
"\r\n"
;
xmlpo +=
"<BILLEDQTY> 1 pcs</BILLEDQTY>"
+
"\r\n"
;
xmlpo +=
"<BATCHALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<GODOWNNAME>Main Location</GODOWNNAME>"
+
"\r\n"
;
xmlpo +=
"<BATCHNAME>Primary Batch</BATCHNAME>"
+
"\r\n"
;
xmlpo +=
"<DESTINATIONGODOWNNAME>Main Location</DESTINATIONGODOWNNAME>"
+
"\r\n"
;
xmlpo +=
"<INDENTNO/>"
+
"\r\n"
;
xmlpo +=
"<ORDERNO>LGM0119058547</ORDERNO>"
+
"\r\n"
;
xmlpo +=
"<TRACKINGNUMBER/>"
+
"\r\n"
;
xmlpo +=
"<DYNAMICCSTISCLEARED>No</DYNAMICCSTISCLEARED>"
+
"\r\n"
;
xmlpo +=
"<AMOUNT>-10.78 USD @ ₹ 69.90/ USD = -₹ 753.52</AMOUNT>"
+
"\r\n"
;
xmlpo +=
"<ADDLEXPENSEAMOUNT>0.00 USD @ ₹ 69.90/ USD = ₹ 0.00</ADDLEXPENSEAMOUNT>"
+
"\r\n"
;
xmlpo +=
"<ACTUALQTY> 1 pcs</ACTUALQTY>"
+
"\r\n"
;
xmlpo +=
"<BILLEDQTY> 1 pcs</BILLEDQTY>"
+
"\r\n"
;
xmlpo +=
"<ORDERDUEDATE JD='43588' P='180 Days'>180 Days</ORDERDUEDATE>"
+
"\r\n"
;
xmlpo +=
"<ADDITIONALDETAILS.LIST> </ADDITIONALDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VOUCHERCOMPONENTLIST.LIST> </VOUCHERCOMPONENTLIST.LIST>"
+
"\r\n"
;
xmlpo +=
"</BATCHALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<ACCOUNTINGALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS.LIST TYPE='Number'>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS> 201724739</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>"
+
"\r\n"
;
xmlpo +=
"</OLDAUDITENTRYIDS.LIST>"
+
"\r\n"
;
xmlpo +=
"<LEDGERNAME>Purchase Import</LEDGERNAME>"
+
"\r\n"
;
xmlpo +=
"<GSTCLASS/>"
+
"\r\n"
;
xmlpo +=
"<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<LEDGERFROMITEM>No</LEDGERFROMITEM>"
+
"\r\n"
;
xmlpo +=
"<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>"
+
"\r\n"
;
xmlpo +=
"<ISPARTYLEDGER>No</ISPARTYLEDGER>"
+
"\r\n"
;
xmlpo +=
"<ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>"
+
"\r\n"
;
xmlpo +=
"<ISCAPVATTAXALTERED>No</ISCAPVATTAXALTERED>"
+
"\r\n"
;
xmlpo +=
"<ISCAPVATNOTCLAIMED>No</ISCAPVATNOTCLAIMED>"
+
"\r\n"
;
xmlpo +=
"<AMOUNT>-10.78 USD @ ₹ 69.90/ USD = -₹ 753.52</AMOUNT>"
+
"\r\n"
;
xmlpo +=
"<SERVICETAXDETAILS.LIST> </SERVICETAXDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<BANKALLOCATIONS.LIST> </BANKALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<BILLALLOCATIONS.LIST> </BILLALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST>"
+
"\r\n"
;
xmlpo +=
"<OLDAUDITENTRIES.LIST> </OLDAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<ACCOUNTAUDITENTRIES.LIST> </ACCOUNTAUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<AUDITENTRIES.LIST> </AUDITENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<INPUTCRALLOCS.LIST> </INPUTCRALLOCS.LIST>"
+
"\r\n"
;
xmlpo +=
"<DUTYHEADDETAILS.LIST> </DUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEDUTYHEADDETAILS.LIST> </EXCISEDUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<RATEDETAILS.LIST> </RATEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<SUMMARYALLOCS.LIST> </SUMMARYALLOCS.LIST>"
+
"\r\n"
;
xmlpo +=
"<STPYMTDETAILS.LIST> </STPYMTDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEPAYMENTALLOCATIONS.LIST> </EXCISEPAYMENTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXBILLALLOCATIONS.LIST> </TAXBILLALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TDSEXPENSEALLOCATIONS.LIST> </TDSEXPENSEALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VATSTATUTORYDETAILS.LIST> </VATSTATUTORYDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<COSTTRACKALLOCATIONS.LIST> </COSTTRACKALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<REFVOUCHERDETAILS.LIST> </REFVOUCHERDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<INVOICEWISEDETAILS.LIST> </INVOICEWISEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<VATITCDETAILS.LIST> </VATITCDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<ADVANCETAXDETAILS.LIST> </ADVANCETAXDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"</ACCOUNTINGALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<DUTYHEADDETAILS.LIST> </DUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<SUPPLEMENTARYDUTYHEADDETAILS.LIST> </SUPPLEMENTARYDUTYHEADDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TAXOBJECTALLOCATIONS.LIST> </TAXOBJECTALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<REFVOUCHERDETAILS.LIST> </REFVOUCHERDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXCISEALLOCATIONS.LIST> </EXCISEALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"<EXPENSEALLOCATIONS.LIST> </EXPENSEALLOCATIONS.LIST>"
+
"\r\n"
;
xmlpo +=
"</ALLINVENTORYENTRIES.LIST>"
+
"\r\n"
;
xmlpo +=
"<PAYROLLMODEOFPAYMENT.LIST> </PAYROLLMODEOFPAYMENT.LIST>"
+
"\r\n"
;
xmlpo +=
"<ATTDRECORDS.LIST> </ATTDRECORDS.LIST>"
+
"\r\n"
;
xmlpo +=
"<GSTEWAYCONSIGNORADDRESS.LIST> </GSTEWAYCONSIGNORADDRESS.LIST>"
+
"\r\n"
;
xmlpo +=
"<GSTEWAYCONSIGNEEADDRESS.LIST> </GSTEWAYCONSIGNEEADDRESS.LIST>"
+
"\r\n"
;
xmlpo +=
"<TEMPGSTRATEDETAILS.LIST> </TEMPGSTRATEDETAILS.LIST>"
+
"\r\n"
;
xmlpo +=
"</VOUCHER>"
+
"\r\n"
;
xmlpo +=
"</TALLYMESSAGE>"
+
"\r\n"
;
xmlpo +=
"<TALLYMESSAGE xmlns:UDF='TallyUDF'>"
+
"\r\n"
;
xmlpo +=
"<COMPANY>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPINFO.LIST MERGE='Yes'>"
+
"\r\n"
;
xmlpo +=
"<NAME>9536a79f-d21d-48d5-968c-evbfg2e5c91cb</NAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPNAME>ABC</REMOTECMPNAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPSTATE>Maharashtra</REMOTECMPSTATE>"
+
"\r\n"
;
xmlpo +=
"</REMOTECMPINFO.LIST>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPINFO.LIST MERGE='Yes'>"
+
"\r\n"
;
xmlpo +=
"<NAME>d775d1ad-cd56-4a75-b8c9-gt21b4c05d0e</NAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPNAME>ABC</REMOTECMPNAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPSTATE>Maharashtra</REMOTECMPSTATE>"
+
"\r\n"
;
xmlpo +=
"</REMOTECMPINFO.LIST>"
+
"\r\n"
;
xmlpo +=
"</COMPANY>"
+
"\r\n"
;
xmlpo +=
"</TALLYMESSAGE>"
+
"\r\n"
;
xmlpo +=
"<TALLYMESSAGE xmlns:UDF='TallyUDF'>"
+
"\r\n"
;
xmlpo +=
"<COMPANY>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPINFO.LIST MERGE='Yes'>"
+
"\r\n"
;
xmlpo +=
"<NAME>9536a79f-d21d-48d5-968c-ecfe2e5c91cb</NAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPNAME>ABC</REMOTECMPNAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPSTATE>Maharashtra</REMOTECMPSTATE>"
+
"\r\n"
;
xmlpo +=
"</REMOTECMPINFO.LIST>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPINFO.LIST MERGE='Yes'>"
+
"\r\n"
;
xmlpo +=
"<NAME>d775d1ad-cd56-4a75-b8c9-cb21b4c05d0e</NAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPNAME>ABC</REMOTECMPNAME>"
+
"\r\n"
;
xmlpo +=
"<REMOTECMPSTATE>Maharashtra</REMOTECMPSTATE>"
+
"\r\n"
;
xmlpo +=
"</REMOTECMPINFO.LIST>"
+
"\r\n"
;
xmlpo +=
"</COMPANY>"
+
"\r\n"
;
xmlpo +=
"</TALLYMESSAGE>"
+
"\r\n"
;
xmlpo +=
"</REQUESTDATA>"
+
"\r\n"
;
xmlpo +=
"</IMPORTDATA>"
+
"\r\n"
;
xmlpo +=
"</BODY>"
+
"\r\n"
;
xmlpo +=
"</ENVELOPE>"
+
"\r\n"
;
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(
"http://localhost:9000/"
);
httpWebRequest.Method =
"POST"
;
httpWebRequest.ContentLength = xmlpo.Length;
httpWebRequest.ContentType =
"application/x-www-form-urlencoded"
;
StreamWriter streamWriter =
new
StreamWriter(httpWebRequest.GetRequestStream());
streamWriter.Write(xmlpo);
streamWriter.Close();
string
result;
HttpWebResponse objResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using
(StreamReader sr =
new
StreamReader(objResponse.GetResponseStream()))
{
result = sr.ReadToEnd();
sr.Close();
}
MessageBox.Show(result);
}
catch
(Exception ex)
{
MessageBox.Show(ex.Message, ex.StackTrace);
}
If this XML is wrong please suggest a correct one or where I can find the XML formate for other tally import entries.
Reply
Answers (
1
)
Regarding real time example of Abstraction and Encapsulation
retrieval of XML information & Copy to excel Files Pin