An article on Integrating Receipt Module of your application with Tally, Tally.ERP
rtslink.com
Home / RTSlink DLL / More on Tally Integration / Receipt Module

How to Integrate Receipt Module with Tally Software?


This article illustrates how to integrate the "Receipt Voucher entry" module of your Software with the Tally Software.


To begin with, we shall manually do a Receipt Voucher entry in the Tally Software.

For reference purpose, the Tally Receipt entry screen is shown herewith.  As you can see, the following input is required:-

Voucher Type:     Receipt

Date:  1-4-2007

Receipt No: 1

Account :  Cash
Particulars: Shweta Softwares

Amount: 1000
Narration: Received a sum of..




 To identify the related fields in your database, a table is given below:-

Tally XML Tags XML Tags Example Field name in your table
(Fill-up this space)
<VOUCHERTYPENAME> <VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
<DATE> <DATE>1-4-2007</DATE>
<VOUCHERNUMBER> <VOUCHERNUMBER>1</VOUCHERNUMBER>
<PARTYLEDGERNAME> <PARTYLEDGERNAME>Shweta Softwares</PARTYLEDGERNAME>
<NARRATION> <NARRATION>Received a sum of...</NARRATION>
<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>
<LEDGERNAME>
<AMOUNT>
</ALLLEDGERENTRIES.LIST>
This section contains Crebit Ledger A/c details as given below:-

<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERNAME>Shweta Softwares</LEDGERNAME>
<AMOUNT>1000</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>
<LEDGERNAME>
<AMOUNT>
</ALLLEDGERENTRIES.LIST>
This section contains Debit Ledger A/c details as given below:-

<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<LEDGERNAME>Cash</LEDGERNAME>
<AMOUNT>-1000</AMOUNT>
</ALLLEDGERENTRIES.LIST>


Remarks:-
1)  Accounting effect of the above enty is as follows:-
     A/c : Cash                                  1000 Dr
     A/c : Shweta Softwares            1000 Cr

2) Party Account Creited
The Party A/c Shweta Softwares is to be credited. In this case, the Amount figure is shown as POSITIVE and the <ISDEEMEDPOSITIVE> tag value is set to NO.

3) Cash A/c to be Debited
The Cash A/c is to be Debited. In this case, the Amount figure is shown as NEGATIVE  and the <ISDEEMEDPOSITIVE> tag is set to YES.


GUID (RemoteID)


GUID  is a 16-byte number that is used to uniquely identify  a record in a database.

For more information on GUID, visit Tally-Integration-Tips

XML tags for Receipt Voucher entry (for Tally 9 / Tally 7.2)


The XML Tags required  for creating Receipt Voucher as per our illustration are given below  :-

<ENVELOPE>
<HEADER> 
<TALLYREQUEST>Import Data</TALLYREQUEST> 
</HEADER> 
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>All Masters</REPORTNAME>
</REQUESTDESC>
<REQUESTDATA> 
<TALLYMESSAGE xmlns:UDF="TallyUDF">
<VOUCHER REMOTEID="7811598w-849g-790n-221j-562536936384-00000002" VCHTYPE="Receipt" ACTION="Create"> <ISOPTIONAL>No</ISOPTIONAL>
<USEFORGAINLOSS>No</USEFORGAINLOSS>
<USEFORCOMPOUND>No</USEFORCOMPOUND>
<VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
<DATE>20070401</DATE>
<EFFECTIVEDATE>20070401</EFFECTIVEDATE>
<ISCANCELLED>No</ISCANCELLED>
<USETRACKINGNUMBER>No</USETRACKINGNUMBER>
<ISPOSTDATED>No</ISPOSTDATED>
<ISINVOICE>No</ISINVOICE>
<DIFFACTUALQTY>No</DIFFACTUALQTY>
<NARRATION/>
<ASPAYSLIP>No</ASPAYSLIP>
<GUID>7811598w-849g-790n-221j-562536936384-00000002</GUID>
<REFERENCE>1</REFERENCE>
<PARTYLEDGERNAME>Shweta Softwares</PARTYLEDGERNAME>

<LEDGERENTRIES.LIST>
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<TAXCLASSIFICATIONNAME/>
<LEDGERNAME>Shweta Softwares</LEDGERNAME>
<AMOUNT>1000.00</AMOUNT>
</LEDGERENTRIES.LIST>

<LEDGERENTRIES.LIST>
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<TAXCLASSIFICATIONNAME/>
<LEDGERNAME>Cash</LEDGERNAME>
<AMOUNT>-1000.00</AMOUNT>
</LEDGERENTRIES.LIST>

</VOUCHER>
</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>


In the above XML tags, the values that you need to fetch from your database have been highlighted.

Once the XML tag is ready, you can send if to Tally Software using RTSlink DLL Send() function.
Tally is a registered trademark of Tally Solutions FZ LLC.

Valid HTML 4.01 Transitional