$Date vs $$Date

$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 RTSAllVouchers
where $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 the 1st $Date refers to the Date field whereas the 2nd $$Date is a function.

Remarks:-
1) RTSAllVouchers is a user-defined Collection and the related TDL which defines it must be specified in the Tally.ini. Click here for more information on RTSAllVouchers.
2) RTSlink DLL v1.8 or higher supports SQL-SELECT. Click here on more information on how to use SQL-SELECT statement.

Support Services

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 DLL

Point 1
Support services are provided for a period of 90 days
Remarks:-
Integrating an Application with Tally Software may require 3-4 weeks appx. This time duration depends upon various factors like the a) Time devoted by the Developer b) The programming experience of the Developer etc.

Support Services include access to password protected resources at our site and blog-site and this is limited to a period of 90 days.

Point 2
Queries are addressed within 24 to 48 hrs
Remarks:-
The average time has been less than 24 hours.

Point 3
Support services are provided by email
Remarks:-
Support services are normally provided by email. In demanding situations (which requires us to get lots-of-information from the Developer) we do provide support by Chat over Yahoo Messenger or Google Talk.

Point 4
Support services are cover the following :-
- Providing Basic guidelines for the Tally Integration process
- Providing guidance and sample codes for using the RTSlink DLL functions
- Providing guidance and sample XML tags to Create; Alter; Delete the Masters and Vouchers using RTSlink DLL
- Providing guidance and sample XML tags to Fetch Tally Reports data using RTSlink DLL
- Helping out in writing proper XML tags
- Helping out in TDL (to a certain extent)
- Access to XML Tags and TDL codes (which is provided to registered users only)

Point 5
Resources provided by Shweta Computers for it's product RTSlink DLL
- Instructions Manual, "RTSlink - An Insight" which covers detailed explanation of features like XML DOM
- XML tags at www.rtslink.com/TallyXMLTags.htm
- Software Registration utility for ONLINE or OFFLINE registration of the DLL

Shweta Computers, assures it best services and shall put all efforts to provide utmost satisfaction to its customers.

However, we would like to point out certain issues / things which are not covered under the Support services for our product RTSlink DLL. Here's it...

WHAT ALL IS NOT COVERED UNDER SUPPORT SERVICES FOR RTSLINK DLL

- Developing and providing customized TDL solutions as a part of RTSlink DLL package
- Developing and providing any other customized Program (Accounting or otherwise) as a part of the RTSlink DLL package
- Providing the source-code of the DLL
- Any sort of changes in the RTSlink DLL
- Customized solutions like demanding
"I have Software for Garments or Pharma Industry. Please provide me source-code of an accounting software for this particular industry with implementation of RTSlink DLL"

TDLplayground
Shweta Computers, has developed a blog-site tdlplayground, wherein it attempts to provide guidance and sample programs to Customize Tally Accounting Software using TDL (i.e. Tally Definition Language) FREE of cost.

Final Words
Business involves trust between Buyer and the Seller. And we are here to put the best of our efforts to WIN your trust.

POST YOUR VIEWS / COMMENTS / SUGGESTIONS
Readers are requested to post their views / suggestions along. Please mention your Name; city.

XML tags for creating Masters and Vouchers in Tally Software

This post provides XML tags (ONE sample each) for :-

1) Creating; Altering; Deleting Masters in Tally Software
2) Creating; Altering; Deleting Vouchers in Tally Software

You 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 have been verified with Tally 7.2 and Tally 9.

XML tags for Masters

1) Download XML tags for Creating a Group named My Debtors"

2) Download XML tags for Altering Group
Remarks: The Parent group for "My Debtors" is changed to "Sundry Creditors" instead of Sundry Debtors

3) Download XML tags for Deleting the Group "My Debtors"

XML tags for Vouchers

1) Download XML tags for Creating Sales Voucher
Remarks: This Sales voucher requires Ledgers and Stock-items. Hence, we have included XML tags for the required Ledgers, Stock-items also. A Sales Voucher of Rs 100/- dt: 1-4-2007 is created using these tags. Also note that the Accounting period in your Tally company must be 1-4-2007 to 31-3-2008.

2) Download XML tags for Altering Sales Voucher
Remarks: The Sales voucher created earlier is now modified. The Amount is now changed to Rs 200/-.

3) Download XML tags for Deleting Sales Voucher
Remarks: The deletes the Sales voucher created earlier.

SAMPLE CODE for using the above Tags with RTSlink DLL

To evaluate RTSlink DLL and the XML Tags, sample codes has been provided in different programming languages as given below:-

1) VB.NET, C# and ASP.NET using C#
2) Visual basic
3) Visual Foxpro
4) Delphi

The above links use XML tags to create Group Master. You can substitute the XML tags and test the XML tags for Vouchers also.

POST your Opinion / View / Comments

Has 'Shweta Computers' provided REASONABLE number of sample codes (with XML tags) for evaluating their product RTSlink DLL in line with what other Business Houses are providing for evaluating their products ?

You may answer in Yes or No or can put your comments.
Please provide your a) Name c) City.

