FAQ-10 ( Excise for Dealers):

Excise Dealer Selling The Goods Bought Under A Excise Purchase Invoice At Different Rate


Excise Dealer is selling the goods bought under a excise purchase invoice at different Rate. While recording Excise Sales Invoice, is it possible to select stock item more than once from the same Purchase Invoice? If yes, how to record Excise Sales by selecting the same item more than once?

Example: On 2-7-2012, BAC Company Purchased 1000 kgs of Hot Rolled Coils @ 2350 per Kg from Sterling Steel Industries. On 10-7-2012, ABC Company sold the stock purchased on 2-7-12 to Decora Equipments - 500 Kg of Hot Rolled Coils @ 3100 and 250 kgs @ 3300.


Yes.  In Tally.ERP 9 Release 3.6, Excise Sales Invoice capability has been enhanced to select the same item more than once form the same purchase invoice. Selection of a Stock item more than once may arise when sale price is different.

To account the above transaction follow the steps:

Step 1: Record Excise Purchase Transaction

Tally.Erp 9 : Excise for Dealers


Step 2: Record Excise Sales Transaction

If a dealer is selling the goods purchased under same invoice at different rate, it is suggested to select the same item more than once for each sale price.

In the Sales Invoice select the Hot Rolled Coils. In Supplier Details screen select the purchase bill and enter the quantity - 500 kgs and accept. In Excise Sales invoice Enter the Rate i.e. Rs. 3100.

Tally.Erp 9 : Excise for Dealers


Tally.Erp 9 : Excise for Dealers


Tally.Erp 9 : Excise for Dealers


Tally.Erp 9 : Excise for Dealers


The completed Excise Sales Invoice appears as shown:

Tally.Erp 9 : Excise for Dealers


Before Printing the Excise Sales Invoice ensure Print Multi Page Excise Invoice is set to Yes along with other Dealer excise Invoice configuration.

Tally.Erp 9 : Excise for Dealers


The Print Preview of Excise Sales invoice appears as shown:

Observe, the excise purchase details are captured at the bottom once because for both the item the source is same invoice.

Tally.Erp 9 : Excise for Dealers


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 ...