Vendor Payment Journal error- Journal Batch Number resetting

(0) Share

Report

Posted on by Ramon L

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

I have the same question (0)

All responses (13)

Answers (3)

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi Ramon,

Could you please go into Status list of the journal batch number number sequence and check if the number "000002" has status set as "Free"?

Was this reply helpful? Yes No
Ramon L 149 on at

Like (0)

Report

Hi Gunjan

THanks for getting back to me , im unsure of what exactly you mean by your reply , can you elabourate please

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

Hello,

There is a quick fix of this issue, check the below link.

community.dynamics.com/.../general-journal---number-sequence-error-in-10-0-5-pu29-vm

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ramon L 149 on at

Like (1)

Report

Thanks Gunjan, cleared the list in UAT , now i will test in Production

Was this reply helpful? Yes No
Ramon L 149 on at

Like (1)

Report

Thanks, Ramit, this was very helpful, I have tested both suggestions, will revert back as soon as I have found the issues location

Was this reply helpful? Yes No
André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Ramon L 149 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Ramon,

It is setup in the Journal names form. Field name "Voucher series".

Was this reply helpful? Yes No