EONE BLOG

Tech Tuesday: Using SmartConnect to Integrate with Multi-Entity Management for Business Central


In the last week I had 3 separate conversations with customers implementing MEM and Binary Stream’s Multi-Entity Management (MEM) for Business Central and SmartConnect. There were some recurring questions and concerns in these discussions that I want to clarify for all our customers and partners.

Note: SmartConnect has been compatible with Binary Stream’s Multi-Entity Management (MEM) for Dynamics GP for over a decade. If you landed here looking for GP MEM instructions you can find them here.

 

Using SmartConnect with MEM for Business Central

Transactions and Journals are restructured to be controlled by dimensions meaning the standard Business Central pages will not work for importing or retrieving data from Business Central. MEM includes 5 API pages that are designed to be used for importing and exporting and importing data from these modules. Binary Stream has documented the API endpoints on their support portal.

 

You will need to use these below pages for your SmartConnect Integrations.

Page ID Included Types

MEM Purchase Header API

70210901

Quote, Order, Invoice, Credit Memo, Return Order

MEM Purchase Lines API

70210902

Quote, Order, Invoice, Credit Memo, Return Order

MEM Sales Header API

70210903

Quote, Order, Invoice, Credit Memo, Return Order

MEM Sales Lines API

70210904

Quote, Order, Invoice, Credit Memo, Return Order

MEM Journal Line API

70211035

general, sales, purchase, cash receipt, payment, and fixed asset G/L

 

Common Questions

Can I use my existing integrations if I add MEM?

If you have integration reading/writing to any of the document types referenced above, those integrations will need to be updated.

If you have some integrations that aren’t listed above (ex. Customers, Vendors, Items), those existing integrations can be kept.

 

Why am I missing Journal Lines in a MEM data source?

Make sure you are using the MEM Journal Line API page. If you are using the standard Journal Lines Pages in SmartConnect, you will only see the lines assigned to the default entity.

 

How can I import my MEM Headers and Lines in one integration?

If you select either the MEMSalesHeader or the MEMPurchaseHeader and check the box for “Include linked entities”, the lines will automatically be added to your mapping and linked to the header based on your source grouping.



If you have any questions, feel free to email me at ethan.sorenson@eonesolutions.com

Leave a Comment





RECENT POSTS


Building Month Over Month Sales Reports with Popdock
WooCommerce Integrations, Simplified
Acumatica - BOOM! It's Integrated!
Throwback Thursday: Real Time Triggers with MSSQL
Shopify Integrations, Simplified

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

ARCHIVES

open all | close all

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 Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.