How to alter the supplier invoice number entered for each stock item in an excise purchase invoice? (Excise for Dealer)

The supplier invoice number can be altered by duplicating the invoice.

Prior to altering the invoice, backup the data to avoid data loss.

1. Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Form RG 23 D > One Item .

2. Check if the supplier reference number which needs to be altered is linked to excise sales, excise debit note, excise material out, excise stock journal or journal vouchers. If they are linked, make a note of those transactions.

3. In the transactions noted above, unlink the supplier references for each stock item by setting the Supplier Invoice Number/Date to Not Applicable in the Supplier Details screen.

4. Go to Gateway of Tally > Display > Day Book > select the excise purchase invoice that needs to be altered and press Alt+2 to duplicate the invoice.

5. In the duplicate invoice, make the changes in the Excise Details screen of the first stock item. These changes will appear in the Excise Details screen of the subsequent stock items.

6. Cancel (press Alt+X ) or delete (press Alt+D ) the original excise purchase invoice, as the changes are made in the duplicated invoice.

7. In the excise sales, excise debit note, excise material out, excise stock journal or journal vouchers noted in the second point, select the duplicated purchase invoice as the Supplier Invoice Number/Date to link to each of the stock items.

8. If the same stock item is selected multiple times in the invoice, then manually change the details for each stock item.

The RG 23D One Item report appears with the invoices linked to altered supplier invoice number as shown below: