Tally Integration using RTSlink DLL

New Rates w.e.f. 7th Nov 2011

2011-11-08T20:53:00.000+05:30

New Rates w.e.f. 7th Nov 2011 are available at http://www.rtslink.com/buy.html

Ledger Outstandings - Bill-wise format - Part 2

2011-09-28T11:45:00.001+05:30

This is further to my earlier post relating to exporting Ledger Outstanding - Bill-wise report. Even though we export (Alt+E) the data in detailed format, the xml output (LedBills.xml) does not contain the details of the Bill Vouchers part i.e.Voucher type, Voucher number etc. Here's the TDL code to get the correct xml output for Ledger Outstandings in Bill-wise format. i.e. LedVch Outstandings

Ledger Outstandings - Bill-wise format

2011-09-26T18:33:00.000+05:30

On exporting the Tally reporting "Ledger Outstandings" in Bill-wise format, the xml output does not contain any tag to identify each bill-record. Here's the TDL code to get the correct xml output for Ledger Outstandings in Bill-wise format. i.e. LedVch Outstandings [#Line: BILL Detail] XMLTAG : BILLDETAILS

Bad Variables - Tally error

2011-08-25T11:56:00.000+05:30

The error "Bad Variables" appears in Tally Software if one or more variables specified in the STATICVARIABLES cannot be set / initialized.

Cost Centre allocation in Purchase through Invoice mode

2011-06-13T09:31:00.002+05:30

Why can't the ‘Cost Centres’ containing ‘Purchase Entries in Invoice mode’ be allocated, when the Sales Entries in Invoice mode can ? Here's the detailed explanation in PDF format provided by Tally Solutions, Bangalore. Cost_Centre_allocation_in_Purchase_through_Invoice_mode.pdf

Tally ERP 9 Release 3 - Stock Journal

2011-02-22T19:39:00.000+05:30

The bug/issue in Tally ERP 9 Release 2.0 relating to Stock Journal XML tags has been now rectified in this release.

Tally ERP 9 Release 3 - IGNORED response tag

2011-02-22T19:10:00.000+05:30

The latest release - Tally ERP 9 Release 3.0 correctly displays the value for the IGNORED tag in the response tags. Earlier, the IGNORED tag used to incorrectly show 0 even if the record pushed into Tally was ignored by Tally.

Stock Value appears incorrectly

2011-02-11T12:05:00.000+05:30

Scenario In a Tally Company with Multiple Locations/Godowns set to Yes, the Stock Value appears incorrectly in StockSummary report in the following situation where :- Opening Stock of Item A Godown A - 5 Nos @ Rs 3 = Rs 15 Godown B - 5 Nos @ Rs 3 = Rs 15 Sale from Godown B - Qty 7 pcs. PS: As the Stock in Godown B is 5 Nos, and the Sale entry is of Qty 7 Nos, there is negative balance in

Ledger Monthly Summary

2011-02-01T10:35:00.000+05:30

To retrieve Ledger Monthly Summary, the following XML tags are to be used :- Yes Yes Works with :- Tally ERP 9 Release 2.1

An Attempt was made to load a program with an incorrect format

2010-12-16T18:04:00.000+05:30

The aforesaid error generally appears when you try to use a 32 bit program in 64 bit OS. To resolve the error (while using RTSlink DLL), you must change/ set the "Compiler - CPU Type" as X86 instead of "Any".

Tally ERP 9 Release 2.0 - Stock Journal XML tags bug

2010-09-21T12:50:00.000+05:30

Tally ERP 9 Release 2.0 - Bug Internal ID 7783 Description:- Stock Journal vouchers when exported manually (or retrieved programmatically) contain some extra xml-tags. Steps to re-produce the bug 1) Create a new Company in Tally ERP 9 Release 1.82 and entered a "Stock Journal" voucher. Next, export the same using option "Display >> Daybook >> Alt+E" . 2) Create a new Company in Tally ERP 9

$$ToValue TDL function

2010-09-09T09:24:00.000+05:30

The TDL function $$ToValue allows you to retrieve total-value of a specific method upto a specific date. Function : $$ToValue Syntax : $$ToValue : Date : FieldName Example1 : $$ToValue : #MyDate : #MyField Example2 : $$ToValue : ($$Date:"02/05/2010") : ($ClosingBalance:Ledger:"Cash") Preview

Tally ERP 9 Release 1.8 - Memory Access Voilation

2010-08-11T11:50:00.004+05:30

