Skip to main content
Solved

Add Number of Digits to the Length of the Payment Reference Number

  • March 21, 2024
  • 2 replies
  • 108 views

Forum|alt.badge.img
  • Freshman II
  • 20 replies

Hello - 

When attempting to cut checks, we are getting the below error message, “Cannot generate the next number for the sequence”, and the last payment reference number was 9999. It seems like there us currently a 4 digit cap on the length of the Payment Reference Number. 

How do I extend the length available numbers on this field? I could not find it in the numbering sequences, and it is different than the AP Payment numbering sequence.

Thanks!!


 


 

 

Best answer by meganfriesen37

That field doesn’t have a numbering sequence on it and that field is not a number type field, so it could just be that it didn’t know what to do when you went from 4 characters to 5.  If you would have had your last number as 09999 I think it probably would have advanced without an issue.  You may have the same issue again when you need to go from 99999 to 100000

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Author
  • Freshman II
  • 20 replies
  • March 21, 2024

Sorry - that appeared to not be the problem. I did however, change the AP Last Reference Number to 10000, and that allowed us to move forward. Any ideas why we would have got the error on the number “10000”?

Thanks!


meganfriesen37
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 590 replies
  • Answer
  • March 25, 2024

That field doesn’t have a numbering sequence on it and that field is not a number type field, so it could just be that it didn’t know what to do when you went from 4 characters to 5.  If you would have had your last number as 09999 I think it probably would have advanced without an issue.  You may have the same issue again when you need to go from 99999 to 100000


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings