Skip to content


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


Quote, Order, Invoice, Credit Memo, Return Order

MEM Purchase Lines API


Quote, Order, Invoice, Credit Memo, Return Order

MEM Sales Header API


Quote, Order, Invoice, Credit Memo, Return Order

MEM Sales Lines API


Quote, Order, Invoice, Credit Memo, Return Order

MEM Journal Line API


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

Leave a Comment


2023 Advanced SmartConnect Bootcamp: REST Web Services Integration
Accessing Your Historical Dynamics NAV Data in D365 Business Central - Part 1: Getting Started
2023 Migration from Dynamics GP to D365 Business Central Training
eOne Welcomes Incremental Group as a New eOne iPaaS Integration Partner
Employee Spotlight: Floyd Jones, Front End Developer


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



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 Partner All Hands Call Popdock promotions release SalesForce SmartConnect 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.