Regarding Fetch Voucher using XML Interface by .NET App

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi......
I am learner of Tally Integration. I am working on tally integration.
I know how to create company,ledger,vocher and so on by XML Interface.
I have developed small Demo for this, but at one place I need some help to complete this demo.
My Scenario is....
1) Prepare XML Request to create(insert) voucher with data and get response
<div style="background-color:white; color:black
<pre> <span style="color:blue <<span style="color:#a31515 ENVELOPE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 HEADER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 VERSION<span style="color:blue >1<span style="color:blue </<span style="color:#a31515 VERSION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 TALLYREQUEST<span style="color:blue >Import<span style="color:blue </<span style="color:#a31515 TALLYREQUEST<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 TYPE<span style="color:blue >Data<span style="color:blue </<span style="color:#a31515 TYPE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ID<span style="color:blue >Vouchers<span style="color:blue </<span style="color:#a31515 ID<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 HEADER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 BODY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DESC<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 DESC<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DATA<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 TALLYMESSAGE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 VOUCHER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DATE<span style="color:blue >" + date + @"<span style="color:blue </<span style="color:#a31515 DATE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 NARRATION<span style="color:blue >" + naration + @"<span style="color:blue </<span style="color:#a31515 NARRATION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 VOUCHERTYPENAME<span style="color:blue >" + voucher + @"<span style="color:blue </<span style="color:#a31515 VOUCHERTYPENAME<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 VOUCHERNUMBER<span style="color:blue >556<span style="color:blue </<span style="color:#a31515 VOUCHERNUMBER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ALLLEDGERENTRIES.LIST<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LEDGERNAME<span style="color:blue >" + leg1 + @"<span style="color:blue </<span style="color:#a31515 LEDGERNAME<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ISDEEMEDPOSITIVE<span style="color:blue >Yes<span style="color:blue </<span style="color:#a31515 ISDEEMEDPOSITIVE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 AMOUNT<span style="color:blue >-" + amt + @"<span style="color:blue </<span style="color:#a31515 AMOUNT<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 ALLLEDGERENTRIES.LIST<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ALLLEDGERENTRIES.LIST<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LEDGERNAME<span style="color:blue >" + leg2 + @"<span style="color:blue </<span style="color:#a31515 LEDGERNAME<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ISDEEMEDPOSITIVE<span style="color:blue >No<span style="color:blue </<span style="color:#a31515 ISDEEMEDPOSITIVE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 AMOUNT<span style="color:blue >" + amt + @"<span style="color:blue </<span style="color:#a31515 AMOUNT<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 ALLLEDGERENTRIES.LIST<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 VOUCHER<span style="color:blue >


<span style="color:blue </<span style="color:#a31515 TALLYMESSAGE<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 DATA<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 BODY<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 ENVELOPE<span style="color:blue >
[/code]

2) In response I get the MasterId of that voucher.
<div style="background-color:white; color:black
<pre><span style="color:blue <<span style="color:#a31515 ENVELOPE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 HEADER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 VERSION<span style="color:blue >1<span style="color:blue </<span style="color:#a31515 VERSION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 STATUS<span style="color:blue >1<span style="color:blue </<span style="color:#a31515 STATUS<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 HEADER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 BODY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DATA<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 IMPORTRESULT<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CREATED<span style="color:blue >1<span style="color:blue </<span style="color:#a31515 CREATED<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ALTERED<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 ALTERED<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LASTVCHID<span style="color:blue >87<span style="color:blue </<span style="color:#a31515 LASTVCHID<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LASTMID<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 LASTMID<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 COMBINED<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 COMBINED<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 IGNORED<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 IGNORED<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ERRORS<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 ERRORS<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 IMPORTRESULT<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 DATA<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DESC<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CMPINFO<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 COMPANY<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 COMPANY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 GROUP<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 GROUP<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 LEDGER<span style="color:blue >9<span style="color:blue </<span style="color:#a31515 LEDGER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 COSTCATEGORY<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 COSTCATEGORY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 COSTCENTRE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 COSTCENTRE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 GODOWN<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 GODOWN<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 STOCKGROUP<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 STOCKGROUP<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 STOCKCATEGORY<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 STOCKCATEGORY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 STOCKITEM<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 STOCKITEM<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 VOUCHERTYPE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 VOUCHERTYPE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CURRENCY<span style="color:blue >3<span style="color:blue </<span style="color:#a31515 CURRENCY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 UNIT<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 UNIT<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 BUDGET<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 BUDGET<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 CLIENTRULE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 CLIENTRULE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 SERVERRULE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 SERVERRULE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 STATE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 STATE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 TDSRATE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 TDSRATE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 TAXCLASSIFICATION<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 TAXCLASSIFICATION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 STCATEGORY<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 STCATEGORY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 DEDUCTEETYPE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 DEDUCTEETYPE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ATTENDANCETYPE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 ATTENDANCETYPE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 FBTCATEGORY<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 FBTCATEGORY<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 FBTASSESSEETYPE<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 FBTASSESSEETYPE<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 TARIFFCLASSIFICATION<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 TARIFFCLASSIFICATION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 EXCISEDUTYCLASSIFICATION<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 EXCISEDUTYCLASSIFICATION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 SERIALNUMBER<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 SERIALNUMBER<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 ADJUSTMENTCLASSIFICATION<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 ADJUSTMENTCLASSIFICATION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 INCOMETAXSLAB<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 INCOMETAXSLAB<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 INCOMETAXCLASSIFICATION<span style="color:blue >0<span style="color:blue </<span style="color:#a31515 INCOMETAXCLASSIFICATION<span style="color:blue >
<span style="color:blue <<span style="color:#a31515 VOUCHER<span style="color:blue >3<span style="color:blue </<span style="color:#a31515 VOUCHER<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 CMPINFO<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 DESC<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 BODY<span style="color:blue >
<span style="color:blue </<span style="color:#a31515 ENVELOPE<span style="color:blue >

[/code]

Here <span style="color:blue <<span style="color:#a31515 LASTVCHID<span style="color:blue >87<span style="color:blue </<span style="color:#a31515 LASTVCHID<span style="color:blue > is the masterId
3) Now by this masterId I want to fetch The full details of The voucher which I have created or inserted in XML format.
4) Store the details which will come from Tally in XML format.
I have successfully done upto step number 2. but from step no 3; I tried many way to fetch the details of Voucher by its masterId but still I didnt get success in that.
Can anyone know this?
Please help me to achive this functionality. Any help is appreciable.
Thank you.


<
Regards, Hiren Bharadwa<br/>
<br/>

View the full article
 
Back
Top