$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.
A blog on how to import and export Tally data using XML requests. Shweta Softwares.
Saturday, September 15, 2007
Tuesday, September 11, 2007
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.
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.
Sunday, September 9, 2007
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.
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.
Monday, September 3, 2007
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"
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"
Subscribe to:
Posts (Atom)