Saturday, January 9, 2010

INTRODUCTION TO TALLY


Welcome to the world of TALLY! It is really remarkable that in the present scenario of software market primarily dominated by foreign companies like Microsoft, Borland, and Lotus etc. Indian software has become hugely popular. In this chapter we take a look at, what exactly TALLY is and at reasons, what have made this software so widely popular?
Indubitably despite the presence of so many other accounting packages available in our market, Tally remains the undisputed king of financial accounting packages available in India. It has been one of the favorite subjects of the rah-rah school of accounts in the last few years. Although Tally cannot change your personal life but it can handle practically any kind of transaction you would need, whatever your business.


In the simplest possible terms Tally is a financial accounting package (with a difference) and at technical lingo it is Extended Enterprise System. You will understand these concepts as you read the book. Unlike other packages Tally doesn’t involve any coding, thereby removing all dreadful sounding ho-hum terms related to programming as well as additional layers of information between your accounts and you. In order to use Tally, you neither need to learn new accounting methods nor should change your existing style of handling account. The software team of Tally has made all efforts to retain the flexibility of your traditional practice of manual accounting. The information can be fed as well as retrieved at random and all human errors can be corrected. Accounts can be classified in any desired manner and all outstanding can be tracked. Many more facilities like this, give you a near duplicate of your manual system of accounting at enormous speed.



A transaction in accounting terminology means transfer of money or money’s worth from one party to another, for example sale of goods, purchase of furniture etc. are examples of transactions. Fundamentally there are two systems of transaction: pre-transaction and post transaction. Let us explore them in detail, assume that you have to make payment to a party, in a pre transaction system, this is done by first creating a voucher, which is signed by the payee and then the transaction is completed by actually making the payment. These pre transaction systems provide preprinted voucher. Cheques and involve creation of internal entries in case of completed transaction. The post transaction system follows the traditional practice of entering a voucher or a cash bill into a cashbook after the payment has been made. Tally is a post transaction system It follows the traditional methods of accounting, that, is the payment is first made on the basis of existing accounting methods (i.e. against a voucher or cash bill) and that information is fed into the Tally. The simple fact that your existing system of accounting remains untouched by Tally is a big reason behind the success of this package.





We are going to learn about Computerized Accounting System. Before we delve into the details of the system, first we’ll get acquainted with term Accounting & its concepts to feel comfortable during implementation of an Accounting System.
Late 80s and early 90s was era of Financial Accounting Software. Users upon acquiring computer for first time were happy to do Financial Accounting that freed them from printed instant Reports. But soon they realized that only a part of business information is being processed leaving the most important part still to be carried out manually. Entrepreneurs started looking for software that will take care of Production & Inventory COMPUTER.
Computers are extremely versatile and finding their way into every business, industry and research activity today. The uses of computers are diverse and encompass entertainment, education, problem-solving, research, decision-making, home and personal management, data banks, communication and message services, etc. These computers can be used by any executive through a variety of user-friendly menu-driven graphical user interface package without any prior computer experience. Do Billing for them, analyze which item moves fast and which don’t who is buying/selling what and when as these information helps greatly in production and materials planning, ultimately improving bottom line.
Many software developers offered separate Financial and Inventory software to take care but users wanted a singe software where if a Invoice is entered that will update Accounts as well inventory information. This is what was termed as Integrated Business Accounting Software.

In this courseware, we give stress on how a Business Organization can computerize all its activities like Accounting, Production, Third Party Jobbing Invoicing & Inventory, which takes maximum time of manual work and is error prone due to numerous computation. Many users are still continuing with a manual billing as most of the software are not flexible enough to meet the complex and varied requirements of various manufacturing process, trade practices and invoicing terms, People place a host of information in Orders, Goods Receipt Note, Challans and Invoices as per their needs and choice, use stationery of varied size and styles.

Thursday, January 7, 2010

Migrating Tally7.2 data to Tally.ERP 9

1.      Double click on the Tally72migration.exe
2.     Tally Data Migration and Tally.ERP 9 start simultaneously in separate screens
3.      As soon as Tally.ERP 9 is loaded, a message Ready for Migration appears in the Migration Messages Pane
4.      Select Migrate Data
5.      The Select Company for Migration appears
6.      Specify the data path, if required



7.      Select the required company from the List of Companies
8.      Incase the company selected contains Payroll data; Tally.ERP 9 prompts a message as shown:




9.      Press Enter to continue with Migration
10. Tally.ERP 9 displays a message Continue Migration Yes or No


11.  Press Yes to start data migration from Tally 7.2 to Tally.ERP 9
12.  The Migration Information screen displays the Types of Masters and Types of Vouchers that need to be migrated from Tally 7.2
13. Tally.ERP 9 displays a message Migrate Yes or No
14.  Press Y or click on Yes to proceed with migration
15.  During the migration process, the calculator pane of Tally.ERP 9 displays the number of Masters and Vouchers migrated to Tally.ERP 9
Note: Certain un-used Voucher Types are removed from Tally.ERP 9, hence there will be a mismatch in Voucher Type Master Statistics.
Employee Masters have been split into Employees and Employee Groups.




