I want to create an invoice number for each item purchased in my application. Here, is an example of the invoice number that I need I want an invoice that contains four numbers that start with 1001,1002,1003,1004,1005… for example if I delete invoice 1004, from my sales database (Sales List Items) This invoice 1004 should back to the Receipt Voucher not the next invoice 1005 is continuing because I want it That invoice number 1004 will come back to the Receipt Voucher. To be my database sales in order so that my sales database is organized and its invoice numbers are consecutive.
I am waiting for your kindly and gently help me thank you friends. and I welcoming any suggestions