web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AP Select Checks autom...
Microsoft Dynamics GP (Archived)

AP Select Checks automation outside Great Plains

(0) ShareShare
ReportReport
Posted on by JPiper 100

Has anyone automated the AP Select Checks process outside of the GP system? We have multiple GP 10 company databases, and it takes a long time to go into each one to build the batch and post them for processing. We would like to build a web interface that calls a script to run the process in each company. I have traced the GP scripts in SQL profiler, but looks like a lot of the code is in Dexterity.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    Re: AP Select Checks automation outside Great Plains

    I looked into this a few years ago. Very complicated, especially if you have to deal with multicurrency.  Your best bet is to automate the process with macros and vba.

    Bradley

  • Community Member Profile Picture
    Community Member on at
    Re: AP Select Checks automation outside Great Plains

    Have you considered intercompany processing?  We have around 80 companies but we only use three for accounts payable.  Those three companies pay the invoices for all others and then use the intercompany features built into Great Plains to send the expense to the correct company.  This reduces check runs and simplifies 1099 processing.

    Keith

  • JPiper Profile Picture
    JPiper 100 on at
    Re: AP Select Checks automation outside Great Plains

    Hello Sunbeam,

    Thank you for your response. I should have been a little clearer in my description. We have 40+ operating companies that the users need to log into each of and process the check runs. That is what takes the time, not system resources.

    I am looking to build an automated process to do the select check process across all companies, without the need to log into each. I have already automated the check printing process to generate 1 payment file to send to the bank from all companies for all payment types with the push of a button in a web app we have built. Now we want to automate the beginning of the process to build out the check batches.

    I have traced the logic using sql profiler, and I can see a lot of the coding must be done in dexterity, and not a single stored procedure. So  I know it is going to be complex to replicate the process without the dex source code. Probably why I can't find anyone that has created a 3rd party add on.

    Thanks again,

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at
    Re: AP Select Checks automation outside Great Plains

    Hi,

    This could be a long process, are you planning to duplicate the select check process to resolve the processing speed? might not be a good idea.

    How about looking into the reason why its porcessing slow? just a suggestion...

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans