Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Non Decentralized checking account check processing

Posted on by 240

We have Dynamics GP2018.  We have multiple entities using the same bank account for vendor check processing.  We do not use MEM.  Does anyone have any suggestions, other than MEM or Mekorma, where tracking and check processing across the multiple entities can be done, without creating duplicate check numbers in more than one entity/processing of the same check numbers in multiple database entities in the one bank account, other than creating a schedule around check processing for each location?

Thank you in advance for your assistance!

  • Suggested answer
    RE: Non Decentralized checking account check processing

    The checkbook setup in each company should store the 'next check number' and increment accordingly, separate from the other companies.  So if the 'next check number' has the same numbering scheme, they will print the same check numbers whether they process at the same time or not at the time time since it just pulls the next check number from the checkbook setup.   If you want to use the same numbering scheme, then yes, you'd have to schedule times for each company/user to print checks, and have them update the 'next check number' each time to the next one, so they do not cross.  Perhaps a manual file on a shared location were each user posts the last used check # or something like that.   The only other way to not produce duplicate check numbers would be to update the 'next check number' on the checkbook in each company and have a 'range' for each different company so they do not cross, like is suggested in my Q1 above.   If you want all companies to read from the same numbering scheme by default, you'd have to search for a 3rd party that may do that. I do not know of any offhand, but something you could inquire to Mekorma about, since they do a lot with checkruns.

    Hope that helps,

    Cheryl W

    Microsoft Support

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: Non Decentralized checking account check processing

    Hi Cheryl!

    Thank you for the response.  Please allow me to explain in further detail.

    There is for Dynamics GP2018 check processing.  This is not for Management Reporter or reporting of the bank account

    There is only one checking bank account being used for 13 different, separate company databases (entities).

    They have multiple locations across the country for each of the different, separate company databases (entities).

    They are concerned that when one company is processing checks in California, that one of the other companies (entities) are processing checks in Illinois, and they end up with duplicating check numbers on each of their check processing runs for the one checking account.  They don't want to produce duplicate check numbers across the different, separate companies (entities) on the one/same checking bank account that's being used for all of them.

    Other than possibly using Multi-Entity Management, or scheduling their check runs in each of the companies so that they don't produce duplicate check numbers on the one checking account, I'm not seeing a resolution for the issue.

    Hope the additional detail helps for further understanding of the issue.

    Thank you in advance for your assistance!

  • RE: Non Decentralized checking account check processing

    Hello,

    I still don't have any context or reference for your question, and we don't use the word 'entity' in GP, so I'm not clear on your ask.  I am not sure if you are asking about GP or about reporting, so I will do the best I can to suggest both ways below:

    Q1: In GP, how can we differentiate the same check numbers between different companies?

    A1:  You can modify the 'Next check number' on the Checkbook setup (Cards | Financial |Checkbook), so the different numbering schemes would indicate which checkbook it came from.   Ex. one checkbook may have check #00001000 and another checkbook have #20001000 and another have #30001000, etc.   So if the check numbers show on a consolidated report, you know where they came from.

    Q2: In MR, how can I show which companies are responsible for the consolidated balance?

    A2:  For MR to break out the account balances by company, you would need to create a consolidated report in MR that includes all companies in the tree, and then you can show the balance of the account in each company.

    I hope that helps, or the community can provide more recommendations for you, but you may want to provide more context for your question.

    Thanks

    Cheryl W.

    Microsoft Support  

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: Non Decentralized checking account check processing

    We have Management Reporter for use in reporting consolidating the bank account information into one collective report.

    What I'm looking for is, the one bank account is being used by all of the entities and they're not de-centralized.  So, other than scheduling and coordinating generating of checks on separate days from one another, how do they keep from using the same check numbers in different companies/entities for the same bank account?  I'm not sure how this would be achieved either without scheduling/coordinating among each of the entities.

  • Suggested answer
    RE: Non Decentralized checking account check processing

    To make sure we are on the same page, multiple companies are using the same bank account number to process checks, so you are looking for reporting that would report across companies to pull the check activity from all companies into the same report?   

    I don't know of anything in GP that would do this as custom reporting would be needed.  Management Reporter would be able to pull the GL cash accounts from all companies into one report.  I believe you can have views in SSRS reporting pulled from any number of DB's in the same report, so I hope that gives you some ideas to explore.

    Perhaps the Community can offer more suggestions for you.  

    Cheryl

    Microsoft Dynamics GP 

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans