Select Your Language :

Same Item Selected Multiple Times in Excise Sales (Excise for Dealer) in Tally.ERP 9

In Dealer Excise Sales Invoice you can select the same item multiple times. Tally.ERP 9 allows the user to select the items with different duty per unit and even the stock itemspurchased under different invoices (from same supplier with the same Nature of Purchase)

Selection of same item multiple times is useful where user wants to sell the goods purchased under Multiple Bills (from same supplier with same nature of purchase & the manufacture is also same) & the duty per unit is different for all the bills or few bills. In this case, while recording the sales if the stock item is selected once and all the bills (with different duty per unit) are selected for the same item, in all the Excise reports the duty per unit will display the average duty of all the bills selected in the invoice as system cannot decide on displaying the duty appropriately.

Hence to get appropriate duty details in all the Excise Reports (including E - Returns), while recording excise sales select same item multiple times with proper bill selection.

Example: On 15-5-2009 ABC Company sold 500 Kgs of Hot Rolled Coils @ 650 per kg to Decora Equipments purchased under Invoice  number - 457 (60 Kgs) &SI/785 (440 kgs)

Record the Transaction in Excise Sales Invoice

 Go to Gateway of Tally > Accounting Vouchers > F8: Sales

  1. Select Excise - Sales Voucher type from the list of Voucher Types.

  2. Enter Ref. details as 1058.

  3. In Excise Unit field Tally.ERP 9 displays ABC Company, as selected during voucher type creation

  4. Select the Party’s A/c Name from the List of ledgers e.g. Decora Equipments

  5. The Buyer’s Details sub-form appears enter Despatch and Order details in corresponding fields and accept the screen to save.

Note: The Buyer's Details will appear automatically if specified during the ledger creation.

  1. Select the Sales ledger from the list of ledger accounts.

  2. Select the VAT/Tax Class from the list Vat/tax Class.

Note: By default the VAT/Tax Class selected in the Sales Ledger appears in the above field which can be changed.

  1. Select the Stock Item from the list of excise stock items.

  2. On selecting the item, the Supplier Details sub-screen for the item appears as shown below.

  1. Select the appropriate purchase e.g. 457 from the List of Purchases table. This table lists all the purchases made for the Stock Item.


Note: The List of Purchases displays the list of purchases made for the selected item from different Suppliers (Manufacturer / First Stage Dealer / Second Stage Dealer/Manufacturer Depot etc). However, once the goods purchased from a Manufacturer is selected for Invoicing, only goods purchased from Manufacturer will be displayed and If goods purchased from a First Stage Dealer is selected, only purchases from First Stage Dealer will be displayed for selection.

  1. Upon selecting a Purchase, the cursor moves to Quantity Utilised field. The value in this field can be altered. Retain 60 kgs as ABC company is selling the all the 60Kgs to the dealer.


Note: If the utilized quantity is more than the purchased quantity the cursor remains in that field and Tally.ERP 9 warns you with a message.


The Supplier Details sub-form can hold the details belonging to a Single Supplier and for one type of purchase only. Tally.ERP 9 allows to select Multiple bills in Supplier Details screen, if the Duty per Unit of the Stock item is different from Bill to Bill, it is suggested to select the stock item as a second item in the voucher & then select the appropriate bill.

  1. In Name of Item field select Hot Rolled Coils again as second line Item


For Hot Rolled Coils the duty per unit paid for purchase made under bill 457 is 329.60 & Duty per unit for Purchase made under SI/785 is 49.44. As the Duty per unit is different, Hot Rolled Coil is selected as the second line item to select the second bill to sell the remaining Quantity of 460 kgs.

  1. In Supplier Details screen select the second Bill - SI/785 & in Quantity field specify 460


  1. Select the applicable Output VAT Ledger, and press Enter, VAT Rate and amount is defaulted automatically

The completed Excise Sales voucher is displayed as shown


  1. Press Enter to accept and save.

The Rule 11 invoice generated of a sales invoice where same item is selected multiple times appears as shown


Tally.ERP 9 Reference Manual LIBRARY
Installation of Tally.ERP9
Site Licensing of Tally.ERP9
Shortcut Keys in Tally.ERP9
Maintaining Company Data
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
Voucher Entry
Reports in Tally.ERP9
Excise for Dealer
Excise for Manufacturer
Reports [ Excise for Manufacturer]
Excise for Importer
Service Tax in Tally.ERP9
Tax Collected at Source (TCS) in Tally.ERP9
Tax Deducted at Source (TDS) in Tally.ERP9
Value Added Tax (VAT) in Tally.ERP9
Central Sales Tax (CST) in Tally.ERP9
GST using Tally.ERP9
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications