How to remove revisions from serial number after amend

Okay here’s how to do it.

Prerequisites:

  1. System admin access
  2. Hold other people from carrying out those transactions (Sales Invoice, Delivery Note…) that you are trying to amend.

To make it easy, let’s go with this example:

Let’s say you are trying to modify a Sales Invoice SINV-00123 and you don’t want the -1 appendage when you modify this invoice.

Step 1: Make a duplicate of the SINV-00123. It will have the latest series number, but leave it in the draft mode. Let’s say the latest series is SINV-00126. So the duplicated document with bear number SINV-00127. You can and should skip this step if you are generating the document in question from another document (like you are making the Sales Invoice from a Delivery Note or from a Sales Order).

Step 2: Now cancel and delete SINV-00123. Don’t just delete. Cancel and Delete.

Step 3: Now ask all people to stop making transactions for this document, till you finish this cycle.

Step 4: No go to the awesome bar and search for Naming Series. Go to the Update Series section. Use the series of the document you are trying to amend (SINV in our example) and update 1 less than the series number of the document you are working with (In our example you use 122 in the current value field). Click Update Series Number. Hit Refresh and clear cache.

Step 5: If you are recreating the document from another document (like from Delivery Note or Sales Order for Sale Invoice), go back to the document and make the document from the upstream document. Else you can go to the document you duplicated in Step 1 and Duplicate the document. Save the document. This document should now bear the series number you were looking for without the appendage -1. Confirm this. Repeat step 4 & 5 till you get it right.

Step 6: Delete the duplicated document (if you duplicated the document) in Step 1, Go to naming series and update the series with the current number (126 in our example). Hit refresh and you can now tell your team that they can proceed making those documents again.

Step 7: Now go back to the document you’d saved in draft in Step 5, and make all necessary changes and submit the document.

Congratulations, you now know how to hack the system so that you get the same series number.

Hope this helps.

Thanks

Jay

3 Likes