Does SL2015 allow changes to the check number field to increase from six digits? Add Alpha characters? We have clients who are upgrading and are running out of check numbers.
*This post is locked for comments
The Check number is already larger than 6 digits in the database, you only need to 'customize' every screen that has check number and change the 'mask' from '999999' to '99999999' to make the check number 8 digits. Don't forget the reconciliation screens etc.
You can change it to 'XXXXXXXX' and allow letters, BUT banks don't like check numbers with letters, and it messes with the sequencing. I would suggest avoiding that. We have appended an 'A' on a check for instance to indicate that it was replaced/duplicated.
I tried that, but could only make changes on the Manual Check /Payment Entry screen (03.030.00). How would the same changes be made on the Check screen (03.620.00) where most of the checks will be issued.
I don't believe the Checks screen is customizable. Sorry.
Restart the Check number sequence with a history purge?
Do you have a script for that?
No. I would make a good backup and keep it. I would purge history and then start checks over at 100.
You may want to review similar discussion threads on the Microsoft Partner Forum. The most common approaches are:
1 – start a new cash acct/sub combination
2 – modify the database to add a leading zero to all existing check numbers and update field masks and reports as necessary to display the larger field.
By modify the database are you referring to the schema? Actually changing the field table lengths in SQL?
No change to the schema. AP tables are set for a 10 digit Alphanumeric field for Refnbr, while the default field mask has been 6 digits on entry screens and a matching default space for that field on most reports. You can change the mask for that field on SL entry screens to display 7 digits instead of 6, and you can widen the refnbr field on reports where necessary to keep the printed refnbr from being truncated on a printout.
I found that updating the existing reference numbers and adding a leading "0" to existing reference numbers makes the updated number scheme easier for the customer. Documents will still appear in the correct order when the next AP reference number sequence rolls over from 0999999 to 1000000. Check the MS partner forum for similar discussions.
Are you suggesting I update all checks (there is a substantial number and not sure I can do that) in the database with a leading "0" or change the next check number in SQL to include a leading "0". I haven't been able to find any other discussions on this topic.
Look at KB article 908830 for the required steps to accommodate 7 digits. I ran SQL scripts to prepend a leading 0 to the existing checks, primarily to keep the sort order the same on some AP reports that include the older checks since the check number is a character field. That extra step isn't necessary to allow using 7 digit reference numbers for AP checks.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
