Item Journals

Use this page to post an item transaction directly to adjust inventory in connection with purchases, sales, and positive or negative adjustments without using documents.

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

Owner Entity for a Location

When transactions are posted, the entity that is used for the posted transaction is based on the Location Code selected for the line. Consider the following example: on the Location page, the owner entity PROD is set up for the location EAST.

On the Item Journals page, the following transaction is created: 

General
Entity Code ADM
Batch Name DEFAULT
Lines
Entity Code Posting Date Entry Type Document No. Item No. Description Location Code Quantity
ADM April 8, 2019 Purchase   1896-S ATHENS Desk EAST 1

When the transaction is posted, the distribution for the line is as follows: 

Entity Code Posting Date Document Type Document No. G/L Account No. Description Gen Posting Type Gen. Bus. Posting Group Gen. Prod. Posting Group Amount Bal. Account Type Entry No.
PROD April 8, 2019   DOC4 10700 Direct Cost on April 8, 2019       -1,004.00 G/L Account 4324
PROD April 8, 2019   DOC4 10700 Direct Cost on April 8, 2019       1,004.00 G/L Account 4323
PROD April 8, 2019   DOC4 10700 Direct Cost on April 8, 2019       -1,003.00 G/L Account 4320

Because the transaction line uses the location code EAST, the distribution for the transaction changes the entity code to PROD (based on the owner entity for the location set up on the Location page).

Processes

To create an item 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, change the Batch Name.
    The transaction lines are updated with transactions that have the same entity as the selected Entity Code and are in the specified Batch Name.
  2. If the action is available, select Preview Posting to review the ledger entries for the transaction.
  3. 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
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.

Applies-to Entry

Specify the entry number to which the quantity is to be applied. When you select the ellipses (…) for the cell, only the entries that have the same entity code as the selected line appear as options and can be selected.

Actions

This page contains the following actions: 

Action Description
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.