FAQ-10 ( Excise for Dealers):

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

Query

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.

Solution

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

[6-83]

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

[6-84]

Tally.Erp 9 : Excise for Dealers

[6-85]

Tally.Erp 9 : Excise for Dealers

[6-86]

Tally.Erp 9 : Excise for Dealers

[6-87]

The completed Excise Sales Invoice appears as shown:

Tally.Erp 9 : Excise for Dealers

[6-88]

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

[6-89]

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

[6-90]

 
Company Information @ Tally.ERP9
 
 
 
Group & Ledger
Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES
Advanced Inventory / Stock
Meaning
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.

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