You’re offline. This is a read only version of the page.
Announcements
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!
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
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!
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
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.
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
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