16.  On successfully completing the migration process, Tally.ERP 9 will display a message Migration Completed Check Statistics




17.  On pressing any key a Congratulatory message appears as shown:




18.  Errors that occur that during the migration process are displayed in the Migration Message pane in red color
Note: Incase of an error during migration, it is advised to rewrite the data by pressing Ctrl + Alt + R from the migration tool and then start migration of data to Tally.ERP 9.
19.  The migrated company data is stored in the default Tally.ERP 9 folder and prefixed with a zero. The company folder will appear as shown




Key Combination Used for Navigation


Windows
Functionality
PgUp
Display previous voucher during voucher entry/alter
PgDn
Display next voucher during voucher entry/alter
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
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
SHIFT + ENTER
Collapse next level details
SHIFT + ENTER
To explode a line into its details
CTRL + ENTER
To alter a master while making an entry or viewing a report

Special Function Key Combination


Windows
Functionality
ALT + F1
To close a company
To view detailed report
To explode a line into its details
To select Inventory vouchers to alter
ALT + F2
To change the period
ALT + F3
To select the company info menu
To create/alter/shut a Company
ALT + F4
To select the Purchase Order Voucher Type
ALT + F5
To select the Sales Order Voucher Type
To view monthly and quarterly report
ALT + F6
To select the Rejection Out Voucher Type
To change the Sales Order Voucher Type
ALT + F7
To select the Stock Journal Voucher Type
To accept all the Audit lists
ALT + F8
To select the Delivery Note Voucher Type
To view the Columnar report
ALT + F9
To select the Receipt Note Voucher Type
ALT + F10
To select the Physical Stock Voucher Type
ALT + F12
To filter the information based on monetary value
Ctrl + F1
To select payroll vouchers for alteration
CTRL + ALT + F12
Advanced Configuration

Special Key Combination


Windows
Functionality
ALT + 2
To Duplicate a voucher
ALT + A
To Add a voucher

To Alter the column in columnar report
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)

To access Auto Value Calculator in the amount field during voucher entry
ALT + D
To delete a voucher
To delete a master
To delete a column in any columnar report
(if it has not been already assigned a different function, as explained above)
ALT + E
To export the report in ASCII, Excel, HTML OR XML format
ALT + I
To insert a voucher

To toggle between Item and Accounting invoice
ALT + L
To select the Language Configuration
ALT + K
To select the Keyboard Configuration
ALT + O
To upload the report at your website
ALT + G
To select language for Tally Interface
ALT + M
To Email the report
ALT + N
To view the report in automatic columns
ALT + P
To print the report
ALT + R
To remove a line in a report
ALT + S
To bring back a line you removed using ALT + R
ALT + U
To retrieve the last line which is deleted using Alt + R
ALT+ V
From Invoice screen to bring Stock Journal screen
ALT + X
To cancel a voucher in Day Book/List of Vouchers
ALT + R
To Register Tally
CTRL + A
To accept a form – wherever you use this key combination, that screen or report gets accepted as it is
CTRL + B
To select the Budget
CTRL + ALT + B
To check the Company Statutory details
CTRL + C
To select the Cost Centre

To select the Cost Category
CTRL+ E
To select the Currencies
CTRL + G
To select the Group
CTRL + H
To view the Support Centre
CTRL + I
To select the Stock Items
Ctrl + Alt + I
To import statutory masters
CTRL + K
To Login as Remote Tally.NET User
CTRL + L
To select the Ledger

To mark a Voucher as Optional
CTRL + O
To select the Godowns
CTRL + Q
To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
CTRL + R
To repeat narration in the same voucher type
CTRL + Alt + R
Rewrite data for a Company
CTRL + S
Allows you to alter Stock Item master
CTRL + U
To select the Units
CTRL + V
To select the Voucher Types

To toggle between Invoice and Voucher

Wednesday, January 6, 2010

Function Key in Tally Gold ERP

Windows
Functionality
F1
To select a company
F1
To select the Accounts Button
F1 (ALT+F1)
To select the Inventory
To view the detailed or condensed report


F1 (CTRL + F1)
To select Payroll Vouchers to alter
F2
To change the current date
To select company inventory features
F3
To select the company
To select Company Statutory & Taxation features
F4
To select the Contra voucher
F5
To select the Payment voucher
F6
To select the Receipt voucher
F7
To select the Journal voucher
F8
To select the Sales voucher
F8 (CTRL+F8)
To select the Credit Note voucher
F9
To select the Purchase voucher
F9 (CTRL+F9)
To select the Debit Note voucher
F10
To select the Reversing Journal voucher
F10 (Ctrl + F10)
To select the Memorandum voucher
F11
To select the Functions and Features screen
F12
To select the Configure screen