We have recently noticed that Tally ERP 9 Release 1.8 raises "Memory access voilation" error and terminates when a UNIT Master record is programmatically pushed. The aforesaid error occurs only in cases wherein the UNIT Master record exists in Tally.PS:The aforesaid problem does NOT occur in Tally ERP 9 Release 1.82 and Tally ERP 9 Release 1.61

LASTMID

2010-07-26T10:27:00.002+05:30

The tag received from Tally Software contains a tag named LASTMID. This tag is as of now (i.e. upto Tally ERP 9 Release 1.82) not assigned any value - which is confirmed by Tally Solutions, Bangalore.

Call to DLLRegisterServer failed with Code 0x80004005

2010-07-23T13:52:00.004+05:30

OS : Windows 7, VistaTo resolve the aforesaid error, follow these steps :-1. Click on Start button.2. Type cmd into the Start Search textbox. Do NOT press enter.3. Press Ctrl+Shift+Enter key.Ctrl-Shift-Enter is the general keyboard shortcut that triggers elevation to “Run as Administrator”.4. Press Alt+C or press Continue to confirm the UAC elevation warning prompt.After the run the REGSVR32 to

Issues in Tally 7.2. while retrieving the PriceLevel

2010-05-01T15:53:00.001+05:30

We tested using the following SELECT-SQL with different versions of TallySelect $$FullList:FullPriceList:$Date,$$FullList:FullPriceList:$PriceLevel from StockItem where $Name='101220'Tally 7.2 Release 3.12The SELECT-query returned the DATE but NOT the PriceLevel.Tally ERP 9 Release 1.61The SELECT-query returned the both the DATE and the PriceLevel.Remarks:-It appears that this is an issue with

Ledger Opening Balance

2010-02-24T11:53:00.003+05:30

You can retrieve the Ledger Opening Balances from Tally using the underneath SQL-SELECT statement :-Select $Name,$OpeningBalance From LedgerThe above SELECT-SQL returns correct balances if you are working in the 1st year. However, in the 2nd year or later (i.e. if the Current Period beginning is different from the Books beginning date) the above SELECT-SQL returns the OpeningBalance as on the

Tally ERP 9 - Creating a company programmatically

2009-11-29T06:50:00.004+05:30

Tally ERP 9 supports "Creation of a Company" programmatically.

Using RTS-XQuery DLL in VB6

2009-11-29T06:42:00.002+05:30

Here's a sample program which illustrates how to use RTS-XQuery DLL in Visual Basic 6.For more information on RTS-XQuery DLL, visit http://www.rtslink.com/rts-xquery-library/

Introducing RTS-XQuery ActiveX Library

2009-11-24T06:52:00.004+05:30

We are pleased to launch RTS-XQuery Library, an ActiveX DLL for Tally Integration with support for XQuery and XQuery Update facility.RTS-XQuery DLL is a superset of RTSlink DLL and includes all the features of RTSlink DLL. It is particulary useful for transferring data from Tally Software to external databases like SQL-Server, MySQL, Access, DBFs etc.RTS-XQuery works with Tally 6.3 and higher

Export Tally data to Relational database

2009-11-07T21:49:00.004+05:30

Here's a Free add-on utility for Tally Software that facilitates export of Tally data into Relational database.For more information on RTS-XQuery Freemium , refer http://www.rtslink.com/rts-xquery-freemium/Click here to view the step-by-step instructions for exporting Tally data to Relational databaseAlternatively, you can download the instructions (PDF-file) for exporting Tally data into

Tally ERP 9 Release 1.52

2009-10-29T06:51:00.003+05:30

Few weeks back, I had written about a problem in Tally ERP 9 Release 1.51 relating to pushing and pulling data programmatically.This was later on confirmed to be a BUG in Tally ERP 9 Release 1.51 by Tally Solutions, Bangalore. The same has now been rectified in Tally ERP 9 Release 1.52

$$FullList function

2009-10-21T11:29:00.003+05:30

$$FullList FunctionThe $$FullList function returns incorrect results in Tally 7.2 in certain cases, but works fine with Tally ERP 9 Release 1.5.ScenarioStep 1)Enter a Sales voucher with following items :-Name Qty Rate AmtItem A 5 100 500Item B 5Item C 5 150 750Step 2)Use the following SELECT-SQL to retrieve data from Tally :-Select $$FullList:InventoryEntries:$

Tally ERP 9 Release 1.51 issues

2009-10-16T15:30:00.003+05:30

This is further to my post on Tally ERP 9 Release 1.51 wherein we had posted an problem that many of us faced recently.It is now confirmed by Tally Solutions, Bangalore that this issue is an BUG and shall be rectified in the coming Release of Tally ERP 9. However, the date for the next Release could not be confirmed.

Tally ERP 9 Release 1.51

2009-09-30T17:43:00.000+05:30

We have recently noticed some issues in Tally ERP 9 Release 1.51 which probably seems to be a BUG in this Release (i.e. Release 1.51)BUG:When a request is sent to push/pull data, the Tally Software terminates with the following message :-Internal Error: Contact Tally SolutionsSoftware Exception c000005(Memory Access Voilation)PS:Though it prima-facie appears to be BUG (according to us), it has

Tally ERP 9 Release 1.3

2009-09-24T17:24:00.003+05:30

Tally ERP 9 Release 1.3 issuesThe SVCURRENTCOMAPNY tag does not work with Tally ERP 9 Release 1.3. Even though the destination company is specified using the SVCURRENTCOMPANY tag, still the data is imported into the currently selected Company in TallyThis problem has been solved in Tally ERP 9 Release 1.5.

Tally ERP 9 speed Issues

2009-09-06T04:26:00.002+05:30

The SELECT SQL slow speed issue with Tally ERP 9 Release 1 has been resolved in the Tally ERP 9 Release 5 (September 2009). For more information on this issue, please refer Tally ERP 9 Speed problem

Tally ERP 9 Speed Issues

2009-05-25T16:49:00.002+05:30

This is with regards to my earlier post on this issue. i.e Tally ERP 9 Speed problemIt has been confirmed by Tally Solutions, Bangalore that there are Speed problems/ issues while using SELECT statement to fetch Tally data from Tally ERP 9. Tally Solutions, Bangalore has also assured that this issue will be resolved in the forthcoming release of Tally ERP 9.

Tally ERP 9 SPEED Issues

2009-05-08T06:35:00.004+05:30

Recently while working on Tally ERP 9 we faced some problems. Tally ERP 9 was very slow in processing SQL-SELECT statements.Click here for more details on the Tally ERP 9 SPEED Tests that we performed.

Attempting managed execution inside OS Loader lock

2009-03-06T17:04:00.003+05:30

I am trying to link my VB.NET / C# application with Tally using RTSlink DLL. But I get this error while calling Open() function :-"Attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or image initialization function since doing so can cause the application to hang. "Solution 11. Go to Debug/Exceptions2. Open up the Managed Debugging Assistants

Tally 9 - Support for UNICODE characters

2009-01-10T10:45:00.004+05:30

Support for UNICODE characters is available in Tally 9. This post deals with some issues relating to UNICODE.1) When we programmatically import / export data from Tally 9, the default character-set used by Tally Software is ASCII.2) However, in case if NO Company is opened in Tally 9 and we programmatically send a SQL-Request to Tally (like to check if any company is open or not), the RESPONSE

Tally SQL-SELECT returns incorrect results at times

2008-12-14T18:01:00.006+05:30

While using SQL-SELECT to retrieve Tally data, we found that in certain cases, Tally Software returns incorrect results. This problem prima-facia appears to be a bug in Tally.The BUG relating to SQL-SELECT statementsThe SQL-SELECT statement in Tally returns incorrect result when some specific characters are used like period (a dot).Steps to replicate the problem:-Step 1Create a new Company in

EFFECTIVE DATE in Tally Software

2008-11-12T10:27:00.004+05:30

FAQs: What is the usage of EFFECTIVE DATE in TallyThe HELP menu in Tally describes EFFECTIVE DATE. Refer topic Voucher-types which provides explanation for Effective Date. The same is given below for your reference. Use EFFECTIVE dates for vouchers? Select Yes if you want to enter effective dates for vouchers. You would opt for this if you have instances where a transaction under

Escape Sequences in XML, XSL

2008-09-22T04:06:00.005+05:30

What is an Escape Sequence ?"An Escape sequence is a series of characters which cause an escape from normal interpretation".Escape sequences use a Special (Escape) character to change the meaning of characters that follow it.For example, you cannot use the & (ampersand sign) in XML as you would normally use it elsewhere. The & (ampersand sign) is a special character and is to be used differently

Tally Software || What is a Cancelled Voucher ?

2008-09-19T12:19:00.007+05:30

Deleted voucher Vs Cancelled voucherDeleting a VoucherYou can use Alt+D to manually delete a Voucher in Tally Software. When you delete a voucher, the Voucher and its effect is removed from the Tally Software.Cancelling a VoucherYou can use Alt+X to manually cancel a Voucher in Tally Software. Cancelling a Voucher does not delete/remove the Voucher from Tally; but its effect is removed. In

Tally Group-Master XML tags contain Invalid unicode character

2008-09-15T10:46:00.004+05:30

This prima-facie appears to be a BUG with Tally 9 and Tally 7.2Steps to replicate the PROBLEM1) Use the following SQL-SELECT to retrieve Tally data :-Select $name , $parent from GROUPS2) Extract of the XML-output generated by the above SQL-SELECT is given below for your reference:-Branch / Divisions PrimaryNotice the line shown in RED color. It contains an

Tally 9 Release 3 BETA issues

2008-08-28T16:53:00.003+05:30

Tally Solutions, Bangalore has come out with a new Release of Tally Software. i.e. Tally 9 Release 3 Beta.What is BETA Software?Beta is a nickname for software which has passed the alpha testing stage of development and has been released to a limited amount of users for software testing before its official release.Tally 9 Release 3 BETASome new and advanced features have been introduced in the

Programmatically create a Company in Tally

2008-07-12T16:12:00.002+05:30

FAQs: Can I programmatically create a Company in Tally ?No. This has been confirm by Tally Solutions, Bangalore. Maybe, in future this may be supported.

Tally 9 bug - Importing Standard Cost / Price data

2008-06-29T10:51:00.007+05:30

Recently, we noticed a problem while importing the Standard Price data into Tally 9. Though this issue is NOT yet officially confirmed by Tally Solutions-Bangalore, it prima facie appears to be a BUG with Tally 9.PrefaceOne of our Clients provided an Excel sheet that contained Stock-Item Masters with Standard-Price details (i.e. Standard Price Effective Date and Rate). The objective was to

Tally 9 Release 2.12 - XML tags bug has been rectified

2008-05-19T16:18:00.005+05:30

The bug in Tally 9 Release 2.1 relating to XML tags in proper-case issue has been rectified in Tally 9 Release 2.12.In March 2008, we had noticed it and had put it up at this blog-site. For those who are not aware of it, can read it here.Now, in Tally 9 Release 2.12 when we export Masters or Vouchers, the XML tags that are generated are in UPPER-CASE and this is in line with Older versions of

Tally 9 vs Tally 7.2 XML tags

2008-04-09T10:22:00.004+05:30

FAQs: Tally 9 XML tagsCan we use the Tally 7.2 XML tags with Tally 9 also ?Yes. Most of the Tally 7.2 XML tags work with Tally 9, except for few minor changes required in certain cases.We generally refer the Tally 7.2 tags format which can be used with both Tally 7.2 and Tally 9. However, there are certain cases wherein the tags differ and you need to use the appropriate tag. One of such cases

Ignore Duplicates option does not work when two or more companies are opened

2008-04-05T04:18:00.006+05:30

While working on this feature we noticed that the Ignore Duplicate option does NOT work when 2 (two) or more companies are open. It works only if a single Company is open. Let us try to understanding what we are talking about.SITUATION 1Step1We created a Company name "Company A" and added 2 Ledger masters viz.Ledger Name: Shweta ComputersUnder Group: Sundry DebtorsLedger Name: Tally

Tally 9 Release 2.1 - Error: No Valid Names!

2008-03-21T19:31:00.009+05:30

Before we look into the cause and solution for the aforesaid Tally Error message, let's revisit Tally 9 Release 2.1 as there has been a major change in the XML tags which was discussed in my previous post also.Here's what we are referring to:-"When we export Vouchers or Masters data from Tally 9 Release 2.1, the XML tags that get generated are in proper-case whereas in the previous versions/

Tally 9 Release 2.1 has a major BUG!!!

2008-03-20T03:50:00.006+05:30

We have recently noticed a major issue with Tally 9 Release 2.1. Though this issue is NOT yet officially confirmed by Tally Solutions-Bangalore, it prima facie appears to be a BUG.What is the BUG ?This BUG relates to XML tags that are generated when data is exported from Tally 9 Release 2.1 either manually or programmatically. The XML tags names in Tally 9 Release 2.1 have been changed.You can

Tally Error : Proper Ref Name not given

2008-03-17T05:40:00.002+05:30

Last week, while working on Tally XML tags, I got this error:- xx: Proper Ref Name not given for 'xxx'!(FOR OBJECT: 'REMOTEID:xxx')Though I could locate the mistake, it took few hours to do so. Here's what caused the problem."The tag used within the tag was blank. As the name suggests, the tag is used to specify the Bill details

