Price Lists in Tally.ERP9

Price List in Tally.ERP9

1.       Price Levels in Tally.ERP 9 2.       Creating Price Levels in Tally.ERP 9 3.       Altering Price Levels in Tally.ERP 9 4.       Price Lists in Tally.ERP 9 5.       Creating a Price List in Tally.ERP 9 6.       Altering a Price List in Tally.ERP 9 7.       Assigning Price Levels to Ledger Accounts 8.       Using Price Levels during Invoicing (Voucher Entry)

1.   Price Levels in Tally.ERP 9 In Tally.ERP 9, you can create different Price Levels and assign different Price Lists to these Price Levels. For example, you can create Wholesaler, Distributor and Customer as Price Levels and assign applicable Price Lists to these Price levels, as per your requirements, so that only the relevant prices and discount rates are used during entry of orders and invoices. Before you start creating Price Lists, you may decide to create Price Levels as required. 2.   Creating Price Levels in Tally.ERP 9 Ensure that whether the Company is enabled for Accounts with Inventory in the Company Master screen. To enable Price Levels, Set the following fields to Yes in F11: Features > F2: Inventory Features screen. 1.    Allow Invoicing (If you do not set this option to Yes, the options for Price Lists will not be available.) 2.    Set Use Multiple Price Levels to Yes.  [1] 3.            Type the name of the price levels to be created, in the Company Price Levels screen.  [2] 4.            Press Ctrl + A to accept the screen and return to the F11: Inventory Features screen. Set the other options as required and accept Yes to save. 3.   Altering Price Levels in Tally.ERP 9 his option allows you to alter the existing Price Levels. To alter a Price Level, Go to Gateway of Tally > F11: Features > F2: Inventory Features screen. 1.    Tab down to Use Multiple Price Levels field and press Enter to go to Company Price Levels screen. Follow the same procedure as discussed in Creating Price Levels, to alter the name of a price level. You can simply overwrite the names you specified previously and save the changes. For more information refer Creating Price Levels. 4.   Price List in Tally.ERP 9 Price Lists are useful for orders and invoices. An up-to-date price list helps in decision-making even at the lowerlevels of the organization and quickens the sales process. Tally.ERP 9 assists in creating quantity based pricing with complex discount structure. Price Lists are available only for inventory items and hence the feature is available only if inventory and invoicing are activated for the company. You can have one or more price lists. You may require more than one price list, when you have different price structures/levels for different purposes viz., different groups of customers requiring different discounts or dealing in different products. Tally.ERP 9 permits you to create any number of price lists, based on the Stock Group and Stock Category to match the structure you need. Go to Gateway of Tally > Inventory Info. > Price List  [3] 5.   Creating a Price List in Tally.ERP 9 Once you have created Price Levels, the Price List option appears in the Inventory Info. menu Go to Gateway of Tally > Inventory Info. > Price List  [4] Creating Price List based on Stock Group Go to Gateway of Tally > Inventory Info. > Price List > Stock Groups ·         If you want to create a Price List consisting of all stock Items falling under different Stock Groups, select Stock Groups from the Price List Menu.   [6] ·         Select a Stock Group Name from the List of Stock Groups.  [8] ·         Select the Price Levels from the list Note:             To view all the Stock Items under the selected Price Level, click on  F12: Configure and set the option Show all Items for Price Level to Yes. ·         Type the applicable rates for the stock items for the selected Price Levels (you will notice that all the items grouped under Components appears under List of Items).  [9] ·         Accept to save Under Group This is the stock group of the Stock Item, for which you want to define the Price Lists. Price Level This is the Price Level under which the Price List needs to be created Applicable From This is the date from which the defined Price List is applicable. The columns you see are as follows. Sl. No This column is auto-generated serial numbers to track the number of items in the Price List. Name of Item This column contains the Name of the Stock Items under the selected Stock group. You can define the Price Listfor each item. Quantities - From & Less Than These fields are repeated for an item and begin with a blank for 0 items and end with a blank for any number of items (i.e., upto 50 Nos you can have a certain pricing if someone buys more than 50Nos you can specify a different rate). This is useful for quantity based pricing and discounts. You can create a staggered quantity price structure, if required. If you do not require quantity based pricing, leave From and Less Than fields blank. Rate Under this column, you can specify Rate, the Rate for the item based on the quantity range given. Discount % (if any) You can define a discount percentage in the Price List which will be taken automatically in the sales invoice, you may also choose to maintain the same price for all bands, but define different discounts. Historical Details (Rate and Disc%) This column displays the last Price List specified for such Stock Group. There are two columns: Rate and Disc %. Tally.ERP 9 provides the historical details of the sale rate and discount percentage of any previously created Price Lists. Therefore, you can define the current price details based on the information given in the Historical details. Cost Price In this column, Tally.ERP 9 displays the cost price of the item calculated based on the stock valuation method given in the item master. This has been provided to assist the user in giving the appropriate sale price. By viewing the historical price details of an item, we can accordingly define the sale price for the new Price List. Note:         For the discount percentage to be taken in the Price List, you should activate the feature Separate Discount Column on Invoices in the F11: Features (Inventory Features). Buttons in Price Lists Screen Ctrl+F4: New Parent Select this option to change the parent Stock Group Name, Price Level from the List. Creating Price List based on Stock Categories Go to Gateway of Tally > Inventory Info. > Price List > Stock Categories ·         If you want to create a Price List consisting of all stock Items falling under different Stock Categories, select Stock Categories from the Price List Menu.  [10] ·         Select a Stock Category from the List of Stock Categories. ·         Select the Price Levels from the list ·         Type the applicable rates for the stock items for the selected Price Levels  [11]  Buttons in Price Lists Screen Ctrl+F4: New Parent Select this option to change the parent Stock Category Name, Price Level from the List. Print/Export/Email/Upload Price Lists Select the relevant buttons while the price list is displayed for it to be printed / sent by e-mail or published. 6.   Altering a Price List in Tally.ERP 9 This option allows you to view the existing Price List based on Stock Groups or Stock Category in edit mode, here you are allowed to change the various information. To alter a Price List based on Stock Groups, Go to Gateway of Tally > Inventory Info. > Price List > Stock Groups 1.    Select the required Stock Group Name from the List of Stock Groups. 2.    Select the required Price Level from the List of Price Levels. 3.    Change the Applicable From date, as required. Follow the same procedure as discussed in Creating a Price List, to alter the Price Lists. Note:        Similarly you can alter the Price List based on Stock Category. To view all the Stock Items under the selected Price Level, click on  F12: Configure and set the option Show all Items for Price Level to Yes. 7.   Assigning Price Levels to Ledger Accounts Once the Price Levels are created in Tally.ERP 9, a new option appears in Ledgers grouped under Sundry Debtors and Sundry Creditors, with the help of which you can assign a specific Price Level to the ledger account. Go to Gateway of Tally > Accounting Info > Ledgers > Create   [12]  You can choose the Price Level that you want to assign to the Ledger, by selecting the Price Level from the PriceLevels list in the Pricing Level Applicable field. Select Not Applicable, if you do not want to assign any PriceLevels to the Ledger. If you want to assign Price Levels to ledgers created earlier, alter the ledger account, tab down to Pricing Level Applicable field and select the applicable price level from the list. Note:         For a Ledger, you can only assign / tag only one Price Level at a time, however you can change the Price Level selection depending upon your requirement in alteration mode or during Voucher Entry. 8.   Using Price Levels during Invoicing (Voucher Entry) The price levels created and assigned to Ledger Accounts automates Stock Item Prices and helps minimizing errors during Invoicing. Go to Gateway of Tally > Accounting Vouchers > F8: Sales 1.    Select As Invoice.   [13] 3.    Accept to save During Invoicing, there is an additional field Price Level enabled once Price Levels feature is activated and is prefilled with the Price Level which are specified for the selected Party ledger and the cursor skips this field. You may change the Price Level during Invoicing by pressing F12: Configure and setting Yes to Allow modification of ALL fields during entry. Go to Gateway of Tally > F12: Configure > Invoice/Orders Entry   [14]  Set Allow modification of ALL fields during entry to No to prevent changes made to prices. If you set it to Yes, you can override the prices already defined. Go to Gateway of Tally > Accounting Vouchers > F8: Sales ·         Select As Invoice.   [15] Once the above configuration is enabled in F12: Configure, you will now be allowed to modify the Price Levels for the selected Party Ledger during Invoicing. Note:           Tally.ERP 9 provides you flexibilty to select items with and without the Price List in the same invoice. For example, for the item which had the Price List defined, Tally.ERP 9 took the details automatically. Whereas for the stock item which did not have a Price List defined, Tally.ERP 9 prompted for the same.

