other useful functions of tally

The Collaborative Tally
Import of Data
Export of Data
TallyODBC

Import of Data
Gateway of Tally -> Import of Data
Importing Master data
Gateway of Tally -> Import of Data->Masters
A file containing the masters exported from another Tally company data should exist so that it can be imported and merged with the data of the current company.
On selection of All Masters, you will be required to give the source file name and format in which it is to be imported. Give the full path of the source file. Data may be imported in Tally in either Tally 5.4 Format, or Tally (XML) Format or plain Tally 6.3 Format. The support for Tally 5.4 format has been included keeping in mind the thousands of programs running all over the world. Select the format required and the data will be effortlessly imported.
Tally 6.3 Formats are inherently richer in content. Lists of Accounts (Masters), and Vouchers (e.g. Daybook), exported out from Tally ees 6.3 are in this format, and may be imported into another company or location. A typical use of this facility is to export the daily vouchers from a Branch, and send it to the Head Office for importing into the main Accounts.
The structure of the import files are sufficiently complex not to merit discussion in a user level manual. For the normal user, it is adequate to know, that the files exported out of Tally 6.3, may be imported back using the Tally 6.3 Format.
Tally's design permits it to import any kind of data. It is capable of being programmed to use data from other systems much more easily. This permits you to continue using other systems and use some of their data in Tally as if they were parts of one integrated system. For example, a customer contact management program may contain various details like status of an order and last contact made. Bring in that data into Tally to merge into a report containing outstanding balances. Any changes in the other data will be immediately reflected in Tally.
For those who wish to connect to other programs and use external data in Tally contact Tally Solutions at 'enterprise@tallysolutions.com', or write in to us for the structure of import files.
Tally creates a log of the import activity in a file TALLY.IMP which is located in the same directory as the Executable Program. Please do refer to this file to check whether all records were successfully imported.


Export of Data

Export of data is provided mainly for summaries and statement reports like Trial Balance, Stock Summary, etc. The main use would be to export data to, say, a spreadsheet, and reorganise it for statutory presentation. Or export it to another company using Tally that will import it directly.
Export of all reports and statements is possible. A separate button is provided in the button bar and press it to export the current report. All the four formats are available for export. For more details on the formats, please see the E-mail section under E-capabilities.
The exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Export Master Data

Gateway of Tally->Display->List of Accounts
Click on Print
Click on Export
File Name
The file name is required and can be anything.
Format
Four formats are available for selection – ASCII, SDF, HTML, XML. Select HTML only if you want to publish or display it. If the export is required to import the file into another system, select any of the others.


XML

To export transactions, select Day Book to export. If you wish to import those transactions in another system, XML format is recommended. An XML output will have an XML envelope and is formatted with XML tags to enable import into other systems. The destination system would need a little re-formatting of XSLT (XML Style Sheets) based on the Tally Styles and can then import the data. However, another Tally system can import the XML data directly using the import menu option and without any re-formatting.
Merge data: The imported data can be merged with existing data in this way. Please refer to the Import of Data section.


TallyODBC

Tally uses ODBC to connect to other programs and exchange data dynamically.


Outward Connectivity
Pick up data from Tally directly into other programs like Microsoft Excel or Word without any programming! Print labels for greeting cards from the ledger addresses stored in Tally! Even create templates for the likes of Audit Reports and Schedule VI forms and plug in data from Tally. Tally's database is now open for use in most popular programs to give you the unlimited flexibility of creating your own reports using up-to-date data from Tally.
How to use ODBC
A brief exercise will explain the process.
We wish to send greeting cards to all our customers. The customer database in Tally already exists. You want to use the names and addresses that you stored there to print out labels for the Greeting Cards. For this job, we will use Tally data in MS Word.
Start Tally. It should keep running.
Ensure that the words ODBC Server is visible in the Gateway of Tally screen
Start MS Word -> Select Tools ->Select Mail Merge
Main Document ->Create-> Mailing Labels
Now press the Data Source button
Get Data->Create Data Source
Click on MS Query (at the bottom of the dialog box beside File Name)
Select TallyODBC. (You could use a saved Query by clicking the Tab Queries. Do that after you have saved this query that we are creating)
Let the Use the Query Wizard remain ticked.
The Query Wizard brings the Tally fields that may be selected. You can also give filter conditions to limit the data brought in to only those that match your criteria.
Hence,
Select Ledger and move by click the > button to the right the following fields:
$Name, $Parent, $Address (move all the other address fields as well.
Then in the next Query Wizard Screen – Filter data to limit all ledger accounts belong to the Group that contains the name 'Customer'. (In our Sundry Debtors Group we have created sub-groups called Trade Customers below which we have different Customer Groups as well) We want to print labels for customers only.
You can save the Query for future use.
Then the process of Mail Merge is intuitive and is the domain of MS-Word. You can set up the main document and bring in the Create Labels dialog box,
Insert Merge Fields from Tally. The labels will be created.

Inward Connectivity

On the other hand, Tally ees 6.3 is capable of being programmed by TallyExperts to use data from other systems much more easily. This permits you to continue using other systems and use some of their data in Tally as if they were parts of one integrated system. For example, a customer contact management program may contain various details like status of an order and last contact made. Bring in that data into Tally to merge into a report containing outstanding balances. Any changes in the other data will be immediately reflected in Tally.


E-capabilities

E-capabilities
Special Key Combinations

E-capabilities
Tally has extensive internet capabilities. E-mail, Web-publishing and data interchange over the Internet are all easily achieved from within Tally.
Pre-requisites to using E-capabilities of Tally:
You should have an internet connection accessible from your computer. This could be through a direct dial-up modem or through the network.
For E-mail - an E-mail account.
For Web Publishing - you should know the sites' URL (address) and have authority to upload files on the sites.
More:

Special Key Combinations

Key Combination
Function
Where available
ENTER
To accept anything you type into a field.
To accept a voucher or master
To get a report with further details of an item in a report.
You have to use this key at most areas in TALLY.
At the receivables report – press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill, receipts and payments against this bill, etc)
ESC
To remove what you typed into a field
To come out of a screen
To indicate you do not want to accept a voucher or master.
-------------------do---------------
CTRL + A
To accept a form – wherever you use this key combination, that screen or report gets accepted as it is
At almost all screens in TALLY, except where a specific detail has to be given before accepting.
CTRL + Q
To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
At almost all screens in TALLY.
ALT + C
To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report)
At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen.
ALT + D
To delete a voucher
To delete a master
(if it has not been already assigned a different function, as explained above)
At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual.
ALT + I
To insert a voucher
At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination.
ALT + A
To Add a voucher
At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination.
ALT + 2
To Duplicate a voucher
At List of Vouchers – creates a voucher similar to the one where you positioned the cursor and used this key combination
SHIFT + ENTER
To explode a line into its details
In almost all Reports:
At a Group/Stock Group/Cost Category/Godown/Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centres/Secondary Godowns/Secondary Stock Categories
At a Stock Item –
At a Voucher – displays its entries and narration
At a Stock Item- displays its godowns and batch details
CTRL + ENTER
To alter a master while making an entry or viewing a report
At voucher entry and alteration screens
At all reports
ALT + R
To remove a line in a report
At all reports
ALT + S
To bring back a line you removed using ALT + R
At all reports

