Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee
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

  • wahoo Profile Picture
    wahoo 275 on at
    RE: Entering ACH Payments in A/P

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entering ACH Payments in A/P

    Yes, it would.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entering ACH Payments in A/P

    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 Microsoft Employee on at
    RE: Entering ACH Payments in A/P

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entering ACH Payments in A/P

    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 Microsoft Employee on at
    RE: Entering ACH Payments in A/P

    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 Microsoft Employee on at
    RE: Entering ACH Payments in A/P

    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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans