Overview

The integration of MV2 and Microsoft Dynamics 365 Business Central involves the initial transfer of data from Business Central to MV2, continued updating of MV2 based on changes made to the data in Business Central, and lastly the transfer of data to Business Central based on transactions that occur in MV2.


Business Central Extension

To keep MV2 updated with changes that occur in Business Central, we’ve created a Business Central Extension that monitors changes made to specific data within Business Central. This extension is installed through the Extension Management function and should only be modified by the MV2 Team.


MV2 Business Central Pages

Additional pages support the extension. Searching for “MV2” in Business Central will show:

  • MV2 Request Queue
  • MV2 External Data Definition
  • MV2 Integration Configuration
  • MV2 Log Viewer
  • MV2 Order Sync Selection
  • MV2 PurchaseOrder Sync Selection

Similar to the MV2 Extension, these Pages are critical to the integration of MV2 to Business Central and should not be modified unless by a member of the MV2 Team or with explicit instructions.


Additional Business Central changes

In support of MV2’s integration with Business Central, there is additional logic that we’ve written to support the transfer of data between the two systems. These include, but are not limited to:

  • Queries
  • API’s
  • Code Units
  • Pages

The details of what these changes are and their usage in the integration can be requested from the MV2 Team.


Terminology

There are some references to the same data in Business Central and MV2, however they use different terminology. Below is a list of the terms used in Business Central and the associated terms in MV2.

*Note: The MV2 UI has been modified to use the Business Central terminology, so the following is for informational purposes.

  • Released Production Order / RPO
    • Each Line on an RPO represents a Manufacture Order in MV2
  • Routings
    • Operations in MV2
  • Bin(s)
    • Inventory Location(s) in MV2
  • Location(s)
    • Warehouse(s) in MV2


Webhook Notifications

MV2 uses webhooks to subscribe to push notifications, following Microsoft REST API Guidelines, to receive updates when entities change in Business Central.  The MV2 Sync Service (located on the MV2 Applicaton Server) will subscribe to a webhook for each of the data entities monitored by MV2. The notification URL of each entity will be the MV2 Sync Service itself.


    Each webhook notification contains the following data:

  • SubscriptionId: Identifying the entity changed
  • Resource: A URL from Business Central to call for the entity data
  • ChangeType, One of three events:
    • Created
    • Modified
    • Deleted


When alerted with the Created or Modified changetypes, the MV2 Sync Service will call the Resource URL for the new or updated data, process the returned data and send the reformatted data to the MV2 Provider API for insertion into MV2 based upon SubscriptionId. For the Deleted changeType, the MV2 Sync Service will process the SystemId from the Resource URL and send a delete request to the MV2 Provider API for insertion into MV2 based upon SubscriptionId.


Transactions

This section details the transactions MV2 sends to Business Central and how they are processed.


Journals and Posting

Most transactions write to a Journal in Business Central, except Purchase Order Receipts which use an API endpoint. Journals are dynamically created using the Operator Panel or username.


Reporting Operation Quantities

‘Record Piece’ transactions write Order, Operation, and Quantity to the Output Journal.


Finishing a Routing Line

‘Change Status Manufacturing Order Operation’ marks Routing Lines as Completed and updates Output Journal.


Reporting Operation Quantities and Labor

‘Stop Labor’ transactions write Order, Operation, Quantity, and Labor time to Output Journal.


Reporting Quantities against an Order

‘Production Receipt’ transactions report finished goods against the last Routing Operation.


Issuing Components against an Operation

‘Issue Material’ transactions write Order, Operation, Component, and Quantity to Consumption Journal.


Finishing an Order

‘Change Status Manufacturing Order’ sets Production Orders to Finished using the same logic as Business Central’s interface.


Inventory Adjustments

‘Miscellaneous Receipt’ and ‘Miscellaneous Issue’ transactions adjust inventory in Item Journal.


Material Transfers

‘Transfer Material’ transactions write Item, From Bin, To Bin, and Quantity to Item Reclassification Journal.


Purchase Receipt

‘Purchase Receipt To Stock’ updates Purchase Orders directly without using Journals.