Tally Integration with Java

2008-03-01T08:32:00.004+05:30

In the recent past, we have received several queries from Customers inquiring about whether the RTSLink DLL can be used in Java for Tally Integration.In this respect, please note the following:-1) RTSlink DLL cannot be used with Java.2) However, Shweta Computers can provide customized solutions for Integrating Java Applications with Tally Software.Please write to sales @ rtslink. com (remove

RTSlink DLL completes one year

2008-01-14T08:18:00.003+05:30

First Anniversary of RTSlink DLLIt has been one year since RTSlink DLL was launched.Many things have changed since then. In the initial days (when RTSlink DLL was launched), very few people were aware of "Tally Integration". In fact, the Tally Integration and Tally Customization activities were restricted to small community of Tally professionals.RTSlink DLL was launched in January 2007. The

SQL Server to Tally Software

2008-01-12T06:16:00.000+05:30

Tally Integration made EasyNew Release 1.3udi-Magic v3.0 Release 1.3 [Professional] allows you to transfer data directly from MS SQL Server to Tally Accounting Software using few SQL-SELECT statements and XML tags.Supports all versions of Microsoft SQL Server.Click here for more details on MS SQL Server to Tally

XBase (DBF) to Tally Software

2008-01-08T10:49:00.000+05:30

Tally Integration made EasyNew Release 1.2udi-Magic v3.0 Release 1.2 [Professional] allows you to transfer data directly from XBase (DBF) files to Tally Accounting Software using few SQL-SELECT statements and XML tags.Supportsa) DBaseb) Fox 2.xc) Visual Foxpro DBFs and DBC filesd) Other XBase file formats. Click here for more details on XBase (DBF) to Tally

Ledger and StockItem Masters

2007-12-21T11:15:00.000+05:30

How can I retrieve Ledger and StockItem Masters with their Closing balances ?You can retrieve Ledger & StockItem masters with their Closing balances either using SQL-SELECT or XML Tags.SQL-SELECT statementLedger-MasterSELECT $Name, $ClosingBalance FROM LedgerStockItem MasterSELECT $Name, $ClosingBalance FROM StockItemXML tagsRefer this link for more information XML tags to retrieve Tally Masters

Fetch Currency information from Tally Software

2007-12-21T11:01:00.001+05:30

You can retrieve Currency details using SQL-SELECT or XML tags as given below:-Using SQL-SELECTSELECT $Name,$OriginalSymbol FROM currencyUsing XML tags

Export Data

List of Accounts $$SysName:XML

Access Tally Data on a Remote Computer using RTSlink DLL

2007-11-09T09:44:00.001+05:30

FAQs: Tally Integration using RTSlink DLLCan I use RTSlink DLL to access Tally data from a Computer which is located in a different city or country ?Yes. You can use RTSlink DLL to access (push or pull) Tally data from a Remote Computer which is located in a different city or country.LIVE DEMOLive demonstration to access (pull and push) Tally data along with support and guidance is provided to

Corrections in ldaily.txt and ldaily.xml

2007-10-18T06:11:00.000+05:30

Minor corrections have been done in the XML and TDL file to fetch "Ledger Daily balances" using RTSlink DLL.FILE: ldaily.txt Old CodeSet : LedgerName: "Cash"New CodeSet : LedgerName: If $$IsEmpty:##LedgerName then "Cash" else ##LedgerNamePlease see:A syntax error in lDaily.xml has also been rectified.

Bug in $$ItemSerial TDL function

2007-10-17T05:09:00.000+05:30

Tally Integration using RTSlink DLL$$ItemSerial [TDL function]"The function $ItemSerial generates Line numbers beginning from 0. It does not accept any parameter and returns Numerical value. "Using $ItemSerial function with MastersSELECT $$ItemSerial,$Name FROM LedgerRemarks:-The $$ItemSerial works fine when used with any MASTER's Collection like LEDGER, GROUP,STOCKITEM etc. However, it returns

CompanyVouchers collection

2007-10-11T06:17:00.000+05:30

FAQs : Tally Integration using RTSlink DLLWhen I use the CompanyVouchers collection, Tally Server returns vouchers for the current-date only.CompanyVouchers is a pre-defined collection. The Collection definition is given herewith for your reference:-[Collection: Company Vouchers] Type : Voucher Child of : ##SVCurrentDate Report : Voucher IsODBCTable : YesAs you can see,

