Sage 100

We solved this problem for this client on their previous version, 2019. We installed 2021 over the weekend and the problem is back.

The PR check register never prints, just says "processing work file records", left it for 45 minutes before cancelling. I suspected it was due to them using 1 bank account with 2 different series' of check numbers. I used DFDM to edit GL_Bank and change all references to check number (NextCheckNo, InitialNextPayrollCheckNo, NextPayrollCheckNo & StartingPayrollCheckNo)  for this bank to the same number. The check register printed instantly and they were able to update. The 2 check ranges are 50000 numbers apart, so I am guessing it was trying to void 50,000 checks. I am assuming the same thing will happen in AP as well.

Has anyone solved this for version 2021?

I can teach them to edit Gl_Bank for the short term, but I need a long term fix.

Can the program logic to generate the voids in the check register programs be bypassed?
Can a script be written in Bank Maintenance (or even better Check Printing) to set all the "check no" fields in GL_Bank to the same number when the starting number is updated?
What was done in previous versions? This was not happening for them in 2019. I think I remember there was a patch, but I was unable to locate one on the KB for 2021.

I'm open to suggestions.

Thanks.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

To maintain separate check sequences we've used separate bank codes (and a transfer transaction).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

We did discussed that option, but she reconciles daily so it would be difficult.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 04-26-2022 12:45
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

To maintain separate check sequences we've used separate bank codes (and a transfer transaction).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

I guess my first suggestion is to convince them to go with ONE number series.  Why does it matter to them that the numbers are distinct?  It is just a number.  Show them the benefits of ACH direct deposit.  How do they keep track of the next number?  Do they use preprinted checks that have the check numbers?  Suggest they buy blank check stock and let Sage print everything.  They can buy two colors to distinguish and even modify the look.

It probably a Sage issue but Sage has a history of reintroducing bugs in new releases.

To prevent graying/thinning of hair, streamline their SOP's so that you can be their process improvement hero.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------

We discussed that as well. They have their reasons for keeping it the way it is. Hoping to get a fix like the previous version so they can keep their SOPs the same.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 04-26-2022 12:56
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

I guess my first suggestion is to convince them to go with ONE number series.  Why does it matter to them that the numbers are distinct?  It is just a number.  Show them the benefits of ACH direct deposit.  How do they keep track of the next number?  Do they use preprinted checks that have the check numbers?  Suggest they buy blank check stock and let Sage print everything.  They can buy two colors to distinguish and even modify the look.

It probably a Sage issue but Sage has a history of reintroducing bugs in new releases.

To prevent graying/thinning of hair, streamline their SOP's so that you can be their process improvement hero.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------

Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

The AP_CheckHistoryHeader does have 225K records most of which are Voids. Is this why the check register takes so long to print, is it scanning the 225K records before printing? I assumed it was creating 50,000 voids in a work table. If I purge void checks won't it still do the same thing if the difference between the 2 ranges of check numbers is 50,000 void checks?

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 04-26-2022 14:01
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------


Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Maybe I'm missing something, but wouldn't manually changing the next check number in bank code maintenance prior to each check run avoid all of the voids?  Is there a reason you need to do it in the GL_Bank file rather than in bank code maintenance?  It would be a hassle, and you would need to trust them to be in bank code maintenance, but better than in DFDM. 

And purging the voids that are already there would probably help too.

------------------------------
Barb Rippberger
Technology Integrators
------------------------------

Original Message:
Sent: 04-26-2022 14:24
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

The AP_CheckHistoryHeader does have 225K records most of which are Voids. Is this why the check register takes so long to print, is it scanning the 225K records before printing? I assumed it was creating 50,000 voids in a work table. If I purge void checks won't it still do the same thing if the difference between the 2 ranges of check numbers is 50,000 void checks?

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 04-26-2022 14:01
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.


Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

@Barb Rippberger Changing the starting number in Bank Code Maintenance alone does not work. There are additional "Check Number" fields that are controlling the behavior. The only way I could get it to print the Check Register was to change all of those fields to the same starting check number.

You are correct, I don't want them in DFDM - I want Sage to stop trying to "help" them by generating void checks when the check number has changed. LOL!​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 04-26-2022 15:16
From: Barb Rippberger
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Maybe I'm missing something, but wouldn't manually changing the next check number in bank code maintenance prior to each check run avoid all of the voids?  Is there a reason you need to do it in the GL_Bank file rather than in bank code maintenance?  It would be a hassle, and you would need to trust them to be in bank code maintenance, but better than in DFDM.

And purging the voids that are already there would probably help too.

------------------------------
Barb Rippberger
Technology Integrators
------------------------------


Original Message:
Sent: 04-26-2022 14:24
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

The AP_CheckHistoryHeader does have 225K records most of which are Voids. Is this why the check register takes so long to print, is it scanning the 225K records before printing? I assumed it was creating 50,000 voids in a work table. If I purge void checks won't it still do the same thing if the difference between the 2 ranges of check numbers is 50,000 void checks?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 14:01
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.


Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

That may be signs of a PR 2.0 (new) issue.  I'm pretty sure what Barb describes does work for AP checks...

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 04-26-2022 15:23
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

