Sales Transactions

MEM functionality works with the following sales transaction pages: 

  • Blanket Sales Order
  • Sales Credit Memo
  • Sales Invoice
  • Sales Order
  • Sales Quote
  • Sales Return Order

Intercompany Distributions

When transactions are processed, the Due To and Due From accounts are selected as follows: 

  • If the destination account has a debit amount (positive amount):
Intercompany Distributions Table
Originating Entity Due From account   Debit  
  Destination Entity Due To account   Credit
  • If the destination entity account has a credit amount (negative amount): 
Intercompany Distributions Table
Destination Entity Due From account   Debit  
  Originating Entity Due To account   Credit

Intercompany Transactions

Four types of intercompany transactions can be created with the following combinations of Intercompany Suite partners: 

  • Both originating and destination companies use the intercompany functionality with Multi-Entity Management.
  • The originating company uses the intercompany functionality with Multi-Entity Management and the destination company uses the intercompany functionality only.
  • The originating company uses the intercompany functionality only and the destination company uses the intercompany functionality with Multi-Entity Management.
  • Both originating and destination companies use the intercompany functionality only.

Transaction Lists

When viewing a list of transactions, only the transactions that belong to an entity to which you have access appear in the list. The list has the Entity Code column that shows the entity to which the transaction belongs.

You can view and edit any transaction as you usually would in Microsoft Dynamics 365 Business Central.

Create Sales Transaction

To create a sales transaction, follow the steps within the Microsoft Dynamics 365 Business Central documentation, and incorporate these steps.

Note icon. Note: If you use the number series with Multi-Entity Management feature, you are prompted to select an entity for the transaction first. If you do not select an entity, the transaction cannot be created. For information on using the number series with Multi-Entity Management, see Assign Number Series Workflow.

  1. In the Select an Entity dialog, select the entity code you want to use and select OK. Your default entity is automatically used, but you can change it as needed.
  2. In the header, select the Allocation Template. Selecting the allocation template is optional.
  3. The entity and allocation template become the default values for the transaction lines.

  4. You can add or edit each transaction line as follows: 
    1. If needed, change the Entity Code.
    2. If needed, specify or change the MEM Allocation Template.
    3. If you want to change the allocation amounts for the line, select Line > MEM Allocation Template.
    4. On the Edit - Allocation page, edit the allocation dimensions and edit the Allocation Details as needed, and select Close.
  5. Select Posting > Preview Posting to review the ledger entries for the transaction.
  6. You can then finish processing the transaction by following the instructions in the Microsoft Dynamics 365 Business Central documentation.

Create Service Item from Sales Order

To be able to create a service item from a sales order or invoice, ensure that he Service Item Group selected for the item uses the Create Service Item option. You can check this option on the Service Item Groups page. For more information, see the Microsoft Dynamics 365 Business Central documentation.

Following the steps within the Microsoft Dynamics 365 Business Central documentation to create a sales order or invoice, and incorporate the following:

  1. In the header, select the Entity Code and Allocation Template.
  2. For each line, change the Entity Code and Allocation Template as needed.
  3. Post the sales order using the Ship and Invoice option.

After the transaction is processed, open the Service Item Card to see the newly created service item. The entity from the sales order line is automatically assigned to the service item, which can be checked on the MEM Master Security page.

Creating Sales Transactions from Incoming Documents

Use this section to create a sales transaction from an incoming document. With Multi-Entity Management, you can assign an incoming document to any of your entities.

For information about how to process incoming documents, see Incoming Documents in the Microsoft Dynamics 365 Business Central documentation.

To assign an entity to an incoming document, do the following:

  1. Go to the Incoming Documents list page.

  2. On the action tab, select New.

  3. Select the entity you want to use.

  4. Select OK.

In the new Incoming Document card, the entity you select appears in the Entity Code field.

Create Incoming Documents Manually

If you choose to process an incoming document manually, then the entity code is visible in whichever type of document you select. For example, if you create a General Journal line, then the entity code is visible on the header and as a column in the Lines FastTab.

To create an incoming document manually, do the following:

  1. Create a new incoming document record.

  2. Then, on the Action tab of the Incoming Document card, select Create Manually.

  3. Select the type of document you want to create. Select OK.

  4. Depending on the type of document you select, that document card opens. For example, if you create a General Journal line, then the General Journals card opens.

When you select the entity for your incoming document, that same entity is used in the new document you create manually.

Use OCR Service with Incoming Documents

You can use an OCR service (Optical Character Recognition) to process incoming documents and convert them into Microsoft Dynamics 365 Business Central records. For more information on using an OCR service, see Use OCR to Turn PDF and Image Files into Electronic Documents in the Microsoft Dynamics 365 Business Central documentation.

To assign an entity through an OCR service, do the following:

  1. Add the entity to your external documents.

  2. Make sure to train your OCR service to read the entity from the external document.

  3. Add the mapping for the entity in the Data Exchange Definition card.

Map the entity to either the Shortcut Dimension 1 Code or the Shortcut Dimension 2 Code in the Data Exchange Definition card, depending on which global dimension you are using for your MEM entity.

Note icon. Note: If an entity is mapped in the Data Exchange Definition card, and the entity of an incoming document is different from the entity of the OCR service, MEM will ask which entity you want to use for the incoming document. You can choose between the entity of the incoming document or the entity that is mapped in your OCR service.

Sales Transactions with Assembly Items

For sales orders, blanket sales orders, and sales quotes, whenever you add an assembly item to any of those types of sales transactions, a corresponding assembly transaction is created. For example, if you create a sales quote with an assembly item, then an assembly quote is automatically created by Business Central. Review the following rules about how entities are assigned when you add assembly items to sales orders, blanket sales orders, and sales quotes.

  • For sales orders, blanket sales orders, and sales quotes, if you add an assembly item, and your inventory posting is set to Entity From Location, then you must enter a location in the Lines FastTab. You can also view the owner entities for the assembly items or resources by opening Assemble-to-Order Lines. Go to the Lines FastTab and select Related information > Assemble to Order > Assemble-to-Order Lines.

  • You cannot manually create a blanket assembly order or assembly quote. You must first create a corresponding blanket sales order or sales quote and then add an assembly item.

Fields

This page contains the following fields: 

Field Description
Allocation Template

Select the entity allocation template for the transaction. This template is the default value for all new entries in the lines area. When you change the entity allocation template, you have the option of rolling down the changes to the other lines.

For more information on the entity allocation template, see MEM Entity Allocation.

Customer Name

Select the customer for the transaction.

When Customer Security is selected on the Multi-Entity Management Setup page and entity relationships with customer records are set up on the MEM Master Security page, only the customers that belong to entities to which you have access can be selected. When Customer Security is not selected, you can select any customer.

Entity Code

Select the entity for the transaction. The default value is your default entity. If needed, you can select any entity to which you have access. When this entity is assigned to the transaction, you can access only the transactions to which you have entity access.

IC Trade Allocation Mark if the sales transaction is IC trade allocation. The default value is specified in the Multi-Entity Management Setup. This filed appears for sales order, sales invoice and posted sales invoice.
Intercompany Suite
IC Partner Entity

Select the IC Partner's entity.

Not available for Sales Quote or Sales Blanket Order.

Lines
Allocation Template

Displays the entity allocation template that is selected in the header. If needed, you can change the template.

To change the allocation values for a line, select Line > MEM Allocation Template.

Entity Code

Displays the entity for the line. The default value is specified in the header. If needed, you can change the entity to any entity to which you have access.

Location Code

Select the location code.

When Location Security is selected on the Multi-Entity Management Setup page and entity relationships with location records are set up on the MEM Master Security page, only the location codes that belong to entities to which you have access can be selected. When Location Security is not selected, you can select any location code.

No.

Select the item number.

When Item Security is selected on the Multi-Entity Management Setup page and entity relationships with item records are set up on the MEM Master Security page, only the item numbers that belong to entities to which you have access can be selected. When Location Security is not selected, you can select any item number.

Intercompany Suite
IC Partner Entity

Select the IC Partner's entity.

Not available for Sales Quote or Sales Blanket Order.

ICS Partner Code

Select the IC Suite Partner.

Not available for Sales Quote or Sales Blanket Order.

Assemble-to-Order Lines
Shortcut Dimension 1 Displays the owner entity of the item or resource.
Shortcut Dimension 2 Displays the shortcut dimension 2 code.

Actions

This page contains the following actions: 

Sales Purchase Action Table
Action Description
Lines
Line > MEM Allocation Template

Shows the details of the entity allocation for the transaction line. You can change the entity allocation for the transaction line as needed. Any changes made are in real-time for the transaction line and do not affect the template.

You can make any of the following changes: 

  • Edit the percentage/amount of an existing allocation.
  • Edit Dimensions of an existing allocation.
  • Add or delete an allocation line.
Page > Edit in Excel

This action is available for the following purchase and sales subforms and list pages: Quote, Order, Credit Memo, Return Orders, and Blanket Orders.

This action allows you to add records or edit existing data.

  • All new records require an entity.
  • For existing records, the entity cannot be changed.

For more information, see the Microsoft Dynamics 365 Business Central documentation.

Important: When using Multi-Entity Management and this action from a list page, the workbook that is opened in Microsoft Excel may not show all records that are currently on the transaction list page in Microsoft Dynamics 365 Business Central. This situation occurs because the entity filter applied to the transaction list page in Business Central is not being correctly applied to the records in Excel. To ensure that all records appear when editing in Excel, clear the entity filter as follows:

  1. In the Data Connector pane, select Filter.
  2. In the Filter dialog, select Clear Filter, apply a different filter as needed, and select Done.
  3. Select Refresh.

The workbook is updated to show all record that apply to the updated filter, including non-MEM records.

Prepare > Incoming Document

Attach an incoming document to the purchase transaction, purchase or sales invoice, credit memo, or journal line. Select Create from File or Select.

  • Create from File: When selected, the incoming document is created with the header entity of the document record.

  • Select Incoming Document: When selected, a list of incoming documents shows only the documents which have the same entity as the header entity of the document record.