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.
(2) After that, “Item Journals” opens and enters the information. In the below screenshot, we entered the opening of Item Inventory, as below.
Field Name | Field Description | Importance |
---|---|---|
Batch Name | Specifies the name of the journal batch. | Mandatory |
Posting Date | Specifies the entry’s posting date. | Mandatory |
Entry Type | Specifies 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 |
Description | Specifies a description of the item on the journal line. | Mandatory |
Location Code | Specifies the code for the inventory location where the item on the journal line will be registered. | Mandatory |
Quantity | Specifies the number of units of the item to be included on the journal line. | Mandatory |
Unit of Measure Code | Specifies 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 Amount | Specifies the price of one unit of the item on the journal line. | Mandatory |
Amount | Specifies 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.
- 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.
- For resolving the above error, Select the Item and go to the option “Line” → ”Item Tracking Lines”, as shown.
(3) After doing the above steps, Post the entries, as shown.
(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.