Re-Order Levels and Re-Order Quantity in Tally.ERP9

Re-Order Levels and Re-Order Quantity in Tally.ERP9

Meaning – Reorder Levels and Reorder Quantity in Tally.ERP 9 1 Reorder Level signifies the quantity of a Stock Item in hand, after reaching which you must placeorders for your supplies. The importance of Reorder Level arises from the need to have sufficient stocks to service customer orders and, at the same time, not to unnecessarily accumulate stock

Specifying Simple Reorder Levels and Minimum Quantity in Tally.ERP 9 2 The Reorder and Minimum order quantity is defined based on fixed consumption pattern. When you select the Stock Group under the Reorder Levels menu, the Simple Reorder Levels screen will be available, by default

Specifying Advanced Reorder Levels and Minimum Quantity in Tally.ERP 9 3 The Advanced Reorder and Minimum order quantity is defined based on dynamic consumption pattern. To specify advanced Reorder Levels, Go to Gateway of Tally > Inventory Info. > Reorder Levels

Altering Reorder Levels and Minimum Quantity in Tally.ERP 9 4 There are two ways of altering the Reorder Levels and the Minimum Order Quantities defined earlier. 1. Go to Gateway of Tally > Inventory Info > Reorder Levels

Reorder Status and Quantities to Order in Tally.ERP 9 5 Go to Gateway of Tally > Display > Statements of Inventory > Reorder Status Select a Group of Stock Items from the List of Groups