Please do not provide fiticious names like ABC (and if your name is really ABC, then please provide your Phone number as we would like to invite you for tea). We don't serve Coke, please excuse us.

ExplodeFlag tag does not work with "Bills Receivable" Report

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 Solutions has been given underneath for your reference:-

a) I am trying to use ExplodeFlag=Yes xml-tag to retrieve the "Bills Receivable" report data in Detailed format, but am getting the report output in Condensed format.
File attached (Receivables.xml)

b) When I tried ExplodeFlag=Yes with other Reports like "Trial Balance", it works fine and I get the Result in Detailed format.
File attached (TB1.xml)

c) Next, I tried to manually export both the Reports mentioned above viz. "Bills Receivable" and "Trial Balance" using the Tally 7.2 Software

Try out the following to understand my query:-

SITUATION ONE (Tally 7.2 Release 3.12)

Export Trial Balance in Condensed XML
1) Use option "Gateway of Tally -> Trial Balance" to display it.
2) Now, press "Ctrl+E" to export the Trial Balance. Select the format as Condensed; XML format.
3) View the XML output generated.

Export Trial Balance in Detailed XML
1) Use option "Gateway of Tally -> Trial Balance" to display it..
2) Now, press "Ctrl+E" to export the Trial Balance. Select the format as Detailed; XML format.
3) View the XML output generated.

RESULT: You can see that the output is different in both the cases. You will get correct output in both the cases.

SITUATION TWO (Tally 7.2 Release 3.12)

Export Bills Receivable in Condensed XML
1) Use option "Gateway of Tally -> Display -> Statement of Accounts -! > Outstanding -> Receivables" to display the Bills Receivable report.
2) Now, press "Ctrl+E" to export it. Select the format as Condensed; XML format.
3) View the XML output generated.

Export Bills Receivable in Detailed XML
1) Use option "Gateway of Tally -> Display -> Statement of Accounts -> Outstanding -> Receivables" to display the Bills Receivable report.
2) Now, press "Ctrl+E" to export it. Select the format as Detailed; Show Qty Info as Yes; XML format.
3) View the XML output generated.

RESULT: Notice that the XML output in case of Bills Receivable is same in both the cases, whether we select Detailed or Condensed.

The same happens when we programmatically use EXPLODEFLAG=YES to fetch the Bills Receivable report, but the output is always in condensed format.

Conclusion:-
ExplodeFlag=Yes when used with Trial-Balance works fine, but does not work with "Bills Receivable"

Recycle bin for Tally Software with Source code

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

Here's all that you wanted to know about Tally Integration at one place :-
www.rtslink.com/Tally-Integration-Tally-Customization.html

What all it covers:-
VFP to Tally (incl Foxpro 2.6 to Tally)
VB to Tally
VB.NET to Tally
C# to Tally
ASP.NET to Tally
Code to Import Sales Voucher from your Application into Tally
Code to Import Receipt Voucher from your Application into Tally

Tally 9

You can Download Tally 9 Demo version from here.

Tally Integration
Use 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.com

Tally Customization
Learn TDL - Tally Definition Language at tdlplayground.blogspot.com

Tags:-
Tally 6.3, Tally 7.2, Tally 8.1, Tally 9 or higher.

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

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

C# - Download sample code for using RTSlink DLL in C#
VB.NET - Download sample code for using RTSlink DLL in VB.NET
ASP.NET with C# - Download sample code for using RTSlink DLL in ASP.NET (with C# or VB.NET)

Please note:-
RTSlink DLL can be used in ASP.NET (with C# or VB.NET) web-based projects in a Local Area Network only. For deploying solutions on a Remote Server, we can provide customized solutions for .NET platform or Java.

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

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

Remarks:-
Substitute the IP-Address given above with the IP-Address of machine in which Tally Software is installed.

Fetch Tally Voucher data including Stock-Item details

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 statement
1) Create a TXT file (say SQL1.TXT) which contains the following code:-

SELECT $Date,$VoucherTypeName,$VoucherNumber,$Amount,
$$FullList:InventoryEntries:$StockItemName,
$$FullList:InventoryEntries:$BilledQty,
$$FullList:InventoryEntries:$Rate
FROM RTSAllVouchers

2) Go to DOS Command-prompt and change to "C:\RTSLINK" folder.
3) Next, type the following command :-

WRAPPER SQL1.TXT /SQL

4) Check for the output in RESPONSE.LOG file.

Using the DLL in Visual Basic, VFP or any Win32 application
Syntax : SQLRequest( <SQL-SELECT statment>)
Remarks : Substitute the SELECT statement as given in the Wrapper exe sample.

Notes:
1) $$FullList is a Tally Internal Function. It processes the given Collection and returns the Field data.
Syntax : $$FullList : <CollectionName> : <Method/ FieldName>
Return Value : String

2) InventoryEntries is a pre-defined Collection. It stores the Stock-Item related information for Tally Vouchers.
3) Date, VoucherTypeName,VoucherNumber,Amount are Fields (also called Methods) of the VOUCHER Object. To fetch Fields/Method data, they are to be pre-fixed by $ sign.