@Barb Rippberger Changing the starting number in Bank Code Maintenance alone does not work. There are additional "Check Number" fields that are controlling the behavior. The only way I could get it to print the Check Register was to change all of those fields to the same starting check number.

You are correct, I don't want them in DFDM - I want Sage to stop trying to "help" them by generating void checks when the check number has changed. LOL!​

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 04-26-2022 15:16
From: Barb Rippberger
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Maybe I'm missing something, but wouldn't manually changing the next check number in bank code maintenance prior to each check run avoid all of the voids?  Is there a reason you need to do it in the GL_Bank file rather than in bank code maintenance?  It would be a hassle, and you would need to trust them to be in bank code maintenance, but better than in DFDM.

And purging the voids that are already there would probably help too.

------------------------------
Barb Rippberger
Technology Integrators


Original Message:
Sent: 04-26-2022 14:24
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

The AP_CheckHistoryHeader does have 225K records most of which are Voids. Is this why the check register takes so long to print, is it scanning the 225K records before printing? I assumed it was creating 50,000 voids in a work table. If I purge void checks won't it still do the same thing if the difference between the 2 ranges of check numbers is 50,000 void checks?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 14:01
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.


Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Does the user have PII permission (GL Module)?  I don't think v2019 had the bank account number encrypted, but v2021 does...

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 04-26-2022 15:33
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

That may be signs of a PR 2.0 (new) issue.  I'm pretty sure what Barb describes does work for AP checks...

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 04-26-2022 15:23
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

@Barb Rippberger Changing the starting number in Bank Code Maintenance alone does not work. There are additional "Check Number" fields that are controlling the behavior. The only way I could get it to print the Check Register was to change all of those fields to the same starting check number.

You are correct, I don't want them in DFDM - I want Sage to stop trying to "help" them by generating void checks when the check number has changed. LOL!​

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 15:16
From: Barb Rippberger
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Maybe I'm missing something, but wouldn't manually changing the next check number in bank code maintenance prior to each check run avoid all of the voids?  Is there a reason you need to do it in the GL_Bank file rather than in bank code maintenance?  It would be a hassle, and you would need to trust them to be in bank code maintenance, but better than in DFDM.

And purging the voids that are already there would probably help too.

------------------------------
Barb Rippberger
Technology Integrators


Original Message:
Sent: 04-26-2022 14:24
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

The AP_CheckHistoryHeader does have 225K records most of which are Voids. Is this why the check register takes so long to print, is it scanning the 225K records before printing? I assumed it was creating 50,000 voids in a work table. If I purge void checks won't it still do the same thing if the difference between the 2 ranges of check numbers is 50,000 void checks?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 14:01
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.


Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Not sure what the behavior behind the curtain is.  Perhaps copy the XXX company to a test company and purge the voids, then observe what happens next.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------

Original Message:
Sent: 04-26-2022 14:24
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

The AP_CheckHistoryHeader does have 225K records most of which are Voids. Is this why the check register takes so long to print, is it scanning the 225K records before printing? I assumed it was creating 50,000 voids in a work table. If I purge void checks won't it still do the same thing if the difference between the 2 ranges of check numbers is 50,000 void checks?

------------------------------
Greg Stiles
S & W Microsystems
------------------------------


Original Message:
Sent: 04-26-2022 14:01
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.


Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Using the AP Utility "Remove Void Checks" solved the problem completely. AP_CheckHistoryHeader went from 250K+ to 27K. The PR Check Register is back to performing at normal speed. Interestingly teh void checks are no longer being created even though the starting check number is being swapped between 27xxx and 75xxx between PR and AP.

Case Closed! Book 'em Danno!

Thanks everyone for the help, appreciate it.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

Original Message:
Sent: 04-26-2022 15:31
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Not sure what the behavior behind the curtain is.  Perhaps copy the XXX company to a test company and purge the voids, then observe what happens next.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
------------------------------


Original Message:
Sent: 04-26-2022 14:24
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

The AP_CheckHistoryHeader does have 225K records most of which are Voids. Is this why the check register takes so long to print, is it scanning the 225K records before printing? I assumed it was creating 50,000 voids in a work table. If I purge void checks won't it still do the same thing if the difference between the 2 ranges of check numbers is 50,000 void checks?

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 14:01
From: Jeff Schwenk
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Giving up SOP's developed in the 90's is extremely difficult.  Just later I had a support call that entailed setting up a new source journal code for the new fiscal year.  It was an SOP I developed for them 17 years ago.  I mentioned times have changed and the reason from my SOP back then no longer is relevant and perhaps they should just use JE instead and auto number (via VI next).  They wouldn't consider it.  Same client is still using FRx.....

Keep pushing them to improve their bottom line through sound SOP's.

BTW, what about the purge voided check utility in AP???

------------------------------
Jeff Schwenk
Bottomline Software, Inc.


Original Message:
Sent: 04-26-2022 13:07
From: Greg Stiles
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

They do Payroll Direct Deposit but not for all employees. Large varied workforce, not possible to do Direct Deposit for all employees.

------------------------------
Greg Stiles
S & W Microsystems


Original Message:
Sent: 04-26-2022 13:05
From: Kevin Moyes
Subject: AP & PR check registers taking forever to print due to a large number of void checks - HELP!!!

Enable wire transfers for the 2nd sequence?  (I don't know if that would work for PR...).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.