web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Entering ACH Payments ...
Microsoft Dynamics SL (Archived)

Entering ACH Payments in A/P

(0) ShareShare
ReportReport
Posted on by Community Member
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.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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?

  • Community Member Profile Picture
    Community Member on at

    Yes, it would.

  • wahoo Profile Picture
    wahoo 275 on at

    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.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans