Inventory journals

-
Note
This topic applies to both Dynamics 365 for Finance and Operations and to Dynamics 365 for Retail.
This topic describes how you can use inventory journals to post various types of physical inventory transactions.
The inventory journals in Microsoft Dynamics 365 for Finance and Operations are used to post physical inventory transactions of various types, such as the posting of issues and receipts, inventory movements, the creation of bills of materials (BOMs), and the reconciliation of physical inventory. All these inventory journals are used in a similar way, but they are divided into different types.

Types of inventory journals

The following types of inventory journals are available:
  • Movement
  • Inventory adjustment
  • Transfer
  • BOM
  • Item arrival
  • Production input
  • Counting
  • Tag counting

Movement

When you use an inventory movement journal, you can add cost to an item when you add inventory, but you must manually allocate the additional cost to a particular general ledger account by specifying a general ledger offset account when you create the journal. This inventory journal type is useful if you want to overwrite the default posting accounts.

Inventory adjustment

When you use an inventory adjustment journal, you can add cost to an item when you add inventory. The additional cost is automatically posted to a specific general ledger account, based on the setup of the item group posting profile. Use this inventory journal type to update gains and losses to inventory quantities when the item should keep its default general ledger offset account. When you post an inventory adjustment journal, an inventory receipt or issue is posted, the inventory values are changed, and ledger transactions are created.

Transfer

You can use transfer journals to transfer items between stocking locations, batches, or product variants without associating any cost implications. For example, you can transfer items from one warehouse to another warehouse within the same company. When you use a transfer journal, you must specify both the "from" and "to" inventory dimensions (for example, for Site and Warehouse). The on-hand inventory for the defined inventory dimensions is changed accordingly. Inventory transfers reflect the immediate movement of material. In-transit inventory isn't tracked. If in-transit inventory must be tracked, you should use a transfer order instead. When you post a transfer journal, two inventory transactions are created for each journal line:
  • An inventory issue at the "from" location.
  • An inventory receipt at the "to" location.

BOM

When you report a BOM as finished, you can create a BOM journal. By using a BOM journal, you can post the BOM directly. This posting generates an inventory receipt of the product, together with an associated BOM and an inventory issue of the products that are included in the BOM. This inventory journal type is useful in simple or high-volume production scenarios where routes aren't required.

Item arrival

You can use the item arrival journal to register the receipt of items (for example, from purchase orders). An item arrival journal can be created as part of arrival management from the Arrival overview page, or you can manually create a journal entry from the Item arrival page. If you enable the item arrival journal name to check for picking locations, Finance and Operations looks for a location for received items and, if there is room, generates location destinations for the incoming items.

Production input

Production input journals work like the item arrival journals but are used for production orders.

Counting

Counting journals let you correct the current on-hand inventory that is registered for items or groups of items, and then post the actual physical count, so that you can make the adjustments that are required to reconcile the differences. You can associate counting policies with counting groups to help group items that have various characteristics, so that those items can be included in a counting journal. For example, you can set up counting groups to count items that have a specific frequency, or to count items when stock falls to a particular level. For information about how to define counting groups, see Define inventory counting processes (Task guide).

Tag counting

Tag counting journals are used to assign a numbered tag to a count lot. The tag should contain a tag number, item number, and item quantity. To ensure that a tag is used only one time, and that all tags are used, every item number should have a unique set of tags that has its own number sequence. Three status values can be set for each tag:
  • Used – The item number is counted for this tag.
  • Voided – The item number is voided for this tag.
  • Missing – The item number is missing for this tag.
When you post a tag counting journal, a new counting journal is created, based on the tag counting journal lines. For more information about tag counting, see Inventory tag counting.

Working with journals

A journal can be accessed by only one user at a time. If several users must access journals at the same time to create journal lines, those users must select journals that aren't currently being used, to prevent information from being overwritten. In situations where multiple departments use the same journal type, it's helpful to create multiple journal names (for example, one per department). It can also be helpful to divide journals so that each posting routine is entered in its own unique inventory journal. For posting routines that are associated with inventory transactions, create one journal for periodic inventory adjustments and another for inventory counting.

