In Dealer Excise Sales Invoice you can select the same item multiple times. Tally.ERP 9 allows the user to select the items with different duty per unit and even the stock itemspurchased under different invoices (from same supplier with the same Nature of Purchase)
Selection of same item multiple times is useful where user wants to sell the goods purchased under Multiple Bills (from same supplier with same nature of purchase & the manufacture is also same) & the duty per unit is different for all the bills or few bills. In this case, while recording the sales if the stock item is selected once and all the bills (with different duty per unit) are selected for the same item, in all the Excise reports the duty per unit will display the average duty of all the bills selected in the invoice as system cannot decide on displaying the duty appropriately.
Hence to get appropriate duty details in all the Excise Reports (including E - Returns), while recording excise sales select same item multiple times with proper bill selection.
Example: On 15-5-2009 ABC Company sold 500 Kgs of Hot Rolled Coils @ 650 per kg to Decora Equipments purchased under Invoice number - 457 (60 Kgs) &SI/785 (440 kgs)
Record the Transaction in Excise Sales Invoice
Go to Gateway of Tally > Accounting Vouchers > F8: Sales
Select Excise - Sales Voucher type from the list of Voucher Types.
Enter Ref. details as 1058.
In Excise Unit field Tally.ERP 9 displays ABC Company, as selected during voucher type creation
Select the Party’s A/c Name from the List of ledgers e.g. Decora Equipments
The Buyer’s Details sub-form appears enter Despatch and Order details in corresponding fields and accept the screen to save.
Note: The Buyer's Details will appear automatically if specified during the ledger creation.
Select the Sales ledger from the list of ledger accounts.
Select the VAT/Tax Class from the list Vat/tax Class.
Note: By default the VAT/Tax Class selected in the Sales Ledger appears in the above field which can be changed.
Select the Stock Item from the list of excise stock items.
On selecting the item, the Supplier Details sub-screen for the item appears as shown below.
Select the appropriate purchase e.g. 457 from the List of Purchases table. This table lists all the purchases made for the Stock Item.
Note: The List of Purchases displays the list of purchases made for the selected item from different Suppliers (Manufacturer / First Stage Dealer / Second Stage Dealer/Manufacturer Depot etc). However, once the goods purchased from a Manufacturer is selected for Invoicing, only goods purchased from Manufacturer will be displayed and If goods purchased from a First Stage Dealer is selected, only purchases from First Stage Dealer will be displayed for selection.
Upon selecting a Purchase, the cursor moves to Quantity Utilised field. The value in this field can be altered. Retain 60 kgs as ABC company is selling the all the 60Kgs to the dealer.
Note: If the utilized quantity is more than the purchased quantity the cursor remains in that field and Tally.ERP 9 warns you with a message.
The Supplier Details sub-form can hold the details belonging to a Single Supplier and for one type of purchase only. Tally.ERP 9 allows to select Multiple bills in Supplier Details screen, if the Duty per Unit of the Stock item is different from Bill to Bill, it is suggested to select the stock item as a second item in the voucher & then select the appropriate bill.
In Name of Item field select Hot Rolled Coils again as second line Item
For Hot Rolled Coils the duty per unit paid for purchase made under bill 457 is 329.60 & Duty per unit for Purchase made under SI/785 is 49.44. As the Duty per unit is different, Hot Rolled Coil is selected as the second line item to select the second bill to sell the remaining Quantity of 460 kgs.
In Supplier Details screen select the second Bill - SI/785 & in Quantity field specify 460
Select the applicable Output VAT Ledger, and press Enter, VAT Rate and amount is defaulted automatically
The completed Excise Sales voucher is displayed as shown
Press Enter to accept and save.
The Rule 11 invoice generated of a sales invoice where same item is selected multiple times appears as shown