XML tags to create Sales Voucher in Tally Software

2007-10-09T15:30:00.000+05:30

CorrectionsMinor changes have been done in the CreSale.xml file. It now includes XML tags for creating Unit master also.Download the cresale.zip fileFor other downloads, visit www.rtslink.com/downloads.htmlRemarks:-CreSale file contains XML tags to create a Sales Voucher programmatically using RTSlink DLL. Tested with Tally 7.2 an Tally 9

BAD PARSE Error

2007-10-08T10:15:00.000+05:30

FAQ's :- Tally Integration using RTSlink DLLI am getting "BAD PARSE" error while using the Send() function of RTSlink DLLThis post is applicable to Tally 9 or higher versions only.Why does the BAD PARSE Error appear ?The Tally Server responds with "BAD PARSE" error when it is enable to parse the XML request that you had sent using the Send() function. In simple words, it means that the XML tags

VB.NET error : Attempting managed execution inside OS Loader lock

2007-10-04T06:21:00.000+05:30

FAQ's - Tally Integration using RTSlinkI am trying to link my VB.NET application with Tally using RTSlink DLL. But I get this error while calling RTSOpen() function :-"Attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or image initialization function since doing so can cause the application to hang. "Solution:-1. Go to Debug/Exceptions2. Open

$Date vs $$Date

2007-09-15T07:33:00.000+05:30

$Date - is an Internal method (i.e. field) of the VOUCHER Object.$$Date - is a function that accepts a string parameter and returns date value.Example:-Select $Date,$VoucherTypeName,$Amount from RTSAllVoucherswhere $Date = $$Date: '01-04-2007'The above SQL-SELECT statement returns all Voucher records where the Date is '01-04-2007'. Please note that condition $Date = $$Date: '01-04-2007' wherein

Support Services

2007-09-11T06:29:00.003+05:30

This post attempts to clarify the 'Type and Extent of Support Services' provided by 'Shweta Softwares' for it's product RTSlink DLL.Readers are invited to post their comments / views / suggestions to this post itself. Please mention your Name and City.WHAT SUPPORT SERVICES WE OFFER FOR RTSLINK DLLPoint 1Support services are provided for a period of 90 daysRemarks:-Integrating an Application with

XML tags for creating Masters and Vouchers in Tally Software

2007-09-09T16:55:00.000+05:30

This post provides XML tags (ONE sample each) for :- 1) Creating; Altering; Deleting Masters in Tally Software2) Creating; Altering; Deleting Vouchers in Tally SoftwareYou can download and use these XML tags for evaluating our product RTSlink DLL. Please note that we have provided ONE sample for MASTER (i.e. Group master) and ONE sample for VOUCHER (i.e. Sales Voucher).The XML tags given herein

ExplodeFlag tag does not work with "Bills Receivable" Report

2007-09-03T12:54:00.000+05:30

ExplodeFlag tag does not work with "Bills Receivable" Report.It has been confirmed by Tally Solutions, Bangalore that the above is a problem with Tally Software (Tally 7.2 & Tally 9).Problem Description:-ExplodeFlag is used to fetch / export data in Detailed format. It works fine with reports like "Trial Balance", "Balance Sheet" but does not work with report "Bills Receivable".My Query to Tally

Recycle bin for Tally Software with Source code

2007-08-27T08:52:00.001+05:30

Recycle bin is a FREE add-on utility for Tally Software. It enables you to retrieve Voucher entries that you may have accidentally deleted in Tally Software. It is similar to the Windows recycle-bin and works with Tally 7.2 and Tally 9. Supports Tally 7.2 and Tally 9 Software.View/Download the Recycle bin TCP Source-code.

Tally Integration

2007-08-11T06:00:00.000+05:30

Tally IntegrationHere's all that you wanted to know about Tally Integration at one place :-www.rtslink.com/Tally-Integration-Tally-Customization.htmlWhat all it covers:-VFP to Tally (incl Foxpro 2.6 to Tally)VB to TallyVB.NET to TallyC# to TallyASP.NET to TallyCode to Import Sales Voucher from your Application into TallyCode to Import Receipt Voucher from your Application into Tally

Tally 9

2007-08-09T16:26:00.001+05:30

You can Download Tally 9 Demo version from here.Tally IntegrationUse RTSlink DLL to read or write Tally data. Works with VB to Tally, VFP to Tally, VB.NET to Tally, C# to Tally, ASP.NET (with C#) to Tally.For more information, visit www.rtslink.comTally CustomizationLearn TDL - Tally Definition Language at tdlplayground.blogspot.comTags:-Tally 6.3, Tally 7.2, Tally 8.1, Tally 9 or higher.