COMMENTS

Comments on this Website: 2
Loading...
.
Share above Content to Your Friends



Name

access account accountant Accounting accounting definitions accounting ebook Accounting education accounting procedure accounting process outsourcing Accounting Software advance advertising africa Amalgamation amendments announcements Annuity assets audit auditing Australia B.Com. balance sheet bank Bank reconciliation banking basic accounting BBA benefits best bill black money blog bloggers book keeping bookkeeping Branch Accounting - full tutorial budget Budget variance business businessman CA calculator canada capital capital budgeting career cash cash book cash flow statement Chiense children china class coaching coins college commerce commerce students company computer computer accounting conference Contact vinod kumar corporate accounting cost cost accounting cost center cost centre CPA credit credit card cs currency data Debit and credit debit cards debt debtor degree depletion depreciation documents dollar domain Downloads Dubai e-accounting earning education Education Loans email employee EPF ERP euromoney examination excel excise duty expenses facebook factor of loan fans feature fifo FII fiji finacle finance Financial financial accounting fire insurance flickr flow forensic forex formula france fraud free fun function fund GAAP GDP gdr germany gold goodwill goodwill accounting google google apps google apps google base google buzz google calendar Google docs google finance google fusion tables google talk govt. GST guide health Hindi Hindi Language history holding company How to treat FBT in Tally 9 HRA ICAI ICAWI ICICI Bank IFRS income income statement Income Tax India indian railway Indonesia inflation inflation accounting infographics information inspiration insurance insurance accounting interest international Internet Introduction of Tally 9 inventory investment invoice IT Japan Job costing journal entries Kalculate keyboard kindle kuwait laptop law LBT learning lease lecture ledger leducation Leverage Analysis liabilities lifo linkedin loan logical point loss loss of profit M.Com. m.phil malaysia management accounting manual accounting manufacturing account market marketing mastercard material MBA MCA media migration mobile money ms word ms. excel multi currency in tally 9 Multicurrency Accounting mutual fund national security new and sacrifice ratio new york times new zealand news NGO nonprofit-accounting North Georgia Mountains NPV NSE odbc office oman online application online accounting otcei pakistan parents pay pal pdf pie chart pie chart of income pnb podcast ppf presentation price privacy policy prize money prof. vinod kumar profit profit and loss account project management provision purchase puzzles quickbooks Quote quotes quotes of svtuition rating agency ratio analysis RBI readers real estate rectification of errors remote control reports reserves responsibility accounting retirement revenue Revenue reserves review risk rupees salary sale saudi arabia saving sbi scholarship school SEBI security service tax share share trading Shares shri lanka singapore sms social accounting society solution South Africa stock stock exchange structure student students study subsidiary company svtuition swiss bank tally tally 9 Tally 7.2 Tally 9 Tally.ERP 9 tanzania tax Tax Accounting TDS teacher teaching technology test testimonial testimonials thailand tips trading trading on equity transaction trend trial balance tuition twitter UAE UGC - NET Commerce UK United Arab Emirates university usa valuation VAT Video Voucher and vouching wikipedia working capital youtube
false
ltr
item
Accounting Education: other useful functions of tally
other useful functions of tally
Accounting Education
http://www.svtuition.org/2008/04/other-useful-functions-of-tally.html
http://www.svtuition.org/
http://www.svtuition.org/
http://www.svtuition.org/2008/04/other-useful-functions-of-tally.html
true
2410664366776677676
UTF-8
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at vinod@svtuition.org for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock