Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...
 
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.
 
 
 
 
[FAQ] : Tally.ERP 9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
 

Enter your email address:
[ Get Tally.ERP 9 Questions & Knowledge Base Feed delivered by eMail ]

Delivered by FeedBurner

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

GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com