Walk Collection - Example 2

Here's a sample TDL program to get the Voucher details with all ledgers using the WALK COLLECTION statement.

;;Adds a new option to Gateway of Tally
[#Menu : Gateway of Tally]
 Add : Item : Before : @@locQuit : Walk Collection - Example2 : Call : MyWalkCollectionExample2

;;This is a new Collection definition which is based on Tally Internal Object named Voucher which contains Voucher details
[Collection : MyVouchers]
 Type  : Voucher
 Fetch   : *, LedgerEntries.*

;;Function to display the Voucher details
[Function : MyWalkCollectionExample2]
 00 : SET FILE LOG ON
 01 : LOG : "***************************"
 
 ;; Loop through the Voucher table and display the vouchers
 05 : WALK COLLECTION : MyVouchers
 10 :  LOG : $$String:$Date + "," + $VoucherTypeName + "," + $VoucherNumber
 
 ;;  Loop through the ledgers and display the Ledger-name and amount
 15 :  WALK COLLECTION : LedgerEntries
 20 :   LOG : "=>" + $LedgerName + "," + $$String:$Amount
 25 :  END WALK
 
 30 : END WALK
 90 : SET FILE LOG OFF
 100 : Exec Command  : Notepad  : "TDLFunc.Log" 
 

Walk Collection

Here's a sample TDL program to get the Voucher details using the WALK COLLECTION statement.

;;Adds a new option to Gateway of Tally
[#Menu : Gateway of Tally]
    Add    : Item    : Before : @@locQuit    : Walk Collection - Example1      : Call    : MyWalkCollectionExample1    

;;This is a new Collection definition which is based on Tally Internal Object named Voucher which contains Voucher details
[Collection : MyVouchers]
    Type     : Voucher
    Fetch   : *, LedgerEntries.*

;;Function definition 
;;Displays the Voucher details
[Function : MyWalkCollectionExample1]
    00 : SET FILE LOG ON
    01 : LOG : "***************************"
    05 : WALK COLLECTION : MyVouchers
    10 :     LOG : $$String:$Date + "," + $VoucherTypeName + "," + $$String:($LedgerEntries[1].LedgerName) + "," + $$String:$LedgerEntries[1].Amount
    20 : END WALK
    90 : SET FILE LOG OFF
    100 : Exec Command        : Notepad     : "TDLFunc.Log"    

About Tally ERP

We have started a new blog to discuss and disseminate information about Tally ERP.

For more information, please visit http://www.rtslink.com/tally-erp

Guidelines for Tally Customization Services Providers

Tally Solutions has recently provided some useful guidelines for Tally Solution providers. This would be helpful both for the Solution providers and the End-Users (Customers).

Below are few key guidelines while engaging with the customers on Solution Business:

·       AMC on Code Maintenance  

Make sure that you state (in writing), the need for your customers to enter into an AMC on customization so that the code is maintained for future version & release compatibility. This is typically 30% (of customization cost) per year and is payable 90 days after go-live.  Alternatively mention that code rework will cost INR 5,400/7,200 per man day in case customer does not want to go for AMC.

In case you have not made this clear for existing customizations, please ensure that you do so at the earliest to avoid conflicts.

·       IP (Intellectual Property) of the Customization Code 

The communication in the proposal has to be very clear on who owns the IP (Source Code) of the customization done: is it your customer or you.

·       Testing Timelines

Proposal should contain clear timelines for the customer to test the customization and get back with any issues. This is typically 90 days from final implementation.

Solution Business engagement templates (listed below) are available in this link ‘Partner Portal (www.tallysolutions.com - use your login) > Resource Centre > Tally Integrator’

·        Pre-Proposal Checklist

·        Requirement Specification Template

·        Commercial Proposal (2 formats)

·        Customization Proposal

·        Implementation – Project Plan

·        Options for Service Agreement

·        High-Level Design Template

·        Low-Level Design Template

·        Sample Data

·        Web Integration POC

Tally ERP 9 to SQL Server

Here's a VB6 program which allows you to get data from Tally ERP 9 into SQL Server database.