ASP.NET to Tally, VB.NET to Tally, C# to Tally

2007-08-04T07:58:00.000+05:30

RTSlink DLL can be used in .NET platform to read or write Tally Software data (works with Tally 6.3, Tally 7.2, Tally 8.1, Tally 9 or higher). Sample code has been provided for using the DLL in C#, VB.NET and ASP.NET with C#. For more information, refer www.rtslink.comC# - Download sample code for using RTSlink DLL in C# VB.NET - Download sample code for using RTSlink DLL in VB.NET ASP.NET with

Can I have Tally Software on a different machine, other than that on which RTSlink DLL is installed ?

2007-07-04T11:25:00.000+05:30

Yes. You can have Tally Software on one machine and RTSlink DLL on a different system and still use the DLL to read/write Tally data.For this you need to create a plain text file named RTSLINK.INI in your Software Application folder which contains the following text:-[Tally]Server=192.168.1.1Remarks:-Substitute the IP-Address given above with the IP-Address of machine in which Tally Software

Fetch Tally Voucher data including Stock-Item details

2007-07-01T06:04:00.000+05:30

This post illustrates how to fetch Tally Voucher data including Item-Name, Item-Qty, Item-Rate using the SQL-SELECT statement. (SQL-SELECT works with RTSlink v1.8 or higher)Using Wrapper EXE to invoke SQL-SELECT statement1) Create a TXT file (say SQL1.TXT) which contains the following code:-SELECT $Date,$VoucherTypeName,$VoucherNumber,$Amount,$$FullList:InventoryEntries:$StockItemName,$$FullList:

Introducing RTSlink v1.9

2007-06-25T18:02:00.000+05:30

RTSlink v1.9 comes with a new function SQLDelete() that allows you to use SQL-DELETE statement to delete Tally Masters and Vouchers. For more information refer Using SQLDelete() function

Working with User-Defined-Collections

2007-06-22T17:08:00.000+05:30

This post illustrates how to fetch data from User-defined-Collection (MyStatistics) which is created in program TDL26. For information on program TDL26, visit tdlplayground.blogspot.comUsage:-SQLRequest("Select $AllLegers,$DebtorsLedgers,$CreditorsLedgers from MyStaistics")Using WRAPPER.EXE:-1) Create a TXT file (say Test.txt in C:\RTSLINK folder) that contains the following SQL-SELECT statement:

User-Defined Collection - RTSAllVouchers

2007-06-20T16:38:00.000+05:30

RTSAllVouchers is a User-defined collection that we shall be using in many of our programs. Hence, the source code is once again provided herewith for your reference:-;; PRODUCT: RTSAllVouchers;; PRODUCT-ID: cc307cfa-1d7f-4f9a-92f8-xde60a2943be;; AUTHOR: Shweta Computers[Collection: RTSAllVouchers] Type: Voucher IsODBCTable: YesNotes:-1) Create a plain TXT file using Notepad with the above code

How to Count Number of Ledgers in Tally Company ?

2007-06-13T11:37:00.000+05:30

At times we need to Count the number of records in a given Collection (i.e. Table). This can be done by using SQLRequest() function of RTSLink DLL. The underneath statement shows how to fetch number of Ledgers :-SQLRequest("Select $$NumItems:LEDGER from Ledger where $$ItemSerial=1")Now let us try to understand the above SELECT statement.1) $$NumItems is an Internal Tally function. It returns the

Error Msg: Date 0-0--1900 is out of range

2007-06-07T17:17:00.000+05:30

The above error message generally appears in the following cases:-1) When you use XML tags to write a Voucher to Tally and the Voucher date is lesser than the Books beginning date in the Tally Company.2) When you specify a date other than 1st or 2nd, and Tally is running in educational mode. In then Tally Education mode, you can enter vouchers for the 1st or 2nd of any month.

Using SQL-Select in Visual Basic to fetch Tally Data

2007-06-05T18:01:00.000+05:30

For information, click "Using SQL-Select to fetch Tally Data from VB"

A common mistake in VB

2007-06-05T15:13:00.000+05:30

One common problem faced by many programmers while using DLL functions in Visual Basic is NOT specifying the ByVal for String Parameters.Correct DeclarationDeclare Function SQLRequest Lib "RTSLINK.DLL" (ByVal strSQL As String) As LongIncorrect DeclarationDeclare Function SQLRequest Lib "RTSLINK.DLL" (strSQL As String) As LongRemarks:- By default, parameters are passed by Reference in Visual Basic

