In this article

Sales Journals

Use this page to post transactions directly to the sales journal.

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

For information how the different combinations of the Account Type and Balance Account affect the entities to which the accounts belong, review the concept information for the Bank Account page.

Centralized and Decentralized Processing

The Apply Entries action can be used with both centralized or decentralized processing on sales journal transactions. This action is part of standard Microsoft Dynamics 365 Business Central. For more information, see Reconcile Customer Payments with the Cash Receipt Journal or from Customer Ledger Entries.

Create Sales Journal

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

  1. In the header, do the following: 
    1. If the Entity Code is empty or you do not want to use the default entity, select an entity.
    2. If needed, select the Allocation Template.
    3. If needed, change the Batch Name.
    4. If needed for intercompany distribution, select Related > Header > Header Dimension.
    The transaction lines are updated with transactions that have the same entity as the selected Entity Code and are in the specified Batch Name. The entity and allocation template become the default values for any line that is added.
  2. 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 Actions > Functions > MEM Allocation Template.
    4. On the Allocation page, edit the Additional Dimensions and the Allocation Details as needed. You can use Manage > Allocate Equally to allocate percentage/amount equally for the selected rows, the remainder amount will go to the last line. If the amount has been fully allocated and involves multiple currency, the percentage of the last line will be auto adjusted and rounding amount go to the original account in the general journal.
    5. Close the dialog to go back to the main journal page.
  3. Select Post/Print > Preview Posting to review the ledger entries for the transaction.
    When the entity of the line is different from the entity of the header, intercompany distributions for the line are applied during the preview or posting of the transactions.
  4. You can then finish processing the transaction as per the instructions in the Microsoft Dynamics 365 Business Central documentation.

Fields

This page contains the following fields:

Journal Fields Table
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. The allocation template for existing lines is not changed. For more information on the entity allocation template, see MEM Entity Allocation.
Entity Code

Select the entity for the transactions. The default value is your default entity. The default entity for the line is automatically updated with the entity value of the selected the customer, vendor, account, or item record. If needed, you can change it any entity to which you have access.

  • When you select the entity, only the transactions in the batch that belong to the entity appear in the list. If the entity is empty, only transactions that do not have an entity appear in the list.
Lines
Entity Code

Displays the entity for the line. The default value is specified in the header. The default entity for the line is automatically updated with the entity value of the selected the customer, vendor, account, or item record.

The selected entity filters the other records such that only the records that belong to that entity are available. For example, when entity 100 is selected, only the account numbers that belong to entity 100 are available.

MEM Allocation Template ID

Select the entity allocation template for the line. The default value is specified in the header, but you can change it if needed.

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

Actions

This page contains the following actions: 

Journal Action Table
Action Description
Actions > Functions > 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 of an existing allocation.
  • Add or delete an allocation line.
Navigate > Header > Header Dimensions

For use with intercompany distributions, allows you to assign other dimensions to the header entity.

When intercompany distributions occur, only the entity code of the header of the originating line is used in the distribution. In turn the destination line uses the entity code from the corresponding originating line.

Page > Edit in Excel

When editing data in Microsoft Excel, a column has been added for the header entity (BssiBatchHeaderEntityID).

  • When the data is opened in Excel, the records are filtered according to the batch header entity specified on the page.
  • For existing lines, this value cannot be changed. For new lines, specify the value to determine which batch header entity the new line belongs.

For more information, see the Microsoft Dynamics 365 Business Central documentation.
Home > Process with Multiple Entities

Opens the MEM Mass Batch Processing page, where you can do the following types of actions:

  • Post and print batches of journal lines.
  • Delete batches of journal lines of specific entities.

Note icon. Note: The Process with Multiple Entities action has replaced the Post with Multiple Entities action as of MEM version 1.1.92.0. Use the Process with Multiple Entities action to open Mass Batch Processing where you can post and print batches.