On Account payable preference, Bill Numbering sequence.
Currently can only allow a maximum of 15 characters.
Kindly assist on how I can change that so as to allow 19 characters.
Any kind of response will be highly appreciated.
Best answer by Naveen Boga
View original
+11
I’m curious as to the pain you’re experiencing that is driving this need. You do understand that a numbering sequence of 15 characters can support 999,999,999,999,999 documents?
+17
Yes,
If yes, I just wrote a code for this and attached the package. You can deploy and verify and confirm.
+11
+17
Where ever we wanted to use this Numbering Sequence with 19 characters, that field also should support the 19 Characters.
Hoping that he wanted to use this number sequence with 19 characters for the Custom Field. For the regular numbering, sequences make sure to have the 15 characters to as not to impact the existing screens.
if you wanted to use it for the existing screen, then you need to customize that graph to support that field with 19 characters.
+8
I suggest reviewing the business logic you have as what you are asking for is going to have a huge side effects. RefNbr is one of the APRegistet key fields which is used in many tables including APInvoice, APTran, APRegister, APAdjust (multiple fields), APTax, TaxTran, APPayment and many more transactional and summary tables that possibly none of us ever have encountered in our customizations and length of all these tables need to be customized.
I’m not quite sure if you have considered the severity of the risk you are posing yourself to. I would say forget it.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.