Short Cut Key Command in Tally.ERP 9

Functions Keys)

Windows Functionality Availability F1 To select a company At all masters menu screen F1 To select the Accounts Button At the Accounting Voucher creation and Alteration screen F1 (ALT+F1) To select the Inventory To view the detailed or condensed report At the Inventory/Payroll Voucher creation and alteration screen In almost all the Reports F1 (CTRL + F1) To open Payroll Vouchers to alter At the Accounting/Inventory voucher creation or alteration screen. F2 To change the current date To select company inventory features At almost all screens in TALLY.ERP 9 At the F11: Features screen F3 To select the company To select Company Statutory & Taxation features To select the company To select Company Statutory & Taxation features F4 To open Contra voucher At Accounting / Inventory Voucher creation and alteration screen F5 To open Payment voucher At Accounting / Inventory Voucher creation and alteration screen F6 To open Receipt voucher At Accounting / Inventory Voucher creation and alteration screen F7 To open  Journal voucher At Accounting / Inventory Voucher creation and alteration screen F8 To open Sales voucher At Accounting / Inventory Voucher creation and alteration screen F8 (CTRL+F8) To open Credit Note voucher At Accounting / Inventory Voucher creation and alteration screen F9 To open Purchase voucher At Accounting / Inventory Voucher creation and alteration screen F9 (CTRL+F9) To open Debit Note voucher At Accounting / Inventory Voucher creation and alteration screen F10 To open Reversing Journal voucher At Accounting / Inventory Voucher creation and alteration screen F10 (Ctrl + F10) To open Memorandum voucher VAt Accounting / Inventory / Payroll Voucher creation and alteration screen F11 To select the Functions and Features screen At almost all screens in TALLY.ERP 9 F12 To open  Configure screen At almost all screens in TALLY.ERP 9

Short-Cut Key - (Special Key Combination)

Windows Functionality Availability 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 ALT + A To Add a voucher To Alter the column in columnar report At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination. Alters the column in all the reports which can be viewed in columnar format ALT + C To create a master at a voucher screen (if it has not been already assigned a different function, as in reports likeBalance Sheet, where it adds a new column to the report) To access Auto Value Calculator in the amount field during voucher entry 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. At all voucher entry screens in the Amount field 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) At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual. All the reports screen which can be viewed in columnar format ALT + E To export the report in ASCII, Excel, HTML OR XML format At all reports screens in TALLY.ERP 9 ALT + I To insert a voucher To toggle between Item and Accounting invoice At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination. At creation of sales and purchase invoice ALT + G To select the Language Configuration At almost all screens in TALLY.ERP 9 ALT + K To select the KeyboardConfiguration At almost all screens in TALLY.ERP 9 ALT + O To upload the report at your website At all reports screens in TALLY.ERP 9 ALT + G To select language for TALLY.ERP 9 Interface At almost all screens of TALLY.ERP 9 ALT + M To Email the report At all reports screens in TALLY.ERP 9 ALT + N To view the report in automatic columns At all the reports where columns can be added ALT + P To print the report At all reports screens in TALLY.ERP 9 ALT + R To repeat the narration in different voucher type At all Vouchers in TALLY.ERP 9 ALT + S To bring back a line you removed using ALT + R At all reports screens in TALLY.ERP 9 ALT + U To retrieve the last line which is deleted using Alt + R At all reports screens in TALLY.ERP 9 ALT+ V From Invoice screen to bring Stock Journal screen At Invoice screen > Quantity Field > Press Alt + V to select the Stock Journal. ALT + X To cancel a voucher in Day Book/List of Vouchers At all voucher screens in TALLY.ERP 9 ALT + R To repeat the narration in different voucher type At almost all screens in TALLY.ERP 9. 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.ERP 9, except where a specific detail has to be given before accepting CTRL + B To select the Budget At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen CTRL + ALT + B To check the Company Statutory details At all the menu screens CTRL + C To select the Cost Centre To select the Cost Category At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info)  creation/alteration screen CTRL+ E To select the Currencies At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen CTRL + G To select the Group At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen CTRL + H To view the Support Centre At Almost all screens in TALLY.ERP 9 CTRL + I To select the Stock Items At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info)  creation/alteration screen Ctrl + Alt + I To import statutory masters At all menu screens CTRL + K To Login as Remote Tally.NET User At Almost all screens in TALLY.ERP 9 CTRL + L To select the Ledger To mark a Voucher as Optional At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen At the creation and alteration of Vouchers CTRL + O To select the Godowns At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info)  creation/alteration screen 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.ERP 9. CTRL + R To repeat narration in the same voucher type At creation/alteration of voucher screen CTRL + Alt + R Rewrite data for a Company From Gateway of Tally screen CTRL + S Allows you to alter Stock Item master At Stock Voucher Report and Godown Voucher Report CTRL + U To select the Units At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info)  creation/alteration screen CTRL + V To select the Voucher Types To toggle between Invoice and Voucher At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen At creation of Sales/Purchase Voucher screen CTRL + K To login to Control Centre At almost all screens of TALLY.ERP 9 CTRL + H To access Support Centre. Wherein you can directly post your queries on the functional and technical aspects of Tally.ERP9, Shoper and Tally.Developer. At almost all screens of TALLY.ERP 9 Alt + Enter To view the Voucher display At Day Book and almost all Voucher Reports Alt + S To view Stock Query report At all Voucher Creation and Alteration screens where inventory is applicable except Contra, Reversing Journal,Memorandum and Physical Stock  Voucher Alt + Z To zoom in to the print preview to 100% screen At all print preview screens that appear on pressing Alt+P with the option I: With Preview enabled + To zoom in to the print preview At all print preview screens that appear after pressing Alt+Z - To zoom out of the print preview At all print preview screens that appear after pressing Alt+Z CTRL + Scroll wheel (Mouse Wheel) To zoom in to the print preview At all print preview screens that appear after pressing Alt+Z SHIFT + Scroll wheel (Mouse Wheel) SHIFT + Right or Left arrow To scroll horizontally - left to right or right to left At all print preview screens that appear after pressing Alt+Z

SPECIAL FUNCTIONS KEY COMBINATIONS

Windows Functionality Availability ALT + F1 To close a company To view detailed report To explode a line into its details To open Inventory vouchers to alter At all menu screens At almost all report screens At almost all screens in TALLY.ERP 9 At the Inventory/ Payroll voucher creation or alteration screen. ALT + F2 To change the period At almost all screens in TALLY.ERP 9 ALT + F3 To select the company info menu To create/alter/shut a Company At Gateway of Tally screen ALT + F4 To open the Purchase Order Voucher Type At Accounting / Inventory Voucher creation and alteration screens ALT + F5 To open the Sales Order Voucher Type To view monthly and quarterly report At Accounting / Inventory Voucher creation and alteration screens At almost all report screens in TALLY.ERP 9 ALT + F6 To open the Rejection Out Voucher Type To open the Sales Order Voucher Type At Accounting / Inventory Voucher creation and alteration screens ALT + F7 To open the Stock Journal Voucher Type To accept all the Audit lists At Accounting / Inventory Voucher creation and alteration screens At Tally Audit Listing screen ALT + F8 To open the Delivery Note Voucher Type To view the Columnar report At Accounting / Inventory Voucher creation and alteration screens At Ledger Voucher screen ALT + F9 To open the Receipt Note Voucher Type At Accounting / Inventory Voucher creation and alteration screens ALT + F10 To open the Physical Stock Voucher Type At Accounting / Inventory Voucher creation and alteration screens ALT + F12 To filter the information based on monetary value At almost all report screens CTRLl + F1 To open payroll vouchers for alteration At the Accounting/Inventory Voucher creation or alteration screen CTRL + ALT + F12 Advanced Configuration At Gateway of Tally SPACE To select the line to delete/hide At almost all report screens CTRL + SPACE To select all the line at one instance to delete/hide At almost all report screens CTRL + ALT+ A To select all the line at one instance to delete/hide At almost all report screens

KEY COMBINATION USED FOR NAVIGATION

PgUp Display previous voucher during voucher entry/alter At voucher entry and alteration screens PgDn Display next voucher during voucher entry/alter At voucher entry and alteration screens 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.ERP 9 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 At almost all screens in TALLY.ERP 9 SHIFT + ENTER Collapse next level details At Voucher Register screen and Trial Balance report SHIFT + ENTER To explode a line into its details In almost all Reports: At a Group/Stock Group/Cost Category/Godowns /Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centres/Secondary Godowns/Secondary Stock Categories At a Voucher – displays its entries and narration At a Stock Item- displays its godowns and batch details At Voucher Register screen – displays the next level details At Trial Balance report - displays the next level details CTRL + ENTER To alter a master while making an entry or viewing a report At voucher entry and alteration screens At all reports