F9 : Inv Rep : Allows you to directly invoke Inventory Reports menu without going back to
the Gateway of Tally screen.
F10:Acc Rep : Allows you to directly invoke Accounting Reports menu without going back to
Gateway of Tally screen.
To get the Closing Stock in the balance Sheet and the Profit and Loss Statement, activate
Integrate Accounts & Inventory? Option in F11 : Features.
F12 : Configure : Allows you to configure your Balance Sheet. Fields in the Balance Sheet
Configuration screen are explained as follows :
i. Show Vertical balance Sheet? : All Multi-column reports of the Balance Sheet are
shown in a vertical layout. You can select Y or N as required.
ii. Profit or Loss both as Liability? Select Yes or No.
iii. Show Percentages? : To see the figures in Balance Sheet along with break-up with
respect to Capita A/C.
iv. Show Working Capital Figures? To have working capital in the Balance Sheet of
Current Assets and Current Liabilities.
v. Method of showing Balance Sheet? By default, the Balance Sheet has horizontal
layout with Liabilities on the left side and Assets on the right side. A window, pops-up with
options to change the default settings of the Assets and Liabilities side in the Balance Sheet.
vi. Appearance of Names : A menu pops up with various styles for the display of Name.
vii. Scale Factor for values? For rounding the figures in the Balance Sheet to the nearest
scale factor.
F12: Range : This button is used to display information based on some search condition. You
can combine the search using the operators ‘OR’ and ‘AND’. You get the Range of information
in Report menu, by pressing Alt and F12 keys together or by clicking on this button. Suppose,
you frame a query for displaying Ledgers having Opening Balance as Non-Zero OR Groups
having Total Debit Transactions greater than 50,000. Now, to get a Balance Sheet Satisfying
the above query, proceed as follows:
Step 1: Select the option Ledgers from the Type of Info sub-menu in the Range of
Information in Report menu and press Enter. A sub-menu pops up
Step 2: Select the option Opening Balance from the sub-menu, another sub-menu Range of
Info. Pops-up
Step 3: Select the option as NON-ZERO from the Range of Info. Sub-menu, instantly you
get a Conditional sub-menu
Step 4: Select the Or option in the Condition menu, and press Enter. The Type of Info. Submenu
pops-up.
Step 5: Select the Group option in the Type of Info. Sub-menu. A sub-menu named
Particulars gets displayed on the screen.
Step 6: Select the Total Debit Transaction option in the Particulars pop-up list. Another submenu
Range of Info. Gets displayed.
Step 7: Select the greater than option in the sub-menu.
Step 8: Now type 50000 in the last field.
Step 9: Finally, select End of List option to end the search. You have the Balance Sheet
based on your query.
• F12: Value : You can specify the Vouchers to be used in calculation by selecting this button.
You get the Value to Calculate in Report menu by clicking on this button or by pressing Ctrl
and F12 keys simultaneously.
Now, let us make a Balance Sheet on the following Query.
Calculate balances using Vouchers having date equal to ‘23-04-2001’ OR Billed Quantity greater
than 40,000. To get a Balance Sheet satisfying this Query, proceed as follows:
Step 1: Click on the F12: Value button and select the Date option in the Particulars sub-menu, you
get a screen once you press the Enter key.
Step 2: From the Range of Info. Menu selects the equal to option. You get another sub-menu
displayed on your screen.
Step 3: Type the date 23-04-2001 and press Enter.
A condition sub-menu gets displayed
Step 4: Select the Or option from the condition sub-menu, to combine the search condition. A
particulars sub-menu pops-up.
Step 5: Select the Billed Qty option from the Particulars pop-up list. A range of Info. Sub-menu
gets displayed
Step 6: Select the option greater than from the Range of Info. Sub-menu and type the value as
40,000.
Step 7: Select the End of List option to end the search. You get the desired Balance Sheet
satisfying the your query.
No comments:
Post a Comment