FAQ-15 ( Excise for Dealers):

In Excise Invoice/ Dealer Excise Reports, Negative Quantity or Negative Value is displayed. Why?

Answer

Negative quantity or negative values will appear in Excise Invoice or in Dealer Excise Reports when a purchase entry is deleted and re-entered against which the sales are (already) done.

Tally.Erp 9 : Excise for Dealers

[6-113]

 

Tally.Erp 9 : Excise for Dealers

[6-114]

Solution

 

Negative quantity or negative values will appear in Excise Invoice or in Dealer Excise Reports when a purchase entry is deleted and re-entered against which the sales are (already) done.

 

Follow the below mentioned procedure to rectify the negative values/quantity

 

Case 1:  Where the method of Voucher Numbering used is Automatic in Excise Sales Voucher type.

 

For the Excise Purchase Invoice which is displaying the Negative Value -

 

Check and note down the Excise Sales Invoice Number and Date of the sales vouchers recorded against the purchase invoice which is displaying Negative value.  

  • In the above screen for the Excise Purchase Invoice No ‘9400538679 dt 16.06.2009’ two Sales are made - EX-0659/18-06-2009 and EX-0667/18-06-2009 
  • Delete the Sales Entries - EX-0659/18-06-2009 and EX-0667/18-06-2009
  • After deleting sales entries re-accept the Purchase Entry (9400538679 dt 16.06.2009) by pressing enter (Don’t Use Ctrl+A).
  • Enter the Sales entries from Day Book (insert the sales entry on 18-06-2009 by selecting invoice number EX-0658 using Alt + A. So that you will get EX-0659 as sales invoice number). Ensure the Invoice number for the vouchers are same as of the earlier deleted entries.
  • Go to Form RG 23D report and check the details in the report.

 

 

Case 2: Where the method of Voucher Numbering used is Manual in Excise Sales Voucher type.

 

 For the Excise Purchase Invoice which is displaying the Negative Value –

  • Check and note down the Excise Sales Invoice Number and Date of the sales vouchers recorded against the purchase invoice which is displaying Negative value and mark the sales vouchers as Optional.
  • After marking the sales vouchers as Optional re-accept the Purchase Entry by pressing enter (Don’t Use Ctrl+A).
  • Mark the optional sales vouchers as Regular and select the appropriate purchase invoice number in the supplier invoice details screen and reaccept.
  • Go to Form RG 23D report and check the details in the report.
 
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 ...