You’re offline. This is a read only version of the page.
Announcements
149
Hi All
I'm hoping someone can help me. I'm getting an error when I create Vendor Payment journals. The system generates a batch number that's already been used before. I have checked the number sequence config and it's tracking the next number correctly namely 000683, however, when I create a new payment journal the next number created is 000002. I have reset the sequence, but it seems that this is not working. I have tested this error in my UAT environment and it's replicating the same error I'm getting in Live.
Another issue is when I delete this line a few times, or I have another user login to the UAT environment and test alongside me, they get the next sequence number correctly, and can generate each next number, however when they delete all the lines and try to capture a new journal they get 000002. I have tried to capture and post the journal with the 000683 journals, but the system fails and I get the same error that the record already exists...
has anyone had this error before
Hello,
Ramon, can you not check the exact number sequence coming into the error details? then find the number sequence in Organisation administration-> Number Sequence
and then follow the steps provided above, delete all the numbers addressed in the video.
Hi Ramon,
Are you using a similar voucher number sequence in any other journal/ module. You can try and find out if yo have a posted transaction with the same voucher number.
Go to General ledger > Inquiries > Voucher transactions.
Fill in the voucher number here and check if there are any posted transactions with the same voucher.
hi guys .. i checked , but find nothing that matches the sequence number voucher number that pops up... its a very odd .... the fix you guys gave me is perfect , but the moment i try to post the journal it says the voucher number has been used : cannot create a record in general journal entry . date. the record already exists
Ramon,
It is setup in the Journal names form. Field name "Voucher series".
Of course I can help, you can check the journal name from General ledger-> Setup-> Journal Setup-> Journal names
Find out your journal name what you are using, and from there you will find the voucher series, check the series, that is the series generating while you are using general journal
Ramit , where is the voucher number generated from? when i create a general journal voucher , i note that it creates a voucher number in the journal line, where is that one configured ? i cant locate where it draws that voucher number from ? would you happen to know where to look
Hi Ramon,
In addition, if you don't care about a possible gap in the journal batch numbering you can disable the continuous setting of the number sequence to prevent this issue for the future.
Hi Ramon,
When you go into the number sequence screen (for journal batch numbers), please click on the button "Status list" as highlighted below -
This should give you a list of numbers used an unused.
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
232,996
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
