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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Issue checks based on ...
Microsoft Dynamics GP (Archived)

Issue checks based on GL code

(0) ShareShare
ReportReport
Posted on by Community Member

We have 18 companies, so running a check run for each company is time consuming.  I am looking into merging each company's general ledgers into one company.  My concern is how to differentiate the check runs for each company's books.  The last 2 digits of our GL accounts represent the company.  Any ideas on how to accomplish running check runs based on the GL code?   xxx-xxxx-xx

*This post is locked for comments

I have the same question (0)
  • Verified answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    I can think of a couple of options.  One would be to use Binary Stream's Multi Entity Management which allows you to assign transactions to an entity and then do check run's per entity (as well as pay on behalf of other entities).

    Another option is Willoware has a set of tools called GP Powerpack and within that set of tools is one tool called Select Check Filters which would allow you to set up filters for selecting checks based on GL codes and segments (among many other filtering options).

    I've used both in the past and both work well.  MEM has alot of other nice functionality for keeping multiple companies within one database (i.e. automatic due to/from, separate 1099 printing per entity, security by entity, etc)

    Here's a link to Binary Stream MEM:  binarystream.com/.../multi-entity-management

    Here's a link to Willoware's GP Powerpack:  willoware.com/.../gp-powerpack

  • Community Member Profile Picture
    Community Member on at

    My employee brought up the fact that we do bank reconciliations in each company.  Can either tool you suggested also help us still reconcile each company bank rec separately?

  • Verified answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    A Ban Rec is per Checkbook ID (and GL account) and typically you'd have a separate checkbook ID per bank account so I don't see any issue with this.  This is assuming you don't have the same bank account across multiple databases (which sounds like a nightmare).

    MEM would offer additional features to help with this where you can assign certain checkbooks to certain entities so that way you couldn't accidentally do a transaction for entity A with entity B's checkbook.

    I'd highly recommend setting up a demo with Binary Stream to see MEM in action.  It sounds like it would be a good fit for you.

  • Community Member Profile Picture
    Community Member on at

    We have multiple companies also.  We designate one company as the primary accounts payable servicer.  It pays vendors for multiple companies and distributes the expense through GP Intercompany settings.  The servicer company recovers its cash paid out for other companies through Due To and Due From general ledger entries.

    We also see advantages in limiting the amount of tax reporting for 1099 forms since only the primary servicing company needs to report.

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans