Question Status

Suggested Answer
kimberlym asked a question on 12 May 2014 9:47 AM
We have a 1099 vendor that we recently started paying by ACH. I'm looking for a way to enter the ach payment in the a/p module without messing up the next consecutive check number for check payments. I know I can enter the voucher and a manual check but won't that mess up the check numbers the next time our a/p clerk does a check run? How do those who do large amount of ACH payment enter them? We have avoided a lot of ACH payments because of the work in keying the info at the bank and then into Solomon.
Reply
Suggested Answer
Rick Kerns responded on 12 May 2014 1:43 PM

Solomon determines the next available check number by looking at the APDoc table and selecting the highest refnbr for CK and HC documents and adding 1 to that.  So, you are correct that using some sort of check number greater than you physical checks will confuse Solomon and you would have to enter the real next check number on the checks screen each time.  Trying to use a bogus check number beginning with a letter will cause the same issue since letters sort after digits.  What we do with my clients is to use check numbers below the paper check numbers for EFT entries and we use a number low enough that it is highly unlikely we will run into existed check numbers.  So, for example, if your lowest retained check is check 004000 then use something like 001000 and up for your EFTs.  Of course, this approach only works if you have some low numbers unused for actual checks.  the only other approach that I have found is to use real high numbers and edit to the correct starting check number when printing physical checks.  It is always a good idea to cross-check what Solomon thinks is the next available check number to what you really have available anyway because paper checks tend to get used for hand checks and not timely entered from time to time.

Reply
Suggested Answer
rgrii responded on 14 May 2014 7:26 AM

I highly recommend using Sandler Kahne's EBanking suite for Dynamics SL. They have a means of creating the check file using a unique # outside of APDOC. Product works great and their support is always dependable. Web site is sksoft.com

Reply
Suggested Answer
Rick Kerns responded on 12 May 2014 1:43 PM

Solomon determines the next available check number by looking at the APDoc table and selecting the highest refnbr for CK and HC documents and adding 1 to that.  So, you are correct that using some sort of check number greater than you physical checks will confuse Solomon and you would have to enter the real next check number on the checks screen each time.  Trying to use a bogus check number beginning with a letter will cause the same issue since letters sort after digits.  What we do with my clients is to use check numbers below the paper check numbers for EFT entries and we use a number low enough that it is highly unlikely we will run into existed check numbers.  So, for example, if your lowest retained check is check 004000 then use something like 001000 and up for your EFTs.  Of course, this approach only works if you have some low numbers unused for actual checks.  the only other approach that I have found is to use real high numbers and edit to the correct starting check number when printing physical checks.  It is always a good idea to cross-check what Solomon thinks is the next available check number to what you really have available anyway because paper checks tend to get used for hand checks and not timely entered from time to time.

Reply
Elaine Rettig responded on 14 May 2014 6:37 AM

Another idea would be to use a different cash acct/sub combo. Each acct/sub combo uses it own range of check numbers.

Reply
Suggested Answer
rgrii responded on 14 May 2014 7:26 AM

I highly recommend using Sandler Kahne's EBanking suite for Dynamics SL. They have a means of creating the check file using a unique # outside of APDOC. Product works great and their support is always dependable. Web site is sksoft.com

Reply
Rick Kerns responded on 14 May 2014 9:57 AM

Elaine's suggestion would cause issues with Cash Manager or Bank Recon (if using one of those modules) if the EFTs are coming out of the same bank as physical checks.  Just a heads up.

Reply
kimberlym responded on 21 May 2014 11:46 AM

Wouldn't that cause the ach to post to a different GL account/subaccount combination so I would need to add two accounts to reconciled the bank statements?

Reply
Elaine Rettig responded on 21 May 2014 12:22 PM

Yes, it would.

Reply
Jane R. responded on 22 May 2014 8:39 AM

I also recommend Sandler Kahne's EBanking, their support has been fantastic on the occasions in which we needed them.  Using their product saves a tremendous amount of time depending on the volume of EFT's you have.

Reply