Vendor Payment Journal error- Journal Batch Number resetting

(0) Share

Report

Posted on by Ramon L

159

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
Copy link

Link copied!

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 159 on at

Like (0)

Report
Copy link

Link copied!

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,803 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 159 on at

Like (1)

Report
Copy link

Link copied!

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

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

Like (1)

Report
Copy link

Link copied!

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... 303,269 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 159 on at

Like (1)

Report
Copy link

Link copied!

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,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Ramon,

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

Was this reply helpful? Yes No