Introducing RTSlink DLL v1.8

2007-06-01T06:03:00.000+05:30

RTSlink DLL v1.8 now comes with a new function SQLRequest() that allows you to use SQL-SELECT statements to fetch Tally data. You can fetch both Masters or Vouchers data including the Item-details and Ledger-details using simple SQL-SELECT statements. Example:-a) Select $Name,$ClosingBalance from LEDGERb) Select $Name from STOCKITEM order by $NameFor more informaion, visit www.rtslink.comOnline

Using RTSLINK DLL in VB.NET

2007-05-19T12:20:00.000+05:30

PInvoke is the mechanism by which .NET languages can call unmanaged functions in DLLs. This is especially useful for calling Windows API functions that aren’t encapsulated by the .NET Framework classes, as well as for other third-party functions provided in DLLs. Using PInvoke in VB.NET to call RTSLINK DLL functionsThere are mainly two ways in which you can use PInvoke in VB1) Using the Declare

Analyzing the Tally Server Response

2007-04-20T05:07:00.000+05:30

RTSLINK DLLThis article describes how to read the Tally Server Response after a XML request is sent using the Send() function. To begin with, let us see the C language declaration of the Send() function.C language declaration of the Send() functionint __stdcall Send(message);Remarks:-The send function returns an Integer value (Zero for success, otherwise the error-code).If the return value is

Creating customized Tally Reports - MyDaybook v1.3

2007-04-17T05:14:00.000+05:30

MyDaybook version 1.3 supercedes the older version 1.2. The new features in MyDaybook version 1.3 are as follows:-1) Allows you to Delete multiple Voucher entriesClick here for more information on MyDaybook v1.3.

Tally Customization - Linking Sales Voucher module with Tally Software

2007-04-16T06:48:00.000+05:30

Tally Customization - How to link Sales Voucher entry module with Tally Accounting Software ?Click here for more information.

Linking Receipt Voucher entry module with Tally

2007-04-10T08:44:00.000+05:30

Click here for more information on linking the Receipt module of your software with Tally.

Export / Fetch Tally data programmatically

2007-03-07T04:14:00.000+05:30

Click here for information about Exporting Tally data programmatically using XML Tags.

Linking Ledger Master module with Tally

2007-02-15T02:26:00.000+05:30

LEDGER.EXE is a Master Entry form developed by Mr Vikas Aggrawal, Ahmedabad. This program has been developed in Visual Foxpro 6 and demonstrates how you can link your application with Tally Accounting Software.NotesEntries done in this VFP form are automatically posted in Tally. Full source-code of LEDGER.EXE (1991 kb) is provided. The source-files include:-1) Ledger.pjx and Ledger.pjt (Project

Group Master Entry form

2007-02-09T03:50:00.000+05:30

GROUP.EXE is a Master Entry form developed by Mr Vikas Aggrawal, Ahmedabad. This program has been developed in Visual Foxpro 6 and demonstrates how you can link your application with Tally Accounting Software.NotesEntries done in this VFP form are automatically posted in Tally. Full source-code of GROUP.EXE (1983 kb) is provided. The source-files include:-1) Group.pjx and Group.pjt (Project file)

Good Programming Practices

2007-02-08T01:41:00.000+05:30

1. Start with a good program design. 2. Your program should be functional at all times. Adding new functionality should not break the existing functionality.3. Divide the work into small incremental steps such that you can accomplish and review it within a single day.4. Review each line of your code.5. Adopt top-bottom approach.

Linking your Software with Tally

2007-02-08T00:56:00.000+05:30

I am not a programmer. Can I use the RTSLINK Utility ?RTSLINK DLL utility is for Programmers / Software developers who have developed their own software and wish to link it with Tally.What does "Linking with Tally" mean ? Suppose, you do a Payment Voucher entry (or any other voucher) in your program. Automatic Posting of this entry into the Tally software is what we call "Linking with Tally". In

2007-01-26T23:48:00.001+05:30

Introduction to RTSlinkRTSlink is a DLL (Dynamic Link Library) that allows software developers to integrate their Applications with Tally 7.2. or higher.RTSLink works on Windows 2000 and later versions and can be used with any Win32 application viz. Visual Basic, Visual Foxpro, Delphi, MS-Access applications. For using RTSlink with Foxpro 2.6 (DOS), you have to use Wrapper.exe provided along with