Hi! I got a kind of urgent issue that I am absolutely stuck with. I'd be very grateful if someone could help out with a solution...
Recently, we got an issue when creating General Journal and Bank Journal. The phenomenon is as below:
- If there are multiple lines in one journal, most commonly the first 2 lines will get the same voucher number. Sometimes the first 3 lines get the same number, and sometimes line 1&2 and line 3&4 get the same number, etc.
- If there is only one line in one journal, then the next journal will get the same number. If the next journal only has one line, then the next next journal will also get that same number. The number only advance to the next in sequence after line 2 has been finished in a journal, and line 3 have been created.
I checked the "Status list" in the number sequence, and the number's status changes as below:
- When a journal is created, but I have not clicked Lines yet (in this state, no line has been added which means no voucher number has been assigned): the Status list is empty.
- When Line 1 is created: the voucher number of this line (let's call it number x) appears in the Status list as "Free".
- When I finished Line 1, and added Line 2: the voucher number x became "Active" in the Status list. Line 2 got number x.
- When I finished Line 2, and added Line 3: the voucher number x disappeared from the Status list, and number x+1 is added to the list as "Active". Line 3 got number x+1.
- When I finished Line 3, and added Line 4: the voucher number x+1 disappeared from the Status list, and number x+2 is added to the list as "Active". Line 3 got number x+2.
My guess is that the cause of this issue lies in the fact that when Line 1 is created, the voucher number's status is "Free" instead of "Active" as it should be? Even with this guess, I don't know how to solve the problem... I have tried the Manual Cleanup > Current in the number sequence menu but it didn't work. The journal's voucher is also set as "In connection with balance" as it should be.
By the way, I'm not sure if this issue is related to Service Update, because we've just finished 10.0.21 update a few days ago...
Also, I used 2 different user accounts to carry out the same test, but the issue only occurred to one user account. The other one got completely correct test result. I don't know why yet... I compared these 2 accounts and as far as I know they seem to be the same.
Please help! And thank you in advance!