Posting journal lines

You can post the journal lines that you create at any time until you've locked an item from additional transactions. The data that you enter in a journal remains in that journal, even if you close the journal without posting the lines.

Data entity support for inventory journals

Data entities support the following types of integration scenarios:
  • Synchronous service (OData)
  • Asynchronous integration
For more information, see Data entities.
Note
Not all inventory journals are OData-enabled, therefore you cannot use the Excel data connector to get data published, updated, and imported back to Dynamics 365 for Finance and Operations.
Another difference between the journal data entities is the ability to use composite entities that include both the header and line data. Currently, you can use the composite entities for:
  • Inventory adjustment journal
  • Inventory movement journal
These two inventory journals only support the Initialize stock scenario as part of a data management import project:
  • When a journal header number is not specified, but a number sequence is specified for the journal type, the import job will automatically create journal headers per 1000 lines. For example, importing 2020 lines will result in the following three journal headers:
    • Header 1: will contain 1000 lines
    • Header 2: will contain 1000 lines
    • Header 3: will contain 20 lines
  • It is assumed that unique line information exists per inventory dimension, which can be a product, storage, and tracking dimension. Therefore, it’s not possible to import journal lines where only the date field differs on the lines within the same import project.

Comments

Post a Comment

Popular posts from this blog

Warehouse Management System in AX 2012-Set Up & Configuration

-
Image
Warehouse Management System in AX 2012-Set Up & Configuration Hi All, As promised in my last post, I am back with WMS feature in AX 2012 R3. This is very interesting  and absolutely a new module that has been added to AX 2012 R3 whose purpose is basically to monitor and automate warehouse processes. WMS in AX is an Advanced distribution which provides complete real time and global view in the business efficiently. Warehouse Management for Microsoft Dynamics AX is an integrated warehousing solution for advanced distribution and order fulfillment that adds to the current capabilities of Microsoft Dynamics AX to support distribution companies and logistics providers. Overview of Features : You can configure inbound and outbound intelligent workflows. You can assign orders to clusters to pick from a single location, and configure profiles to control the validation and packing of items into shipping containers. You can create, implement...
Read more

Create Item/Product and Product master in Dynamics AX 2012 R2

-
Image
Create Item/Product and Product master in Dynamics AX 2012 R2 In This Article we are going to discuss how to create a product and Product master (Items). In 2012 R2, ‘ Item’  is replaced with ‘ Product’ . Item master was in Inventory Management Module, now there is a separate module for item/product creation ‘Product Information Management’. There are two types of Products in 2012 they are: 1. Product 2. Product Master 1. Product: Clearly identifiable products that do not have variations associated with them. You can think of them as standard or base products. Use the  Products list page  in the  Product information management  module to view and manage products. Manage Product: 2. Product Master: These serve as templates or models for  variants . The  variants  of a product master can be either predefined or created in sales scenarios by using a product configuration. A product master is associated with one or more ...
Read more

D365: Request for quotations (RFQ). Process RFQ overview

-
Image
D365: Request for quotations (RFQ). Process RFQ overview In this blog post I am going to review one type of procurement solicitation that is available within Microsoft dynamics 365 for Finance and Operations – Requests for quotations (RFQ). In general, RFQ is used when the company wants to receive competitive offers from several vendors for the goods they might purchase. As the result, company invite suppliers into a bidding process to bid on specific products or services, it is some kind of putting out goods to tender or requesting for proposal. And now it’s time to step up to the plate and follow the process presented below: I would like to bring to the table details on creating an RFQ, sending it to vendors, and evaluating bids returned by vendors. The first step in the RFQ process is to set up prerequisites. The following prerequisites are required for this functionality. Let’s break each setting down… Procurement and sourcing parameters for requests for ...
Read more