Dear friends, I need help to you
I want to create a separate invoice number for each item purchased. I need an invoice number which I connected it to my SAVE button after I Click that button, I want the invoice number to change the next invoice number appears. I tried to do it many times
but still not find what I want I need an invoice number 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 look forward to your warm and prompt response