FAQ-14 ( Excise for Dealers):

Is It Possible To Select Same Stock Item Multiple Times In A Dealer Excise Purchase Invoice?


Yes, it is possible. Tally.ERP 9 allows the user to select the Stock Items with different assessable value, different rate of Duty and even the stock items purchased against different invoices (from manufacturer).

Following is the procedure to select same item multiple times in Excise Purchase Invocie

Example: On 5-9-2008 ABC Company purchased Hot Rolled Coils from Globus Steel Industries vide invoice no. GSI/025/08-09. The details are as follows.

Stcok Item


Purchase Cost

Assessable Value

Rate of Duty

Manufacturers invoice against which

the stock item is purchased

Hot Rolled Coils

1000 Kg




SSI/785/08-09, dated 15-6-2008

Hot Rolled Coils

500 Kg




SSI/785/08-09, dated 15-6-2008

Hot Rolled Coils





SSI/650/08-09, dated 20-5-2008

Record the transaction in a purchase invoice

1.         Select Excise Purchase Invoice and Enter GSI/025/08-09 in the Supplier invoice No. field

2.         Select Globus Steel industries in Party's A/c Name field. In the Supplier Details screen select the Manufacturer as shown in the screen

Tally.Erp 9 : Excise for Dealers


Note: If the supplier of the goods is not the manufacturer, specify the details of the manufacturer of the goods in the Manufacturer / Importer Details section. In the Supplier’s Details by using Alt+M key or by clicking on the M: Manual button in the buttons bar, Manufacturer /Importer details can be entered manually or you can select the Manufacturer ledger from the List of Ledger Accounts if the Manufacturer ledger is created and available

3.         Select the Nature of Purchase as First Stage Dealer. If the Nature of Purchase selected in the Party Ledger the same will be defaulted

4          In the Name of Item field select Hot Rolled Coils. Enter Quantity - 1000 Kg and Amount - Rs.15,00,000 to view Excise Details screen

5.         In the Excise Details screen enter the details as shown

Tally.Erp 9 : Excise for Dealers


Note: In the Assessable Value  Rs. 12,00,000 on which the Excise Duty to be calculated. The amount specified in this amount should the amount on which the Excise Duty is calculated by the manufacturer.

6.          In Name of Item field select Hot Rolled Coils again as second line Item. Enter Quantity - 500 and Amount - Rs. 8,00,000 

Tally.Erp 9 : Excise for Dealers


7.         In the Excise Details screen enter the details as shown

Tally.Erp 9 : Excise for Dealers


Note: In the above screen supplier Invoice No. is altered as GSI/025/08-09-1. Invoice Number is altered in order to identify the Invoice Number for the Stock Item – Hot Rolled Coils selected as a second line item. Even though you alter the Invoice number for the second line item, in all the reports the Invoice number entered in the Supplier Invoice No. field will be displayed. 

For the second line item the rate of duty applicable is 8%. In Duty Details section, for Basic Excise Duty Type change the Rate of Duty as 8%. Duty amount will be calculated and displayed based on the rate of duty specified.         

8.         In Name of Item field select Hot Rolled Coils again as third line Item. Enter Quantity - 750 and Amount - Rs. 13,00,000

9.         In the Excise details screen enter the details as shown

Tally.Erp 9 : Excise for Dealers


Note: In RG 23D Entry No. field - 4366 is specified. This Number represents the suppliers RG 23D entry no, where the details of the particular transaction is available. As the Quantity of 750 is purchased under the Invoice no- SSI/650/08-09 which is different from the earlier Invoice Number. So appropriate RG 23D entry no, corresponding the purchase invoice is specified

As in Tally.ERP 9 you can select the stock items purchased under different invoices from the same party In the above screen under Manufacturers/ Importer Invoice Details,supplier has entered different manufacturers invoice No. i.e. SSI/650/08-09 which is different from the invoice selected earlier for Quantity 1000 and 500

10.     The completed Purchase Invoice is as shown below.

Tally.Erp 9 : Excise for Dealers


To Check the effect of these type of transaction

Go to Gateway of Tally> Display > Statutory Reports > Excise Reports> Dealer > Excise Stock Register

Excise Stock Register as on 5-9-2008 is displayed as shown

In all the reports the stock items selected multiple times in a purchase invoice will be displayed one by one based on the selection in the purchase Invoice.

Observe, in the Invoice No/Date column the Invoice Number as specified in Supplier Invoice No. field in voucher entry screen is displays irrespective of alteration done (as GSI/025/08-09-1 and GSI/025/08-09-2) in the Excise Details screen for the second and third line items.

Tally.Erp 9 : Excise for Dealers



Similarly you can verify all the reports.

Company Information @ Tally.ERP9
Group & Ledger
Advanced Inventory / Stock
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

Tally,Tally GST,TallyERP9 GST, 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. This Website is not associated with any product or vendor mentioned in this Website.

Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...