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.
|
