Creation and Posting of Item Opening from Item Journal in D365 BC

Creation and Posting of Item Opening from Item Journal:

(1) In this blog, we will see how to create and post Item Journal. Use item journals to post item inventory transactions directly to item ledger entries. Item Journal is mainly used for adjustment (positive and negative) of Item inventory. Item journal would be an easy way to adjust my inventory from all locations. Go to the search bar and type “Item Journals”, as shown.

Search Item Journals in Business Central

(2) After that, “Item Journals” opens and enters the information. In the below screenshot, we entered the opening of Item Inventory, as below.

entered the opening of Item Inventory
Field NameField DescriptionImportance
Batch NameSpecifies the name of the journal batch.Mandatory
Posting DateSpecifies the entry’s posting date.Mandatory
Entry TypeSpecifies the type of transaction that will be posted from the item journal line.Mandatory
Document No.Specifies a document number for the item journal line.Mandatory
Item No.Specifies the number of the item on the journal line.Mandatory
DescriptionSpecifies a description of the item on the journal line.Mandatory
Location CodeSpecifies the code for the inventory location where the item on the journal line will be registered.Mandatory
QuantitySpecifies the number of units of the item to be included on the journal line.Mandatory
Unit of Measure CodeSpecifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.Mandatory
Unit AmountSpecifies the price of one unit of the item on the journal line.Mandatory
AmountSpecifies the line’s net amount.Mandatory
Lot No. or Batch No.Specifies the tracking of the item.Mandatory → if Item Tracking is applicable in Item Master. For that go to the “Line” → ”Item Tracking Lines”.
  • After entered, go to the “Post/Print” Post. Pop window open, Press “Yes”, as shown.
Post-Print pop up for Item Journal in d 365 bc
  • In the above entries, Item Tracking is applicable in Item No. “80218-T”. if item tracking is not assigned, then the system shows an error with detail of Item No. and Item Journal Line while posting, as shown.
Item Tracking Error in bc d365
  • For resolving the above error, Select the Item and go to the option “Line” ”Item Tracking Lines”, as shown.
Item Journals Business Central
Item Tracking Lines in BC D365

(3) After doing the above steps, Post the entries, as shown.

Click yes for journal lines in bc d365

(4) Now go to the Item List and select the posted items and see the effect in the Item Ledger Entries. All the item-related transactions are available in Item Ledger Entries as shown.

Item ledger entries in business central

TCS Register Report Development and Format in BC D365
TDS Register Report Development and Format in BC D365
How to Create or Setup Accounting Period in BC D365
Purchase Received not Invoiced Report in BC D365
Bank reconciliation report (BankReconciliation)– Microsoft Docs

Leave a Reply