Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Using Multiple Companies in SmartConnect


As we are getting very close to releasing new SmartConnect Excel Templates for Dynamics GP I am reminded of some really great features we have inside of SmartConnect. Today I want to give you a little insight into using multiple companies from your Dynamics GP implementation.

The new templates will allow you to pick which Dynamics GP company and send transactions into that company without reconfiguring the SmartConnect map each time. How did we do this? The answer is simple, inside of the Map in the Companies button for the destination. Normally in this window you would choose a specific company and check the box to have transactions created in that company. You do have the ability to create records in multiple companies by selecting each desired company. Why would you do this? Great question, and I think there are a variety of answers but here are a couple to think about.

1)  You have a master database of Accounts, Customers, Vendors, Employees and you want to synchronize those records.
2)  You want to use real-time Dynamics GP triggers to automatically create these records in other databases.

Another option is to not have any companies selected at all! How would that work? Well, we have a way to use data from your source to select which company the record should be using for integration. Let me explain a bit more, if you have a field of data that has your company id (database name) you can simply pass that in by using the define button on the companies button and returning that fields value. A simple example script is below:

Return _GPCompanyID

You can also get a lot more sophisticated if you don’t have a specific field that spells out your company id by using a case statement like below:

Select Case _mySource

Case “Far”
Return  “FAR”

Case “Gra”
Return  “GFL”

Case “Chi”
Return  “CHI”

Case Else

‘If no match is found, return an empty string
Return String.Empty
End Select

Now you can do things like bring in Journal Entries into multiple Dynamics GP companies with one pass instead of running multiple maps.

I hope today you may have been inspired to try new options in how you setup maps.

Thanks,

Chris Dew
Director of Product Management

13 Comments

  1. Beat BUCHER on July 9, 2013 at 9:18 pm

    Chris,
    Great article! Though I haven't started yet to use SmartConnect, I can't wait to try that multi company ability…
    Beat

  2. Beat BUCHER on July 9, 2013 at 9:18 pm

    Chris,
    Great article! Though I haven't started yet to use SmartConnect, I can't wait to try that multi company ability…
    Beat

  3. Beat BUCHER on July 9, 2013 at 9:18 pm

    Chris,
    Great article! Though I haven't started yet to use SmartConnect, I can't wait to try that multi company ability…
    Beat

  4. Abarshini on September 18, 2013 at 12:59 am

    Wonderful blog & good post.Its really helpful for me, awaiting for more new post. Keep Blogging!

    Web Development Services in Chennai

  5. Cindi Todd on June 13, 2016 at 9:44 pm

    This is great! Have you ever used this with a GP rolling column? In other words, have you been able to pass the company defined through to that GP rolling column field?

    • Chad Bruels on June 21, 2019 at 10:50 am

      I’m guessing this isn’t possible. But if it is, I want to know how as well.

      • Chad Bruels on June 21, 2019 at 11:51 am

        I was just told by a colleague that \”even though you must select a Company ID in the GP Rolling Column window, if the map detects that Define is used instead of the company selection checkbox, it will call the correct company stored procedure during integration\”. I confirmed this functionality worked for my client.

  6. Kevin Lehoullier on March 29, 2018 at 3:38 pm

    This is an old post but if someone is monitoring what is the syntax for case or if then else for multiple company selection?
    e.g.

    case when co
    ‘CO1’ then ‘CO1’
    ‘CO2’ then ‘CO2’
    else blanks
    end

    • Patrick Roth on July 15, 2020 at 1:35 pm

      This is an old question by now too. But here I believe you are asking “can we use the Define to return multiple DBs for my destination” – the same way we can select multiple destination checkboxes.

      No, currently SC doesn’t have a way to return multiple DBs via the Define button code.

      • Husain on April 18, 2023 at 12:46 pm

        Hi Patrick, does SC have the ability to do this now?

        • David Youngquist on April 24, 2023 at 11:12 am

          Husain,

          No, you still cannot use the “Define” feature to send data into more than 1 company using data in your source file. However if the data is always going to the same companies (i.e. not using the Define window) then you can select multiple companies on the previous destination window, if you check off 2 companies, it will send data into both companies. Typically you would only use this option if you are adding the same data to multiple companies. For example, you have the same chart of account in multiple companies, and you want to import the same accounts into ALL your companies, you can open the Companies window and check off multiple companies.

  7. Adan Torres on July 11, 2020 at 10:36 pm

    Hello im using this option, but when the gp transactions has been created im receiving a duplicate amount on a payble transactions, i mean i hope to receipt a purchase and total amount for 500 usd and im receiving a amount for 1000, i dont understand why, could someone help me to understand what’s going on and how can i fix it , see my define company rule below

    SELECT CASE _REPORTORGUNIT2

    CASE “NST”
    RETURN “NST”

    CASE “NSN”
    RETURN “NDSRT”

    CASE “NSI”
    RETURN “DGINV”

    CASE “NSU”
    RETURN “ZONA”

    CASE ELSE
    return string.Empty
    END SELECT

    • Patrick Roth on July 15, 2020 at 1:39 pm

      Using the “Define” button code to determine your company vs marking the checkbox wouldn’t cause the “my amount for the pop receipt transaction is doubled” issue you note.

      You’d have to check to see what fields are mapped to what in the integration and verify the data being integrated to see if its the data you expect.

      If the data is correct (the numbers show what you expect) – then you’d have to see what your mappings are. Perhaps you have a calculation that is wrong (if using one) or else field set to “SUM” when it shouldn’t be.

Leave a Comment





RECENT POSTS


Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING
US Office Closed, Memorial Day - May 29, 2023
Accessing Historical Dynamics GP Data in NetSuite: The Azure Data Lake
New Webinar Series: What is the Azure Data Lake?
UPCOMING WEBINAR: Top 10 New Popdock Features

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.