All commands of calculator panel in Tally | Tally Calculator Panel Commands

 Calculator Commands in Tally

 You can see & show data in any format within a few seconds by using Tally calculator Panel. Kindly go through below article for more information.

Least people know the full functionality of Calculator panel of Tally.ERP 9. Most of the tally operators use its for calculations only or for auto calculator while entering invoice entries.

You will be surprised to know that Tally.ERP 9 has a powerful reporting and search system in its calculator panel.  Here you can use Sql Query commands to see or show reports.

in a simple way, Tally.ERP 9 has an in-built SQL processor which processes SQL command - SELECT -statements on collections. 

Watch this video to understand better

Try

these

commands

in calculator panel:-

The syntax to write an SQL Query in Tally.ERP 9 calculator panel is:

SELECT [<Method Name/s> / <*>] FROM <Collection/Table> WHERE <Condition> ORDER BY <Method Name/s>

Ok, let me make it simple.

Type  in calculator;-

SELECT $Name FROM Ledger

Press enter.

it will show you all ledgers names.

$Name is here the Method Name and the Collection is Ledger.

SELECT $Name FROM StockItem

Press enter.

it will show you all Stock Item names.

$Name is here the Method Name and the Collection is StockItem.

you can use more than one Method names in your report by adding another Method name. Look at the example below.

SELECT $Name, $Parent FROM Ledger

Or

SELECT $Name, $Parent, $OpeningBalance, $ClosingBalance FROM Ledger

Actually this one which I am sharing below is my favorite to see all details. This helps me to make TDL code files. 

SELECT * FROM Ledger

it shows dull details of given field like Ledger.

Jus move on the report using direction keys like right arrow key and check all mentioned details.

In Tally, A Collection is location where all the stored information is available. The collection LEDGER will have all the information about all the ledgers in the company. In the above example we have used another Collection StockItem to show report. All you need to do is just find the collection name and check the reports as per your requirement.

A method is where the particular information of a collection is stored. In our example, The method $Name is where the names of all the Ledgers are stored.

Don't forget to add $ before the method name like $Name, $Address, $ClosingBalance etc.

Now we will understand the use of WHERE and ORDER BY in the command. These are optional. you wish to use or not, you can decide.

SELECT $Name FROM Ledger WHERE $ClosingBalance BETWEEN 100 AND 1000

This command will show you selected ledgers names which have closing balance between 100 to 1000. Means we are using WHERE here for filtration. 

Now we will understand the use of Wildcard symbol % which is use for searching records marching with specified letters/Words.

SELECT $Name FROM ledger WHERE $name LIKE '%Traders%'

It will show you all ledgers names containing Traders. In My video I Used Many Debtors names like Mishra Traders, Kunal Traders, Bajaj Traders, Rajiv Traders etc.

With the WHERE , you can use the following Mathematical operators :-

= Equal to

< > or !=  Not equal to

> Greater than

<  Less than

>=   Greater than or equal to

<=   Less than or equal to

ORDER BY :-

To sort ascending order the result of the query the ORDER BY is used. The ORDER BY  sorts the result of the query in ascending order by default. To sort the results in descending order the DESC  is used

We can use more commands in Calculator panel:-

 type one of the command to see result in calculator panel

Balancesheet

Profit

Outstanding

Balancesheet from 1-4-2022 to 1-6-2022

Outstanding Mishra Traders (your Debtor/creditor)

Outstanding Mishra Traders from ____ to ___

Caputal

Cash

Sales

Purchase

Sales From___to _____

I will be back with more informative videos and articles. Pls let me know the feedback about this blog. Write a valuable comment.

Regards

Rajiv Mishra